Browse > Article

Spatial OLAP Implementation for GIS Decision-Making - With emphasis on Urban Planning -  

Kyung, Min-Ju (세종대학교 지구정보공학과)
Yom, Jae-Hong (세종대학교 지구정보공학과)
Publication Information
Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography / v.27, no.6, 2009 , pp. 689-698 More about this Journal
Abstract
SOLAP system integrates and complements the functions of both OLAP and GIS systems. This enables users not only to easily access geospatial data but also to analyze and extract information for decision making. In this study a SOLAP system was designed and implemented to provide urban planners with GIS information when making urban planning decisions. Rapid urbanization in Korea has brought about ill-balanced urban structure as the result of development without detailed analysis of urban plans. Systematic urban planning procedures and automated systems are crucial for detail analysis of future development plans. Data regarding the development regulations and current status of land use need to be assessed precisely and instantly. Multi-dimensional aspects of a suggested plan must be formulated instantly and examined thoroughly using 'what if' scenarios to come up with a best possible plan. The SOLAP system presented in this study designed the dimension tables and the fact tables for supplying timely geospatial information to the planners when making decisions regarding urban planning. The database was implemented using open source DBMS and was populated with necessary attribute data which was freely available from the Statistics Korea bureau homepage. It is anticipated the SOLAP system presented in this study will contribute to better urban planning decisions in Korea through more timely and accurate provision of geospatial information.
Keywords
Spatial DBMS; GIS; SOLAP; Decision-Making; Urban Planning;
Citations & Related Records

Times Cited By SCOPUS : 0
연도 인용수 순위
  • Reference
1 김영우, 문영기 (2008), 도시기본계획상 토지이용계획 수립의 한계와 개선방안, 국토연구원, v.58, pp. 95-114
2 Papadias, D., Kalnis, P., Zhang, J. and Tao, Y. (2001), Efficient OLAP Operations in Spatial Data Warehouses, Proceedings of the 7th International Symposium on Advances in Spatial and Temporal Databases, pp. 443-459
3 Bimonte, S., Wehrle, P., Tchounikine, A. and Miquel M. (2006), GeWOlap: A Web Based Spatial OLAP Proposal, Springer Berlin Heidelberg, On the Move to Meaningful Internet Systems 2006:OTM 2006 Workshops pp. 1596-1605
4 http://www.kostat.go.kr (Accessed Oct. 15, 2009)
5 Bimonte, S., Tchounikine, A., and Miquel, M. (2007), Spatial OLAP:Open Issues and a Web Based Prototype, 10th AGILE International Conference on Geographic Information Science 2007, pp. 1-11
6 K2 GeoSpatial (2007), JMap 3.1 Administrator Manual, K2 GeoSpatial, pp. 1-156
7 염형민, 이승일, 전유신 (2002), 도시계획정보체계 개발 모델 연구, 한국GIS학회지, 한국GIS학회, v.10, no.1,pp. 81-97
8 Rivest, S., B\acute{e}dard, Y., Proulx, M. J., Nadeau, M., Hubert, F. and Pastor, J. (2005), SOLAP Technology: Merging Business Intelligence with Geospatial Technology for Interactive Spatio-Temporal Exploration and Analysis of Data, ISPRS Journal of Photogrammetry & Remote Sensing, v.60, pp. 17-33   DOI   ScienceOn
9 김정희, 정지수, 권영진 (2008), 도시계획과 토지이용규제 정보화의 현황과 전망, 대한국토·도시계획학회, no.9, pp. 18-23
10 B\acute{e}dard Y., Merett T., Han J. (2001), Fundamentals of Spatial Data Warehousing for Geographic Knowledge Discovery, Geographic Data Mining and Knowledge Discovery, Research Monographs in Geographic Information Systems, pp. 52-72
11 Proulx, M. J. (2009), How to Build JMap SOLAP Datacubes, University Laval, pp. 1-21
12 http://www.mltm.go.kr (Accesed Oct. 15, 2009)
13 Scotch, M., Parmanto, B. (2005), SOVAT:Spatial OLAP Visualization and Analysis Tool, Proceedings of the 38th Hawaii International Conference on System Sciences, pp. 1-7   DOI
14 김형복 (2007), 도시계획정보체계와 국토이용정보체계, 한국GIS학회, 2007 한국GIS 학회 추계학술대회, 한국GIS 학회, pp. 141-157
15 김태명 (2000), 싱가포르 국가연구 - 도시계획의 특성분석을 중심으로, 한국정책과학학회, v.4, no.1,pp. 3-25
16 김정훈, 강현수, 양승우, 이병철, 김동한 (2005), 유비쿼터스와 도시계획, 대한국토·도시계획학회, v.4, no.277, pp. 3-13
17 http://www.kheops-tech.com (Accessed Oct. 15, 2009)
18 http://spatialolap.scg.ulaval.ca (Accessed Oct. 15, 2009)
19 김훈 (2001), 프랑스의 도시계획체계와 공정 토지 취득 법제의 제유형에 관한 고찰, 국토연구원, pp. 147-163