Diiference between OODBMS and ORDBMS

Definition:

Object-Relational databases extend the Relational Data Model

to address those weaknesses identified previously.

An Object-Relational database adds features associated with

object-oriented systems to the Relational Data Model.

MAJOR DIFFERENCE BETWEEN AN

ORDBMS AND AN OODBMS

OODBMSs try to add DBMS functionality to one

or more OO programming languages.

ORDBMSs

REVOLUTIONARY IN THAT THEY ABANDON SQL

ORDBMSs try to add richer data types and OO

features to a relational DBMS.

EVOLUTIONARY IN THAT THEY EXTEND SQL

CONSIDERATIONS

OODBMS - put more emphasis on the role of the client, i.e.,

Client side caching! This can radically improve long, process

intensive, transactions.       

ORDBMS - SQL is still the language for data definition,

manipulation and query – Still have Impedance Mismatch!

OODBMSs have been optimised to directly support objectoriented

applications and specific OO languages.

ORDBMSs are supported by most of the ‘major players’ in

the DBMS market place.       

Thanks to the Internet, the legal need to keep track of lots of business information, new marketing methods, and the explosion of data-intensive scientific progress, databases are being used more than ever before for storing and accessing information. There are currently three different models in use for database management systems: relational, object-oriented, and object-relational. This article introduces all three, and discusses their relative strengths and weaknesses.