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

Previous slide

Back to first slide

View graphic version