The Comparison of Anchor and Star Schema from a Query Performance Perspective

Result code in IS VaVaI
<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F61989100%3A27510%2F12%3A86084671" target="_blank" >RIV/61989100:27510/12:86084671 - isvavai.cz</a>
Result on the web
<a href="http://www.waset.org/journals/waset/v71/v71-201.pdf" target="_blank" >http://www.waset.org/journals/waset/v71/v71-201.pdf</a>
DOI - Digital Object Identifier
—

Result language
angličtina
Original language name
The Comparison of Anchor and Star Schema from a Query Performance Perspective
Original language description
Today's business environment requires that companies have access to highly relevant information in a matter of seconds. Modern Business Intelligence tools rely on data structured mostly in traditional dimensional database schemas, typically represented by star schemas. Dimensional modeling is already recognized as a leading industry standard in the field of data warehousing although several drawbacks and pitfalls were reported. This paper focuses on the analysis of another data warehouse modeling technique - the anchor modeling, and its characteristics in context with the standardized dimensional modeling technique from a query performance perspective. The results of the analysis show information about performance of queries executed on database schemas structured according to principles of each database modeling technique
Czech name
—
Czech description
—

Type
J<sub>x</sub> - Unclassified - Peer-reviewed scientific article (Jimp, Jsc and Jost)
CEP classification
IN - Informatics
OECD FORD branch
—

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

Similar results(10)