murugaiah
asked on
Difference between Oracle RDBMS and Other RDBMS
What is difference between ORACLE RDBMS and other RDBMS like Sybase, MS-SQL Server,etc. Some unique feature having Oracle. What is the difference
Only 5?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Unable to see the answer. If I click on Text Below , it is not showing the answer. How to open your answer
murugaiah:
It's over ur comment !!
It's over ur comment !!
MS-SQL Server means Windows NT and only Windows NT and nothing else !
If you need a highend database (millions of records), fast queuries, real good multiprocessing then you should choose UNIX.
Oracle is available for UNIX, MS SQL Server not !
If you need a highend database (millions of records), fast queuries, real good multiprocessing then you should choose UNIX.
Oracle is available for UNIX, MS SQL Server not !
ASKER
That's all, I increased points to 10 more. Can you can you tell more information about that.
Only 15 ? That too, when they r for free!!!!!!!!!
Here's answer worth 15 :
Oracle is more complex to administer than SQL Server.
Oracle has this stupid concept of instance, SQL Server doesn't.
Oracle can do row level locking. SQL Server , not sure.,..it didn't use to at least.
Oracle claims to have invented the concept of RDBMS !!! Is this true ?
Here's answer worth 15 :
Oracle is more complex to administer than SQL Server.
Oracle has this stupid concept of instance, SQL Server doesn't.
Oracle can do row level locking. SQL Server , not sure.,..it didn't use to at least.
Oracle claims to have invented the concept of RDBMS !!! Is this true ?
Ok.. i forgot this one :
To administer (as an administrator) an Oracle database, u must be physically present at the server machine (where oracle is installed) normally unless u r using a utility like PCAnywhere. U cannot do it from another client computer.
In SQL Server u can always do this, as long as you have the correct passwords.
Correect me buddies if i am wrong.... ?
To administer (as an administrator) an Oracle database, u must be physically present at the server machine (where oracle is installed) normally unless u r using a utility like PCAnywhere. U cannot do it from another client computer.
In SQL Server u can always do this, as long as you have the correct passwords.
Correect me buddies if i am wrong.... ?
Oracle 8 is easy to install.
And you can install from the Oracle 8 CD all administrative tool's to manage the database.
But I know: For some people M$ makes the best word processing, spreadsheet and presentation graphics software, so they created the best database, too.
And you can install from the Oracle 8 CD all administrative tool's to manage the database.
But I know: For some people M$ makes the best word processing, spreadsheet and presentation graphics software, so they created the best database, too.
Jitu,
You are wrong in all your points.
You are wrong in all your points.
mgokman>
Be kind enuff to clarify, Sir.
Be kind enuff to clarify, Sir.
Jitu,
Installation of Oracle 8.0.3 under NT.
You can choose a the beginning of the setup setup "Enterprise", then you are asked for a path, used network protocols and then all necessary components are installed. At the end a database assistant wizard appears in which you can select the sizes of tablespaces and so on and the database is created for you.
As I wrote before, there are admin tools available (I use them under NT 4) with which you can increase the size of the database, starting, shutting down. All this can be done from a client !
OK, Oracle 7.x installations may be more difficult, but not Version 8.
I still enjoy this discussion and hope all others do that, too.
murugaiah: Do you have to make a decision for a project ?
My experience is: Every software for a certain purpose can handlle 90% of the requests, the last 10% makes the difference but this is detected normally AFTER the project has been started. This is the risk for the project leader and the reason why he (or she) is better paid.
I'm not a project leader.
No one can tell me that a MS SQL Server can be managed by an experienced MS Access user. Some Access powerusers may have the impression they can do that, but they are wrong.
Installation of Oracle 8.0.3 under NT.
You can choose a the beginning of the setup setup "Enterprise", then you are asked for a path, used network protocols and then all necessary components are installed. At the end a database assistant wizard appears in which you can select the sizes of tablespaces and so on and the database is created for you.
As I wrote before, there are admin tools available (I use them under NT 4) with which you can increase the size of the database, starting, shutting down. All this can be done from a client !
OK, Oracle 7.x installations may be more difficult, but not Version 8.
I still enjoy this discussion and hope all others do that, too.
murugaiah: Do you have to make a decision for a project ?
My experience is: Every software for a certain purpose can handlle 90% of the requests, the last 10% makes the difference but this is detected normally AFTER the project has been started. This is the risk for the project leader and the reason why he (or she) is better paid.
I'm not a project leader.
No one can tell me that a MS SQL Server can be managed by an experienced MS Access user. Some Access powerusers may have the impression they can do that, but they are wrong.
Hello Jitu,
I hope you didn't take it personally, but you asked to correct you if you were wrong, so I "corrected" you<G>.
Here are details:
>>Oracle is more complex to administer than SQL Server.<<
I shouldn't even have to explain why this is wrong. Regardless of the subject, more or less complex always depends on whether or not you know what you are doing. Administering Oracle is more complex for those who never went beyond using the Enterprise manager. However, if you want to be a good SQL Server DBA, you should learn more than that. Oracle also has it's own enterprise manager and I know quite a few DBAs that are using it not realy knowing what's hapening. So Oracle is no more no less complex than anything else in this world.
>>Oracle has this stupid concept of instance, SQL Server doesn't. <<
This is another perl. Here is mine in the same manner SQL Server "has this stupid concept" of device, Oracle doesn't.
Each product has its own conepts. Use them or loose them.
>>Oracle can do row level locking. SQL Server , not sure.,..it didn't use to at least.<<
Sorry you are right on this one. And no SQL Server doesn't do row level locking which is a serious problem for OLTP apps. I witnessed quite a few hang-ups due to page locks.
>>Oracle claims to have invented the concept of RDBMS !!! Is this true ?<<
Oracle never claimed this. But they were the first working RDBMS. WHen Date and Code published their white paper on their Relational model, Larry Ellison and his two partners wrote the first RDBMS using the concepts invented by Date and Code.
>>To administer (as an administrator) an Oracle database, u must be physically present at the server machine (where oracle is installed) normally unless u r using a utility like PCAnywhere. U cannot do it from another client computer.<<
This is not true. You can use Oracle Enterprise manager to do practically all administrative tasks remotely. Moreso, if you are on Unix, then you can dial-in or telnet to your server and do all you need to do.
I hope I made it more clear than my initial "correction".
I hope you didn't take it personally, but you asked to correct you if you were wrong, so I "corrected" you<G>.
Here are details:
>>Oracle is more complex to administer than SQL Server.<<
I shouldn't even have to explain why this is wrong. Regardless of the subject, more or less complex always depends on whether or not you know what you are doing. Administering Oracle is more complex for those who never went beyond using the Enterprise manager. However, if you want to be a good SQL Server DBA, you should learn more than that. Oracle also has it's own enterprise manager and I know quite a few DBAs that are using it not realy knowing what's hapening. So Oracle is no more no less complex than anything else in this world.
>>Oracle has this stupid concept of instance, SQL Server doesn't. <<
This is another perl. Here is mine in the same manner SQL Server "has this stupid concept" of device, Oracle doesn't.
Each product has its own conepts. Use them or loose them.
>>Oracle can do row level locking. SQL Server , not sure.,..it didn't use to at least.<<
Sorry you are right on this one. And no SQL Server doesn't do row level locking which is a serious problem for OLTP apps. I witnessed quite a few hang-ups due to page locks.
>>Oracle claims to have invented the concept of RDBMS !!! Is this true ?<<
Oracle never claimed this. But they were the first working RDBMS. WHen Date and Code published their white paper on their Relational model, Larry Ellison and his two partners wrote the first RDBMS using the concepts invented by Date and Code.
>>To administer (as an administrator) an Oracle database, u must be physically present at the server machine (where oracle is installed) normally unless u r using a utility like PCAnywhere. U cannot do it from another client computer.<<
This is not true. You can use Oracle Enterprise manager to do practically all administrative tasks remotely. Moreso, if you are on Unix, then you can dial-in or telnet to your server and do all you need to do.
I hope I made it more clear than my initial "correction".
mgokman, liebla >
Thanks for the info. I learned quite a bit in the process of this discussion.
Would like to hear more from all on the subject and their experiences.
Jitu
Thanks for the info. I learned quite a bit in the process of this discussion.
Would like to hear more from all on the subject and their experiences.
Jitu
ASKER
I accept mgokman's proposed answer. Anybody wants to comment on mgokman's answer