Column-oriented Database

Une base de données orientée colonnes est un système de gestion de base de données (SGBD) qui stocke les tableaux de données par colonne et non par ligne.

ClickHouse® is an open-source column-oriented database management system that allows generating analytical data reports in real-time.

• https://github.com/ClickHouse/ClickHouse
• https://clickhouse.com/clickhouse
• https://clickhouse.com/docs

OLAP stands for Online Analytical Processing. It is a broad term that can be looked at from two perspectives: technical and business. At the highest level, you can just read these words backward:

• Processing — Some source data is processed…
• Analytical — …to produce some analytical reports and insights…
• Online — …in real-time.