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
|