Querying Geographical Data Warehouses with GeoMDQL
Joel da Silva, Ausberto S. Castro Vera, Anjolina Grisi de Oliveira, Robson Fidalgo, Ana Carolina Salgado, Valéria Cesário Times · Brazilian Symposium on Databases · 2007
Integrating geographical and multidimensional processing has been proposed in several researches in the database literature. One of the most im- portant issues of this process is data querying. However, most of the current approaches do not take into account the use of a query language to make the simultaneous specification of multidimensional and spatial operators available. In this paper, we present GeoMDQL, which is a geographical-multidimensional query language, specifically been designed for SOLAP environments. Ge- oMDQL is based on well-known standards such as the MDX language and OGC Simple Features Specification for SQL. We present here the GeoMDQL grammar and a discussion regarding the taxonomy and syntax of GeoMDQL query types. Additionally, some aspects related to the GeoMDQL architecture implementa- tion are shown together with a case study description to illustrate the proposed query language syntax.