Column-oriented DBMS
A column-oriented DBMS (or columnar database) is a database management system (DBMS) that stores data tables as columns rather than as rows. Practical use of a column store versus a row store differs little in the relational DBMS world. Both columnar and row databases use traditional database 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 ETL and data visualization tools. However, by storing data in columns rather than rows, the database can more precisely access the data it needs to answer a query rather than scanning and discarding unwanted data in rows. Query performance is often increased as a result, particularly in very large data sets.
genre
primaryTopic
Column-oriented DBMS
A column-oriented DBMS (or columnar database) is a database management system (DBMS) that stores data tables as columns rather than as rows. Practical use of a column store versus a row store differs little in the relational DBMS world. Both columnar and row databases use traditional database 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 ETL and data visualization tools. However, by storing data in columns rather than rows, the database can more precisely access the data it needs to answer a query rather than scanning and discarding unwanted data in rows. Query performance is often increased as a result, particularly in very large data sets.
has abstract
A column-oriented DBMS (or col ...... larly in very large data sets.
@en
CODB (ang. column-oriented DBM ...... rtica, ParAccel and GreenPlum.
@pl
Eine Spaltenorientierte Datenb ...... nnten Datenbanksysteme folgen.
@de
Il sistema di gestione di basi ...... orizzazione basata sul valore.
@it
Une base de données orientée c ...... de la colonne se ressemblent.
@fr
列式数据库是以列相关存储架构进行数据存储的数据库,主要适合于 ...... 分配,主要适合于小批量的数据处理,常用于联机事务型数据处理。
@zh
列指向データベース管理システムは、データベース管理システム ...... ベース」(Columnar Database)とも呼ばれる。
@ja
Link from a Wikipage to an external page
Wikipage page ID
Wikipage revision ID
742.521.884
hypernym
comment
A column-oriented DBMS (or col ...... larly in very large data sets.
@en
CODB (ang. column-oriented DBM ...... j bazie danych wygląda to tak.
@pl
Eine Spaltenorientierte Datenb ...... nnten Datenbanksysteme folgen.
@de
Il sistema di gestione di basi ...... umero di dati simili tra loro.
@it
Une base de données orientée c ...... de la colonne se ressemblent.
@fr
列式数据库是以列相关存储架构进行数据存储的数据库,主要适合于 ...... 分配,主要适合于小批量的数据处理,常用于联机事务型数据处理。
@zh
列指向データベース管理システムは、データベース管理システム ...... ベース」(Columnar Database)とも呼ばれる。
@ja
label
Base de données orientée colonnes
@fr
CODB
@pl
Column-oriented DBMS
@en
Sistema di gestione di basi di dati orientato alle colonne
@it
Spaltenorientierte Datenbank
@de
列式数据库
@zh
列指向データベース管理システム
@ja