Rows vs Columnar Databases

This lesson explains the differences between row and columnar databases.

Rows vs Columnar Databases

Databases are frequently used to store data. They do so in a manner different from how we visually perceive data arranged in rows. TData is stored in two possible formats:

  • Row Format
  • Columnar Format

We are already familiar with databases that use the row format. These are the traditional relational databases such as MySQL, PostgreSQL, Oracle, and others Row format databases store records as rows in a table. A typical representation of our example Car table, consisting of four columns when stored in a relational database, is like this:

Get hands-on with 1200+ tech skills courses.