====== Column-oriented Database ======

Une [[wpfr>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.

===== Softwares =====

==== ClickHouse ====

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

[[/glossaire/OLAP|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.