Skip to main content
SpringerLink
Log in
Book cover

Geospatial Thinking pp 43–60Cite as

A Visual Query Language for Spatial Data Warehouses

  • Chapter
  • First Online:

Part of the book series: Lecture Notes in Geoinformation and Cartography ((LNGC,volume 0))

Abstract

SOLAP systems are technologies intended to support geographic business intelligence. They allow decision-makers to explore and analyze a large amount of geo-referenced data usually through interactive browsing user interfaces. In this paper, we explore a new interactive methodology which supports users to query and aggregate this kind of structured data by means of specific visual notations. The widely recognized capability of visual query languages to bridge the gap between users’ expertise and advanced query formulation adds effectiveness to the methodology, thus providing a useful support for posing correct SOLAP expressions by spatially arranging visual metaphors in a simple and intuitive way.

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

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   129.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD   169.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Bédard, Y., Proulx, M., Rivest, S., Badard, T. (2006) Merging Hypermedia GIS with Spatial On-Line Analytical Processing: Towards Hypermedia SOLAP. Geographic Hypermedia: Concepts and Systems, Springer, Berlin-Heidelberg, 167-185

    Google Scholar 

  2. Cabibbo, L. and Torlone, R. (1998) From a Procedural to a Visual Query Language for OLAP. In Procs of the Intl. Conference on Scientific and Statistical Database Management, Capri, Italy. IEEE Computer Society, 74-83.

    Google Scholar 

  3. Catarci, T., Costabile, M.F., Levialdi, S., Batini, C. (1997) Visual Query Systems for Databases: a Survey. Journal of Visual Languages and Computing 8(2) 215-260.

    Article  Google Scholar 

  4. Egenhofer, M.(1997) Query Processing in Spatial Query by Sketch, Journal of Visual Languages and Computing 8(4) 403-424.

    Article  Google Scholar 

  5. Ferri, F. Grifoni, P., Rafanelli, M. (2005) The Sketch Recognition and Query Interpretation by GSQL, aGeographical Sketch Query Language. In Proceedings of CIT 2005, 34-38

    Google Scholar 

  6. Ferri, F., Pourabbas, E., Rafanelli, M. (2002) The syntactic and semantic correctness of pictorial configuration query geographic databases by PQL, in: Proceedings of the 17th ACM Annual Symposium on Applied Computing (ACM SAC2002), Madrid, Spain, 432-437.

    Google Scholar 

  7. GeoMondrian, available at http://geosoa.scg.ulaval.ca/en/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=19

  8. Inmon W.H. (1996) Building the Data Warehouse. Wiley, New York.

    Google Scholar 

  9. Kaushik, S., Rundensteiner, E. (2001) SEE: A Spatial Exploration Environment Based on a Direct-Manipulation Paradigm, IEEE Transactions on Knowledge and Data Engineering, 13 (4), 2001, pp: 654 – 670

    Article  Google Scholar 

  10. Paolino L., Laurini, R., Sebillo, M., Tortora, G., Vitiello, G. (2009) Phenomena – A Visual Environment for Querying Heterogenous Spatial Data, Journal of Visual Languages and Computing, Vol. 20(6) December 2009, pp.420-436

    Article  Google Scholar 

  11. Malinowski, E., Zimányi, E. (2008). Advanced Data Warehouse Design From Conventional to Spatial and Temporal Applications. Berlin, Springer

    Google Scholar 

  12. Meyer, B. (1992) Beyond Icons: Towards new metaphors for visual query languages for spatial information systems, in: Proceedings of International Workshop on Interfaces to Database Systems (IDS 92), Glasgow, UK, 113-135.

    Google Scholar 

  13. Morris, A.J., Abdelmoty, A.I., El-Geresy, B.A., Jones C.B. (2004) A Filter Flow Visual Querying Language and Interface for Spatial Databases, GeoInformatica 8(2) 107-141.

    Article  Google Scholar 

  14. Pourabbas, E. and Rafanelli, M. (2002) A Pictorial Query Language for Querying Geographic Databases using Positional and OLAP Operators. SIGMOD Record,31,2,22-27

    Google Scholar 

  15. Rafanelli, M. (2003). Operators for Multidimensional Aggregate Data. In: Multidimensional databases: problems and solutions. Hershey, PA, USA: IGI Publishing.

    Google Scholar 

  16. Ravat, F., Teste, O., Tournier, R. and Zurfluh, G. (2007) Graphical Querying of Multidimensional Databases. In Proceedings of the Advances in Databases and Information Systems, September 29-October 3, 2007, Bulgaria. Berlin, Springer, 298-313.

    Google Scholar 

  17. Rivest, S., Bédard, Y., Proulx, M., Nadeaum, M., Hubert, F. and Pastor, J. (2005) Solap: Merging Business Intelligence With Geospatial Technology For Interactive Spatio-Temporal Exploration And Analysis Of Data. Journal Of International Society For Photogrammetry And Remote Sensing, 60, 1, 17-33.

    Article  Google Scholar 

  18. Trujillo, J., Glorio, O. (2009) Designing Data Warehouses for Geographic OLAP Querying by Using MDA. ICCSA (1): 505-519

    Google Scholar 

  19. Trujillo, J., Palomar, M., Gomez, J., Song, Il-Y. (2001) Designing Data Warehouses With OO Conceptual Models. Computer, 34, 12, 6

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Cemagref, UR TSCF, 24 Avenue des Landais, 63172, Clermont-Ferrand, France

    Sandro Bimonte

  2. Dipartimento di Matematica e Informatica, Università di Salerno,Via Ponte don Melillo, 84084, Fisciano, Italy

    Vincenzo Del Fatto, Luca Paolino, Monica Sebillo & Giuliana Vitiello

Authors
  1. Sandro Bimonte
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Vincenzo Del Fatto
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Luca Paolino
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Monica Sebillo
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Giuliana Vitiello
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Sandro Bimonte .

Editor information

Editors and Affiliations

  1. Inst. Superior Estatistica e, Gestao Informacao (ISEGI), Universidade Nova Lisboa, Travessa Estevao Pinto, Lisboa, 1070-312, Portugal

    Marco Painho

  2. Depto. Sistemas de Informacao, Universidade do Minho, Campus de Azurem, Guimaraes, 4800-058, Portugal

    Maribel Yasmina Santos

  3. Hochschule für Angewandte Wissenschaften, Hochschule Harz, Friedrich Str. 57-59, Wernigerode, 38855, Germany

    Hardy Pundt

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Bimonte, S., Fatto, V.D., Paolino, L., Sebillo, M., Vitiello, G. (2010). A Visual Query Language for Spatial Data Warehouses. In: Painho, M., Santos, M., Pundt, H. (eds) Geospatial Thinking. Lecture Notes in Geoinformation and Cartography, vol 0. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-12326-9_3

Download citation

Publish with us

Policies and ethics

Search

Navigation