Skip to main content

Object Oriented and Relational Database

Object Relational and Object-Oriented Database


What Is Object Relational Database?

An object-relational database (ORD) is a database management system (DBMS) that’s composed of both a relational database (RDBMS) and an object-oriented database (OODBMS). An object-relational database acts as an interface between relational and object-oriented databases because it contains aspects and characteristics from both models.

Object-oriented database (ORD) serves two main purposes:
  • It connects the divide between relational databases and the object-oriented modeling techniques that are usually used in programming languages like C#, Java and C++.
  • It bridges the gap between conceptual data modeling techniques for relational and object-oriented databases like entry-relationship diagram (ERD) and object-relational mapping (ORM).

What Is Object Oriented Database?

An object-oriented database is organized around objects rather than actions and data rather than logic. Therefore, an object database is a database management system in which information is represented in the form of objects as used in object-oriented programming. 

Usually, when OODBMS is integrated with an object programming language, there is a much greater consistency between the database and the programming language because both use the same model of data representation. When compared to a relational database management system, an object-oriented database stores complex data and relationships between data directly, without mapping to relational rows and columns whereas a relational database stores information in tables with rows and columns.

Key Differences

Features Of Object Oriented Database (OODBMS)
  1. In object oriented database, relationships are represented by references via the object identifier (OID). 
  2. Object oriented systems employ indexing techniques to locate disk pages that store the object. Therefore, they are able to provide persistent storage for complex-structured objects. 
  3. Handles larger and complex data than RDBMS.
  4. The constraints supported by object oriented systems vary from system to system.
  5. In object oriented systems, the data management language is typically incorporated into a programming language such as #C++.
  6. Stores data entries are described as object.
  7. Object oriented database can handle different types of data.
  8. In the object oriented database, the data is stored in the form of objects.

Features Of Object Relational Database (ORDBMS)
  1. In object t relational database, connections between two relations are represented by foreign key attributes in one relation that reference the primary key of another relation.
  2. Relational database systems do not specify any data storage structure, each base relation is implemented as separate file and therefore, they are unable to provide persistent storage for complex-structured objects. 
  3. Handles comparatively simpler data.
  4. Object oriented database has keys, entity integrity and referential integrity.
  5. In relational database systems there are data manipulation languages such as SQL, QUEL and QBE which are based on relational calculus.
  6. Stores data in entries is described as tables.
  7. Relational database can handle a single type of data.
  8. In relational database, data is stored in the form of tables, which contains rows and column.


Object Oriented Database Vs Object Relational Database :


BASIS OF COMPARISON                

OBJECT ORIENTED DATABASE (OODBMS) 

OBJECTED RELATIONAL DATABASE (ORDBMS) 

Connection Between Two Relations 

Relationships are represented by references via the object identifier (OID).  

Connections between two relations are represented by foreign key attributes in one relation that reference the primary key of another relation.  

Data Storage Structure 

It employs indexing techniques to locate disk pages that store the object. Therefore, they are able to provide persistent storage for complex-structured objects.  

It  does not specify any data storage structure, each base relation is implemented as separate file and therefore, they are unable to provide persistent storage for complex-structured objects

Quantity Of Data 

Handles larger and complex data than RDBMS.  

Handles comparatively simpler data.  

Constraints

The constraints supported by this system vary from system to system.  

It has keys, entity integrity and referential integrity.  

Data Manipulation Language 

The data management language is typically incorporated into a programming language such as #C++.  

There are data manipulation languages such as SQL, QUEL and QBE which are based on relational calculus.  

Description Of Stored Data 

Stores data entries are described as object.  

Stores data in entries is described as tables.  

Type Of Data 

Object oriented database can handle different types of data.    

Relational database can handle a single type of data.  

Data Storage 

The data is stored in the form of objects.  

Data is stored in the form of tables, which contains rows and column.   


Labels:

Comments

Post a Comment

Please do not enter any spam link in the comment box.

Popular posts from this blog

DBMS Keys

DBMS Keys KEYS in DBMS is an attribute or set of attributes which helps you to identify a row (tuple) uniquely in a relation(table). They allow you to find the relation between two tables. Keys help you uniquely identify a row in a table by a combination of one or more columns in that table. Key is also helpful for finding unique record or row from the table. Database key is also helpful for finding unique record or row from the table. Example: Employee ID FirstName LastName 11 Andrew Johnson 22 Tom Wood 33 Alex Hale In the above-given example, employee ID is a primary key because it uniquely identifies an employee record. In this table, no other employee can have the same employee ID. Here are some reasons for using sql key in the DBMS system. Keys help you to identify any row of data in a table. In a real-world application, a table could contain thousands of records. Moreover, the records could be duplicated. Keys in RDBMS ensure that you can uniquely identify a table record despite ...
Post a Comment
Read more

Colors in CSS

Ways to declare Colors in CSS (Image by - Sharma Guides | Subham232330) 1. Color Name 2. Hex Value 3. RGB() and RGBA() 4. HSL() and HSLA() 5. HWB() * Color Name:- background-color:red; * HEX Value:- background-color:#001122; * RGB():- background-color:rgb(25,31,52); * RGBA():- background-color:rgba(0,0,0,1.5);          |           Transparency The hexadecimal system uses values from 0 to 255 but in RGB we can use 0% to 100% as well.
Post a Comment
Read more

Computer Short Questions

Computer Short Questions & Answers: 1. What is any part of the computer that you can physically touch? – Hardware 2. Which generation of computers is still under development? – Fifth 3. What is the most common storage device for the personal computer? – Hard Disk Drive 4. Which key is used in combination with another key to perform a specific task? – Control 5. What is the pattern of printed lines on most products? – Barcodes 6. To make the number pad act as a directional arrow, we press which key? – Shift 7. Which devices let the computer communicate with you? – Input 8. What is the most frequently used piece of hardware for inputting data? – Hardware 9. What is the place where the computer stores programs and data? – Storage unit 10. What is the process of dividing the disk into tracks and sectors? – Formatting 11. What is the space in your computer that loads’ and works with data? – RAM memory 12. What is the storage which stores or retains data after power off? – Non-volatile s...
Post a Comment
Read more