Browse > Article
http://dx.doi.org/10.5345/JKIC.2011.04.2.100

OLAP and Decision Tree Analysis of Productivity Affected by Construction Duration Impact Factors  

Ryu, Han-Guk (Department of Architectural Engineering, Changwon National University)
Publication Information
Journal of the Korea Institute of Building Construction / v.11, no.2, 2011 , pp. 100-107 More about this Journal
Abstract
As construction duration significantly influences the performance and the success of construction projects, it is necessary to appropriately manage the impact factors affecting construction duration. Recently, interest in the construction industry has been rising due to the recent change in the construction legal system, and the competition among the construction companies on construction time. However, the impact factors are extremely diverse. The existing productivity data on impact factors is not sufficient to properly identify the impact factor and measure the productivity from various perspectives, such as subcontractor, time, crew, work and so on. In this respect, a multidimensional analysis by a data warehouse is very helpful in order to view the manner in which productivity is affected by impact factors from various perspectives. Therefore, this research proposes a method that effectively takes the diverse productivity data of impact factors, and generates a multidimensional analysis. Decision tree analysis, a data mining technique, is also applied in this research in order to supply construction managers with appropriate productivity data on impact factors during the construction management process.
Keywords
Construction Duration Impact Factor; Productivity; Multidimensional Analysis; Decision Tree; Data Warehouse;
Citations & Related Records
Times Cited By KSCI : 4  (Citation Analysis)
연도 인용수 순위
1 Lee JK. Preliminary system prototype of construction data warehouse. Korea Institute of Construction Engineering and Management 2004; 5(3): 165-173.   과학기술학회마을
2 Ahmad I, Azhar S, Lukauskis P. Development of a decision support system using data warehousing to assist builders/developers in site selection. Automation in Construction 2004; 13(4):525-542.   DOI   ScienceOn
3 Zhiliang M, Wong KD, Heng L, Jun Y. Utilizing exchanged documents in construction projects for decision support based on data warehousing technique. Automation in Construction 2005; 14(3):405-412.   DOI   ScienceOn
4 Rujirayanyong T, Shi JJ. A project-oriented data warehouse for construction. Automation in Construction 2006; 15(6):800-807.   DOI   ScienceOn
5 Oh SW, Kim MH, Kim YS. The application of data warehouse for developing construction productivity management system. Korea Institute of Construction Engineering and Management 2006; 7(2): 127-137.   과학기술학회마을
6 Fan H, Kim H, Zaiane OR. Data warehousing for construction equipment management. Canadian Journal of Civil Engineering 2006; 33:1480-1489.   DOI   ScienceOn
7 Oracle Korea. Data warehouse research book. 2003.
8 Ryu HG, Kim SK, Lee HS. A Competitive advantage analysis of construction duration through the comparison of actual data of domestic construction firms-focused on mix-use residential building and officetel building-. Korea Institute of Construction Engineering and Management 2006; 7(1):138-147.   과학기술학회마을
9 Ryu HG. A method for calculating schedule delay considering lost productivity [MS dissertation]. Seoul: Seoul National University; 2003.
10 Codd EF, Codd SB, Salley CT. Providing OLAP (On-line Analytical Processing) to User-Analysts: An IT Mandate, Sunnyvale: Codd & Associates. 1993.
11 Kwon OJ. OLAP solutions + $\alpha$ SQL server 2000 analysis services, Seoul: Daerim, 2001.
12 Chau KW, Cao Y, Anson M, Zhang J. Application of data warehouse and decision support system in construction management. Automation in Construction 2003; 12(2):213-224.   DOI   ScienceOn