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

What is the monitor? How many types and what is it? Details about CRT, LCD and LED monitors.

मॉनिटर क्या है? कितने प्रकार का होता है और क्या होता है? सीआरटी, एलसीडी और एलईडी मॉनिटर के बारे में विवरण। मॉनिटर क्या है? = मॉनिटर वह पार्ट्स है जो कंप्यूटर सिस्टम के साथ टीवी जैसा दिखता है। मॉनिटर कंप्यूटर सिस्टम का एक बहुत ही महत्वपूर्ण आउटपुट डिवाइस है। इसे डिस्प्ले डिवाइस के नाम से भी जाना जाता है। कंप्यूटर पर हम जो भी कार्य करते हैं उन्हें इस मॉनिटर के माध्यम से देखा जा सकता है, इसलिए मॉनिटर को विजुअल डिस्प्ले यूनिट कहा जाता है। मॉनिटर अलग-अलग साइज में आते हैं जैसे- 14 इंच, 15 इंच, 17 इंच, 19 इंच आदि। (Image by - Google Images) मॉनिटर कितने प्रकार के होते हैं? = रंग प्रदर्शन के आधार पर मॉनिटर्स को दो श्रेणियों में विभाजित किया जा सकता है। 1) मोनोक्रोम मॉनिटर (Monochrome Monitor), 2) कलर मॉनिटर (Color Monitor) । *  वर्तमान में मोनोक्रोम मॉनिटर का उपयोग शायद ही ध्यान देने योग्य है। अब हर जगह कलर मॉनिटर का इस्तेमाल किया जाता है। 1) मोनोक्रोम मॉनिटर (Monochrome Monitor) = इस प्रकार का मॉनिटर केवल सादा-काला चित्र प्रदर्शित करता है। वर्तमान में मोनोक्रोम मॉनिटर बहुत कम उपयोग होता ...
Post a Comment
Read more

Normalization Types in DBMS

Normalization Types in DBMS First Normal Form (1NF) A relation will be 1NF if it contains an atomic value.  It states that an attribute of a table cannot hold multiple values. It must hold only single-valued attribute. First normal form disallows the multi-valued attribute, composite attribute, and their combinations. Example: Relation EMPLOYEE is not in 1NF because of multi-valued attribute EMP_PHONE. EMPLOYEE table: EMP_ID EMP_NAME EMP_PHONE EMP_STATE 14 John 7272826385, 9064738238 UP 20 Harry 8574783832 Bihar 12 Sam 7390372389, 8589830302 Punjab The decomposition of the EMPLOYEE table into 1NF has been shown below: EMP_ID EMP_NAME EMP_PHONE EMP_STATE 14 John 7272826385 UP 14 John 9064738238 UP 20 Harry 8574783832 Bihar 12 Sam 7390372389 Punjab 12 Sam 8589830302 Punjab Second Normal Form (2NF) In the 2NF, relational must be in 1NF.  In the second normal form, all non-key attributes are fully functional dependent on the primary key  Example: Let's assume, a school can ...
Post a Comment
Read more