No description available.

This master´s thesis discusses concept of implementation for data governance. The theoretical part of this thesis is about data governance. It explains why data are important for company, describes definitoons of data governance, its history, its components, its principles and processes and fitting in company. Theoretical part is amended with examples of data governance failures and banking specifics. The main goal of this thesis is to create a concept for implementing data governance and its implementation in real company. That is what practical part consists of.

This thesis focus on creating data warehouse and process of its implementation. The content is: Introduction into data warhousing, implemetation of data warehouse and process of its population.

At a certain point of its life cycle, each data warehouse gets into a state in which the length of the ETL processing starts slowly approaching the acceptable limit. Even the slightest lapse means a hardly erasable time lag and the data supplies to users are increasingly delayed. Before the situation becomes more problematic, we need to react. This diploma thesis deals with the possible solutions of this problem- the ETL performance optimization. The main aim of the thesis is to propose the set of recommendations for the ETL process optimization and its presentation based on practical real world examples. While going through this thesis, the readers get inside the running of the real ETL optimization project. They learn how to proceed during its particular periods, what to avoid and how to reduce the risk level as much as possible. Moreover, the thesis mentions the prevention of the ETL performance loss and discusses the critical factors of the effective ETL process design. Although the proposed methods are described in a general perspective, the thesis is mainly focused on Oracle's database, which is its certain limitation. Also hardware optimization is not a part of the text. First chapters of the thesis describe the problem from the theoretical point of view, which is important for the correct understanding of the main content and the existing literature concerning this problematic is included here as well. Next sections describe the proposed methods and recommendations for the optimization of the ETL processes including tests and project results evaluation. They are mainly focused on the ETL process synchronization and the SQL code optimization areas. All the methods are presented of examples of the real project implemented by the author.

Cílem diplomové práce je návrh a implementace Business Intelligence v malé firmě, jako je personální agentura zabývající se poskytováním ?TEMPORARY HELP?. Požadavky na aplikaci BI jsou koncipovány na základě metodiky Balanced Scorecard. Teoretická část: popis základních principů a nástrojů konceptů BSC a BI včetně definování jejich vzájemného vztahu a specifických nároků daných užitím v malé firmě. Praktická část: ověření získaných poznatků z teoretické části práce v personální agentuře. V rámci BSC byly definovány konkrétní strategické cíle s měřítky a stanoveny strategické akce. Vybrané strategické cíle jsou sledovány vytvořenou BI aplikací v prostředí MS SQL 2000 a MS OFFICE XP.

Hlavním cílem diplomové práce (DP) je provedení analýzy prostředí a jednotlivých nástrojů na podporu Business Intelligence (BI) na platformě Oracle. Analýza zahrnuje komplexní proces BI řešení od instalace potřebných programových prostředků (databáze, BI balíky, dokumentace atd.) až po zprovoznění praktické demonstrační aplikace a zhodnocení celé platformy. Práce se skládá ze čtyřech hlavních částí. V první části uvádím čtenáře do problematiky BI. V druhé části analyzuji globální charakteristiky prostředí Oracle BI a porovnávám je s SQL Serverem. Třetí část obsahuje analýzu a komparaci systému Oracle BI se systémem SQL Server ve třech oblastech (oblasti zahrnují: extrakci ? transformaci ? natažení dat, analytické zpracování dat a reporting) včetně vyhodnocení uvedených oblastí podle několika kritérií. V jednotlivých oblastech zjišťuji zejména dílčí architektury, používané nástroje a jejich funkcionalitu. Poslední část doplňuje stručnou analýzu světového trhu OLAP technologií.

This diploma thesis deals with building of large Data Warehouses on Microsoft SQL Server 2008 platform. First part of the thesis discuss about news in MS SQL Server 2008, which I have considered as being important for Business Intelligence area. Following chapters are focused on approach to implementation of real Data Warehouse for Customs Administration of Czech Republic on MS SQL Server 2008 basis. These parts of the thesis cover specifics of the Customs Administration of Czech Republic, current state of Data Warehouse and reasons for migrating to MS SQL Server 2008. Further the thesis describes both logical and physical architecture of proposed solution and a way of implementation Data Warehouse on MS SQL Server 2008. The main aim of the thesis is to create a list of critical success factors (CSF) of building large Data Warehouses on MS SQL Server 2008 platform. It's not only plain list CSF, but rather the best practices for MS SQL Server Data Warehouses implementation. The most significant contribution of this thesis is that it offers instruction manual for designing and implementing large Data Warehouse on MS SQL Server basis. Background for the creation of summary of CSV and recommendations were vendor's publications and especially my own experience with the product. My colleagues from company Adastra gave me an advisory opinion as well.

The Teradata database system is specially designed for data warehousing environment. This thesis explores the use of Teradata in this environment and describes its characteristics and potential areas for optimization. The theoretical part is tended to be a user study material and it shows the main principles Teradata system operation and describes factors significantly affecting system performance. Following sections are based on previously acquired information which is used for analysis and optimization in several areas of described environment.

The primary objective of this work is to investigate the potential of utilizing Hadoop and Amazon Redshift in the Amazon Web Services ("AWS") cloud, in order to design and implement a data warehouse, the efficacy of which will be tested afterwards. Contributions of this work include: documenting the technologies in the AWS cloud in Czech, demonstration of the design and performance tests of the data warehouse and the ETL part. Another considerable benefit is the added value to the company for whom the project was designed, and which is currently using the output of the project.

The present diploma thesis focuses on the subject matter of large data warehouses under the aspect of their sustainable operation and development, seeking to analyze the key factors which influence the operation of data warehouses at large businesses. The thesis is divided into three main sections, preceded by a short theoretical introduction. The first part aims at explaining and illustrating the architecture of data warehouses, with the bulk of this section being devoted to a description of the key components of data warehouse solutions as a whole, and the various available alternatives for their technical implementation. The second section familiarizes the reader with the manner in which data warehouses are managed and operated, discussing the most important operational tasks in individual sub-sections. The final section focuses on working with client tools within the ETL platform of Informatica Powercenter. This work's original contribution lies in the comparison of how the design of individual components expresses itself in the simplicity and quality of routine operations. As a matter of fact, data warehouses can only be operated as conveniently and competently as they were designed and implemented. In this thesis of mine, I primarily draw on my immediate experience and acquired knowledge from data warehouse operations at a large domestic enterprise.