columnstore
noun/ˈkɒl.əm.stɔ(ɹ)/
Etymology From column + store.
1
Computing, Databases, Engineering, Mathematics, Natural sciences, Physical sciences, Sciences A database storage method that stores data tables by columns rather than rows, optimizing for analytical query performance.
Data management
- The HPDB is the functional repository for time-series market data. Unlike a standard database, which reads rows of data, HPDBs are columnstore databases.2011, Paul Zubulake, Sang Lee, The High Frequency Game Changer: How Automated Trading Strategies Have Revolutionized the Markets, illustrated edition, John Wiley & Sons, page 112:
- In order to achieve optimal performance, PolyBase is capable of dynamically creating columnstore tables, parallalizing data extraction from Hadoop and Azure sources, or pushing computations on Hadoop-based data to Hadoop clusters where necessary.2017 November 30, Drazena Gaspar, Ivica Coric, editors, Bridging Relational and NoSQL Databases (Advances in Data Mining and Database Management), Coric, page 219:
1 more example
- When first introduced, batch mode execution was closely integrated with the columnstore storage format.2024, Pedro Lopes, Pam Lahoud, Learn T-SQL Querying: A guide to developing efficient and elegant T-SQL code, 2 edition, Packt Publishing Ltd, page 75:
- Antonyms
- rowstore