The SB-index and the HSB-index: efficient indices for spatial data warehouses

Spatial data warehouses (SDWs) allow for spatial analysis together with analytical multidimensional queries over huge volumes of data. The challenge is to retrieve data related to ad hoc spatial query windows according to spatial predicates, avoiding the high cost of joining large tables. Therefore, mechanisms to provide efficient query processing over SDWs are essential. In this paper, we propose two efficient indices for SDW: the SB-index and the HSB-index. The proposed indices share the following characteristics. They enable multidimensional queries with spatial predicate for SDW and also support predefined spatial hierarchies. Furthermore, they compute the spatial predicate and transform it into a conventional one, which can be evaluated together with other conventional predicates by accessing a star-join Bitmap index. While the SB-index has a sequential data structure, the HSB-index uses a hierarchical data structure to enable spatial objects clustering and a specialized buffer-pool to decrease the number of disk accesses. The advantages of the SB-index and the HSB-index over the DBMS resources for SDW indexing (i.e. star-join computation and materialized views) were investigated through performance tests, which issued roll-up operations extended with containment and intersection range queries. The performance results showed that improvements ranged from 68% up to 99% over both the star-join computation and the materialized view. Furthermore, the proposed indices proved to be very compact, adding only less than 1% to the storage requirements. Therefore, both the SB-index and the HSB-index are excellent choices for SDW indexing. Choosing between the SB-index and the HSB-index mainly depends on the query selectivity of spatial predicates. While low query selectivity benefits the HSB-index, the SB-index provides better performance for higher query selectivity.

Integration of spatial and temporal models to predict extreme water table depths

The objective of this work was to evaluate extreme water table depths in a watershed, using methods for geographical spatial data analysis. Groundwater spatio-temporal dynamics was evaluated in an outcrop of the Guarani Aquifer System. Water table depths were estimated from monitoring of water levels in 23 piezometers and time series modeling available from April 2004 to April 2011. For generation of spatial scenarios, geostatistical techniques were used, which incorporated into the prediction ancillary information related to the geomorphological patterns of the watershed, using a digital elevation model. This procedure improved estimates, due to the high correlation between water levels and elevation, and aggregated physical sense to predictions. The scenarios showed differences regarding the extreme levels - too deep or too shallow ones - and can subsidize water planning, efficient water use, and sustainable water management in the watershed.

GeoHealth: A Georeferenced System for Health Data Analysis in Primary Care

The Primary Care Information System (SIAB) concentrates basic healthcare information from all different regions of Brazil. The information is collected by primary care teams on a paper-based procedure that degrades the quality of information provided to the healthcare authorities and slows down the process of decision making. To overcome these problems we propose a new data gathering application that uses a mobile device connected to a 3G network and a GPS to be used by the primary care teams for collecting the families' data. A prototype was developed in which a digital version of one SIAB form is made available at the mobile device. The prototype was tested in a basic healthcare unit located in a suburb of Sao Paulo. The results obtained so far have shown that the proposed process is a better alternative for data collecting at primary care, both in terms of data quality and lower deployment time to health care authorities.

Identificação e análise espacial das aglomerações produtivas do setor de confecções na região Sul

O artigo procura identificar e analisar a evolução das aglomerações produtivas do setor confeccionista no Sul do Brasil. Dois fatores alicerçam o procedimento metodológico: proximidade geográfica e concentração setorial, combinados por Análise Espacial de Concentração. O primeiro, proximidade geográfica, por meio da Análise Exploratória de Dados Espaciais, e o segundo, concentração setorial, por meio da construção do índice de Concentração normalizado. Os resultados evidenciaram a transposição positiva dos aglomerados. Além disso, verificou-se evolução para o Estado do Paraná, tanto em transborda mento como em concentração espacial. Observou-se estabilidade em spillover, mas com forte concentração, no Estado de Santa Catarina.

Fragmentação geopolítica: uma análise estrutural das propostas de separatismo no Brasil

Este trabalho tem por objetivo dar luz ao debate sobre a criação dos novos entes federativos, trazendo elementos objetivos sobre a caracterização socioeconômica dos novos espaços geopolíticos e seus respectivos papéis no novo contexto espacial do sistema inter-regional brasileiro. O artigo traz resultados inéditos para a discussão, buscando, inicialmente, identificar padrões hierárquicos e de dependência espacial e produtiva neste novo contexto federativo. Tais resultados subsidiama analise subsequente dos impactos da nova configuração das transferências constitucionais, que identifica pormeio de simulações comummodelo inter-regional de insumo-produto especialmente calibrado para as 33 regiões consideradas no estudo, não apenas os potenciais ganhadores e perdedores, mas também os mecanismos de interação espacial subjacentes a estes processos.