Design And Implementation Of Enterprise Data Warehouse

As the development of enterprise, traditional ERP, which is taking daily operating type handling as purpose, can’t directly get the data needed by corporate executives, because data is extracted from different data sources. This phenomenon plays a restraining effect on enterprise management. As a result, enterprise needs an ERP system which is based on Data Warehouse and oriented analytical data to organize and present data as the demand of corporate executives. This thesis introduces a typical case that a company applies the system based on Data Warehouse to the management.First, this thesis introduces the development process of ERP and analyzes3new technologies to support favorable decision, ETL (Extraction-Transformation-Loading), Data Warehouse, OLAP (On-Line Analytical Processing). Data Warehouse, based on the Database, is a new environment to support the decision analysis for satisfying management. Data Warehouse has some important properties:facing theme, data Integration, data long-period, therefore Data Warehouse is the core of Decision Support System. ETL, the process of converting from different kinds of source data to the appropriate data type of Data Warehouse, is the beginning of Decision Support System. OLAP, based on the Multi-dimensional data type of Data Warehouse,can satisfy enterprise management by Slicing, Drilling(including rolling-up and drilling-down), Rotating on Multi-dimensional data type. Thus, OLAP is the final result of Decision Support System. Then this thesis makes the development of Decision Support System example based on ERP system of a company. This section introduces and analyzes the demands of a Decision Support System. One is the demand of simple presentations of reports which don’t need the multidimensional analyses; another one is the demand of multidimensional analyses of reports which don’t need the drilling, last one is the demand of analyses from various years which don’t need both multidimensional analyses and drilling. The author designs the data warehouse, ETL process and OLAP on Multi-dimensional data set, as the demands of users, to support the decision of corporate executives.Corporate executives are satisfied with the system, because the system does well in supporting the decision of corporate executives. The processing from confirming demand to achieving the system is a good conference to the ERP processing of similar enterprise.