A Multidimensional Model of Data Warehouses

Article Preview

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.

You might also be interested in these eBooks

Info:

Periodical:

Advanced Materials Research (Volumes 989-994)

Pages:

1657-1659

Citation:

Online since:

July 2014

Export:

Price:

Permissions CCC:

Permissions PLS:

Сopyright:

© 2014 Trans Tech Publications Ltd. All Rights Reserved

Share:

Citation:

* - Corresponding Author

[1] H. Inmon, Building the Data Warehouse, 3rd ed., John Wiley & Sons, USA, 2002. noro, Italy, (2000).

Google Scholar

[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.

Google Scholar

[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.

DOI: 10.1016/s0926-5805(02)00087-0

Google Scholar

[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.

DOI: 10.1016/j.autcon.2004.03.001

Google Scholar

[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.

DOI: 10.1016/j.autcon.2004.08.016

Google Scholar

[6] J.H. Yoo, S.H. Song, W.H. Lyou, H.S. Lee, Development of performance analysis system for construction projects using a data warehousing echnology, Korean Journal of Construction Engineering and Management6 (1) (2005) 89–98.

Google Scholar