GEOMDQL: Uma Linguagem de Consulta geogrÃfica e Multidimensional

AUTOR(ES)
DATA DE PUBLICAÇÃO

2008

RESUMO

There have been a number of proposals in the literature aimed at integrating functionality and characteristics related to analytical (OLAP - Online Analytical Processing) and geographic (GIS- Geographic Information Systems) data processing. The main goal is to provide a unique environment with geographicmultidimensional processing capabilities in order to provide a means of supporting strategic decisionmaking processes. This kind of environment has been named SOLAP (Spatial OLAP). However, due to the fact that these two technologies were conceived with different purposes in mind, the interaction of the two environments is not an easy task and even with so much research being developed, there remain unresolved issues that deserves exploration. The definition of data models for Geographic Data Warehouses (GDW) is one of the items of this integration. Another issue refers to aggregation functions for geographic measures. These functions are currently used in the definition of geographic and multidimensional data cubes. Consequently, we also need new models of data cubes that allow the association of geometries to the facts and the members of the levels. Data querying is one of the most important issues in this process. However, most approaches do not have a query language that allows both multidimensional and spatial operators to be used simultaneously. The present thesis addresses this context, presenting: i) a formal model for GDW specification; ii) a set of aggregation functions for geographic measures; iii) a formal model for data cubes named GeoMDCube; and iv) a geographic-multidimensional query language named GeoMDQL (Geographic Multidimensional Query Language). Using a single syntax, GeoMDQL extends and integrates the main multidimensional and spatial operators found in most multidimensional and geographic processing tools and environments. GeoMDQL is based on well-known standards such as the MDX (Multidimensional Expressions) and OGC Simple Features for SQL. The proposed ideas were applied in practice through the implementation of a SOLAP architecture named Golapware and the development of a case study based on data from real applications. It was possible to demonstrate the utilization of the models, functions, query language and SOLAP operators discussed in this thesis

ASSUNTO(S)

geomdcube solap geographical and multidimensional query language solap geomdql geomdcube geomdql ciencia da computacao geographical data warehouse data warehouse geogrÃfico

ACESSO AO ARTIGO

Documentos Relacionados