Wide Partition (Wide row pattern)


Wide Partition is a data modeling pattern where multiple related rows are grouped in a partition in order to support fast access to multiple rows in a single query (within the partition).

This pattern model primarily transactional event such as:

  • hotel reservation (all available rooms for a particular date)
  • balance (all transactional rows in one period)

Powered by ComboStrap