Application Study In Enterprise Resources Planning Of Data Warehouse

In nowadays cruel competition world, with the process of the economic globalization, the opportunity and challenge coexist, enterprises, in order to survive, develop, defeat the rival, must grasp the future .To grasp the future means to manage information. Enterprise Resources Planning and Data Warehouse are all the technology developed rapidly in recent years, Gathering organically the system of ERP and data warehouse system together, and building a comprehensive, easy to search and analytical data warehouse system based on ERP system, they can affect with each other, both satisfy the business enterprise usually the business and processes, and satisfy the decision and analysis of manager, this is a very valid mode to manage a business enterprise. It will raise the management level and the decision methods of the business enterprise, better adapting market economy system, and bring the larger benefit and competitive advantages for the business enterprise. The data warehouse combines with the system of ERP, will bring strategic value for business enterprise. What this thesis probed into mainly is the application study of the data warehouse technique in ERP. First of all, expounded the background of studying in proposition, the current situation of ERP and the data warehouse the development and deficiency, then introduced the basic theories of the data warehouse, has included the definition and characteristic of the data warehouse, and studied data organization in the data warehouse and data warehouse tools, has also introduced the concept, management thought and characteristic of ERP, and the main function module of ERP, has described the connection in the data warehouse and ERP. This thesis has describe the system structure of the data warehouse in ERP system, has analysed the component of the data warehouse and the characteristic of the data in ERP system, discussed a kind of new technological route of building the data warehouse, has improved the already existing structure of system based on data warehouse of ERP system, have analysed the warehouse system structure of two-tier data based on ERP. Finally, propose the design plan of the Shuibuya hydropower station ERP systematic data warehouse, adopt SQL Server of Microsoft Company to establish the data warehouse, this foundation of data warehouse remedy the shortcoming of ERP system analysing about decision that it is insufficient to support, it is the supplement with beneficial system to Shuibuya hydropower station ERP.