Advantages and Disadvantages of ORDBMS (object relational database management system)


Advantages of ORDBMS

  1. Extend the relational data model by including object orientation and constructs and constructs to deal With added data types.
  2. Allow attributes of tuples to have complex types, including non-atomic values such as nested relations.
  3. Preserve relational foundations, in particular the declarative access to data, while extending modelling power.
  4. Upward compatibility with existing relational languages.

Disadvantages of ORDBMS

  1. Poor representation of 'real world' conceptual model — usually the relational schema does not correspond to real world entities.
  2. Difficult to change schema without affecting the applications; e.g., Y2K.
  3. Semantic overloading.
  4. Poor support for integrity and business rules.
  5. Fixed number of attributes and all attribute values must be atomic.
  6. Limited operations.
  7. Difficult to handle recursive queries.
  8. Impedance mismatch (when SQL is embedded in PLs).
  9. Poor navigational access.
  10. Short-lived transactions (strict locking and recovery mechanisms).