columnstoreとは 意味・読み方・使い方

語源

From column +‎ store.

発音

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

名詞

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.

反意語

• rowstore