【摘要】：近幾年來,隨著計(jì)算機(jī)應(yīng)用技術(shù)的不斷發(fā)展,包裝印刷行業(yè)告別了“鉛與火”,進(jìn)入了全新的“光與電”新時(shí)代,其生產(chǎn)經(jīng)營方式發(fā)生巨大的變化。包裝印刷企業(yè)之間的競爭愈加殘酷,“微利”時(shí)代的來臨使得諸多企業(yè)舉步維艱,現(xiàn)有的ERP系統(tǒng)已遠(yuǎn)遠(yuǎn)不能滿足現(xiàn)有生產(chǎn)模式的需求。信息技術(shù)的迅速發(fā)展和企業(yè)管理決策支持的迫切需要,在短短幾年內(nèi)將數(shù)據(jù)倉庫從純粹的理論研究迅速轉(zhuǎn)化為支持領(lǐng)域中一種實(shí)用性極強(qiáng)的技術(shù)。工業(yè)4.0智能化將包裝印刷企業(yè)從簡單的印刷處理、激光照排處理、電腦處理時(shí)代、CTP直接制版帶入了數(shù)字印刷、“互聯(lián)網(wǎng)+印刷”、“云印刷”和包裝印刷的數(shù)據(jù)倉庫和數(shù)據(jù)挖掘。數(shù)據(jù)倉庫技術(shù)是不同于現(xiàn)有的數(shù)據(jù)庫,它是一個(gè)大型的“數(shù)據(jù)分析平臺(tái)”,在歷史數(shù)據(jù)大量存在的前提下,為進(jìn)一步挖掘分析數(shù)據(jù)資源,為了決策需要而產(chǎn)生的。通過數(shù)據(jù)倉庫的應(yīng)用與企業(yè)精益管理相結(jié)合,可以扎實(shí)地推進(jìn)其的實(shí)施,包括精益設(shè)備、精益研發(fā)、精益質(zhì)量、精益營銷、精益物流等。本文首先介紹了當(dāng)前包裝印刷企業(yè)信息化現(xiàn)狀、精益管理開展的需求,然后對(duì)數(shù)據(jù)倉庫結(jié)構(gòu)、特點(diǎn)、工具進(jìn)行了說明,以作者所工作過的兩家印刷企業(yè)為依托,重點(diǎn)對(duì)包裝印刷企業(yè)創(chuàng)建數(shù)據(jù)倉庫、OLAP模型進(jìn)行研究,對(duì)在線分析處理系統(tǒng)(OLAP)進(jìn)行了較為詳細(xì)的創(chuàng)建和安全分析。該系統(tǒng)借鑒了當(dāng)前最流行的工具和方法,具有良好的適應(yīng)性和可靠性,數(shù)據(jù)倉庫構(gòu)建快捷方便,具有很好的應(yīng)用價(jià)值,是將數(shù)據(jù)倉庫技術(shù)具體應(yīng)用到包裝印刷企業(yè)精益管理中的一次探索。
[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.
【學(xué)位授予單位】：青島理工大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2015
【分類號(hào)】：TP311.13

【參考文獻(xiàn)】

相關(guān)期刊論文 前10條

1 袁國民;;數(shù)據(jù)倉庫在企業(yè)管理中的應(yīng)用探討[J];現(xiàn)代企業(yè)教育;2014年08期

2 張杰;;數(shù)據(jù)倉庫技術(shù)應(yīng)用研究[J];電子技術(shù)與軟件工程;2014年05期

3 胡小英;李翔;;數(shù)據(jù)倉庫建設(shè)探索與實(shí)踐[J];電子世界;2014年07期

4 王志鵬;孫萌;;數(shù)據(jù)倉庫的查詢優(yōu)化研究[J];無線互聯(lián)科技;2014年03期

5 崔愿星;;淺析數(shù)據(jù)倉庫與數(shù)據(jù)挖掘的應(yīng)用[J];內(nèi)江科技;2014年01期

6 包冬冬;;企業(yè)數(shù)據(jù)倉庫技術(shù)應(yīng)用探討[J];中國新通信;2013年11期

7 王萌;;數(shù)據(jù)倉庫構(gòu)建技術(shù)[J];華章;2011年33期

8 姚遠(yuǎn);;論數(shù)據(jù)倉庫技術(shù)在CRM中的意義及其應(yīng)用[J];企業(yè)科技與發(fā)展;2011年18期

9 楊莉國;歐付娜;劉慶海;程海濤;盧亮;;數(shù)據(jù)倉庫相關(guān)技術(shù)研究綜述[J];電腦知識(shí)與技術(shù);2011年10期

10 宋斌;陳海東;雷勇;黃紹君;卓飛豹;;數(shù)據(jù)倉庫在數(shù)字化醫(yī)院的應(yīng)用[J];東南國防醫(yī)藥;2010年06期

，

本文編號(hào)：2230630