臺灣博碩士論文加值系統

近年來，隨著電腦運算技術及網路技術的快速發展，物聯網及大數據的相關應用逐漸受到重視，各產業也將其視為未來的重大趨勢。而隨著硬體價格逐漸下降，物聯網(IOT)的概念逐漸被廣泛運用在各產業之中，其中製造業透過機台連網與雲端整合的智慧製造備受矚目，在德國提出了工業4.0相關計畫後，各國也陸續提出了相關的計畫。
本研究透過訪談個案公司，尋找企業面臨工業4.0轉型時所遇到之部分問題，建構出一個模型，透過資策會之ServBox 擷取資料，開發出一套以PHP、MySQL及Hadoop為基礎的生產資訊監控系統，以此系統來透通現場生產資訊、預測生產時間及監控機台數據。透過系上之機台進行模擬加工實驗，印證系統可行性，提供個案公司進行改善參考。

In recent years, with the computing technology and the rapid development of network technology, Internet of things and large data-related applications gradually attention, the industry will be its future as a major trend. With the gradual decline in hardware prices, the concept of Internet of Things (IOT) is being widely used in various industries, including manufacturing through the machine network and intelligent manufacturing with cloud integration are in high-profile, after the industrial 4.0 released by Germany, countries have also forward the relevant plans.
In this study, we interviewed some companies to find some problems related in the transformation of industry 4.0 and constructed a model to develop a set of production based on PHP, MySQL and Hadoop information monitoring system, with the site transparent information, forecast production time and monitoring machine data. Through the machine of laboratory to simulate the processing experiments, confirming the feasibility of the system, providing case improvement for reference.

目錄
摘要........................................................................................................................I
Abstract ................................................................................................................ II
致謝..................................................................................................................... III
目錄.....................................................................................................................IV
表目錄.................................................................................................................VI
圖目錄............................................................................................................... VII
第一 章 緒論..................................................................................................... 1
1.1研究背景與動機.........................................................................................1
1.2研究目的.....................................................................................................3
1.3研究流程.....................................................................................................4
1.4研究限制.....................................................................................................6
第二 章 文獻探討............................................................................................. 7
2.1雲端運算.....................................................................................................7
2.2大數據.........................................................................................................9
2.3 Hadoop ......................................................................................................11
2.4物聯網.......................................................................................................15
2.4.1物聯網架構....................................................................................16
2.4.2物聯網相關計畫............................................................................17
2.5工業4.0.....................................................................................................17
2.5.1工業4.0..........................................................................................17
2.5.2生產力4.0......................................................................................18
2.5.3各國工業4.0相關計畫.................................................................19
2.6情境智能...................................................................................................20
2.7 PHP ............................................................................................................22
2.8 MySQL資料庫.........................................................................................22
2.9財團法人工業資訊策進會.......................................................................23
2.9.1資策會ServBox.............................................................................23
2.9.2 TMTC標準....................................................................................25
2.10 Amazon ...................................................................................................26
2.10.1 Amazon Web Services ................................................................. 27
2.10.2 Amazon EC2 ................................................................................28
第三 章 研究架構與方法...............................................................................29
3.1個案問題...................................................................................................29
3.1.1個案公司介紹................................................................................29
3.1.2個案問題........................................................................................29
3.2系統開發流程...........................................................................................30
3.3 ServBox設定集參數蒐集........................................................................32
3.4 AWS設定.................................................................................................37
3.5個案公司現況...........................................................................................39
3.6目標系統...................................................................................................40
3.7系統架構設計...........................................................................................41
3.8研究方法與生產時間預測.......................................................................44
3.8.1研究架構........................................................................................44
3.8.2研究方法架構圖............................................................................45
3.8.3移動平均法....................................................................................46
第四 章 實驗與系統驗證...............................................................................49
4.1系統流程分析...........................................................................................49
4.1.1現況流程分析................................................................................49
4.1.2導入系統流程分析........................................................................50
4.2系統功能介紹...........................................................................................50
4.3實驗與系統驗證.......................................................................................53
4.3.1實驗假設........................................................................................53
4.3.2實驗結果........................................................................................54
第五 章 結論與建議.......................................................................................57
5.1結論...........................................................................................................57
5.2建議...........................................................................................................58
參考文獻.............................................................................................................60
英文部分.........................................................................................................60
中文部分.........................................................................................................61
網址部分.........................................................................................................63

表目錄
表1-1電話溝通及資訊系統生產資訊獲取模式之比較...................................3
表2-1雲端運算的三種服務模式.......................................................................8
表2-2大數據相關研究文獻................................................................................9
表2-3 Hadoop相關研究....................................................................................12
表2-4物聯網的架構及作用..............................................................................16
表2-5各國物聯網計畫......................................................................................17
表2-6各國工業4.0相關計畫...........................................................................19
表2-7情境智能相關定義整理..........................................................................21
表3-1本研究所截取之參數整理.....................................................................34
表3-2工單系統各欄位功能說明.....................................................................42
表3-3機台監控系統各欄位功能說明.............................................................43
表4-1實驗結果整理表......................................................................................56

