Vers une description et une modélisation des entrées des modèles de coût mathématiques pour l'optimisation des entrepôts de données

Abstract : Data warehouses (DW) have become a mature technology. The emphasis of the analysis requests is driven by technological change, the new programmig paradigms and ModelDriven Engineering (MDI). Before using these technological advances, the DW must be buil tand prepared for its proper operation. The construction phase bas seen massive description efforts and meta modeling to facilitate the definition of correspondence between local data sources schemas and DW schema and to reduce heterogeneity between sources. Despite its importance in all stages of the design life cycle of an DW, the operational phase and in particular its physical task, did not have the same interest in term of description and meta modeling. During this phase, mathematical cost models are used to quantify the quality of the solutions proposed. The development of these models requires collection efforts and analysis of relevant parameters. To simulate the operation of a DW, all the dimensions of a DBMS must be integrated. In this thesis, we propose to describe in detail these dimensions with meta-modeling mechanisms. Given the singularity and hierarchy between storage media, we have developed an ontology dedicated to storage media, which makes explicit their properties. The similarities between these supports motivated us to develop a hybrid cache based on flash memory. This increases the cache ability to store a large number of intermediate results shared by multiple decision-support queries. The reuse of these results will increase the overall performance of fue DBMS. Our contributions are validated with experiments using our theoretical cost models and the Oracle DBMS.
Keywords : Meta-modeling
Document type :
Theses
Complete list of metadatas

Cited literature [140 references]  Display  Hide  Download

https://tel.archives-ouvertes.fr/tel-01598874
Contributor : Abes Star <>
Submitted on : Saturday, September 30, 2017 - 1:05:56 AM
Last modification on : Wednesday, September 5, 2018 - 1:30:09 PM
Long-term archiving on : Sunday, December 31, 2017 - 12:46:11 PM

File

2017ESMA0006_salmi.pdf
Version validated by the jury (STAR)

Identifiers

  • HAL Id : tel-01598874, version 1

Collections

Citation

Cheik Salmi. Vers une description et une modélisation des entrées des modèles de coût mathématiques pour l'optimisation des entrepôts de données. Autre [cs.OH]. ISAE-ENSMA Ecole Nationale Supérieure de Mécanique et d'Aérotechique - Poitiers, 2017. Français. ⟨NNT : 2017ESMA0006⟩. ⟨tel-01598874⟩

Share

Metrics

Record views

1073

Files downloads

865