Designing data warehouses for equipment management system with genetic algorithms

檔案

日期

2008

期刊名稱

INTERNATIONAL JOURNAL OF PRODUCTION RESEARCH

摘要

Effective equipment management is becoming one of the key factors in keeping a competitive advantage in the dynamic business environment since equipment is an important asset for manufacturing companies. Nowadays, maintenance administration has become one of the most important tasks in equipment management, particularly in manufacturing industries. Equipment management system (EMS) aims at reducing maintenance cost and production loss caused by machine breakdown. In addition, EMS can assist equipment engineers to make the right maintenance decisions at the right time, and at the right shop floor. Traditional computerized maintenance management systems (CMMS) have helped equipment engineers to deal with maintenance operations, but they lack decision support capability. In this paper, we design a data warehouse (DW) for EMS to help equipment engineers make maintenance decisions with various equipment related dimensions to improve effectiveness. A set of cubes can be built from EMS DW for the purpose of decision-making. In order to achieve a reasonable query response time under the memory space limit, a mechanism of partial materialization based on genetic algorithms (GAs) is adopted to design data cubes in the EMS DW. From the computational results the proposed GA-based approach for cube design can be applied to effectively select the appropriate multi-dimensional views for equipment management.

所屬典藏

期刊論文
顯示完整詮釋資料 統計資料