DOI QR코드

DOI QR Code

Development of Data Warehouse for Construction Material Management

건설공사 자재 관리를 위한 데이터 웨어하우스 개발

  • Ryu, Han-Guk (Department of Architectural Engineering, Changwon National University)
  • Received : 2010.08.31
  • Accepted : 2010.09.26
  • Published : 2011.06.20

Abstract

During a construction project, construction managers must be provided with material information to help them to make decisions more efficiently without delaying the delivery of material. Construction work can be smoothly performed with the proper material supply. Construction duration depends on several material-related decisions, including the order, delivery, and allocation of material to the correct work location. Hence, it is worthwhile to introduce data warehouse techniques that generate subject-oriented and integrated data to construction material management. The data warehouse for construction material management can perform multidimensional analysis and then define KPIs (Key Performance Index) in order to provide construction managers with construction material information such as lead time, material delivery rate, material installation rate and so on. This research proposes a method of effectively facilitating large amounts of data in the operating systems during the construction management process. In other words, the proposed method can supply structured and multi-perspective material-related information using data warehouse techniques.

건설공사는 수많은 자원 중 상당부분이 자재공급업체에서 제공하는 자재의 원활한 공급에 따라 작업의 원활성이 결정된다. 자재를 적기에 조달하고 배분하는 결과에 따라 작업이 순조롭게 진행되고 궁극적으로 소기의 공사기간 내에 공사를 완료할 수 있다. 본 연구는 데이터 웨어하우스 기술을 활용하여 건설공사에서 중요한 자재관리에 활용할 수 있는 방법을 제시하였다. 건설공사의 자재관리를 위해 필요한 자재리드타임, 자재조달비율, 자재설치비율 등에 대한 정보를 다차원적으로 분석하고 KPI를 설정하여 의사결정 정보로 활용할 수 있도록 하였다. 궁극적으로 본 연구는 건설공사의 운영계 시스템에서 발생하는 수많은 자재관련 데이터들을 효과적으로 활용하는 방법을 제시하였다. 즉, 주제 중심적이고 통합적인 데이터를 제공할 수 있는 데이터 웨어하우스 기술을 활용하여 체계적인 자재관리 정보를 제공할 수 있도록 하였다.

Keywords

References

  1. Inmon B. Building the data warehouse. New York: John Wiley & Sons,Inc; 2002. 412 p.
  2. Oracle Korea. [Data warehouse research book]. Seoul (Korea): Oracle Korea; 2003. 114 p. Korean.
  3. Chau KW, Cao Y, Anson M, Zhang J. Application of data warehouse and decision support system in construction management. Automation in Construction. 2003 Mar;12(2):213-24. https://doi.org/10.1016/S0926-5805(02)00087-0
  4. 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 July;13(4):525-42. https://doi.org/10.1016/j.autcon.2004.03.001
  5. 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 Jun;14(3):405-12. https://doi.org/10.1016/j.autcon.2004.08.016
  6. Lee JK. [Preliminary system prototype of construction data warehouse]. Korean Journal of Construction Engineering and Management. 2004 Jun;5(3):165-73. Korean.
  7. Rujirayanyong T, Shi JJ. A project-oriented data warehouse for construction. Automation in Construction. 2006 Nove;15(6):800-7. https://doi.org/10.1016/j.autcon.2005.11.001
  8. Oh SW, Kim MH, Kim YS. [The application of data warehouse for developing construction productivity management system]. Korean Journal of Construction Engineering and Management.. 2006 April;7(2):127-37. Korean.
  9. Park MS, Kim N, Lee HS, Ahn C, Lee KS. [Construction project performance management using BSC and Data Warehouse]. Korean Journal of Construction Engineering and Management. 2009 Mar;10(2):14-25.
  10. Fan H, Kim H, Zaiane OR. Data warehousing for construction equipment management. Canadian Journal of Civil Engineering. 2006 July;33:1480-9.

Cited by

  1. A Basic Model of the Procurement Planning of Resources by Activity in Construction Projects vol.12, pp.3, 2012, https://doi.org/10.5345/JKIBC.2012.12.3.340