Difference between RDBMS and ORDBMS

1. RDBMS :
RDBMS stands for Relational Database Management System.

In this database management, the data is organized into the related tables. To access the database it uses Structured Query Language (SQL). This model is based on the mathematical theory of relational algebra and calculus. The original concept for the model is proposed by Dr. E.F. Codd in a 1970. After some time the model was classified by defining twelve rules which are known as Codd’s rule. For any database to be relational database it must satisfy atleast 6 out of 12 Codd’s rules. These 12 Codd’s rule are as follows :

• Information Rule
• Guaranteed Access Rule
• Systematic Treatment Of Null Values
• Database Description Rule
• Comprehensive Data Sub-Language Rule
• View Updating Rule
• High Level Insert, Update and Delete
• Physical Data Independence
• Logical Data Independence
• Integrity Independence
• Distribution Independence
• Non Subversion Rule

2. ORDBMS :
ORDBMS stands for Object-Relational Database Management System.

It provides all the facilities of RDBMS with the additional support of object oriented concepts. The concept of classes, objects and inheritance are supported in this database. It is present in the ground level between the RDBMS and OODBMS. In this data can be manipulated by using any query language. It is complex because it has to take care of both Relational database concepts and as well as Object Oriented concepts. Some of the object related DBMS available in the market are as follows :

• IBM’S DB2 Universal Database system
• Informix’s Universal server

Difference between RDBMS and ORDBMS :

S.No.	RDBMS	ORDBMS
1.	RDBMS is a Relational Database Management System based on the Relational model of data.	ORDBMS is a Object Oriented Relational Database Management System based on the Relational as well as Object Oriented database model.
2.	It follows table structure, it is simple to use and easy to understand.	It is same as RDBMS but it has some extra confusing extensions because of the Object Oriented concepts.
3.	It has no extensibility and content.	It is only limited to the new data-types.
4.	Since RDBMS is old so, it is very mature.	It is developing so it is immature in nature.
5.	In this, there is extensive supply of tools and trained developers.	It can take the advances of RDBMS tools and developers.
6.	It has poor support for Object-Oriented programming.	It supports the features of object-oriented programming.
7.	It supports Structured Query Language (SQL).	It supports Object Query Language (OQL).
8.	RDMS is used for traditional applications tasks such as data administration and data processing.	ORDMS is used for applications with complex objects.
9.	It is capable of handling only simple data.	It is also capable of handling the complex data.
10	MS SQL server, MySQL, SQLite, MariaDB are examples of RDBMS.	PostgreSQL is an example of ORDBMS.