This diploma thesis deals with building of large Data Warehouses on Microsoft SQL Server 2008 platform. First part of the thesis discuss about news in MS SQL Server 2008, which I have considered as being important for Business Intelligence area. Following chapters are focused on approach to implementation of real Data Warehouse for Customs Administration of Czech Republic on MS SQL Server 2008 basis. These parts of the thesis cover specifics of the Customs Administration of Czech Republic, current state of Data Warehouse and reasons for migrating to MS SQL Server 2008. Further the thesis describes both logical and physical architecture of proposed solution and a way of implementation Data Warehouse on MS SQL Server 2008. The main aim of the thesis is to create a list of critical success factors (CSF) of building large Data Warehouses on MS SQL Server 2008 platform. It's not only plain list CSF, but rather the best practices for MS SQL Server Data Warehouses implementation. The most significant contribution of this thesis is that it offers instruction manual for designing and implementing large Data Warehouse on MS SQL Server basis. Background for the creation of summary of CSV and recommendations were vendor's publications and especially my own experience with the product. My colleagues from company Adastra gave me an advisory opinion as well.
| Identifer | oai:union.ndltd.org:nusl.cz/oai:invenio.nusl.cz:10454 |
| Date | January 2009 |
| Creators | Gottwald, Tomáš |
| Contributors | Novotný, Ota, Pour, Jan |
| 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.0015 seconds