Browse > Article
http://dx.doi.org/10.5762/KAIS.2015.16.9.6376

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)
Publication Information
Journal of the Korea Academia-Industrial cooperation Society / v.16, no.9, 2015 , pp. 6376-6384 More about this Journal
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
Data-warehouse; Master Plan; Metadata; Renewal Promotion Project; Urban Regeneration;
Citations & Related Records
Times Cited By KSCI : 6  (Citation Analysis)
연도 인용수 순위
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   DOI
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)   DOI
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)   DOI
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   DOI
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   DOI
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. 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
19 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
20 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