Object Relational Database is the extended version of relation database. One extra concept has been imposed which is the object concept, which leads to proper memory management. Anything that gets stored in an object relational database is known as a one-one object.
Let us discuss What is an Object-Relational Database or Object-Relational DBMS? and the Advantages of Object-Relational Database over a Relational Database.
Before start this topic, Please read about SQL Introduction
Contents
Object Relational Database
ORDBMS stands for Object Relational Database Management Systems. It is a part of a database management system that stores data in related tables.
An ORDBMS is a database management system that is a hybrid between the object-oriented model (OODBMS) and the relational model (RDBMS).
Almost all modern database management systems such as PostgreSQL, Oracle, SQL Server, Informix etc. are based on the Object-Relational Database Management System.
Feature of Object Relational Database/ORDBMS
- Class
- Object
- Abstraction
- Encapsulation
- Polymorphism
- Inheritance
- Exception Handling
Class:
It is template, style or blueprint which does not have any physical existence. It is collection of properties and behavior of similar type objects.
Object:
Object has its physical existence having its own property and behavior. It is instance of a class.
Abstraction:
Abstraction is concept through which essential part of an object will be represented having the background detail. Abstraction leads to data hiding and data hiding leads to data security.
Encapsulation:
Wrapping data of members and member function under one module is known as encapsulation where each module is known as a class.
Polymorphism:
Polymorphism is a concept through which one object behavior differently in diff. diff. circumstances depending a requirement.
Inheritance:
Using inheritance concept of member and member function of one object can be reused in another. It leads to reusability and reusability leads to less amount of coding.
Exception Handling:
Using this concept user can handle the abnormal behavior of a program. Whenever an exception occur during runtime system control will navigate to exception block (catch), handles the exception and exit out of the program normally.
Due to above feature makes Object Relational Database/ORDBMS powerful and flexible.
Advantages of Object Relational Database over Relational Database
- Support for user defined data type
- Support for multimedia
- High quality server feature
Support for user defined data type
ORDBM support s user defined data type i.e. user can designed its own data type either to declare column of a table or to declare a variable in PL/SQL in Oracle or stored procedure in Server.
Support for multimedia
ORDBM not only support storage of conventional data such as character, number, data etc but also it is capable to store multimedia files such as JPG, GIP, WMF, AVI etc. type of files.
High quality server feature
ORDBM is powerful for its high quality server feature which includes security and processing capacity of a server. It supports three their security system->client label -> network label ->server label and it support 512 petabyte of processing memory to process concurrent information.
As because ORDBM based on the theory of relational architecture. It supports maximum Codd‘s rules so it otherwise known as fully relational. An ORDB supports up to eleven codd‟s rules.
Warm UP :
- ORDBMS stands for Object Relational Database Management Systems. It is a part of database management system that stores data in related tables.
- ORDBMS has great feature such as Class, Object, Abstraction, Encapsulation, Polymorphism, Inheritance and Exception Handling
- Object Relational Database also support for user defined data type, multimedia file, high quality server feature
Reference Link
Please read more about Object Relational Database Management System / ORDBMS, Relational Data Base Management System / RDBMS and Object-Oriented Data Base Management System / OODBMS
