Design of Data Warehouse System for Reducing Defect Rate in Automotive Pulley Manufacturing Process

자동차 풀리 제조공정의 불량률 감소를 위한 데이터 웨어하우스 구조 설계

Automotive pulleys play a key role in driving the cooling pump, oil pump, air-conditioner and so on by using an engine power. Researches on design processes and technologies of the pulleys can be found in many literatures. On the other hand, the areas related to manufacturing processes of the pulleys have been treated negligently. Vast data extracted from various information systems are transformed, integrated, and summarized to become a special database for helping users make a decision. The database, namely the data warehouse has been popularly used in the marketing and customer management of enterprises and recently applied to improve the design and manufacturing processes. In this study the manufacturing process of pulleys were analyzed through the intensive investigation of shop-floors and the interviews with workers and managers. The defects generated during a manufacturing process were categorized in a few types and the causes of defects examined for extracting the dominant parameters in the setup process for producing pulleys. As the first step to construct the data warehouse for the manufacturing processes of pulleys, authors proposed its architecture focused on the reduction of defect rate during the setup process.