Data warehousing for construction equipment management

Hongqin Fan, Hyoungkwan Kim, Osmar R. Zaïane

Research output: Contribution to journalArticle

8 Citations (Scopus)

Abstract

Equipment logistics, maintenance, and repair are important aspects of construction equipment management. A well-managed equipment fleet helps reduce downtime, as well as total maintenance and repair costs. With quickly growing fleets of equipment, large contractors tend to divert the maintenance and repair of equipment from equipment managers to project managers. As a result, the equipment managers shift their attention from operational-level decision-making to corporate-level strategic decision-making regarding equipment management, which is often a challenging job with the current equipment management system. This paper presents an equipment data warehouse and a prototype decision support system (DSS). The proposed equipment data warehouse enables equipment managers to visually analyze the equipment fleet data from different perspectives and at various level of details. The data-warehouse-based DSS facilitates high-level, fact-based decision-making regarding equipment logistics, supplies, maintenance, repair, and replacement and has higher levels of performance and flexibility than the current equipment management system.

Original languageEnglish
Pages (from-to)1480-1489
Number of pages10
JournalCanadian Journal of Civil Engineering
Volume33
Issue number12
DOIs
Publication statusPublished - 2006 Dec 1

Fingerprint

Construction equipment
Data warehouses
repair and maintenance
Managers
Repair
Decision making
decision making
decision support system
Decision support systems
construction equipment
Logistics
logistics
Contractors

All Science Journal Classification (ASJC) codes

  • Civil and Structural Engineering
  • Environmental Science(all)

Cite this

Fan, Hongqin ; Kim, Hyoungkwan ; Zaïane, Osmar R. / Data warehousing for construction equipment management. In: Canadian Journal of Civil Engineering. 2006 ; Vol. 33, No. 12. pp. 1480-1489.
@article{511438177d04408fb39c1a3f29a6878a,
title = "Data warehousing for construction equipment management",
abstract = "Equipment logistics, maintenance, and repair are important aspects of construction equipment management. A well-managed equipment fleet helps reduce downtime, as well as total maintenance and repair costs. With quickly growing fleets of equipment, large contractors tend to divert the maintenance and repair of equipment from equipment managers to project managers. As a result, the equipment managers shift their attention from operational-level decision-making to corporate-level strategic decision-making regarding equipment management, which is often a challenging job with the current equipment management system. This paper presents an equipment data warehouse and a prototype decision support system (DSS). The proposed equipment data warehouse enables equipment managers to visually analyze the equipment fleet data from different perspectives and at various level of details. The data-warehouse-based DSS facilitates high-level, fact-based decision-making regarding equipment logistics, supplies, maintenance, repair, and replacement and has higher levels of performance and flexibility than the current equipment management system.",
author = "Hongqin Fan and Hyoungkwan Kim and Za{\"i}ane, {Osmar R.}",
year = "2006",
month = "12",
day = "1",
doi = "10.1139/L06-108",
language = "English",
volume = "33",
pages = "1480--1489",
journal = "Canadian Journal of Civil Engineering",
issn = "0315-1468",
publisher = "National Research Council of Canada",
number = "12",

}

Data warehousing for construction equipment management. / Fan, Hongqin; Kim, Hyoungkwan; Zaïane, Osmar R.

In: Canadian Journal of Civil Engineering, Vol. 33, No. 12, 01.12.2006, p. 1480-1489.

Research output: Contribution to journalArticle

TY - JOUR

T1 - Data warehousing for construction equipment management

AU - Fan, Hongqin

AU - Kim, Hyoungkwan

AU - Zaïane, Osmar R.

PY - 2006/12/1

Y1 - 2006/12/1

N2 - Equipment logistics, maintenance, and repair are important aspects of construction equipment management. A well-managed equipment fleet helps reduce downtime, as well as total maintenance and repair costs. With quickly growing fleets of equipment, large contractors tend to divert the maintenance and repair of equipment from equipment managers to project managers. As a result, the equipment managers shift their attention from operational-level decision-making to corporate-level strategic decision-making regarding equipment management, which is often a challenging job with the current equipment management system. This paper presents an equipment data warehouse and a prototype decision support system (DSS). The proposed equipment data warehouse enables equipment managers to visually analyze the equipment fleet data from different perspectives and at various level of details. The data-warehouse-based DSS facilitates high-level, fact-based decision-making regarding equipment logistics, supplies, maintenance, repair, and replacement and has higher levels of performance and flexibility than the current equipment management system.

AB - Equipment logistics, maintenance, and repair are important aspects of construction equipment management. A well-managed equipment fleet helps reduce downtime, as well as total maintenance and repair costs. With quickly growing fleets of equipment, large contractors tend to divert the maintenance and repair of equipment from equipment managers to project managers. As a result, the equipment managers shift their attention from operational-level decision-making to corporate-level strategic decision-making regarding equipment management, which is often a challenging job with the current equipment management system. This paper presents an equipment data warehouse and a prototype decision support system (DSS). The proposed equipment data warehouse enables equipment managers to visually analyze the equipment fleet data from different perspectives and at various level of details. The data-warehouse-based DSS facilitates high-level, fact-based decision-making regarding equipment logistics, supplies, maintenance, repair, and replacement and has higher levels of performance and flexibility than the current equipment management system.

UR - http://www.scopus.com/inward/record.url?scp=34249774284&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=34249774284&partnerID=8YFLogxK

U2 - 10.1139/L06-108

DO - 10.1139/L06-108

M3 - Article

AN - SCOPUS:34249774284

VL - 33

SP - 1480

EP - 1489

JO - Canadian Journal of Civil Engineering

JF - Canadian Journal of Civil Engineering

SN - 0315-1468

IS - 12

ER -