Columnar database

Concept and definition

Columnar database

What is Columnar database?

A columnar database is a type of database in which data is organised and stored in columns rather than rows. In a traditional relational database, data is stored in rows and each row represents an instance of an entity. In contrast, in a columnar database, each column represents a variable or attribute and all rows have the same attributes.

This type of data organisation is particularly suitable for data analysis and processing applications, including artificial intelligence and machine learning, as it allows faster and more efficient data retrieval for data aggregation and filtering operations.

Columnar databases are often used in big data applications and distributed processing environments, as they enable high performance in aggregation queries and analysis of large datasets. Some of the most popular columnar databases include Apache Cassandra, Apache HBase and Apache Druid.

« Back to glossary

Do you want to get in touch?

CDRs contain data that a telecommunications company collects about phone calls, such as time and length of call. This data can be used in analytical applications.
Fill the form
Share:
Sales KPIs. What they are and which are the best

Achieving business goals and tracking success is an important aspect of improving any business. In sales, measuring the progress of [...]

Read More »
Basic concepts for building commercial software with artificial intelligence

The first thing you need to know is the limits of AI and after mastering the basic concepts you will be able to build a large commercial software with intelligent [...]

Read More »
AI in the energy sector: main use cases

There is a consensus among executives of the world's leading companies about the crucial impact that Artificial Intelligence (AI) will have on the [...]

Read More »
What credit scoring is and why Artificial Intelligence will change it forever

Credit scoring is a system used to rate credits and thus try to automate the decision making process at the time of purchasing a loan, and to [...]

Read More »
See more entries
© Gamco 2021, All Rights Reserved - Legal notice - Privacy - Cookies