More than 90% of Enterprise Applications run on RDBMS.
Learn technology advantages of RDBMS over OODBMS.
| RDBMS |
OODBMS |
| RDBMS has more than 90% of the Database market. |
OODBMS has less than 5% of the Database market. |
| RDBMS can handle 1010 records. |
OODBMS can handle only up to 107. |
| More than 90% of the world’s enterprise applications use RDBMS technology from leading vendors like Microsoft, Oracle & IBM. |
OODBMS’s main disadvantage is that their technology is immature and they are only used in applications such as CAD. |
| In an RDBMS modifying the database schema either by creating, updating or deleting tables is typically independent of the actual application. |
In an OODBMS based application modifying the schema by creating, updating or modifying a persistent class typically means that changes have to be made to the other classes in the application that interact with instances of that class. This typically means that all schema changes in an OODBMS will involve a system wide recompile. Also updating all the instance objects within the database can take an extended period of time depending on the size of the database. |
| This is not the case in RDBMS as the database structure is independent of the programming language used. |
An OODBMS is typically tied to a specific language via a specific API. This means that data in an OODBMS is typically only accessible from a specific language using a specific AP. |
| In an RDBMS, the relational nature of the data allows one to construct ad-hoc queries where new tables are created from joining existing tables then querying them. |
Lac of Ad-Hoc queries. Since it is currently not possible to duplicate the semantics of joining two tables by "joining" two classes then there is a loss of flexibility with an OODBMS. Thus the queries that can be performed on the data in an OODBMS is highly dependent on the design of the system. |
| RDBMS can handle large data which can run into terabytes of information. |
OODBMS is incapable of handling large data. |
Download Article in PDF Format
To access more information:
call +91-33-22866196 / 9830019363 or email info[at]edominer[dot]com
|
