Affiliation:
1. First Aeronautic Institute of Air Force
Abstract
Reducing query time by means of selecting a proper set of materialized views with a lower cost is crucial for effcient datawarehousing. The database, however, needs to be utilized more, by providing a functional environment of probability analysis. The objective of this paper is to improve the effectiveness of utilizing historical cost data in an analytical OLAP (On-Line Analytical Processing) environment. The results show that the OLAP environment can help understand the uncertainties inconstruction cost estimate, and provide a way for projecting more reliable construction costs.
Publisher
Trans Tech Publications, Ltd.
Reference6 articles.
1. H. Inmon, Building the Data Warehouse, 3rd ed., John Wiley & Sons, USA, 2002. noro, Italy, (2000).
2. J.K. Lee, H.S. Lee, Principles and strategies for applying data warehouse technology to construction industry, Architectural Research 5 (1) (2003)61–68.
3. K.W. Chau, Y. Cao, M. Anson, J. Zhang, Application of data warehouse and decision support system in construction management, Automation in Construction 12 (2002) 213–224.
4. I. Ahmad, S. Azhar, P. Lukauskis, Development of a decision support system using data warehousing to assist builders/developers in site selection, Automation in Construction 13 (2004) 525–542.
5. M. Zhiliang K.D. Wong,L. Heng,Y. Jun, Utilizing exchanged documents in construction projects for decision support based on data warehousing technique, Automation in Construction 14 (2005) 405–412.