Návrh a implementace datového skladu pro signalizační monitoring mobilní sítě

The goal of the thesis is to create a design and impelemnt a data warehouse for signaling monitoring of mobile network for A interface in O2 Czech Republic, a.s. The thesis consists of two basic parts, theoretical and empirical. Theoretical part of the thesis aims to analyze existing approaches to data warehouse developing and to assess current state of data warehouse technology and selected options of data warehouse optimalization on RDBMS Oracle. The thesis provides information about specifics of data warehousing in telecommunication industry. The empirical part is divided into eight chapters. The first chapter introduces basic information about the created data warehouse. The introduction is followed by analysis of hardware elements of the server which supporrts the data warehouse. Next chapter is dedicated to developed installation procedures for chosen operating system, DBMS, necessary drivers and supporting modules. Further chapter describes design of the created data warehouse and its optimalization. The information is followed by design and implementaion of ETL processes and supporting scripts. The thesis also includes analysis and configuration design of disk storage for the implemented data warehouse with regard to capabilities of selected hardware. The final chapter is dedicated to design and implementation of aggregation tables and mechanisms.