The IRMA Community
Newsletters
Research IRM
Click a keyword to search titles using our InfoSci-OnDemand powered search:
|
Relational Data Access for Business Data Analytics
|
|
Author(s): Veit Köppen (Otto-von-Guericke-University Magdeburg, Germany)and Andreas Lübcke (regiocom LLC, Magdeburg, Germany)
Copyright: 2014
Pages: 8
Source title:
Encyclopedia of Business Analytics and Optimization
Source Author(s)/Editor(s): John Wang (Montclair State University, USA)
DOI: 10.4018/978-1-4666-5202-6.ch182
Purchase
|
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.
Related Content
|
Dina Darwish.
© 2024.
48 pages.
|
|
Dina Darwish.
© 2024.
51 pages.
|
|
Smrity Prasad, Kashvi Prawal.
© 2024.
19 pages.
|
|
Jignesh Patil, Sharmila Rathod.
© 2024.
17 pages.
|
|
Ganesh B. Regulwar, Ashish Mahalle, Raju Pawar, Swati K. Shamkuwar, Priti Roshan Kakde, Swati Tiwari.
© 2024.
23 pages.
|
|
Pranali Dhawas, Abhishek Dhore, Dhananjay Bhagat, Ritu Dorlikar Pawar, Ashwini Kukade, Kamlesh Kalbande.
© 2024.
24 pages.
|
|
Pranali Dhawas, Minakshi Ashok Ramteke, Aarti Thakur, Poonam Vijay Polshetwar, Ramadevi Vitthal Salunkhe, Dhananjay Bhagat.
© 2024.
26 pages.
|
|
|