臺灣博碩士論文加值系統

製造業為追求效率、強化管理，紛紛導入資訊系統，隨使用目的不同，引進的系統也不同，除此外各單位為了業務上的需要，也會利用Office等文書軟體建立小型的資料庫或簡易的計算模組，無論資料是以任何形式的方式存在，對於企業而言，經過分析、統計與重組後，其結果可能都是具有價值的商業資訊，有助於提升企業的競爭力，因此如何蒐集、整合分散四處的資料並進而整合成可供參考的資訊，是具有挑戰性且重要的課題。
個案公司是一家中小型企業，產品為矽晶圓，主要資訊系統包含ERP與MES，各單位因業務需要，也會以Excel建立小型資料檔，因此有價值的商業資訊分散四處，造成取得與應用上的難度，加上不同的資料間的使用目的不同，彼此間未必有交集，往往需要再透過其他資料串聯才能加以合併使用，而個案公司的產品規格多樣、複雜，更增加了資料處理的難度，
生產管理是影響製造是否順暢的重要腳色，其接觸的單位很多，遭遇問題牽涉的範圍也很廣，當需要從系統取得資訊進行決策時，往往從單一系統取得的資訊，難免不夠完整或無法完全適用，即使透過資訊單位取得所需的資訊，也已失去時效性。因此本研究嘗試以生管主要職責作為出發點，分析在執行業務的過程中，需要進行決策判斷的時機，並依此設計輔助決策的報表，由於報表所需資訊可能分散於不同系統，且原始資料需要重組、合併等處理，因此期望透過EAI加以整合，最終建立輔助生管決策之資訊系統。

To gain efficiency and strengthen quality control, manufacturers implement various information systems depending on needs and requirements. Often times, Microsoft Office is also adopted for establishing simplified computing models or databases. Regardless of how information is recorded or collected, data after statistical analysis and restructure can be meaningful and helpful to enterprises. Therefore, how to collect decentralized data and integrate them into meaningful information is both challenging and important.
The studied case in this research is a medium size enterprise that produces silicon wafers with a large number of specifications. The company currently uses Enterprise Resource Planning and Manufacturing Execution Systems software to access and control their data. Besides, excel application is also the common way to process and keep data within the company. Therefore, as different platforms of software are used, valuable data are also scattered and cannot be crossed referenced. Meaningful information becomes difficult to obtain. Crucial business decision making moments are often missed as a consequence and often times, wrong strategic directions are made due to lack of timely and correct information.
Production management plays a critical role in keeping production processes working smoothly and efficiently. This department not only has to interact with a wide range of different departments, it also needs to resolve issues and conquer problems on a daily basis. When production managers need to draw information from current database, numbers from one platform normally are not enough nor complete. Even with the help of Information Technology department, most likely, the data IT provides are outdated or not in use. Therefore this study attempts to forecast decision making moments during business process and formulate reports that will assist managers to make better decisions. Since these reports need to collect data from various platforms, Enterprise Application Integration solution is expected to apply. The final goal of this study is to establish a decision making support system to help production management make timely and accurate decisions.

一 、緒論 1
1.1研究背景 1
1.2研究動機 1
1.3研究目的 2
1.4研究步驟與方法 2
二 、文獻探討 4
2.1企業內部異質性系統整合問題 4
2.2企業內部系統的整合方式 4
2.3企業應用整合(Enterprise Application Integration，縮寫EAI) 5
2.4決策支援系統 5
2.4.1決策支援系統的定義 5
2.4.2決策支援系統的架構 6
2.4.3決策支援系統相關技術 6
三 、產業資訊架構 8
3.1個案公司產業特性與資訊架構 8
3.2資訊需求分析 12
3.2.1矽晶圓生產規劃 12
3.2.2生產監控 12
3.2.3生產資訊統計與分析 13
四 、系統分析與實作展示 14
4.1矽晶圓生產規劃階段 15
4.1.1產能負荷模擬 15
4.1.2物料用量預估報表 17
4.2生產監控階段 19
4.2.1低良率站點警示報表 19
4.2.2製令單停滯時間過長警示報表 22
4.2.3各站在製品(WIP)統計圖表 27
4.3生產資訊統計與分析階段 29
4.3.1製令單良品數及不良品數統計 29
4.3.2交期逾期警示報表 31
五 、結論與未來展望 33
5.1結論 33
5.2未來研究建議 33
參考文獻 35

[1]Brodie, M., Stonebraker, M., Migrating Legacy System, John Wiley and Sons, Inc., USA, 1995.
[2]Flickinger, Bernd H., Baker, Thomas E., Supply Chain Management in the 1990s, APICS ─ The Performance Advantage, February 1995.
[3]Johannesson, P., Wangler, B., Jayaweera, P., Application and Process Integration – Concepts, Issues, and Research Directions, NUTEK and SIDA.
[4]Johannesson, P., Wangler, B., Wåhlander, C., A Process Broker Architecture for Systems Integration, 1998, available at: http://www.dsv.su.se/~pajo/arrange/frontprop7.htm
[5]Keen, P. G. W., &; Scott-Morton, M. S., Decision Support Systems: An Organizational Perspective, Addison-Wesley. 1978.
[6]Lublinsky, Boris, Achieving the Ultimate EAI Implementation, EAI Journal, February 2001.
[7]O’Brien, James A., Management Information Systems, McGraw-Hill Education – Europe, 2002.
[8]Scott-Morton, M. S., Management Decision Support Systems: Computer-based Support for Decision Making, Harvard University, Cambridge, Massachusetts, 1971.
[9]Sprague, Ralph H. Jr., A Framework for the Development of Decision Support Systems, MIS Quarterly, Vol.4, No.4, 1980
[10]江大有，「應用EAI技術提升ERP系統內生產管理績效之探討」，國立台灣科技大學，碩士論文，民國九十五年六月。
[11]林明憲，「矽晶圓半導體材料技術」，全華出版社，民國一百零二年十月。
[12]鄧國廷，「運用EAI作為提升企業資訊技術價值之研究」，國立台灣科技大學，碩士論文，民國九十二年六月。
[13]蘇偉仁，「EAI/BPM技術先驅面對整合的競爭─寒冬後的新遊戲規則」，資訊與電腦，民國九十二年五月。
[14]黃郁仁，「應用EAI技術作為管控生產供料之探討」，國立台灣科技大學，碩士論文，民國九十五年六月。
[15]梁定澎，「決策支援系統與商業智慧」，智勝文化，民國九十一年