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 Row Stores

Chapter 182
Encyclopedia of Business Analytics and Optimization
This storage type is dominant in relational databases. It is optimized for transactional processing and stores all attributes sequentially for each data object.
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