Performance optimization of grid aggregation in spatial data warehouses - Archive ouverte HAL
Article Dans Une Revue INTERNATIONAL JOURNAL OF DIGITAL EARTH Année : 2015

Performance optimization of grid aggregation in spatial data warehouses

Mehdi Zaamoune
  • Fonction : Auteur
  • PersonId : 775943
  • IdRef : 190034858
François Pinet
Sandro Bimonte
  • Fonction : Auteur
Philippe Beaune
  • Fonction : Auteur

Résumé

The problem of storage and querying of large volumes of spatial grids is an issue to solve. In this paper, we propose a method to optimize queries to aggregate raster grids stored in databases. In our approach, we propose to estimate the exact result rather than calculate the exact result. This approach reduces query execution time. One advantage of our method is that it does not require implementing or modifying functionalities of database management systems. Our approach is based on a new data structure and a specific model of SQL queries. Our work is applied here to relational data warehouses.

Mots clés

Dates et versions

hal-02082963 , version 1 (28-03-2019)

Identifiants

Citer

Myoung-Ah Kang, Mehdi Zaamoune, François Pinet, Sandro Bimonte, Philippe Beaune. Performance optimization of grid aggregation in spatial data warehouses. INTERNATIONAL JOURNAL OF DIGITAL EARTH, 2015, 8 (12), pp.970--988. ⟨10.1080/17538947.2014.962999⟩. ⟨hal-02082963⟩
39 Consultations
0 Téléchargements

Altmetric

Partager

More