Abstract
Analytic and geographic decision support queries are characterized by performing spatial analysis on data aggregated at different levels of detail and are typically large and complex to be written from scratch (manually) by a non-specialist user. Considering that decision support tools are in evidence and many databases (DB) have information with some geographic reference, non-specialist users of these DB need analytic and spatial decision support tools to better analyze DB information. In this context, Spatial On-Line Analytical Processing (SOLAP) tools have received a lot of attention. Nevertheless, as there is no de jure standard language for OLAP yet, like standard SQL is to Relational Database Management Systems (RDBMS), these tools are dependent on specific OLAP languages, Application Programming Interface (API) and servers. In order to propose an alternative to this problem, this paper presents an Analytic and Geographic Information Service (AGIS). Our proposal is based on open and extensible standards (i.e. it is not based on an OLAP server) to offer a service that provides multilevel analytic functions that aim to enrich the set of functionalities of Geographic Information Systems (GIS). In order to do this, AGIS 1) abstracts the complexity of generating analytic and geographic decision support queries and 2) is independent of hardware and software platform. To satisfy these goals, a three-tiered architecture and a metamodel were defined and implemented. As a proof of concept, a study case to analyze the electrical energy situation in Brazil was implemented using our proposal.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Fidalgo, R.N.: Uma Infra-estrutura para Integração de Modelos, Esquemas e Serviços Multidimensionais e Geográficos. Doctorate Thesis, Federal University of Pernambuco, Recife, PE (2005)
Bimonte, S., Tchounikine, A., Miquel, M.: Spatial OLAP: Open Issues and a Web Based Prototype. In: 10th AGILE International Conference on Geographic Information Science, p. 11 (2007)
Rivest, S., Bédard, Y., Proulx, M., Nadeau, M., Hubert, F., Pastor, J.: SOLAP technology: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data. ISPRS Journal of Photogrammetry & Remote Sensing 60(1), 17–33 (2005)
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. John Wiley & Sons, Inc., New York (2002)
Thomsen, E.: OLAP Solutions: Building Multidimensional Information Systems. John Wiley & Sons, Inc., New York (1997)
Worboys, M., Duckham, M.: GIS: A Computing Perspective, 2nd edn. CRC Press, Inc., Boca Raton (2004)
ISO/IEC 9075. Database Language SQL, International Standard ISO/IEC 9075:1992, American National Standard X3.135-1992, American National Standards Institute, New York, NY (1992)
ISO 19125-2. Geographic information – Simple feature access – Part 2: SQL option, International Standard ISO 19125-2:2004, ISO (2004)
He, H.: What is Service-Oriented Architecture? O’Reilly Media, September 30 (2003), http://webservices.xml.com/pub/a/ws/2003/09/30/soa.html
Fidalgo, R.N., Times, V.C., Silva, J., Souza, F.F.: GeoDWFrame: A Framework for Guiding the Design of Geographical Dimensional Schemas. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2004. LNCS, vol. 3181, pp. 26–37. Springer, Heidelberg (2004)
OGC, OpenGIS® (2009)
GeoMondrian Project, http://www.geo-mondrian.org
Kheops JMap, http://www.kheops-tech.com/en/jmap
Kheops JMap Spatial OLAP, http://www.kheops-tech.com/en/jmap/solap.jsp
ESRI OLAP for ArcGIS, http://www.esri.com/software/arcgis/extensions/olap
Bimonte, S.: On Modelling and Analysis of Geographic Multidimensional Databases. In: Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction. Idea Group Publishing, USA (2008)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Barros, D.M.V., do Nascimento Fidalgo, R. (2010). An Architecture and a Metamodel for Processing Analytic and Geographic Multilevel Queries. In: Taniar, D., Gervasi, O., Murgante, B., Pardede, E., Apduhan, B.O. (eds) Computational Science and Its Applications – ICCSA 2010. ICCSA 2010. Lecture Notes in Computer Science, vol 6016. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-12156-2_33
Download citation
DOI: https://doi.org/10.1007/978-3-642-12156-2_33
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-12155-5
Online ISBN: 978-3-642-12156-2
eBook Packages: Computer ScienceComputer Science (R0)