|
|
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 ::
