A project-oriented data warehouse for construction

A construction organization generates a great amount of operational data that are distributed across various functional systems to support its daily operations. Although those data may be potentially useful for future projects, they are not widely collected and centrally stored in the organization....

Full description

Saved in:
Bibliographic Details
Published inAutomation in construction Vol. 15; no. 6; pp. 800 - 807
Main Authors Rujirayanyong, Thammasak, Shi, Jonathan J.
Format Journal Article
LanguageEnglish
Published Amsterdam Elsevier B.V 01.11.2006
Elsevier
Subjects
Applied sciences
Buildings. Public works
Construction
Data warehousing
Decision support system
Exact sciences and technology
Information system
Miscellaneous
Project management. Process of design
Structural analysis. Stresses
Database
Construction
Information system
Decision support system
Data warehousing
System architecture
Project management
Data storage
Modeling
Construction industry
Online AccessGet full text

Cover

More Information
Summary:A construction organization generates a great amount of operational data that are distributed across various functional systems to support its daily operations. Although those data may be potentially useful for future projects, they are not widely collected and centrally stored in the organization. This research presents a Project-oriented Data Warehouse (PDW) for contractors. PDW is designed with dimensional data models consisting of 26 tables. Sixteen of the tables are dimension tables for storing general descriptive information, and the other ten are fact tables for detailing various facts that are captured in the lifecycle of construction projects. PDW can be directly populated with data from existing operational systems, such as P3 files, MS Access, P3/e databases, and Excel files. It maintains each data in the context of its associated project so that a user can retrieve a specific piece of information plus any background information of the related project. PDW has been populated with three sample project data. Through the user interface, a user can generate interested query reports as needed. The presented warehouse structure and data models are scalable. They may be adopted by medium or large contractors for developing company-level data facilities.
Bibliography:ObjectType-Article-2
SourceType-Scholarly Journals-1
ObjectType-Feature-1
content type line 23
ISSN:0926-5805
1872-7891
DOI:10.1016/j.autcon.2005.11.001