The group technology database be created by Online Analytical Processing

• Main Authors: Chung-Hao Cheng, 陳仲豪
• Other Authors: 陳雲岫
• Format: Others
• Language: zh-TW
• Published: 2011
• Online Access: http://ndltd.ncl.edu.tw/handle/52107095126298070471

碩士 === 元智大學 === 工業工程與管理學系 === 99 === 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.