Logical and Physical Design of Spatial Non-Strict Hierarchies in Relational Spatial Data Warehouse
| Autor: | Sandro Bimonte, Ferrahi Ibtisam Ibtisam, Kamel Boukhalfa |
|---|---|
| Přispěvatelé: | USTHB LSI EL ALIA ALGER DZA, Partenaires IRSTEA, Institut national de recherche en sciences et technologies pour l'environnement et l'agriculture (IRSTEA)-Institut national de recherche en sciences et technologies pour l'environnement et l'agriculture (IRSTEA), Technologies et systèmes d'information pour les agrosystèmes (UR TSCF), Institut national de recherche en sciences et technologies pour l'environnement et l'agriculture (IRSTEA) |
| Rok vydání: | 2019 |
| Předmět: |
SPATIAL DATA WAREHOUSE
SPATIAL INDEXATION Information retrieval Computer science NON-STRICT SPATIAL HIERARCHY 02 engineering and technology Spatial data warehouse SPATIAL SLICE QUERY Hardware and Architecture Logical conjunction 020204 information systems [SDE]Environmental Sciences 0202 electrical engineering electronic engineering information engineering 020201 artificial intelligence & image processing Physical design Software |
| Zdroj: | International Journal of Data Warehousing and Mining (IJDWM) International Journal of Data Warehousing and Mining (IJDWM), IGI Global, 2019, 15 (1), pp.21-48. ⟨10.4018/IJDWM.2019010101⟩ |
| ISSN: | 1548-3932 1548-3924 |
| DOI: | 10.4018/ijdwm.2019010101 |
| Popis: | International audience; The emergence of spatial or geographic data in DW Systems defines new models that support the storage and manipulation of the data. The need to build an SDW and to optimize SOLAP queries continues to attract the interest of researchers in recent years. Several spatial data models have been investigated to extend classical multidimensional data models with spatial concepts. However, most of existing models do not handle a non-strict spatial hierarchy. Moreover, the complexity of the spatial data makes the execution time of spatial queries very considerable. Often, spatial indexation methods are applied to optimizing access to large volumes of data and helps reduce the cost of spatial OLAP queries. Most of existing indexes support predefined spatial hierarchies. The authors show, in this article, that the logical models proposed in the literature and indexing techniques are not suitable to non-strict hierarchies. The authors propose a new logical schema supporting the non-strict hierarchies and a bitmap index to optimize queries defined by spatial dimensions with several non-strict hierarchies. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|