Journal of the Korea Academia-Industrial cooperation Society (한국산학기술학회논문지)

The Korea Academia-Industrial cooperation Society (한국산학기술학회)
권호 표지
DOI QR코드

DOI QR Code

Data-warehouse Prototype for Supporting Master Plan of Renewal Promotion Projects

재정비촉진사업 마스터플랜 지원 데이터웨어하우스 프로토타입

  • Cho, Dong-Hyun (Department of Architectural Engineering, University of Seoul) ;
  • Koo, Kyo-Jin (Department of Architectural Engineering, University of Seoul)
  • 조동현 (서울시립대학교 건축공학과) ;
  • 구교진 (서울시립대학교 건축공학과)
  • Received : 2015.05.19
  • Accepted : 2015.09.11
  • Published : 2015.09.30
Download PDF
⟨ Previous Next ⟩

Abstract

In practice of urban redevelopment promotion projects, since the decision-making is dependent on the verbal agreements between the participants, planning changes are frequently occur. A master plan can be utilized as an effective feedback and adjusting means for decisions. It is a difficult to establish a master plan quickly and effectively to consider the large number of information. Effective decision support system that can storage and retrieval information items systematically and efficiently necessary when planning master plan is required. In this study, a data-warehouse prototype that supports the master planning at early stage was suggested. A metadata index database was developed by identifying information items of base survey results and master plan cases. Also user interface for information searching was presented. The applicability of the prototype was evaluated by case application. It was found that the prototype allows effective searching of desired information through meta data.

재정비촉진사업 실무에서 참여자 간 구두 협의에 의존하고 있어 계획안 자체가 빈번히 변경되는 문제가 발생하고 있다. 마스터플랜이 참여자 의견조율을 위한 수단으로 활용될 수 있지만, 소수의 총괄계획가 및 총괄계획팀이 사업과 관련된 대규모의 정보항목들을 고려하여 마스터플랜을 신속하고 효과적으로 수립하는 것은 한계가 있다. 마스터플랜 수립에 필요한 정보항목들을 체계적 효율적으로 저장하고, 검색이 가능하도록 구성하여 효과적인 의사결정을 지원할 수 있는 시스템이 필요하다. 본 연구에서는 사업초기단계에서의 마스터플랜 수립을 지원하는 데이터웨어하우스 프로토타입을 제안한다. 전문가 면담 및 사례분석을 바탕으로 재정비촉진사업 운영상의 문제점을 도출하고 개선방안을 제시하였다. 마스터플랜을 작성할 때 기본적인 근거자료로 활용되는 기초조사결과와 마스터플랜사례 정보항목을 도출하여 메타데이터 인덱스 데이터베이스를 구축하고 정보검색 사용자 인터페이스를 제시하였다. 프로토타입을 실제 마스터플랜 수립업무 사례에 적용한 결과, 메타데이터를 통한 필요한 정보의 효과적인 검색이 가능하였다.

Keywords

References

  1. S. Seo, and S. Cho, Improvement Strategies of the Master Architect Design System, Housing & Urban Research Institute, Korea National Housing Cooperation, 2003
  2. Y. Kim, K. Baek, and D. Oh, "A Study on the Characteristics of City Center Regeneration in Sheffield, England", Journal of the Architectural Institute of Korea, Planning and Design Section, Vol. 19, No. 9, pp. 69-78, 2003
  3. Y. Ahn, and K. Ahn, "A Study on the Weight of Items for the Effective Operation of Master Planner, as a Design Method Adapted in New Town Development Projects", Journal of the Urban Design Institute of Korea, Vol. 9, No. 1, pp. 5-18, 2008
  4. D. A. Maluf, and P. B. Tran, "Managing Unstructured Data With Structured Legacy Systems", IEEE Aerospace Conference, March 1-8, MT, USA, 2008. DOI: http://dx.doi.org/10.1109/aero.2008.4526666
  5. L. Soibelman, J. Wu, C. Caldas, I. Brilakis and K. Lin, "Management and Analysis of Unstructured Construction Data Types", Journal of Advanced Engineering Informatics, Vol. 22, No. 1, pp. 15-27, 2008. DOI: http://dx.doi.org/10.1016/j.aei.2007.08.011
  6. T. A. El-Diraby, C. Lima and B. Fies, "Domain Taxonomy for Construction Concepts: Toward a Formal Ontology for Construction Knowledge", Journal of Computing in Civil Engineering, Vol. 19, No. 4, pp. 394-406, 2005. DOI:http://dx.doi.org/10.1061/(ASCE)0887-3801(2005)19:4(394)
  7. Y. Zhu, W. Mao and I. Ahmad, "Capturing Implicit Structures in Unstructured Content of. Construction Documents", Journal of Computing in Civil Engineering, Vol. 21, No. 3, pp. 220-227, 2007. DOI: http://dx.doi.org/10.1061/(ASCE)0887-3801(2007)21:3(220)
  8. W. Inmon, Building the Data Warehouse. 2nd ed., John Wiley & Sons Inc, 1996
  9. V. Poe, S. Brobst and P. Klauer, Building a Data warehouse for Decision Support. Prentice Hall PTR, 1996
  10. K. Jeon, Development of data warehouse for decision support in community-based home visiting nurse services. Thesis, Yonsei University, 2001
  11. S. Oh, M. Kim and Y. Kim, "The Application of Data Warehouse for Developing Construction Productivity Management System", Korean Journal of Construction Engineering and Management, Vol. 7, No. 2, pp. 127-137, 2006.
  12. D. Dolk and R. Kirsch, "A Relational Information Resource Dictionary System", Communications of the ACM, Vol. 30, No. 1, 48-61, 1987. DOI: http://dx.doi.org/10.1145/7885.7888
  13. B. Develin, Data Warehouse : from Architecture to Implementation, Addison Wesley Inc., 1996
  14. R. Hackathorn, Data Warehousing Energizes Your Enterprise, Datamation, Vol. 41, No. 2, pp. 38-45, 1995
  15. J. Lee, "Preliminary System Prototype of Construction Data Warehouse", Korean Journal of Construction Engineering and Management, Vol. 5, No. 3, pp. 127-137, 2004
  16. H. Park and K. Koo, "Metadata based Information Management Prototype System of Building Material", Journal of the Architectural Institute of Korea, Structure and Construction Section, Vol. 30, No. 5, pp. 109-116, 2014. DOI: http://dx.doi.org/10.5659/JAIK_SC.2014.30.5.109
  17. G. Noh, H. Lee, D. Cho and K. Koo, "Construction Knowledge Map based Document Management Prototype", Journal of the Architectural Institute of Korea, Structure and Construction Section, Vol. 28, No. 4, pp. 107-114, 2012
  18. H. Park and K. Koo, "Drawing Management Prototype System using Automatic Extracting Information based on Metadata Library", Journal of the Architectural Institute of Korea, Structure and Construction Section, Vol. 30, No. 7, pp. 81-88, 2014. DOI: http://dx.doi.org/10.5659/JAIK_SC.2014.30.7.81
  19. S. Kim, K. Ahn and G. Shim, "An Analysis of the Effectiveness of FAR Incentive System According to Land Donation", Journal of the Urban Design Institute of Korea, Vol. 11, No. 2, pp. 45-62, 2010
  20. H. Lee, E. Hong and T. Kim, "An Architecture for Information System using Data Warehouse", The Journal of MIS Research, Vol. 7, No. 1, pp. 7-24, 1997