Application of data warehouse and Decision Support System in construction management

被引:59
|
作者
Chau, KW [1 ]
Cao, Y
Anson, M
Zhang, JP
机构
[1] Hong Kong Polytech Univ, Dept Civil & Struct Engn, Kowloon, Hong Kong, Peoples R China
[2] Tsinghua Univ, Dept Civil Engn, Beijing 100084, Peoples R China
关键词
decision support system; project management; construction; data warehouse; on-line analysis processing;
D O I
10.1016/S0926-5805(02)00087-0
中图分类号
TU [建筑科学];
学科分类号
0813 ;
摘要
How to provide construction managers with information about and insight into the existing data, so as to make decision more efficiently without interrupting the daily work of an On-Line Transaction Processing (OLTP) system is a problem during the construction management process. To solve this problem, the integration of a data warehouse and a Decision Support System (DSS) seems to be efficient. 'Data warehouse' technology is a new database discipline, which has not yet been applied to construction management. Hence, it is worthwhile to experiment in this particular field in order to gauge the full scope of its capability. First reviewed in this paper are the concepts of the data warehouse, On-Line Analysis Processing (OLAP) and DSS. The method of creating a data warehouse is then shown, changing the data in the data warehouse into a multidimensional data cube and integrating the data warehouse with a DSS. Finally, an application example is given to illustrate the use of the Construction Management Decision Support System (CMDSS) developed in this study. Integration of a data warehouse and a DSS enable the right data to be tracked down and provide the required information in a direct, rapid and meaningful way. Construction managers can view data from various perspectives with significantly reduced query time, thus making decisions faster and more comprehensive. The applications of a data warehousing integrated with a DSS in construction management practice are seen to have considerable potential. (C) 2002 Elsevier Science B.V. All rights reserved.
引用
收藏
页码:213 / 224
页数:12
相关论文
共 50 条
  • [1] The Application of Data Warehouse in Decision Support System
    Yang XiaoHua
    [J]. COMPUTATIONAL MATERIALS SCIENCE, PTS 1-3, 2011, 268-270 : 534 - 539
  • [2] Application of data warehouse technique in educational decision support system
    Dong, Ping
    Dong, Junjun
    Huang, Tiansheng
    [J]. 2006 IEEE INTERNATIONAL CONFERENCE ON SERVICE OPERATIONS AND LOGISTICS, AND INFORMATICS (SOLI 2006), PROCEEDINGS, 2006, : 818 - +
  • [3] Application of Data Warehouse Techniques in Enterprise Decision Support System
    Han, Qingtian
    Gao, Xiaoyan
    [J]. 9TH INTERNATIONAL CONFERENCE ON COMPUTER-AIDED INDUSTRIAL DESIGN & CONCEPTUAL DESIGN, VOLS 1 AND 2: MULTICULTURAL CREATION AND DESIGN - CAID& CD 2008, 2008, : 1116 - +
  • [4] Application of Data Warehouse in Decision Support and Business Intelligence System
    Jain, Shubham
    Sharma, Shilpi
    [J]. PROCEEDINGS OF THE SECOND INTERNATIONAL CONFERENCE ON GREEN COMPUTING AND INTERNET OF THINGS (ICGCIOT 2018), 2018, : 231 - 234
  • [5] Application of database duplication technology in data warehouse decision support system
    Hao, Lina
    Wu, Guangyu
    Chen, Wenlin
    Xu, Xinhe
    [J]. Xiaoxing Weixing Jisuanji Xitong/Mini-Micro Systems, 2000, 21 (01): : 98 - 100
  • [6] Data warehouse and its application in urban planning decision support system
    Xie, Rong
    [J]. Wuhan Cehui Keji Daxue Xuebao/Journal of Wuhan Technical University of Surveying and Mapping, 2000, 25 (02): : 172 - 177
  • [7] A data warehouse-based decision support system for sewer infrastructure management
    Park, Taeil
    Kim, Hyoungkwan
    [J]. AUTOMATION IN CONSTRUCTION, 2013, 30 : 37 - 49
  • [8] Regional human resource management decision support system based on data warehouse
    Xiao, HR
    Zhang, HY
    Li, MQ
    [J]. PROCEEDINGS OF THE 4TH WORLD CONGRESS ON INTELLIGENT CONTROL AND AUTOMATION, VOLS 1-4, 2002, : 2118 - 2121
  • [9] Application of the Decision Support System "DATA" for Regional Management
    Averchenkova, E. E.
    Dergacheva, E. A.
    [J]. PROCEEDINGS OF THE INTERNATIONAL SCIENTIFIC CONFERENCE - FAR EAST CON (ISCFEC 2020), 2020, 128 : 3230 - 3234
  • [10] Geoportal as Decision Support System with Spatial Data Warehouse
    Karabegovic, Almir
    Ponjavic, Mirza
    [J]. 2012 FEDERATED CONFERENCE ON COMPUTER SCIENCE AND INFORMATION SYSTEMS (FEDCSIS), 2012, : 915 - 918