Opis: The goal of this case study was to examine which implementation of the data warehouse will yield better results in the observed scenario – monitoring of energy consumption in public buildings.
Data warehouse (DW) is a type of database created with the goal of preparing data for analysis and reporting. We implemented two versions of DW, one based on the star and the other on the snowflake schema model.
Series of tests were conducted to evaluate implemented solutions. Statistical analysis showed that for the observed scenarios, implementation based on snowflake schema performs better, in both shorter ETL execution time and smaller size of DW.Ključne besede: data warehouse, dimensional model, star schema, snowflake schema, ETL processObjavljeno: 04.07.2016; Ogledov: 653; Prenosov: 77 Celotno besedilo (2,11 MB)