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 Online Transactional Processing (OLTP)

Chapter 182
Encyclopedia of Business Analytics and Optimization
Classical operative databases gather and manage data. OLTP focuses on short read and write transactions and a multi-user access. For OLTP workload, we mostly consider all features of entities. In such a scenario, only restricted resources and data are used per operation. In addition, ACID and other business operative requirements have to be considered.
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