Abstract
Data Warehouse (DW) is a dimensional database for providing decision support by means of on-line analytical processing (OLAP) techniques. Another technology also used to provide decision support is Geographical Information System (GIS). Much research aims at integrating these technologies, but there are still some open questions, particularly regarding the design of a geographical dimensional data schema. This paper discusses some related work and proposes GeoDWFrame that is a framework based on the star schema and has been specified as guidance for designing geographical dimensional schemas. Some experimental results are also given.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Inmon, W.H.: Building the Data Warehouse, 2nd edn. John Wiley & Sons, Chichester (1997)
Kimball, R.: The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley & Sons, Inc., Chichester (1996)
Kimball, R., Reeves, L., Ross, M., Thornthwaite, W.: The Data Warehouse Lifecycle Toolkit. In: Expert Methods for Designing, Developing and Deploying Data Warehouses, Wiley Computer Publishing, New York (1998)
Chaudhuri, S., Dayal, U.: An overview of Data Warehousing and OLAP Technology. SIGMOD Record 26(1) (1997)
OMG: Common Warehouse Metamodel (CWM) Specification (2002)
Longley, P.A., Goodchild, M.F., Maguire, D.J.: Geographical Information Systems: Principles, Techiniques, Applications and Managemente, 2nd edn. John Wiley and Sons, Chichester (1999)
Demers, M.N.: Fundamentals of Geographic Information Systems, 2nd edn. John Wiley & Sons, Chichester (2000)
Fidalgo, R.N., Times, V.C., Souza, F.F.: GOLAPA: An Open and Extensible Architecture for Integration between OLAP and GIS. In: Proc. Brazilian Workshop on Geoinformatics, GeoInfo (2001) (in Portuguese)
GOLAPA Project: GOLAPA official home page – (2004), http://www.cin.ufpe.br/~golapa/architecture
Han, J., Stefanovic, N., Koperski, K.: Selective materialization: An efficient method for spatial data cube construction. In: Wu, X., Kotagiri, R., Korb, K.B. (eds.) PAKDD 1998. LNCS, vol. 1394, Springer, Heidelberg (1998)
Bédard, Y., Merrett, T., Han, J.: Fundamentals of spatial data warehousing for geographic knowledge discovery. In: Miller, H.J., Han, J. (eds.) Geographic Data Mining and Knowledge Discovery (2001)
Rivest, S., Bédard, Y., Marchand, P.: Towards better support for spatial decision-making: Defining the characteristics of Spatial On-Line Analytical Processing (SOLAP). Geomatica 55(4) (2001)
Shekhar, S., Lu, C.T., Tan, X., Chawla, S., Vatsavai., R.R.: Map Cube: A Visualization Tool for Spatial Data Warehouses. In: Miller, H., Han, J. (eds.) Geographic data mining and knowledge discovery (2001)
Papadias, D., Kalnis, P., Zhang, J., Tao, Y.: Efficient OLAP Operations in Spatial Data Warehouses. In: Jensen, C.S., Schneider, M., Seeger, B., Tsotras, V.J. (eds.) SSTD 2001. LNCS, vol. 2121, p. 443. Springer, Heidelberg (2001)
Papadias, D., Tao, Y., Kalnis, P., Zhang, J.: Indexing SpatioTemporal Data Warehouses. In: Proc. Int. Conf. on Data Engineering, ICDE (2002)
Zhang, L., Li, Y., Rao, F.,, Yu, X., Chen, Y.: Spatial Hierarchy and OLAP-Favored Search in Spatial Data Warehouse. In: Proc. Int. Workshop on Data Warehousing and OLAP, DOLAP (2003)
Gonzales, M.L.: Spatial OLAP: Conquering Geography. DB2 Magazine (1999)
Kouba, Z., Matousek, K., Miksovsky, P.: On Data Warehouse and GIS integration. In: Ibrahim, M., Küng, J., Revell, N. (eds.) DEXA 2000. LNCS, vol. 1873, p. 604. Springer, Heidelberg (2000)
Ferreira, A.C., Campos, M.L., Tanaka, A.K.: An Architecture for Spatial and Dimensional Analysis Integration. In: Proc. World Multiconference on Systemics, Cybernetics and Informatics, SCI (2001)
TerraLib official home page (2004), http://www.terralib.org/documentation.html
OpenGIS. Geography Markup Language Implementation Specification, version 2.1.2 (2002)
Harinarayan, V., Rajaraman, A., Ullman, J.: Implementing Data Cubes Efficiently. In: Proc. ACM SIGMOD Int. Conf. on Management of Data (1996)
Guttman, A.: R-Tree: A dynamic Index Structure for Spatial Searching. In: Proc. ACM SIGMOD Int. Conf. on Management of Data (1984)
Microsoft SQL Server official home page (2004), http://www.microsoft.com/sql/
Deegree Web Feature Service official home page (2004), http://deegree.sourceforge.net/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Fidalgo, R.N., Times, V.C., Silva, J., Souza, F.F. (2004). GeoDWFrame: A Framework for Guiding the Design of Geographical Dimensional Schemas. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2004. Lecture Notes in Computer Science, vol 3181. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30076-2_3
Download citation
DOI: https://doi.org/10.1007/978-3-540-30076-2_3
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22937-7
Online ISBN: 978-3-540-30076-2
eBook Packages: Springer Book Archive