OOP (lecture 11)

Part 1: Limits of Conventional RDBMs

Limit of Conventional databases

  1. Good at large number of rows, but only with a few types (columns)
  1. Hard to have design changes propagate throughout many object
  1. Not good at version control of the database, and working with a large number of Devs
  1. Not good at handling long transactions

Limit of Relational databases

  1. Normalisation - leads to real world objects becoming abstracted, this leads to many joins during query processing
  1. Passive data - behaviour of data that is not related to data

OODBs can solve this, they can store the structure of complex objects and their functionally is held

Part 2: Storing Objects (Object types)

Objects types have:

  1. attributes
  1. methods that define its behaviour
  1. associations - links to other objects
Object diagram

Part 3: Problems with OODBMS

Strats for OODB development

Object Relational Database Management Systems

Classes and Object types - metadata

Attributes - data