Column-oriented DBMS
A column-oriented DBMS or columnar DBMS is a database management system (DBMS) that stores data tables by column rather than by row. 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 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.
influenced
Wikipage disambiguates
Amazon RedshiftApache AccumuloApache ArrowApache AvroApache CarbonDataApache DruidApache ImpalaApache KuduApache ORCApache ParquetC-StoreCBATClickHouseClick pathClustrixColumn-based analytical technologyColumn-oriented databaseColumn-store architectureColumn (database)Column oriented databaseColumn storageColumn storeColumnar databaseCorrelation databaseData warehouseDatabaseDatabase administrationDatabase engineDatabase normalizationDatabase storage structuresEXtremeDBExasolGio WiederholdGraph databaseGreenplumHector (API)IBM BLU AccelerationIn-database processingIn-memory processing
Link from a Wikipage to another Wikipage
influenced
primaryTopic
Column-oriented DBMS
A column-oriented DBMS or columnar DBMS is a database management system (DBMS) that stores data tables by column rather than by row. 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 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.
has abstract
A column-oriented DBMS or colu ...... carding unwanted data in rows.
@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
Un sistema gestor de base de d ...... ara ciertas cargas de trabajo.
@es
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
page length (characters) of wiki page
Wikipage revision ID
1.025.502.007
Link from a Wikipage to another Wikipage
wikiPageUsesTemplate
hypernym
type
comment
A column-oriented DBMS or colu ...... carding unwanted data in rows.
@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
Un sistema gestor de base de d ...... as en lugar de en filas, la ba
@es
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
Sistema gestor de base de datos orientado a columnas
@es
Spaltenorientierte Datenbank
@de
列式数据库
@zh
列指向データベース管理システム
@ja