圖目錄
圖1-1本系統與ERP之相對關係圖..................................................................4
圖1-2研究架構圖................................................................................................6
圖2-1物聯網架構圖..........................................................................................16
圖2-2工業4.0之演進.......................................................................................18
圖2-3台灣生產力4.0之演進...........................................................................19
圖2-4 ServBox資料庫設定畫面.......................................................................24
圖2-5 ServBox參數設定介面...........................................................................25
圖2-6 ServBox 程式運行畫面..........................................................................25
圖2-7 TMTC資料轉譯流程.............................................................................26
圖2-8 AWS提供服務之網頁............................................................................27
圖3-1系統開發流程圖......................................................................................31
圖3-2將工具機接上網路線..............................................................................32
圖3-3控制器IP設定畫面................................................................................33
圖3-4機台IP位置設定....................................................................................33
圖3-5機台連線測試..........................................................................................34
圖3-6參數擷取設定之服務表..........................................................................35
圖3-7設定資料擷取頻率及次數.....................................................................36
圖3-8擷取參數設定..........................................................................................36
圖3-9資料儲存位置設定..................................................................................37
圖3-10資料擷取資料庫....................................................................................37
圖3-12 AWS虛擬機列表..................................................................................39
圖3-13 AWS運行Hadoop架構圖...................................................................39
圖3-14個案公司現況流程圖............................................................................40
圖3-15目標系統構想圖....................................................................................41
圖3-16本研究系統架構圖................................................................................44
圖3-17研究方法架構圖....................................................................................45
圖4-1現況流程圖..............................................................................................49
圖4-2導入系統流程圖......................................................................................50
圖4-3系統首頁..................................................................................................51
圖4-4新增工單頁面..........................................................................................51
圖4-5查詢工單-工單列表頁面........................................................................52
圖4-6查詢工單-詳細資訊頁面........................................................................52
圖4-7機台數據監控頁面..................................................................................53
圖4-8加工至第25件時之系統截圖...............................................................54
圖4-9加工至第50件時之系統截圖...............................................................55
圖4-10加工至第75件時之系統截圖.............................................................55
圖4-11加工完成時之系統截圖........................................................................56
圖5-1未來研究方向架構圖..............................................................................59

1.Center for Intelligent Maintenance Systems (IMS Center), “IMS brochure.” (2014)
2.Lee, Jay; Wu, F.; Zhao, W.; Ghaffari, M.; Liao, L , “Prognostics and health management design for rotary machinery systems—Reviews, methodology and applications. ” Mechanical Systems and Signal Processing, 42, pp 314-334 (2013)
3.Layton, Julia, “How Amazon Works” (2013)
4.Douglas, Laney, “The importance of big data: a definition” Gartner (2012)
5.Executive Office of the President, “Big data is a big deal ” (2012)
6.Meriete Horst, “Ambient Intelligence in Home Care in the Netherlands, ” IET Working Papers Series(2012)
7.Ahmed Zouinkhi, Eddy Bajic, Eric Rondeau, Mohamed Ben Gayed and Mohamed Naceur Abdelkrim, “Ambient Intelligence: Awareness context application in industrial storage.” Wireless Sensor Network 2011, 3, pp. 135-146 (2011)
8.The Economist, “Data, data everywhere.” (2010)
9.Peter Mell, Tim Grance, NIST, Information Technology Laboratory, “Effectively and Securely Using the Cloud Computing Paradigm.” (2009)
10.J. C. Augusto and P. Mccullagh, “Ambient intelligence: Concepts and applications.” International Journal on Computer Science and Information Systems, 4(1), pp.1-28 (2007)
11.Phillips Research, “Other perspectives on ambient intelligence” (2007)
12.Emile Aarts and José Encarnação, “True Visions: The Emergence of Ambient Intelligence” Springer (2006)
13.E. Maeda and Y. Minami, “Steps toward ambient intelligence.” NIT Technical Review, 4(1) (2006)
14.C. K. M. Crutzen, “Invisibility and the meaning of ambient intelligence. ” International Review of Information Ethics, 6, pp.1-11 (2006)
15.Vasilakos and W. Pedrycz, “Ambient Intelligence, Wireless Networking, and Ubiquitous Computing.” Artech House Publishers. (2006)
16.Sanjay Ghemawat, Howard Gobioff, and Shun-Tak Leung, “The Google File System” SOSP '03 Proceedings of the nineteenth ACM symposium on Operating systems principles pp.29-43 (2003)
17.K. Ducatel, M. Bogdanowicz, F. Scapolo, J. Leijten & J-C. Burgelman, “Scenarios for ambient intelligence in 2010.” (2001)
Mark Weiser, “The Computer for the 21st Century” (1991)
1.行政院，行政院生產力4.0發展方案(2015)
2.張小玫，物聯網將掀起工業4.0革命(2015)
3.資訊工業策進會，精密機械資通訊標準助您迎接 製造業未來的挑戰(2013)
4.黃安德，基於Hadoop的動態群組形成之集中式和MapReduce演算法研究(2013)
5.廖丞宇，植基於Hadoop雲端運算架構之平行基因演算法與粒子群演算法的應用(2013)
6.范國拯，動態重複資料刪除在Hadoop分散式檔案系統上(2013)
7.闞大成，善用Hadoop孕育多樣化產業應用(2012)
8.吳俊德，基於Hadoop架構下運用Dual-cubes模型作三回合適性化診斷錯誤(2012)
9.曾坤福，基於PHP與MySQL應用程式之Apache HBase 分散式資料庫與關聯式資料庫中介橋接機制設計與實作(2012)
10.李至善，Hadoop架構上之悲觀式診斷及修復實作(2012)
11.張修華，Hadoop平台上之病毒分析研究(2012)
12.周建廷，利用MapReduce軟體架構於Hadoop叢集進行地貌型直接逕流模組演算之研究(2011)
13.郭文俊，高效能雲端儲存管理策略之研究(2011)
14.蔡碧展，基於Hadoop平台的雲端基因架構(2010)