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

Result code in 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>

Result on the web

—

DOI - Digital Object Identifier

—

Result language

angličtina

Original language name

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

Original language description

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.

Czech name

—

Czech description

—

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)

Project

—

Continuities

I - Institucionalni podpora na dlouhodoby koncepcni rozvoj vyzkumne organizace

Publication year

2016

Confidentiality

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

Article name in the collection

Proceedings of the 11th Scientific Conference Internet in the Information Society 2016

ISBN

978-83-65621-00-9

ISSN

—

e-ISSN

neuvedeno

Number of pages

13

Pages from-to

89-101

Publisher name

WSB Dąbrowa Górnicza, Polsko

Place of publication

Dąbrowa Górnicza

Event location

Dąbrowa Górnicza

Event date

Sep 22, 2016

Type of event by nationality

EUR - Evropská akce

UT code for WoS article

000432782200007