Object-Relational Data Model in DBMS

The Object-Relational data model refers to a combination of a Relational database model and an Object-Oriented database model. As a result, it supports classes, objects, inheritance, and other features found in Object-Oriented models, as well as data types, tabular structures, and other features found in Relational Data Models.

In this article, we will dive deeper into the Object-Relational Data Model in DBMS according to the GATE Syllabus for (Computer Science Engineering) CSE. Keep reading ahead to learn more.

Table of Contents

What is the Object-Relational Data Model in DBMS?
History
Pros- Object-Relational Data Model
Cons- Object-Relational Data Model

What is the Object-Relational Data Model in DBMS?

It combines the relational and Object-Oriented models, as the name implies. This model was developed to bridge the gap between the Object-Oriented and relational models. Many additional capabilities are available, such as the ability to create complicated data types based on our requirements utilising existing data types. The issue with this paradigm is that it can become overly complicated and difficult to manage. As a result, a thorough comprehension of the model is essential.

One of the main goals of the Object-Relational data model is to bridge the gap between Object-Oriented practices and the Relational databases common in programming languages like C++, C#, and Java.

History

Both relational as well as Object-Oriented data models are extremely beneficial. However, it was determined that they both lacked certain traits; therefore, work began on creating a model that combined the two. As a result of research conducted in the 1990s, this data model was developed.

Pros- Object-Relational Data Model

The following are some of the benefits of the Object-Relational model:

Inheritance

Users of this data model can inherit objects, tables, and other data to expand their capability. Inherited objects have new properties in addition to those that were inherited.

Complex Data Types

Existing data types can be used to create complex data types. This is useful in the Object-Relational data model because complex data types allow for more effective data manipulation.

Extensibility

In the Object-Relational data model, the system’s capability can be expanded. This can be accomplished through the use of complicated data types and advanced Object-Oriented concepts such as inheritance.

Cons- Object-Relational Data Model

Because it combines the features of both the Object-Oriented data model and the Relational data model, this data model can be rather complicated and hard to handle at times.

Keep learning and stay tuned to get the latest updates on the GATE Exam along with Eligibility Criteria, GATE Syllabus for CSE (Computer Science Engineering), GATE CSE Notes, GATE CSE Question Paper, and more.

Also Explore,