Difference Between RDBMS and ODBMS

RDBMS is a Database Management System which is the most popular one and currently in use and it is based on the relational model. Object-Relational database (ORDBMS) is a Database Management System that is an extension of RDBMS and is used to support more applications and it tries to link the relational and object-oriented model.

RDBMS is basically a relational model and the data here is stored as related tables. So, it is a collection of one or more relations/tables with columns and rows. Each column is a characteristic of the relation and each row indicates to a record that includes data values for any thing. RDMSs are developed by extending two previous database systems­ -hierarchical and the network models. The concepts of relational integrity and normalization are the key aspects of RDBMS, which are based on the 13 rules for a relational system developed by Ted Codd. Three important fundamentals that should be followed by a RDMS are-

  1. All information should be in the form of a table.
  2. Any value found in the table columns should not be repeated.
  3. The use of Standard Query Language (SQL).

The biggest advantage of RDBMSs is its user friendly nature in terms of creation of access and extension of data. After creating a database, new data categories can be added to the database without making any change in the existing application. One limitation of the RDBMS is incompatibility with languages other than SQL and the necessity of the information to be in tables where associations between entities are denoted by values. RDMSs do not have enough storage area to handle images, digital audio and video.

ORDBMS delivers a common ground between RDMS and object-oriented databases (OODBMS) or in other words ORDBMS supplies an object oriented front end on a RDBMS. When there is a communication between an application with an ORDBMS it will behave as if the data is stored as objects. Then the object information will be converted into data tables with rows and columns and the data will be handled as it were stored in a RDBMS. Also, upon the retrieval of data, it will return a complex object that was created by reassembling the simple data. ORDBMS provides means to convert data between RDBMS and OODBMS format, so that the programmer can do without writing codes to convert between the two formats and the database access becomes really easy from an object oriented language.

Applications using RDBMS work extra when storing complex data and ORDBMS provides support for this issue. But due to the internal conversion between different data formats, performance of ORDBMSs can be tainted.

Category: VS  |  Tags: