Abstract
The integration of a Data Warehouse and a Decision Support System (DSS) can provide construction managers with sufficient information for decision making without interrupting daily work of an On-Line Transaction Processing system. In this paper, the concepts of the data warehouse, On-Line Analysis Processing and DSS are first reviewed. 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. An application example is given to illustrate the use of the Construction Management Decision Support System developed in this study. This prototype system can enable the right data to be tracked down and provides 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 more efficiently. Moreover, the approach can be applied to other fields.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Sarda, N.L.: Temporal Issues in Data Warehouse Systems. Proceedings of the International Symposium on Database Application in Non-traditional Environments. (1999) 27–34
Yang, Jyh-Bin, Yau, Nie-Jia: Application of Case-Based Reasoning in Construction Engineering and Management. Proceedings of the Third Congress of Computing in Civil Engineering held in conjunction with A/E/C Systems. (1996) 663–669
Vanegas, J., Chinowsky, P.: Computing in civil Engineering. American Society of Civil Engineers (1996)
Dyche, J.: e-Data Turning Data into Information with Data Warehousing. Addison-Wesley (2000)
Poe, V., Klauer, P., Brobst S.: Building A Data warehouse for Decision Support. Prentice Hall (1998)
Samtani, S., Mohania, M., Kumar, V., Kambayashi, Y.: Recent Advances and Research Problems in Data Warehousing. Advances in Database Technologies. Proceedings of ER’98 Workshops on Data Warehousing and Data Mining, Mobile Data Access, and Collaborative Work Support and Spation-temporal Data Management. Singapore (1998) 81–92
Marks, W.T., Frolick, M.N.: Building Customer Data Warehouses for a Marketing and Service Environment: A Case Study. Information Systems Management 18(3) (2000) 51–56
Corey, M., Abbey M.: SQL Server 7 Data Warehousing. McGraw-Hill (1999)
Peterson, T., Pinkelman, J.: Microsoft OLAP Unleashed. SAMS (1999)
Thomsen, E., Spofford, G., Chase, D.: Microsoft OLAP Solutions. Wiley Computer Publishing (1999)
Vassiliadis, P., Skiadopoulos, S.: Modelling and Optimisation Issues for multidimensional Databases. Proceedings of the 12th International Conference on Advanced Information System Engineering. Stockholm (2000) 482–497
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Cao, Y., Chau, K.W., Anson, M., Zhang, J. (2002). An Intelligent Decision Support System in Construction Management by Data Warehousing Technique. In: Han, Y., Tai, S., Wikarski, D. (eds) Engineering and Deployment of Cooperative Information Systems. EDCIS 2002. Lecture Notes in Computer Science, vol 2480. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45785-2_28
Download citation
DOI: https://doi.org/10.1007/3-540-45785-2_28
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-44222-6
Online ISBN: 978-3-540-45785-5
eBook Packages: Springer Book Archive