Understand Columnar and Row-Based Database

An important step before choosing the database

Xiaoxu Gao
Towards Data Science
5 min readOct 28, 2022

--

Photo by Campaign Creators on Unsplash

In database systems, data can be stored in two ways: row-oriented data stores and column-oriented data stores. By changing the way data is stored on the hard drive of the computer, we can make a big impact on the database’s performance. The choice also determines whether it is optimized for transactional or…

--

--

I’m a Developer with a focus on Python and Data Engineering. I write stuff to talk to myself and the world. You can find me on linkedin.com/in/xiaoxugao/.