OODBMS vs ORDBMS

• ORDBMS vs. ORDBMS
• similarities: both support user-defined ADTs, constructed types, reference types,
  object identity, query language
• differences: ORDBMSs add new data types to RDBMS; OODBMSs add

DBMS functionalities to a programming language

• Integration with host language
• OODBMS: seamless integration with C++/Small talk
• ORDBMS: integration is only through embedded SQL in a host language

• Application requirement
• OODBMS:
• few large objects fetched occasionally: few disk I/O
• long duration transactions on in-memory objects
• ability to cache objects in memory
• ORDBMS:
• large collection of data
• extensive disk I/O
• short transactions

• Query language
• OODBMS:
• Query processing is relatively inefficient
• No standard available
• ORDBMS:
• Query facilities is the centerpiece
• SQL-based standards available: SQL3, SQL4

An object database (also object-oriented database) is a database model in which information is represented in the form of objects as used in object-oriented programming.

oRdbms-An object-relational database (ORD), or object-relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in ...