A Visual Query Language for Spatial Data Warehouses

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.

[1]  Luca Cabibbo,et al.  From a procedural to a visual query language for OLAP , 1998, Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243).

[2]  Alia I. Abdelmoty,et al.  A Filter Flow Visual Querying Language and Interface for Spatial Databases , 2004, GeoInformatica.

[3]  Walid G. Aref,et al.  Digital government security infrastructure design challenges , 2001 .

[4]  Elaheh Pourabbas,et al.  The syntactic and semantic correctness of pictorial configurations to query geographic databases by PQL , 2002, SAC '02.

[5]  Elaheh Pourabbas,et al.  A pictorial query language for querying geographic databases using positional and OLAP operators , 2002, SGMD.

[6]  Yvan Bédard,et al.  Merging Hypermedia GIS with Spatial On-Line Analytical Processing: Towards Hypermedia SOLAP , 2006 .

[7]  Olivier Teste,et al.  Graphical Querying of Multidimensional Databases , 2007, ADBIS.

[8]  Max J. Egenhofer,et al.  Query Processing in Spatial-Query-by-Sketch , 1997, J. Vis. Lang. Comput..

[9]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[10]  Emmanuel Stefanakis.  Geographic Hypermedia : Concepts and Systems , 2006 .

[11]  Esteban Zimányi,et al.  Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications , 2010 .

[12]  Elke A. Rundensteiner,et al.  SEE: A Spatial Exploration Environment Based on a Direct-Manipulation Paradigm , 2001, IEEE Trans. Knowl. Data Eng..

[13]  Juan Trujillo,et al.  Designing Data Warehouses for Geographic OLAP Querying by Using MDA , 2009, ICCSA.

[14]  Maurizio Rafanelli,et al.  Operators for Multidimensional Aggregate Data , 2003, Multidimensional Databases.

[15]  Tiziana Catarci,et al.  Visual Query Systems for Databases: A Survey , 1997, J. Vis. Lang. Comput..

[16]  Bernd Meyer,et al.  Beyond Icons: Towards New Metaphors for Visual Query Languages for Spatial Information Systems , 1992 .

[17]  Genny Tortora,et al.  Phenomena - A visual environment for querying heterogenous spatial data , 2009, J. Vis. Lang. Comput..

[18]  Maurizio Rafanelli,et al.  The Sketch Recognition and Query Interpretation by GSQL, aGeographical Sketch Query Language , 2005, The Fifth International Conference on Computer and Information Technology (CIT'05).

[19]  Yvan Bédard,et al.  SOLAP technology: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data , 2005 .