Designing data warehouses for equipment management system with genetic algorithms

K. Y. Chen*, Mu-Chen Chen, W. Y. Liu

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review


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.

Original languageEnglish
Pages (from-to)6113-6135
Number of pages23
JournalInternational Journal of Production Research
Issue number21
StatePublished - 1 Nov 2008


  • Data warehouse
  • Equipment management system
  • Genetic algorithms
  • Maintenance management

Fingerprint Dive into the research topics of 'Designing data warehouses for equipment management system with genetic algorithms'. Together they form a unique fingerprint.

Cite this