DBMS > Data Model > What is Object-Relational Data Model?

Object-Relational Model
It is a combination of both the relational model and the object-oriented model. This model was built to fill the gap between object-oriented model and the relational model. We can handle complex data types according to our requirements using the existing data types.

Data base that support object-relational model is called object-relational database (ORD) and the database management system that support  ORD is called object-relational database (ORDBMS). ORD supports the basic components of any object-oriented database model in its schemas and the query language used, such as objects, classes and inheritance. 

Example: PostgreSQL is an ORDBMS

Features of Object Relational model

• Inheritance: Object Relational data model allows its users to inherit objects, tables etc. so that they can extend their functionality. Inherited objects contains new attributes as well as the attributes that were inherited.
• Complex Data Types : Complex data types can be formed using existing data types. This is useful in Object relational data model as complex data types allow better manipulation of the data.
• Extensibility: The functionality of the system can be extended in Object relational data model. This can be achieved using complex data types as well as advanced concepts of object oriented model such as inheritance.

Disadvantages of Object Relational model

The object relational data model can get quite complicated and difficult to handle as it is a combination of the Object oriented data model and Relational data model and utilizes the functionalities of both of them.

Prev

What is Object-Oriented Data Model?

Next

What is associative data model?

Feedback

Submit