columnstore

plural columnstores

1. data managementcomputingA database storage method that stores data tables by columns rather than rows, optimizing for analytical query performance.

   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

   2 more examples

   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