The Study Of Erp System Based On Data Warehousing

In the era of economic development, internal data of all walks of life presents exponential growth, but these data exists in inconsistent data structure, data redundancy, incomplete and so on. Therefore these data cannot be integrated into a unified data platform. The traditional ERP system for these complex data access performance, It can not make full use of these data to make these data transformation useful information to guide the industry enterprise decision. So how to obtain the useful information from these data to enterprises is fundamental problem.The development and maturity of technique of data warehouse lays the theoretical foundation for the thesis lays. This paper presents combination the technology of data warehouse and enterprise resource planning (ERP) to create the ERP system based on data warehouse. First, we based on the traditional ERP system application data warehouse technology to make the data standardization, integration to providing a suitable for the analysis of data of environment. Then using OLAP detailed analysis of the data to find the business operation situation in the past and present and using data mining techniques to find some hidden relationships or pattern so that find the strategic and competitive issues to better auxiliary enterprise senior managers to make business strategy. This paper focuses on the research, combined traditional ERP system and data warehouse to create ERP system, and discussed core technology of the integration, at the same time, through this technology to achieve the sales management system application.