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:
Artificial intelligence against delinquency and non-payments in companies

The current scenario we are experiencing in Spain with the COVID-19 health crisis has led to many companies having to carry out ER [...]

Read More »
What is factoring and when to use it in your company?

When seeking financing for companies, one of the most widely used formulas today is factoring. This is a resource that is not always [....]

Read More »
Digital Transformation in SMEs

Nowadays digital transformation is key in any type of business. The 40% of Spanish companies will not exist in its current form in the next few [...]

Read More »
What is Artificial Intelligence doing today for the financial sector?

The Official Chamber of Commerce of Seville, in collaboration with the Spanish Institute of Financial Analysts (IEAF), offered last March 16th [...]

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