Comparison of multidimensional database schema querying results using ordered and unordered dimensional attributes data
The result's identifiers
Result code in IS VaVaI
<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F61989100%3A27510%2F15%3A86093669" target="_blank" >RIV/61989100:27510/15:86093669 - isvavai.cz</a>
Result on the web
—
DOI - Digital Object Identifier
—
Alternative languages
Result language
angličtina
Original language name
Comparison of multidimensional database schema querying results using ordered and unordered dimensional attributes data
Original language description
The paper deals with the analysis of possible effects of the preordering of Attribute relations' data values in the anchor database schema on the query execution performance. The anchor data modeling technique is studied due to its purpose of supportingagile oriented data warehouse development process with expected benefits in the query execution performance field. The analysis is carried out using paired two-sample statistical test and particular variables are commented in more detail. The results show that on the 5% level of significance there is no statistical evidence of differences between the preordering and default anchor schema related query execution results, in comparison with results obtained for the standard star schema. Despite that thereare cases of queries where the preordering had its effect on the query execution performance.
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)
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
Strategic Management and its Support by Information Systems 2015 : proceedings of the 11th international conference : May 21st-22nd, Uherské Hradiště, Czech Republic
ISBN
978-80-248-3741-3
ISSN
—
e-ISSN
—
Number of pages
8
Pages from-to
431-438
Publisher name
VŠB - Technical University of Ostrava
Place of publication
Ostrava
Event location
Uherské Hradiště
Event date
May 21, 2015
Type of event by nationality
WRD - Celosvětová akce
UT code for WoS article
—