Piet-QL: a query language for GIS-OLAP integration

Authors:
Leticia I. Gomez;Alejandro A. Vaisman;Sebastián Zich
Affiliations:
Instituto Tecnólogico de de Buenos Aires;Universidad de Buenos Aires and University of Hasselt and Transnational University of Limburg, Belgium;Universidad de Buenos Aires
Venue:
Proceedings of the 16th ACM SIGSPATIAL international conference on Advances in geographic information systems
Year:
2008

Citing 7
Cited 1

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Selective Materialization: An Efficient Method for Spatial Data Cube Construction

PAKDD '98 Proceedings of the Second Pacific-Asia Conference on Research and Development in Knowledge Discovery and Data Mining
Maintaining Data Cubes under Dimension Updates

ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Cooperation with geographic databases

Multidimensional databases
Spatiotemporal Aggregate Computation: A Survey

IEEE Transactions on Knowledge and Data Engineering
Piet: a GIS-OLAP implementation

Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Aggregation languages for moving object and places of interest

Proceedings of the 2008 ACM symposium on Applied computing

A data model and query language for spatio-temporal decision support

Geoinformatica

Quantified Score

Hi-index	0.00

Visualization

Abstract

Commercial Geographic Information Systems (GIS) still fail to provide integration with OLAP (On Line Analytical Processing) tools. In previous work we have introduced Piet, a system aimed at providing this integration. In this paper we describe a new powerful query language developed for the system, denoted Piet-QL. Piet-QL not only extends the original language for Piet, allowing for example to filter geometric queries with information in a data cube, but also has a more natural semantics. In this paper we formally study the syntax and semantics of Piet-QL, provide a comprehensive set of examples, describe the implementation, and discuss experimental results.