Analysis of Query Execution Performance in Context of a Traditional and Agile Oriented Multidimensional Data Modeling Approach

Kód výsledku v 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>

Výsledek na webu

—

DOI - Digital Object Identifier

—

Jazyk výsledku

angličtina

Název v původním jazyce

Analysis of Query Execution Performance in Context of a Traditional and Agile Oriented Multidimensional Data Modeling Approach

Popis výsledku v původním jazyce

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

Název v anglickém jazyce

Analysis of Query Execution Performance in Context of a Traditional and Agile Oriented Multidimensional Data Modeling Approach

Popis výsledku anglicky

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

Druh

D - Stať ve sborníku

CEP obor

IN - Informatika

OECD FORD obor

—

Projekt

<a href="/cs/project/EE2.3.20.0296" target="_blank" >EE2.3.20.0296: Výzkumný tým pro modelování ekonomických a finančních procesů na VŠB-TU Ostrava</a><br>

Návaznosti

P - Projekt vyzkumu a vyvoje financovany z verejnych zdroju (s odkazem do CEP)<br>S - Specificky vyzkum na vysokych skolach

Rok uplatnění

2014

Kód důvěrnosti údajů

S - Úplné a pravdivé údaje o projektu nepodléhají ochraně podle zvláštních právních předpisů

Název statě ve sborníku

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

—

Počet stran výsledku

13

Strana od-do

105-117

Název nakladatele

VŠB-Technical University of Ostrava

Místo vydání

Ostrava

Místo konání akce

Ostrava

Datum konání akce

5. 2. 2014

Typ akce podle státní příslušnosti

EUR - Evropská akce

Kód UT WoS článku

—