|
| |
|
|
Development of methodics for performance comparison of data warehouse systems
Ronovský, Jan ; Pavlíček, Antonín (advisor) ; Meixner, Jiří (referee)
This thesis focuses on developing methodics for performance comparison of data warehouse systems. Firstly, the thesis defines data warehouses in various development stages of organization BI and describes knowledge about data warehouses. Methodics developed in the thesis describes architecture of standardized data warehouse, data flow between areas of data warehouse and processes in data warehouse. Understanding of these concepts is crucial for assurance of methodics applicability. Methodics offer logical progression of steps, which start and include testing of data warehouse systems. The contribution of the thesis is in having guide, what needs to be done when organization must do while testing various systems for data warehouses. Also it describes how this testing should be done on middle level detail, which is the absolute minimum level of abstraction that can be done due to wide applicability of methodics. Methodics offers solution to the problem of performance comparison when organization need to answer question - Which data warehouse system should we use in our organization? However, methodics expects already some knowledge about data warehouse content.
|
|
|
Proposal and application of model for testing DWH implementation on Teradata platform
Lysáček, Jakub ; Matuštík, Ondřej (advisor) ; Meixner, Jiří (referee)
The thesis focuses on application of theory of software testing in data warehousing area. The main goal of the thesis is an introduction of selected theory of software testing and analogical use of the theory in data warehousing environment. Part of the main goal is an introduction of architectonic model of testing process and later on focusing on part of testing which is problematic in data warehousing area. Partial goal of the thesis is validation of problematic part of the model using practical scenario. This partial goal is divided into two parts. First part focuses on requirements gathering and categorizing their priority. Second part focuses on demonstrating how project requirements, available resources and Teradata specific environment manipulate with the testing process. Theoretical part summarizes selected theory of software testing which is later applied in the area of data warehouse testing. The chapter introduces phases of data warehouse testing and specific goals of each testing phase. Chapter also describes model FURPS which is used to classify software quality dimensions a selected methods of requirements priority classification. An architectural model of testing process and its entities are described in the second part of theory. The theory then focuses on problematic part of the model which is requirements gathering and classification of their priority and demonstrates the influence of time, quality requirements and available resources on the overall process of testing. Practical part introduces a real-life scenario which demonstrates an application of described theory, namely requirements gathering, classification of requirements priorities and assigning dimensions of quality. The next part demonstrates the influence of available resources and requirements on the scope of testing. The outcome of the practical part of the thesis is that requirements gathering and classification of their priorities allows us to classify and sort scope of testing into logical and clear units, assign roles and their responsibilities and flexibly react on changes of project requirements. The thesis also points out that there are risks associated with changes of scope and emphasizes on the need of their evaluation.
|
|
| |
|
|
Architecture of banking data warehouse
Bureš, Petr ; Pour, Jan (advisor) ; Meixner, Jiří (referee)
The thesis deals with banking data warehouse and the factors which influence their architecture. The goal of the thesis is to analyze the influence by fulfilling the three partial goals -- defining banks' requirements on data warehouses, analyzing a data warehouse in the real banking environment and making a comparison of the Czech banks' data warehouses. First, the thesis briefly introduces elements of business intelligence (BI) and data warehousing. Second, after deducing reasons for BI implementation in commercial banks, the requirements on data warehouse are synthesized and their impacts on the data warehouse architecture are analyzed. Finally, conclusions of the thesis are applied on creation of the survey which enables comparison of the Czech banks' data warehouses. The thesis applies the theory of relationship between BI maturity, requirements on BI and data warehouse architecture and creates a tool for evaluating and comparing the data warehouses of banks with respect to bank's BI maturity and predisposition for a particular architecture. The tool can serve as a basis for a general tool able to compare data warehouses in other branches of economy and can help to better understand relations between organizations' need for information, BI solutions used and underlying data warehouses.
|
guest ::
RSS feed.