UNIT - 6 (DBMS)
ORDBMS
An object-relational database system is a relational database system that has
been extended to incorporate object-oriented characteristics. Database
schemas and the query language natively support objects, classes, and
inheritance. Furthermore, it permits data model expansion with new data types
and procedures, exactly like pure relational systems. Oracle, DB2, Informix,
PostgreSQL (UC Berkeley research project), etc. are some of the ORDBMSs.
Advantages of ORDBMS
● SQL Support: While ORDBMS supports the structures of the SQL
query language, they are quite flexible when tested against query
language make it easier to handle complex queries unlike OODBMS.
● Scalability: It is easier and can accommodate large data sets as
compared to OODBMS due to the fact that it retains the structure of
relational databases.
● Interoperability: ORDBMS appears to offer better compatibility with
the conventional RDMS thus making it easy to migrate from the
conventional normal database to more OOD respectively.
Disadvantages of ORDBMS
● Complexity in Implementation: Although many object-oriented
notions are supported by ORDBMS their representation using
● SQL
● can be problematic.
● Overhead: The combination in a hybrid approach causes a certain
overhead which does have its influence in cases where only
object-oriented or tabular representations are needed.
What is OODBMS?
OODBMS stands for Object-Oriented Database Management System. It is a
DBMS where data is represented in the form of objects, as used in
object-oriented programming. OODB implements object-oriented concepts
such as classes of objects, object identity, polymorphism, encapsulation, and
inheritance. An object-oriented database stores complex data as compared to
a relational database. Some examples of OODBMS are Versant Object
Database, Objectivity/DB, ObjectStore, Cache, and ZODB.
Advantages of OODBMS
● Complex Data Representation: This is because, through
OODBMS, hard dependencies can be well modeled to capture
flexibility such as inheritance, encapsulation, and polymorphism.
● Direct Mapping: Here, objects of OODBMS match with the objects
in programming languages, and so there is less difference between
them, which is known as impedance.
● Reusability: Lectures such as inheritance make it possible to use
existing code thereby shortening development time.
Disadvantages of OODBMS
● Complexity: The key working principle in an OODBMS is that the
OODBMS is an implementation level of OOD, therefore, is more
complex than traditional relational databases.
● Limited Query Support: OODBMS does not support queries such
as SQL meaning there is little flexibility when it comes to querying.
● Lack of Standardization: OODBMS do not contain such standards
as is the case with relational databases hence making the interfaces
across different plates forms to be inconsistent.
Difference Between OODBMS and ORDBMS
OODBMS ORDBMS
It stands for Object Oriented It stands for Object Relational
Database Management System. Database Management System.
Object-oriented databases, like An object-relational database is one
Object Oriented Programming, that is based on both the relational
represent data in the form of objects and object-oriented database
and classes. models.
ORDBMS adds object-oriented
OODBMSs support ODL/OQL.
functionalities to SQL.
Every object-oriented system has a Keys, entity integrity, and referential
different set of constraints that it can integrity are constraints of an
accommodate. object-oriented database.
The efficiency of query processing is
Processing
low.
