Columnar Database

Definition - What does Columnar Database mean?

A columnar database is a database management system (DBMS) that stores data in columns rather than in rows as relational DBMSs do. The main differences between a columnar database and a traditional row-oriented database are centered around performance, storage necessities and schema modifying techniques. The goal of this type of database is to effectively read and write data to and from the secondary storage in order to be able to speed up the processing time in returning a query.

A columnar database may also be known as a column-oriented database

Techopedia explains Columnar Database

The data that is stored appears in record order, meaning the entry in the first column is related to the entry in the second column and other columns if the entry appears in the same row. For example, the 100th entry in column 1 belongs to the same record as the 100th entry in column 2. This makes it possible for individual data to be accessed in columns as a group rather than accessing it individually and row by row. Data is stored from top to bottom rather than from left to right as in a row-oriented RDBMS.

Columnar databases are beneficial because the data can be highly compressed, which permits columnar operations to be performed at a fast pace. It is also self-indexing and uses less disk space when compared to an RDBMS. However, the loading process can take time depending on the size of data that is involved. It also becomes a challenge for the database if there are incremental loads, which adds problems in terms of system performance.

Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.