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 codd‟s rules.
The following are the feature wise advantage of 10g over 9i
1. Jserver 2. ISQLPLUS
3. Flashback table
4. Flash back DB
