The main goal of this diploma thesis is to provide advice and recommendations to increase the effectiveness of Business Intelligence using Oracle database. More specifically, the focus of the thesis is the optimization of ETL processes and objects in a data warehouse. Tests to compare different optimization techniques are performed to meet the defined goal. These tests are based on common tasks solved in data warehouses on daily basis. Tests are also supported by publications of leading authors in Oracle environment. The second goal of this work is the implementation of appropriate optimization techniques to real ETL pro-cess in order to increase its effectiveness. Performance changes are compared and measured using metrics defined for the ETL process and requirements from client. Optimization techniques presented for main objectives are used to achieve the second objective. Contri-bution of the thesis is to show the most important optimization techniques and tips that every developer should know and be able to use effectively. Another added value is au-thor's practical experiences in real data warehouse environment.
| Identifer | oai:union.ndltd.org:nusl.cz/oai:invenio.nusl.cz:164047 |
| Date | January 2011 |
| Creators | Řeháček, Tomáš |
| Contributors | Pour, Jan, Kovář, Štěpán |
| Publisher | Vysoká škola ekonomická v Praze |
| Source Sets | Czech ETDs |
| Language | Czech |
| Detected Language | English |
| Type | info:eu-repo/semantics/masterThesis |
| Rights | info:eu-repo/semantics/restrictedAccess |
Page generated in 0.0046 seconds