#Day10 - Data Layout (Row-Based vs Column-Based)

A series of posts to understand databases better

Before we dive deeper into the different data layouts on disk, it is important to understand the various data layout patterns. In a database, there are different ways in which data is written to disk, including row-based and column-based data layout.

1. Row-based storage: In row-based storage, data for a single row of a table is stored together in one block…