Wide Partition (Wide row pattern)

About

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)