JOURNAL BROWSE
Search
Advanced SearchSearch Tips
Data-warehouse Prototype for Supporting Master Plan of Renewal Promotion Projects
facebook(new window)  Pirnt(new window) E-mail(new window) Excel Download
 Title & Authors
Data-warehouse Prototype for Supporting Master Plan of Renewal Promotion Projects
Cho, Dong-Hyun; Koo, Kyo-Jin;
  PDF(new window)
 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;
 Language
Korean
 Cited by
 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 crossref(new window)

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) crossref(new window)

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) crossref(new window)

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 crossref(new window)

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 crossref(new window)

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