臺灣博碩士論文加值系統

台灣是全世界的加工廠，所以在擁有很多零件工廠的情況下，就會有各式各樣屬於自己工廠的群組技術。而群組技術系統中有很多不一樣的編碼方式，很多公司都是將原有的編碼再做進一步的加工或調整。群組技術的目的在於利用編碼系統，可以快速的將新的零件做歸類，降低生產成本與節省重新編碼的時間。

本論文為模擬出三種不同的群組技術系統，分別為Vuoso-Praha、Opitz和KK-3，再用這三種編碼不盡相同的群組技術系統，利用線上處理分析系統(OLAP)的方式，做出一套資料庫系統。

資料庫系統需要與操作者互動，資料庫方面是使用MYSQL，而網頁的部分則是使用PHP動態網頁語法，在伺服器方面則是利用Appserv，讓本機電腦做為伺服器端，方便程式的測試。在最後過程的部分，將會從零件編碼、操作資料庫中的資料到撰寫程式等介紹。

Taiwan is one of the famous countries about manufacturing. There are many group technology systems in the world. Each system is different. As we know, every factory does have own Group technology. The purpose about Group technology is that when there is a new part, the company will take time for coding it, but group technology could save time and do some cost down in the same time.

This research is comparing three kind of group technology system, Vuoso-Praha, Opitz and KK-3. They have similar purpose but different coding. In this paper, I will simulate these systems by using online analytical processing (OLAP), and create a simple system for them.

The user should interact with database, so I take PHP for designing web page, MYSQL for database﹐ Appserv for server which can be set on own desktop. I will introduce this system which include parts coding, creating database, the web page design etc.

摘 要 i
Abstract ii
誌謝 iii
目錄 iv
圖目錄 v
表目錄 vi
第一章、緒論 1
1.1研究背景 1
1.2研究動機 1
1.3研究目的 1
第二章、文獻探討 2
2.1群組技術 2
2.1.1群組技術介紹 2
2.1.2 編碼與分類 3
2.2 OLAP簡介 6
第三章、方法 11
3.1編碼技術選用 11
3.2製作所需之程式 15
3.3 系統介紹 15
第四章、系統建置 16
4.1資料庫建置 16
4.2動態網頁製作 21
4.3 SQL語法 21
4.4資料庫搜尋 26
4.5 關聯式線上分析處理系統(ROLAP) 27
4.6 多重維度線上分析處理系統 28
第五章、結論與未來方向 29
文獻參考 30
附錄 32

[1] Surajit, C. and Umeshwar, D. , " An overview of data warehousing and OLAP technology ", SIGMOD Record, 26, March 1997.
[2] Oscar, R. and Alberto, A., " A framework for multidimensional design of data warehouses from ontologies ", Data & Knowledge Engineering 69 (2010) 1138–1157
[3]Love, D. M. and Barton, J. A., " Drawing retrieval using an automated coding technique ", Integrated Design & Manufacture Research Unit, Aston University, U.K.
[4]Gregory V. F. and Mark T. S., "Achieving competitive
advantage through group technology ", Business Horizons, May-June 1996
[5]Keqin, W. and Lionel, R. and Nada, M. and Benoit, E. and Shurong, T., " Manufacturing quality information classification based on group technology and quality BOM ",Computational Engineering in Systems Applications(CESA), October 4-6, 2006, Beijing, China.
[6]Doug, L. and Jeff, B., " Aspects of design retrieval performance using automatic GT coding of 2D Engineering Drawings ", 4th Int. Conf. on Integrated Design and Manufacture in Mechanical Engineering, Bath, April 2004.
[7]Dowlatshahi, S. and Nagaraj, M.," Application of group technology for design data management ", Computers ind. Vol. 34. No. 1. pp. 235-255, 1998
[8]Chaudhuri, S. and Dayal, U. " An overview of data warehousing and OLAP technology ", SIGMOD Record, 26, March 1997.
[9]Tien-Chien Chang and Richard A. Wysk and Hsu-Pin Wang, " Computer-Aided Manufacturing" , PRENTICE HALL, Englewood Cliffs, N. J. 07632
[10]位元文化,PHP 6 動態網頁入門實務,松岡資產管理(股)公司
[11]陳惠貞,PHP & MYSQL程式設計實例講座,學貫行銷股份有限公司
[12]Krzysztof Kaczmarski, " Comparing GPU and CPU in OLAP Cubes Creation ", Faculty of Mathematics and Information Science, Warsaw University of Technology, pl. Politechniki 1, 00-661 Warsaw, Poland.
[13]Sebastien Nedjar and Rosine Cicchetti and Lotfi Lakhal, "Extracting semantics in OLAP databases using emerging cubes", Information Sciences 181 (2011) 2036–2059
[14]Kevin Chihcheng Hsu and Ming-Zhong Li, "Techniques for finding similarity knowledge in OLAP reports", Expert Systems with Applications 38 (2011) 3743–3756
[15]Anindya Datta and Helen Thomas, "The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses", Decision Support Systems 27 1999. 289–301
[16]Istvan Szepkuti, "Multidimensional or relational? How to organize an on-line analytical processing database", Technical Report, 1999