about erp system data warehouse（对erp系统数据仓库）.docVIP

About ERP system data warehouse Abstract: With the increasing wealth of information, knowledge explosion became inevitable, to discover knowledge from data (KDD) and data mining has become an important technology in the widespread implementation of the ERP, how information from vast amounts of business to find valuable knowledge has become the key to success in business, in this context, to migrate data to the data warehouse has become very important in building a data warehouse is a complex, long-term process, especially for the construction of enterprise ERP system, we steam through a Invoicing repair industry to build a data warehouse system, the system explains how to build a data warehouse in the ERP environment, and the physical implementation of the system are discussed. Keywords: Information, ERP, data warehousing, OLTP, OLAP, data mining Today’s society is an information explosion era, information rich and knowledge poor is widespread. “Draped diapers to sell beer,” the story has touched many people’s nerves. Information as a valuable resource for modern enterprises, occupy an increasingly important status, has become the basis for scientific management of modern enterprises, the premise of making correct and effective means of control. Currently, the face of fierce market competition, many large companies have to implement “customer-centric, service and development” business strategy. How to optimize customer relationships, enhance their competitive advantage has become a modern enterprise focus. Existing applications tend to “product” as the center, “documents (ticket” deal for the foundation for online transaction processing (Online Transaction Processing, referred to as OLTP systems, and customer-centric business management requirements of existing business systems integration and data effectively to re-establish for online analytical processing (Online Analysis Processing, referred to as OLAP systems by analyzing customer behavior, gra