Classification Based on Disk Layout

There are two types of databases classification based on the layout of the data on disk:

• Row-oriented

• Column-oriented

Row-oriented

The row-oriented database organizes data by entity, keeping all the attributes associated with the same entity next to each other. This organization method uses a tabular data format with a row representing an entity and a column representing attributes. In short, row-oriented databases partition data horizontally.

Since disk memory uses blocks as an abstraction to store and retrieve records, modeling individual records to fit inside a block or contiguous blocks allows for efficient data retrieval. As a result, a row-oriented database is optimized for reading and writing records efficiently.

The queries on row-oriented databases are often short-lived and targeted. These databases are generally used in transactional and web applications, where latency is a prime concern.

Advantages of row-oriented databases

• Allows for easy insertion, update, and deletion of a small batch of records.

• Uses point-in-time queries to fetch an individual ...