Object Relational Database Management System (ORDBMS)

Oracle, PL SQL, SQL Server,

Object Relational DBMS :
   “It is the extended version of relation database. One extra concept has been imposed that is object concept, which leads to proper memory management. Anything get stored in object relation database is known as one-one object.”

Feature of ORDBMS
1. Class
2. Object
3. Abstraction
4. Encapsulation
5. Polymorphism
6. Inheritance
7. 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:
It has its physical existence having its own property and behavior. It is instance of a class.

Abstraction:
It 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:
That is a concept through which one object behavior differently in diff. diff. circumstances depending a requirement.

Inheritance:
Using this 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.

Above feature makes ORDBMS powerful and flexible.

Advantages of ORDB or over RDB
1. Support for user defined data type
2. Support for multimedia
3. High quality server feature
4. Fully relational

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.

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.

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 pat bytes 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 codds rules.

The following are the feature wise advantage of 10g over 9i
1. Jserver
2. ISQLPLUS
3. Flashback table
4. Flash back DB

0 Comments