Data Warehouse In The Erp Application

With the rapid development of information technology, the application of the database system has rapidly developed from the traditional data processing to the spacial and temporal information processing, multimedia information processing, information library of the office, scientific and application-oriented database and the database application based on the Internet. With the abroad application of the database and information, the amount of the data stored in the database increased very quickly. Without the ability to analyse the large quantities of data scientifically, the boss of Wal-Mart could not consider the fact that there are much relations between the beer and the napkin although he is smart enough. But when the two kinds of goods were placed together to sell, the amount of the sale of the beer was improved. So we can see that Data Warehouse can do much help to the data analysis.Data Warehouse is a new technology in the field of information. Using the Data Warehouse, we can make use of the abundant data resources in the enterprise to support the decision about the enterprise. It can also combine the experience from the objective data and from the person who make the decisions.As the important tools of management in the enterprise, ERP is applied more widely step by step. But the ability of data analysis in ERP is not stronger enough. Furthermore the structure and ability in data analysis of database is the key parameter to the capability. The ability of data analysis of software for ERP is called Business Intelligence (BI) whose function is to deal with and analyse the data stored in ERP system, i.e. to help the user to find the potential value of the data stored in ERP.This thesis is based on the ERP project of Huajing Co., ltd. in Henan Province. Firstly, the technology of Data Warehouse that is used in the process of programming of HJ-ERP is introduced; secondly, the integration of ERP and Data Warehouse is discussed. Furthermore research and requirements analysis of the Data Warehouse in HJ-ERP based on the practical investigantion is described. At last, the process of establishing the physical database and the methods of designing the OLAP in Data Warehouse of HJ-ERP is introduced through the software code and diagram. The main contents of this thesis are outlined as follows,1. The model of the integration about ERP and Data Warehouse is put forward based on the each character of ERP and Data Warehouse. And the Data Warehouse is applied to ERP system.2. The requirement analysis and the whole designation of Data Warehouse inHJ-ERP is introduced which is based on the practical investigation on the manufacture, sale, purchase and finance etc. in the company.3. The physical database of HJ-ERP is designed which is based on the practical demand of the company. And the ERP system is realized through MS SQL Server that is based on the analysis of the system table, trigger and the stored procedure.4. The data of analysis type is extracted from environment of transaction processing and is reorganized according to the requirement of Data Decision Support (DSS). And at the same time the environment of analysis processing is established separately.5. The analysis of multidimensional cube which is established on the subject domain of manufacture, sale and stock is applied to the Data Warehouse in HJ-ERP through the tools of OLAP and the MDX language. Furthermore the DSS is established based on HJ-ERP.