columnstore

English

Etymology

From column +‎ store.

Pronunciation

  • IPA(key): /ˈkɒl.əm.stɔ(ɹ)/

Noun

columnstore (plural columnstores)

  1. (databases, data management) A database storage method that stores data tables by columns rather than rows, optimizing for analytical query performance.
    • 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:
      The HPDB is the functional repository for time-series market data. Unlike a standard database, which reads rows of data, HPDBs are columnstore databases.
    • 2017 November 30, Drazena Gaspar, Ivica Coric, editors, Bridging Relational and NoSQL Databases (Advances in Data Mining and Database Management), Coric, page 219:
      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.
    • 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:
      When first introduced, batch mode execution was closely integrated with the columnstore storage format.

Antonyms

This article is issued from Wiktionary. The text is available under Creative Commons Attribution-Share Alike 4.0 unless otherwise noted. Additional terms may apply for the media files.