GlobeOLAP - Improving the Geospatial Realism in Multidimensional Analysis Environment

Vinícius Ramos Toledo Ferraz, Marilde Terezinha Prado Santos

2010

Abstract

The combination of Geographic Data Warehouses (GDW) and Spatial OLAP (SOLAP) provide efficient browsing and storing of very large spatio-temporal databases. However, some advanced techniques of geovisualization are not well supported in many of these tools. Three-dimensional Thematic Mapping through Virtual Globes is one of them, and it can provide a friendly but powerful mechanism for summarize visually huge amounts of geospatial-analytical data and their changes over time. This paper shows the GlobeOLAP, a prototype of a Web-based SOLAP tool that allows the customized generation of many types of Thematic Maps to be visualized three-dimensionally in a Virtual Globe (Google Earth), together with the traditional tabular view. This tool can improve management decisions by allowing managers to identify patterns and build knowledge in a spatial realistic environment.

References

  1. Abelló A., Romero, O. (2009) On-Line Analytical Processing. In Liu L., Özsu M. T. (Ed.), Encyclopedia of Database Systems (Vol. 20, pp. 2731-2735). Berlin: Springer.
  2. Andrienko G. et al. (2007). Geovisual analytics for spatial decision support: Setting the research agenda. International Journal of Geographical Information Science, 21(8), 839-857. doi:10.1080/ 13658810701349011
  3. Bédard, Y., (1997). Spatial OLAP. In Geomatics IV, Annual Forum on R&D. Canadian Institute of Geomatics.
  4. Butler, D. (2006). Virtual globes: The web-wide world. Nature, (439), 776-778. doi:10.1038/439776a
  5. Bédard , Y. et al. (2005). Merging Hypermedia GIS with Spatial On-Line Analytical Processing: Towards Hypermedia SOLAP. In Stefanakis, E. et al. (Ed.), Geographic Hypermedia (Lecture Notes in Geoinformation and Cartography), 167-187. Berlin: Springer. doi: 10.1007/978-3-540-34238-0
  6. Bimonte, S. et al. (2006). GeWOlap: A Web Based Spatial OLAP Proposal. In Second International Workshop on Semantic-based Geographical Information Systems. Springer-Verlag.
  7. Chaudhuri S., Dayal, U. (1997). An overview of data warehousing and OLAP technology. ACM SIGMOD Record, 26(1), 65-74. http://doi.acm.org/10.1145/ 248603.248616
  8. Colonese, G. et al. (2004). PostGeoOlap: an Open-Source Tool for Decision Support. In II Brazilian Symposium on Information Systems.
  9. Compieta, P. et al. (2007). Exploratory spatio-temporal data mining and visualization. Journal of Visual Languages and Computing, 18, 255-279. doi:10.1016/j.jvlc.2007.02.006
  10. Craglia et al., Next-Generation Digital Earth. (2008) International Journal of Spatial Data Infrastructures Research, 3, 146-167.
  11. Dykes, J., MacEachren, A. M., Kraak, M. (2005). Exploring Geovisualization. Amsterdam: Elsevier.
  12. da Silva, R. O. L., Manhães, R. S., Gitahy, P. F. WebGeoOlap: Visualização de dados multidimensionais e geográficos para ambiente web. Revista de Sistemas de Informação, 1. FSMA.
  13. Damiani, M. L., and Spaccapietra S. (2006). Spatial Data Warehouse Modeling. In Darmont, J. & Boussaid, O. (Ed.), Processing and Managing Complex Data for Decision Support (pp. 1-27). IDEA Group Publishing.
  14. Di Martino, S. et al. (2009). Integrating Google Earth within OLAP Tools for Multidimensional Exploration and Analysis of Spatial Data. Enterprise Information Systems (LNBIP), 24, 940-951. doi:10.1007/978-3- 642-01347-8_78
  15. ESRI (2010). OLAP for ArcGIS. Retrieved February 22, 2010, from http://www.esri.com/software/arcgis/ extensions/olap/
  16. Fidalgo, R. N. et al. (2004). Providing Multidimensional and Geographical Integration Based on a GDW and Metamodels. In SBBD'2004, XIX Brazilian Symposium on Databases. SBC.
  17. Field, R. T. and Taylor, R. N. (2002). Principled design of the modern Web architecture. ACM Transactions on Internet Technology (TOIT), 2(2), 115-150. http://doi.acm.org/10.1145/514183.514185.
  18. Goodchild, M. F. (2008). The use cases of digital earth. International Journal of Digital Earth, 1(1), 31-42. Taylor & Francis. doi:10.1080/17538940701782528
  19. Google (2010a). Google Maps API. Retrieved February 22, 2010, from http://code.google.com/apis/maps/
  20. Google (2010b). Google Earth. Retrieved February 22, 2010, from http://earth.google.com/
  21. Google (2010c). Google Earth API. Retrieved February 22, 2010, from http://code.google.com/apis/earth/
  22. Han, J., Kopersky, K., Stefanovic, N. (1997). GeoMiner: A System Prototype for Spatial Data Mining. ACMSIGMOD Int. Conf. Management of Data. New York: ACM Press.
  23. Hodza, P. (2009). Evaluating User Experience of Experiential GIS. Transactions in GIS, 13(5-6), 503- 525. Blackwell Publishing. doi:10.1111/j.1467- 9671.2009.01176.x
  24. Inmon, W. H. (2005). Building the data warehouse (4th ed.). New York: John Willey and Sons.
  25. JPivot (2010). JPivot. Retrieved February 22, 2010, from http://jpivot.sourceforge.net/
  26. JRubik (2010). Introduction to JRubik. Retrieved February 22, 2010, from http://rubik.sourceforge.net/jrubik/ intro.html
  27. Kimball, R. and Ross, M. (2002). Data Warehouse Toolkit (2nd ed.). New York: John Willey and Sons.
  28. MacEachren, A. M., (1979). The evolution of thematic cartography: A research methodology and historical review. Canadian Cartographer, 16, 17-33.
  29. MacEachren, A. M. et al. (1999). Virtual environments for geographic visualization: potential and challenges. New Paradigms in Information Visualization and Manipulation, 35-40. New York: ACM Press.
  30. MacEachren, A. M. et al. (2004). Geovisualization for Knowledge Construction and Decision Support. IEEE Computer Graphics and Applications, 24(1), 13-17. Los Alamitos: IEEE Computer Society Press. doi: 10.1109/MCG.2004.1255801
  31. McHugh, R., Roche, S., Bédard, Y. (2008). Towards a SOLAP-based public participation GIS. Journal of Environmental Management, 90(6), 2041-2054. doi:10.1016/j.jenvman.2008.01.020
  32. Microsoft (2010). Bing Maps Platform. Retrieved February 22, 2010, from http://www.microsoft.com/ maps/developers/
  33. Monmonier, M. (1996). How to Lie with Maps (2nd ed.). Chicago: The University of Chicago Press
  34. NASA (2010). NASA World Wind. Retrieved February 22, 2010, from http://worldwind.arc.nasa.gov/java/
  35. OGC (2007). The OpenGIS® Web Processing Serivce. Retrieved February 22, 2010, from http://www.opengeospatial.org/standards/wps/
  36. OpenLayers (2010). OpenLayers: Free Maps for the Web. Retrieved February 22, 2010, from http://openlayers.org/Pentaho (2010a). Pentaho Google Maps Dashboard Technical Overview. Retrieved February 22, 2010, from http://community.pentaho.com/google_maps/
  37. Pentaho (2010a). Pentaho Google Maps Dashboard. Retrieved February 22, 2010, from http://community.pentaho.com/google_maps/
  38. Pentaho (2010b). Pentaho Analysis Services: Mondrian Project. Retrieved February 22, 2010, from http://mondrian.pentaho.org/
  39. Rivest, S., Bédard, Y., Proulx, M. J., Nadeau, M. (2002) . SOLAP: A new type of user interface to support spatio-temporal multidimensional data exploration and analysis. In Proceedings of the ISPRS Joint Workshop on Spatial, Temporal and Multi-Dimensional Data Modelling and Analysis.
  40. Rivest, S. et al. (2005). SOLAP technology: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data. ISPRS Journal of Photogrammetry & Remote Sensing, 60, 17-3. doi:10.1016/j.isprsjprs.2005.10.002
  41. Ruiz C. V., Times, C. V. (2009) A Taxonomy of SOLAP Operators. In SBBD'2009, XXIV Brazilian Symposium on Databases. SBC.
  42. Sandvik, B. (2008). Using KML for Thematic Mapping. M.Sc. in Geographical Information Science. University of Edinburgh (dissertation).
  43. Shekhar, S. et al (2000). Map Cube: A Visualization Tool for Spatial Data Warehouses. In Miller, H. J. and Han, J. (Ed.), Geographic Data Mining and Knowledge Discovery, 73-108. New York: Taylor & Francis.
  44. Shepherd, I. D. H. (2008). Travails in the Third Dimension: A Critical Evaluation of ThreeDimensional Geographical Visualization. Geographic Visualization (pp. 199-222). New Jersey: John Wiley & Sons.
  45. Schotch, M., Parmanto, B. (2005). SOVAT: Spatial OLAP Visualization and Analysis Tool. In 38th Hawaii International Conference on System Sciences.
  46. Siqueira, T. L. L. et al. (2009). The impact of spatial data redundancy on SOLAP query performance. Journal of Brazilian Computer Society, 15(2). Campinas: SBC. doi:10.1590/S0104-65002009000200003
  47. Slocum, T. A. et al. (2005). Thematic Cartography and Geographic Visualization (2nd ed.). Upper Saddle River, NJ: Pearson Prentice Hall.
  48. Song, I. Data Warehouse. In Liu L., Özsu M. T. (Ed.), Encyclopedia of Database Systems (Vol. 1, pp. 2731- 2735). Berlin: Springer.
  49. Spatialanalytics (2010). SOLAPLayers. Retrieved February 22, 2010, from http://www.spatialytics.org/ projects/solaplayers/
  50. Stolte, C., Tang, D., Hanrahan, P. (2002). Multiscale Visualization Using Data Cubes. IEEE Transactions on Visualization and Computer Graphics, 9(2), 176- 187. doi: 10.1109/TVCG.2003.1196005
  51. Tao, Y., Papadias D. (2009). Spatio-Temporal Data Warehouses. In Liu L., Özsu M. T. (Ed.), Encyclopedia of Database Systems (Vol. 1, pp. 2731- 2735). Berlin: Springer.
  52. Tiede, D., Lang, S. (2010). Analytical 3D views and virtual globes - scientific results in a familiar spatial context. ISPRS Journal of Photogrametry and Remote Sensing [in press].
  53. Wieczorek, W. F., Delmerico, A. M. (2009). Geographic information systems. Wiley Interdisciplinary Reviews: Computational Statistics, 1(2), 167-186. doi:10.1002/wics.21
  54. Yahoo (2010). Yahoo! Maps Web Services API. Retrieved February 22, 2010, from http:// developer.yahoo.com/maps/
Download


Paper Citation


in Harvard Style

Ramos Toledo Ferraz V. and Terezinha Prado Santos M. (2010). GlobeOLAP - Improving the Geospatial Realism in Multidimensional Analysis Environment . In Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 5: ICEIS, ISBN 978-989-8425-08-9, pages 99-107. DOI: 10.5220/0002977100990107


in Bibtex Style

@conference{iceis10,
author={Vinícius Ramos Toledo Ferraz and Marilde Terezinha Prado Santos},
title={GlobeOLAP - Improving the Geospatial Realism in Multidimensional Analysis Environment},
booktitle={Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 5: ICEIS,},
year={2010},
pages={99-107},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002977100990107},
isbn={978-989-8425-08-9},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 5: ICEIS,
TI - GlobeOLAP - Improving the Geospatial Realism in Multidimensional Analysis Environment
SN - 978-989-8425-08-9
AU - Ramos Toledo Ferraz V.
AU - Terezinha Prado Santos M.
PY - 2010
SP - 99
EP - 107
DO - 10.5220/0002977100990107