ePrints.FRI - University of Ljubljana, Faculty of Computer and Information Science

Building a data warehouse in an energy trading company

Matej Pintar (2016) Building a data warehouse in an energy trading company. EngD thesis.

Download (1299Kb)


    The main objective of the thesis is to present a project »Building a data warehouse in an energy trading company«. Thesis is divided into three sections. The first section contains a brief introduction to the characteristics of the electricity market in the case of Slovenian market. Second section starts with theoretical background of data warehousing, its concepts of data retrieval, consolidation and periodicity. It also contains a description of differences between normalized and dimensional data warehouse and differences between various types of online analytical processing cubes. The last section is divided into several chapters. Fourth chapter contains a brief description of a situation regarding data fragmentation in company GEN-I before the data warehouse implementation, provides some basic information about the project, shows data warehouse architecture and provides definition of dimensional model. Fourth chapter is concluded with description of MOLAP database scheme. Fifth, sixth and seventh chapters contains a description of some of the most exciting challenges and their solutions which were encountered during the development and implementation of the data warehouse. Thesis is concluded with a final word about the impact the project had after introducing it to the end users.

    Item Type: Thesis (EngD thesis)
    Keywords: Data warehouse, Dimensional modeling, MOLAP, In-Memory OLAP, Table partitioning, ColumnStore Index, Electricity energy markets, Microsoft SQL Server
    Number of Pages: 76
    Language of Content: Slovenian
    Mentor / Comentors:
    Name and SurnameIDFunction
    izr. prof. dr. Viljan Mahnič241Mentor
    Link to COBISS: http://www.cobiss.si/scripts/cobiss?command=search&base=51012&select=(ID=1536830147)
    Institution: University of Ljubljana
    Department: Faculty of Computer and Information Science
    Item ID: 3265
    Date Deposited: 04 Mar 2016 12:01
    Last Modified: 22 Mar 2016 14:50
    URI: http://eprints.fri.uni-lj.si/id/eprint/3265

    Actions (login required)

    View Item