Spatial Data Warehouse Design and Spatial OLAP Implementation for Decision Making of Geospatial Data Update

다국어 초록 (Multilingual Abstract)

Many authorities and local governments collect and maintain immense geospatial databases composed of various types of vector and raster data. These geospatial data need to be updated and monitored on a regular basis to provide accurate information. As the mapping area and the variety of data (GPS, DEM, LIDAR, aerial photography, satellite imagery, 3D building models, texture images,videos, etc.) collected for these areas increase, the maintenance costs also increases. Therefore, it is crucial to make effective costsaving decisions regarding the time, place, and type of geospatial data to be updated. In this study, geospatial data updating criteria are discussed and a multi-dimensional database model is proposed to aid the decision-making process in updating geospatial data.
Based on this model, a star schema SDW (Spatial Data Warehouse) is designed and a SOLAP (Spatial OLAP) is implemented to aid in making optimal decisions regarding geospatial database updating.

다국어 초록 (Multilingual Abstract)

Many authorities and local governments collect and maintain immense geospatial databases composed of various types of vector and raster data. These geospatial data need to be updated and monitored on a regular basis to provide accurate information. As the mapping area and the variety of data (GPS, DEM, LIDAR, aerial photography, satellite imagery, 3D building models, texture images,videos, etc.) collected for these areas increase, the maintenance costs also increases. Therefore, it is crucial to make effective costsaving decisions regarding the time, place, and type of geospatial data to be updated. In this study, geospatial data updating criteria are discussed and a multi-dimensional database model is proposed to aid the decision-making process in updating geospatial data.
Based on this model, a star schema SDW (Spatial Data Warehouse) is designed and a SOLAP (Spatial OLAP) is implemented to aid in making optimal decisions regarding geospatial database updating.

참고문헌 (Reference)

1 조재희, "시공간데이터 분석을 위한 다차원 모델과 시각적 표현에 관한 연구" 한국데이타베이스학회 13 (13): 137-147, 2006

2 신동빈, "수치지도 수정·갱신을 위한 건설공사 준공도면 활용방안 연구" 한국공간정보시스템학회 10 (10): 35-43, 2008

3 전치수, "공간 데이터웨어하우스에서 시공간 분석 지원을 위한 비중복 적재기법" 한국공간정보시스템학회 9 (9): 81-91, 2007

4 Fernando, J. B., "Warehousing and mining aggregate measures concerning trajectories of moving objects" Universit`aCa’ Foscari di Venezia 2009

5 Sonia, R., "Toward better support for spatial decision making: Defining the characteristics of Spatial Online Analytical Processing (SOLAP)" 55 (55): 539-555, 2001

6 Choi, B. G., "The establishment of quality estimation elements for spatial data" 327-331, 2005

7 Golfarelli, M., "The dimensional fact model: A conceptual model for data warehouses" 7 (7): 215-247, 1998

8 National Geographic Information Institute, "Systematic plans of digital map's modification and updating, Notice 2006-155"

9 Gopalkrishnan, V, "Star/snow-flake schema driven object-relational data warehouse design and query processing strategies" 1676 : 1999

10 Yom, J. H., "Spatial data warehouse design for updating of spatial data" 1742-1745, 2009

11 Bédard, Y., "Spatial On-Line Analytical Processing (SOLAP): Concepts architectures and solutions from a geomatics engineering perspective, In Data Warehouses and OLAP Solutions, Chap. 13" IRM Press 298-319, 2007

12 Bimonte, S., "Spatial OLAP: Open issues and a web based prototype" 1-11, 2007

13 Bédard, Y, "Spatial OLAP"

14 Scotch, M, "SOVAT: Spatial OLAP visualization and analysis tool" 1-7, 2005

15 Rivest, S., "SOLAP technology: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data" 60 : 17-33, 2005

16 Refractions, "Postgis 1.3.6"

17 Bédard, Y., "Merging hypermedia GIS with spatial on-line analytical processing" 167-185, 2006

18 Intelli3, "JMAP Spatial OLAP (Map4Decision). Retrieved September15th"

19 Bédard, Y., "Integrating GIS components with knowledge discovery technology for environmental health decision support" 70 (70): 79-94, 2003

20 Spatialytics, "GeoKettle v3.2.0"

21 Bimonte, S., "GeWOlap: A web based spatial OLAP proposal" Springer BerlinHeidelberg: On the Move to Meaningful Internet Systems 1596-1605, 2006

22 Bédard, Y., "Fundamentals of spatial data warehousing for geographic knowledge discovery, In Geographic Data Mining and Knowledge Discovery" Taylor and Francis 2001

23 Kim, Y. H., "Expected problems in the production of nationwideseamless map using heterogeneous spatial data - with emphasis ondigital maps" Photogrammetry, and Cartography 311-315, 2007

24 Papadias, D., "Efficient OLAP operations in spatial data warehouses" 443-459, 2001

25 Bernier, E., "Easier surveillance of climate-related health vulnerabilities through a webbased spatial OLAP application" 8 (8): 1-18, 2009

26 Jin, H. C, "Building up spatial data warehouses into the spatial data infrastructure" 2 (2): 2000

27 Inmon, W. H., "Building the data warehouse, 4th ed" Wiley Publishing, Inc 2005

28 Yom, J. H., "Application of spatial metadata standards for catalog web servicesin Korea" 423-426, 2007

29 Chaudhuri, S, "An overview of data warehousing and OLAP technology" 26 (26): 65-74, 2000

30 Vassiliadis, P, "A survey on logical models for OLAP databases" 28 (28): 64-69, 1999

31 Korean Association of Surveying & Mapping, "A study on the real-time revision method for GIS DB, Ministry of Land" Transport and Maritime Affairs 92-110, 2003

32 Ok, G. H., "A spatial data cubes with concept hierarchy on spatial data warehouse" 13 (13): 35-38, 2006

33 Gabriel, P., "A spatial dashboard: Analyzing vechicle ground movement safety performance" 1-9, 2006