The Application Of Data Warehouse Technology In Lean Management Of Packaging & Printing Enterprises

In recent years, with the continuous development of computer application technology, packaging and printing industry from “lead and fire” era to the new era of new “light and electricity”, great changes have been taken in the way its production and operation. The small profit era makes many enterprises hard to manage because of the increasingly cruel competition among Packaging & printing enterprises. The existing ERP system has far away from satisfing the needs of existing production mode.Because of the rapid development of information technology and the urgent needs of the enterprise management decision support, the data warehouse has been quickly transformed from a purely theoretical research into a kind of practical strong technical of support domain in a few short years. Industrial 4.0 intelligent makes packaging and printing enterprises from simple processing, laser photo typesetting printing, computer processing time,CTP plate making into the digital printing, internet+printing, "cloud" printing, the data warehouse and data mining of packaging and printing. Data warehouse is different from the existing databases in the enterprises,. It is a large “data analysis platform”. In order to analysis data for further mining resources, Data warehouse technology is produced for decision making under the premise of abundant historical data. Through the application of data warehouse and the combination of lean management, it can be pushed forward smoothly including lean equipment, research and development, lean mass, lean marketing, logistics, etc.This paper first introduces the current status of packaging and printing enterprises informatization, the demand of the lean management, and then introduces the structure of DW, characteristics of DW, the tools. According to two printing companies that the author worked, creating the data warehouse of packaging and printing enterprises, OLAP model is mainly focus on research. The creation and safety analysis of the online analytical processing(OLAP) system is discussed in detail.The system draws on the most popular tools and methods, it has good adaptability and reliability of the data warehouse construction convenient.It has the very good application value, and is an exploration of the data warehouse technology concrete application to packaging and printing enterprise lean management.