|
|
Metadata integration in data warehouse
Volf, Karel ; Matějka, Martin (advisor) ; Novotný, Ota (referee)
This diploma thesis aim at the implementation of metadata in the context of data warehouses and Business Intelligence. Metadata can provide significant benefits to the organization, help address regulatory requirements, and increase the use of BI tools to prevent user denial. The main goals of the diploma thesis are the metadata integration according to the theoretical knowledge from the first part of this thesis and the practical implementation of the solution of consolidating business and technical metadata in the second part of the thesis. The first chapter defines the goals of the work and the expected benefits. The second chapter defines the concept of metadata, types and standards. Chapter three provide metadata context in the perspective of company's data governance, and summarize an analytical market for metadata and data integration tools. The fourth chapter evaluates the usability of metadata based on research on the subject. The fifth chapter describes one of the possible metadata integration solutions according to the theoretical knowledge summarized in the preceding chapters. The sixth chapter summarizes the practical experience of implementing the solution into the insurance company BI environment. The main contribution of the thesis is the description of implementation of the real solution and its evaluation.
|
|
|
MS SQL Server BI Platform Metadata Management
Havlíček, Ondřej ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
The main goal of this thesis is to propose and evaluate possible solutions how to manage metadata of the Business Intelligence systems built on the MS SQL Server platform in order to meet the requirements specified by CleverDecision, s.r.o.The goal is reached by a study of the available sources, consultations with the emloyees of the company and by a practical exploration of the potentialities of the MS SQL Server and related tools. The first contribution of this thesis is an exploration of the subject of metadata in Business Intelligence. The second one is the fullfilment of the company's requirements. In doing so, Adrienne Tannenbaums's methodical process of analysis and design of a metadata solution was partially applied. Also, the possible solutions were proposed and evaluated and the recommended solution was tried out and illustrated. The thesis begins with a explanation of significance of metadata in Business Intelligence. Afterwards, metamodels, metadata standards and metadata solution are introduced. It is followed by the methodical process which analysis in particular the beneficients of metadata, their requirements, the sources of metadata in MS SQL Server and the architecture of metadata models. Then, the individual alternatives are evaluated and the recommended one is illustrated in practice.
|
guest ::
