[prev] 29 [next]

Classical DBMSs

Assumptions made in conventional DBMSs:
  • data is sets of tuples; tuples are lists of atomic values
  • data values can be compared precisely (via =, >, <, ...)
  • filters can be described via boolean formulae
  • SQL/PLpgSQL can handle all data manipulation
  • transaction-based consistency is critical
  • data stored on disk, processed in memory
  • data transferred in blocks of many tuples
  • disk memory cost is most expensive in system
  • disks are connected to processors via fast local bus