Analysis of Query Execution Performance in Context of a Traditional and Agile Oriented Multidimensional Data Modeling Approach
The result's identifiers
Result code in IS VaVaI
<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F61989100%3A27510%2F14%3A86090187" target="_blank" >RIV/61989100:27510/14:86090187 - isvavai.cz</a>
Result on the web
—
DOI - Digital Object Identifier
—
Alternative languages
Result language
angličtina
Original language name
Analysis of Query Execution Performance in Context of a Traditional and Agile Oriented Multidimensional Data Modeling Approach
Original language description
In this paper we assess aspects of the physical processing of database queries executed in the environment of traditional variant of a multidimensional data model in contrast with the variant based on the construction of an anchor schema. These schema variants relate to the field of Business Intelligence system application in organizations for which the speed of complex business question type query execution is an important success factor. Anchor data modeling has the potential to offer noticeable benefits to the field of the multidimensional data model design ? these are also briefly described in the paper. We assess physical processing factors of the query execution and we analyse results using the regression analysis method. Results show predictorswith significant explanatory power that describe substantial amount of variability in the dependent variable (average query execution times). The conclusions indicate several interesting that are useful for further analysis of differences
Czech name
—
Czech description
—
Classification
Type
D - Article in proceedings
CEP classification
IN - Informatics
OECD FORD branch
—
Result continuities
Project
<a href="/en/project/EE2.3.20.0296" target="_blank" >EE2.3.20.0296: Research team for modelling of economic and financial processes at VSB-TU Ostrava</a><br>
Continuities
P - Projekt vyzkumu a vyvoje financovany z verejnych zdroju (s odkazem do CEP)<br>S - Specificky vyzkum na vysokych skolach
Others
Publication year
2014
Confidentiality
S - Úplné a pravdivé údaje o projektu nepodléhají ochraně podle zvláštních právních předpisů
Data specific for result type
Article name in the collection
MEKON : conference proceedings of MEKON 2014 : selected papers : 16th international conference : February 5-6, 2014, Ostrava, Czech Republic
ISBN
978-80-248-3396-5
ISSN
1805-9945
e-ISSN
—
Number of pages
13
Pages from-to
105-117
Publisher name
VŠB-Technical University of Ostrava
Place of publication
Ostrava
Event location
Ostrava
Event date
Feb 5, 2014
Type of event by nationality
EUR - Evropská akce
UT code for WoS article
—