Assessment of query execution performance using selected Business Intelligence tools and experimental agile oriented 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%2F15%3A86094609" target="_blank" >RIV/61989100:27510/15:86094609 - isvavai.cz</a>
Result on the web
<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>
Alternative languages
Result language
angličtina
Original language name
Assessment of query execution performance using selected Business Intelligence tools and experimental agile oriented data modeling approach
Original language description
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's respective resulting dataset size.
Czech name
—
Czech description
—
Classification
Type
D - Article in proceedings
CEP classification
—
OECD FORD branch
10201 - Computer sciences, information science, bioinformathics (hardware development to be 2.2, social aspect to be 5.8)
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)
Others
Publication year
2015
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
Proceedings of the 2015 Federated Conference on Computer Science and Information Systems
ISBN
978-83-60810-65-1
ISSN
2300-5963
e-ISSN
neuvedeno
Number of pages
7
Pages from-to
1327-1333
Publisher name
Polskie Towarzystwo Informatyczne
Place of publication
Varšava
Event location
Łódź
Event date
Sep 13, 2015
Type of event by nationality
WRD - Celosvětová akce
UT code for WoS article
000376494300165