Column-Oriented DBMS Platform

From GM-RKB
(Redirected from columnar DBMS)
Jump to navigation Jump to search

A Column-Oriented DBMS Platform is a DBMS platform that primarily uses a columnar data structures.



References

2022

  • (Wikipedia, 2022) ⇒ https://en.wikipedia.org/wiki/Column-oriented_DBMS Retrieved:2022-11-27.
    • A column-oriented DBMS or columnar DBMS is a database management system (DBMS) that stores data tables by column rather than by row. Benefits include more efficient access to data when only querying a subset of columns (by eliminating the need to read columns that are not relevant), and more options for data compression. However, they are typically less efficient for inserting new data.

      Practical use of a column store versus a row store differs little in the relational DBMS world. Both columnar and row databases can use traditional database query languages like SQL to load data and perform queries. Both row and columnar databases can become the backbone in a system to serve data for common extract, transform, load (ETL) and tools.


2020

Database Name Language Implemented in Notes
Apache Druid Java started in 2011 for low-latency massive ingestion and queries
Apache Kudu C++ released in 2016 to complete the Apache Hadoop ecosystem
Calpont InfiniDB C++
ClickHouse C++ released in 2016 to analyze data that is updated in real time
CrateDB Java
C-Store
Greenplum Database C
PostgreSQL cstore_fdw [1], vops [2] C cstore_fdw uses ORC format
MariaDB ColumnStore C & C++ formerly Calpont InfiniDB
MapD C++
Metakit C++
MonetDB C
Scylla (database) Open Source C++

2008