[prev] 80 [next]

Data Distribution

Partitioning/distributing data
  • where to place (parts of) tables
    • determined by usage of data  (locality, used together)
    • affects communication cost ⇒ query evaluation cost
  • how to partition data within tables
    • no partitioning ... whole table stored on ≥1 DBMS
    • horizontal partitioning ... subsets of rows
    • vertical partitioning ... subsets of columns
Problem: maintaining consistency