Search the World's Largest Database of Information Science & Technology Terms & Definitions
InfInfoScipedia LogoScipedia
A Free Service of IGI Global Publishing House
Below please find a list of definitions for the term that
you selected from multiple scholarly research resources.

What is Column Store

Chapter 182
Encyclopedia of Business Analytics and Optimization
A column store is the storage of database entries in such a way that values of attributes are stored together. This enables a higher compression rate and data access for aggregation. It is developed for online analytical processing especially for attribute-wise data access, such as aggregations, groupings, or selections on single attributes of very large relations.
Published in Chapter:
Relational Data Access for Business Data Analytics
Veit Köppen (Otto-von-Guericke-University Magdeburg, Germany) and Andreas Lübcke (regiocom LLC, Magdeburg, Germany)
Copyright: © 2014 |Pages: 8
DOI: 10.4018/978-1-4666-5202-6.ch182
Abstract
The growing amount of data enables more complex business analytics. Data for business analytics is stored in databases or data warehouses. Analysts want to execute their queries under requirements in a suitable time horizon. An architectural decision has a significant influence on response times. Therefore, it is necessary not only to identify and weight analysis tasks, but also to decide on the storage architecture. The architectural design influences the query execution time up to factor 100. We present both architectures and their influence on the database workload. Classic row stores perform better on transactional analysis and column stores outperform the other in simple online analytical processing.
Full Text Chapter Download: US $37.50 Add to Cart
eContent Pro Discount Banner
InfoSci OnDemandECP Editorial ServicesAGOSR