Column Based Database

What is a Column Based Database?

Column Based Database also known as Column-oriented database management system (DBMS) stores data by column instead of row. By storing tables in columns, the database will access, query and search data by scanning the columns rather than rows.

Benefits of Column Based Database

Row-oriented databases store each record in one or more contiguous blocks on disk. Column-oriented databases store each column in one or more contiguous blocks. Each scheme is better-suited to different use cases.