Skip to main content
SpringerLink
Log in

Spatial data warehouse design and spatial OLAP implementation for decision making of geospatial data update

  • Research Paper
  • Surveying and Geo-Spatial Information Engineering
  • Published:
KSCE Journal of Civil Engineering Aims and scope

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  • Bédard, Y. (2009). Spatial OLAP, Canada, http://spatialolap.scg.ulaval.

  • Bédard, Y., Gosselin, P., Rivest, S., Proulx, M. J., Nadeau, M., Lebel, G., and Gagnon, M. F. (2003). “Integrating GIS components with knowledge discovery technology for environmental health decision support.” International Journal of Medical Informatics, Vol. 70, No. 1, pp. 79–94.

    Article  Google Scholar 

  • Bédard, Y., Merrett, T., and Han, J. (2001). Fundamentals of spatial data warehousing for geographic knowledge discovery, Geographic Data Mining and Knowledge Discovery, Miller, H. and Han, J. (eds.), Taylor and Francis, London.

    Google Scholar 

  • Bédard, Y., Proulx, M. J., Rivest, S. and Badard, T. (2006). “Merging hypermedia GIS with spatial on-line analytical processing.” Geographic Hypermedia, pp.167–185.

  • Bédard, Y., Rivest, S., and Proulx, M. J. (2007). “Spatial On-Line Analytical Processing (SOLAP): Concepts architectures and solutions from a geomatics engineering perspective.” Data Warehouses and OLAP Solutions, Chap. 13, IRM Press (Idea Group), pp. 298–319.

  • Bernier, E., Gosselin, P., Badard, T., and Bédard, Y. (2009). “Easier surveillance of climate-related health vulnerabilities through a webbased spatial OLAP application.” International Journal of Health Geographics, Vol. 8. No. 18, pp. 1–18.

    Google Scholar 

  • Bimonte, S., Tchounikine, A., and Mique, M. M. (2007). “Spatial OLAP: Open issues and a web based prototype.” Proc., 10th AGILE International Conference on Geographic Information Science, Denmark., pp. 1–11.

  • Bimonte, S., Wehrle, P., Tchounikine, A., and Miquel, M. M. (2006). “GeWOlap: A web based spatial OLAP proposal.” Springer Berlin Heidelberg: On the Move to Meaningful Internet Systems, pp. 1596–1605.

  • Chaudhuri, S. and Dayal, U. (2000). “An overview of data warehousing and OLAP technology.” ACM Sigmod Record, Vol. 26, No. 1, pp. 65–74.

    Article  Google Scholar 

  • Cho, J. H. and Seo, I. J. (2006). “Multidimensional model for spatiotemporal data analysis and its visual representation.” Journal of Information Technology Application & Management, Vol. 13, No. 1, pp. 137–147.

    Google Scholar 

  • Choi, B. G., An, K. D., Shin, S. H., and Cho, K. H. (2005). “The establishment of quality estimation elements for spatial data.” Geographic Information System Association of Korea, pp. 327–331.

  • Fernando, J. B. (2009). Warehousing and mining aggregate measures concerning trajectories of moving objects, PhD Thesis, Università Ca’ Foscari di Venezia, Italia.

    Google Scholar 

  • Gabriel, P., Miguel, M. S., João, N., and Telmo, A. (2006). “A spatial dashboard: Analyzing vechicle ground movement safety performance.” 9th International IEEE Conference on Intelligent Transportation Systems, Canada, pp. 1–9.

  • Golfarelli, M., Maio, D., and Rizzi, S. (1998). “The dimensional fact model: A conceptual model for data warehouses.” International Journal of Cooperative Information Systems, Vol. 7, Nos. 2–3, pp. 215–247.

    Article  Google Scholar 

  • Gopalkrishnan, V., Li, Q., and Karlapalem, K. (1999). “Star/snow-flake schema driven object-relational data warehouse design and query processing strategies.” Workshop on Data Warehousing and Knowledge Discovery (DaWaK), No. 1676 in LNCS. Springer.

  • Inmon, W. H. (2005). Building the data warehouse, 4th ed., Wiley Publishing, Inc, Indianapolis, Indiana.

    Google Scholar 

  • Intelli3 (2009). JMAP Spatial OLAP (Map4Decision). Retrieved September 15th from http://www.kheops-tech.com/en/jmap/solap.jsp.

  • Jeon, C. S., Lee, D. W., You, B. S., Lee, S. J., and Bae, H. Y. (2007). “Non-duplication loading method for supporting spatio-temporal analysis in spatial data warehouse.” KOREA Spatial Information System Society, Vol. 9. No. 2. pp. 81–91.

    Google Scholar 

  • Jin, H. C. and Jeong, S. R. (2000). “Building up spatial data warehouses into the spatial data infrastructure.” KOREA Spatial Information System Society, Vol. 2. No. 2. pp. 89–97.

    Google Scholar 

  • Kim, Y. H., Jeong, J. Y., Kyoung, M. J, Yom, J. H., and Lee, D. C. (2007). “Expected problems in the production of nationwide seamless map using heterogeneous spatial data — with emphasis on digital maps.” Proc., 2007 Annual Conference of Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography, Korea, pp. 311–315.

  • Korean Association of Surveying & Mapping (2003). A study on the real-time revision method for GIS DB, Ministry of Land, Transport and Maritime Affairs, pp. 92–110.

  • National Geographic Information Institute (2006). Systematic plans of digital map’s modification and updating, Notice 2006-155 from http://www.ngii.go.kr/kor/board/view.do?rbsIdx=44&idx=870.

  • Ok, G. H., Lee, D. W., You, B. S., and Bae, H. Y. (2006). “A spatial data cubes with concept hierarchy on spatial data warehouse.” Korea Information Processing Society, Vol. 13. No. 1. pp. 35–38.

    Google Scholar 

  • Papadias, D., Kalnis, P., Zhang, J., and Tao, Y. (2001). “Efficient OLAP operations in spatial data warehouses.” Proc., 7th International Symposium on Advances in Spatial and Temporal Databases, California, pp. 443–459.

  • Refractions (2009). Postgis 1.3.6, Retrieved July 15th from http://postgis.refractions.net.

  • Rivest, S., Bé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, Vol. 60, pp. 17–33.

    Article  Google Scholar 

  • Scotch, M. and Parmanto, B. (2005). “SOVAT: Spatial OLAP visualization and analysis tool.” Proc., 38th Hawaii International Conference on System Sciences, Hawaii, pp. 1–7.

  • Shin, D. B. and Yu, S. C. (2008). “A study on the application of as-built drawings for updating digital maps.” KOREA Spatial Information System Society, Vol. 10, No. 4, pp. 37–45.

    Google Scholar 

  • Sonia, R., Yvan, B., and Pierre, M. (2001). “Toward better support for spatial decision making: Defining the characteristics of Spatial Online Analytical Processing (SOLAP).” Geomatica, Vol. 55, No. 4, pp. 539–555.

    Google Scholar 

  • Spatialytics (2009). GeoKettle v3.2.0, Canada, Retrieved July 25th from http://sourceforge.net/projects/geokettle.

  • Vassiliadis, P. and Sellis, T. (1999). “A survey on logical models for OLAP databases.” ACM SIGMOD Record, Vol. 28, No. 4, pp. 64–69.

    Article  Google Scholar 

  • Yom, J. H., Kyoung, M. J., Jeong, J. Y., and Lee, D. C. (2007). “Application of spatial metadata standards for catalog web services in Korea”. Proc., the Korean Society of Remote Sensing (KSRS), Korea, pp. 423–426.

  • Yom, J. H., Kyung, M. J., Kim, S. Y., and Seo, Y. M. (2009). “Spatial data warehouse design for updating of spatial data.” Proc., 35 th Annual Conference of Korean Society of Civil Engineers, Korea, pp. 1742–1745.

Download references

Author information

Authors and Affiliations

  1. Dept. of Geoinformation Engineering, Sejong University, Seoul, 143-747, Korea

    Min-Ju Kyung, Jae-Hong Yom & Seung-Yong Kim

Authors
  1. Min-Ju Kyung
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jae-Hong Yom
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Seung-Yong Kim
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Jae-Hong Yom.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Kyung, MJ., Yom, JH. & Kim, SY. Spatial data warehouse design and spatial OLAP implementation for decision making of geospatial data update. KSCE J Civ Eng 16, 1023–1031 (2012). https://doi.org/10.1007/s12205-012-1410-2

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s12205-012-1410-2

Keywords

Search

Navigation