Assessment of query execution performance using selected Business Intelligence tools and experimental agile oriented data modeling approach

Kód výsledku v IS VaVaI

<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F61989100%3A27510%2F15%3A86094609" target="_blank" >RIV/61989100:27510/15:86094609 - isvavai.cz</a>

Výsledek na webu

<a href="https://fedcsis.org/proceedings/2015/pliks/267.pdf" target="_blank" >https://fedcsis.org/proceedings/2015/pliks/267.pdf</a>

DOI - Digital Object Identifier

<a href="http://dx.doi.org/10.15439/2015F267" target="_blank" >10.15439/2015F267</a>

Jazyk výsledku

angličtina

Název v původním jazyce

Assessment of query execution performance using selected Business Intelligence tools and experimental agile oriented data modeling approach

Popis výsledku v původním jazyce

The paper deals with the assessment of an experimental data modeling approach which is intended to support the agile oriented data modeling. The approach is based on the Anchor Data Modeling technique and is applied on a multidimensional data model. The assessed approach is expected to facilitate more effective execution of queries in the data mart environment. The emphasis is placed on the comparison of the query execution performance using database schemas, each built using traditional and the experimental approach. The tests are done in the environment of selected modern Business Intelligence tools, and using two test queries with varying output dataset sizes. The results show that the use of the database schema, created according to the experimental data modeling approach, had positive impact on the querying performance in several cases. The magnitude of impact on the querying performance, however, varied depending on each query&apos;s respective resulting dataset size.

Název v anglickém jazyce

Assessment of query execution performance using selected Business Intelligence tools and experimental agile oriented data modeling approach

Popis výsledku anglicky

The paper deals with the assessment of an experimental data modeling approach which is intended to support the agile oriented data modeling. The approach is based on the Anchor Data Modeling technique and is applied on a multidimensional data model. The assessed approach is expected to facilitate more effective execution of queries in the data mart environment. The emphasis is placed on the comparison of the query execution performance using database schemas, each built using traditional and the experimental approach. The tests are done in the environment of selected modern Business Intelligence tools, and using two test queries with varying output dataset sizes. The results show that the use of the database schema, created according to the experimental data modeling approach, had positive impact on the querying performance in several cases. The magnitude of impact on the querying performance, however, varied depending on each query&apos;s respective resulting dataset size.

Druh

D - Stať ve sborníku

CEP obor

—

OECD FORD obor

10201 - Computer sciences, information science, bioinformathics (hardware development to be 2.2, social aspect to be 5.8)

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)

Rok uplatnění

2015

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

Proceedings of the 2015 Federated Conference on Computer Science and Information Systems

ISBN

978-83-60810-65-1

ISSN

2300-5963

e-ISSN

neuvedeno

Počet stran výsledku

7

Strana od-do

1327-1333

Název nakladatele

Polskie Towarzystwo Informatyczne

Místo vydání

Varšava

Místo konání akce

Łódź

Datum konání akce

13. 9. 2015

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

WRD - Celosvětová akce

Kód UT WoS článku

000376494300165