Alternative solution for the design and storage of rapidly changing dimensions in a data mart

Kód výsledku v IS VaVaI

<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F61989100%3A27510%2F16%3A86097780" target="_blank" >RIV/61989100:27510/16:86097780 - isvavai.cz</a>

Výsledek na webu

—

DOI - Digital Object Identifier

—

Jazyk výsledku

angličtina

Název v původním jazyce

Alternative solution for the design and storage of rapidly changing dimensions in a data mart

Popis výsledku v původním jazyce

Even in the modern era of data management and processing, it is good to try to revise older data modeling solutions because traditional data sources are still frequently used in the company decision-making as a part of the Business Intelligence system usage. This paper presents an evaluation of an alternative solution to the design and implementation of rapidly changing business dimensions&apos; property storage, which are commonly stored in a data mart. The solution is based on the application of the principles of a novel data modeling approach called the Anchor Data Modeling in the field of the design and implementation of a multidimensional data model. The approach is evaluated mainly from the SQL query execution performance perspective on a sample of 10 queries. The results show that the implementation of the approach had certain positive as well as negative impacts on the query execution performance and several other benefits related to the physical processing of queries in the environment of a modern relational database management system.

Název v anglickém jazyce

Alternative solution for the design and storage of rapidly changing dimensions in a data mart

Popis výsledku anglicky

Even in the modern era of data management and processing, it is good to try to revise older data modeling solutions because traditional data sources are still frequently used in the company decision-making as a part of the Business Intelligence system usage. This paper presents an evaluation of an alternative solution to the design and implementation of rapidly changing business dimensions&apos; property storage, which are commonly stored in a data mart. The solution is based on the application of the principles of a novel data modeling approach called the Anchor Data Modeling in the field of the design and implementation of a multidimensional data model. The approach is evaluated mainly from the SQL query execution performance perspective on a sample of 10 queries. The results show that the implementation of the approach had certain positive as well as negative impacts on the query execution performance and several other benefits related to the physical processing of queries in the environment of a modern relational database management system.

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

—

Návaznosti

I - Institucionalni podpora na dlouhodoby koncepcni rozvoj vyzkumne organizace

Rok uplatnění

2016

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 11th Scientific Conference Internet in the Information Society 2016

ISBN

978-83-65621-00-9

ISSN

—

e-ISSN

neuvedeno

Počet stran výsledku

13

Strana od-do

89-101

Název nakladatele

WSB Dąbrowa Górnicza, Polsko

Místo vydání

Dąbrowa Górnicza

Místo konání akce

Dąbrowa Górnicza

Datum konání akce

22. 9. 2016

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

EUR - Evropská akce

Kód UT WoS článku

000432782200007