3 October 2012

The Object Relational Gap (updated)

The Object Relational Gap
transient persistent
classes tables
  • inheritance
attributes columns
objects rows
  • instance attribute
  • implicity ID: reference 
  • field
  • explicit ID: primary key 
relations relations
  • references
  • unidirectional 
  • ordered (lists) 
  • foreign keys
  • bidirectional 
behaviour centric data centric
  • navigate to object
  • behaviour based partitioning
  • methods 
  • operate on set
  • relation based partitioning
  • stored procedures 
    • tight behaviour-data coupling
    • triggers, constraints
    • data hiding, encapsulation


    • Permissions