数据仓库技术在包装印刷企业精益管理中的应用

发布时间：2018-09-08 13:16

【摘要】：近几年来,随着计算机应用技术的不断发展,包装印刷行业告别了“铅与火”,进入了全新的“光与电”新时代,其生产经营方式发生巨大的变化。包装印刷企业之间的竞争愈加残酷,“微利”时代的来临使得诸多企业举步维艰,现有的ERP系统已远远不能满足现有生产模式的需求。信息技术的迅速发展和企业管理决策支持的迫切需要,在短短几年内将数据仓库从纯粹的理论研究迅速转化为支持领域中一种实用性极强的技术。工业4.0智能化将包装印刷企业从简单的印刷处理、激光照排处理、电脑处理时代、CTP直接制版带入了数字印刷、“互联网+印刷”、“云印刷”和包装印刷的数据仓库和数据挖掘。数据仓库技术是不同于现有的数据库,它是一个大型的“数据分析平台”,在历史数据大量存在的前提下,为进一步挖掘分析数据资源,为了决策需要而产生的。通过数据仓库的应用与企业精益管理相结合,可以扎实地推进其的实施,包括精益设备、精益研发、精益质量、精益营销、精益物流等。本文首先介绍了当前包装印刷企业信息化现状、精益管理开展的需求,然后对数据仓库结构、特点、工具进行了说明,以作者所工作过的两家印刷企业为依托,重点对包装印刷企业创建数据仓库、OLAP模型进行研究,对在线分析处理系统(OLAP)进行了较为详细的创建和安全分析。该系统借鉴了当前最流行的工具和方法,具有良好的适应性和可靠性,数据仓库构建快捷方便,具有很好的应用价值,是将数据仓库技术具体应用到包装印刷企业精益管理中的一次探索。
[Abstract]:In recent years, with the continuous development of computer application technology, packaging and printing industry said goodbye to "lead and fire", entered a new "light and electricity" new era, its production and management mode has undergone tremendous changes. The competition between packaging and printing enterprises is becoming more and more cruel, and the arrival of the era of "small profit" makes many enterprises difficult to move forward. The existing ERP system can not meet the demand of the existing production mode. With the rapid development of information technology and the urgent need of enterprise management decision support, the data warehouse is rapidly transformed from pure theoretical research into a very practical technology in the field of support within a few years. Industry 4.0 intelligent packaging printing enterprises from simple printing processing, laser phototypesetting, computer processing times, CTP direct plate making into digital printing, "Internet printing," Cloud Printing and Packaging Printing data Warehouse and data Mining. Data warehouse technology is different from the existing database, it is a large-scale "data analysis platform", in the premise of a large number of historical data, in order to further mining and analysis of data resources, for the need of decision-making. Through the application of data warehouse and enterprise lean management, we can promote its implementation, including lean equipment, lean R & D, lean quality, lean marketing, lean logistics and so on. This paper first introduces the current information situation of packaging and printing enterprises and the needs of lean management, then explains the structure, characteristics and tools of the data warehouse, which is based on the two printing enterprises that the author has worked for. The OLAP model of data warehouse for packaging and printing enterprises is studied in detail. The online analysis and processing system (OLAP) is established and security analysis is carried out in detail. The system draws lessons from the most popular tools and methods at present. It has good adaptability and reliability, and the data warehouse is fast and convenient to build, and has good application value. It is an exploration to apply data warehouse technology to lean management of packaging and printing enterprises.
【学位授予单位】：青岛理工大学
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：TP311.13

【参考文献】