|
|
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.
|
|
|
Application of metadata in business intelligence systems
Andrle, Ondřej ; Pour, Jan (advisor) ; Omacht, Jiří (referee)
The diploma thesis focuses on metadata as important means which are able to stop a trend of increasing costs of development, operation and maintenance of decision support systems -- Business Intelligence. The theoretical part of the thesis is elaborated based on such assumption. Its goal is to produce an extensive analysis of the term metadata -- starting with a general definition of the term, then dealing with the categorization and analyzing the issues and benefits. Further on, the term metadata management is discussed as well as metadata repository which is the key element of metadata solutions. The aim of the practical part of the thesis is to analyze the selected commercial metadata management solutions and answer the question whether there is currently a suitable comprehensive solution which would suit the needs of a chosen financial institution, Komerční banka. Furthermore, another question is discussed in the thesis and that is if a suitable solution is to either purchase a commercial solution or decide for own development. The analysis in both parts of the thesis, theoretical and practical, is mainly based on foreign sources, above all articles by specialists in the area of data warehousing, and numerous consultations with an expert on metadata from Komerční banka, Mr. Jiří Omacht.
|
|
|
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 ::
