Le déploiement, une phase à part entière dans le cycle de vie des entrepôts de données : application aux plateformes parallèles

Abstract : Designing a parallel data warehouse consists of choosing the hardware architecture, fragmenting the data warehouse schema, allocating the generated fragments, replicating fragments to ensure high system performance and defining the treatment strategy and load balancing.The major drawback of this design cycle is its ignorance of the interdependence between subproblems related to the design of PDW and the use of heterogeneous metrics to achieve thesame goal. Our first proposal defines an analytical cost model for parallel processing of OLAP queries in a cluster environment. Our second takes into account the interdependence existing between fragmentation and allocation. In this context, we proposed a new approach to designa PDW on a cluster machine. During the fragmentation process, our approach determines whether the fragmentation pattern generated is relevant to the allocation process or not. The results are very encouraging and validation is done on Teradata. For our third proposition, we presented a design method which is an extension of our work. In this phase, an original method of replication, based on fuzzy logic is integrated.
Document type :
Theses
Complete list of metadatas

Cited literature [141 references]  Display  Hide  Download

https://tel.archives-ouvertes.fr/tel-01127551
Contributor : Abes Star <>
Submitted on : Saturday, March 7, 2015 - 3:26:11 AM
Last modification on : Wednesday, September 5, 2018 - 1:30:09 PM
Long-term archiving on : Monday, June 8, 2015 - 3:55:19 PM

File

2014ESMA0027.pdf
Version validated by the jury (STAR)

Identifiers

  • HAL Id : tel-01127551, version 1

Collections

Citation

Soumia Benkrid. Le déploiement, une phase à part entière dans le cycle de vie des entrepôts de données : application aux plateformes parallèles. Autre [cs.OH]. ISAE-ENSMA Ecole Nationale Supérieure de Mécanique et d'Aérotechique - Poitiers, 2014. Français. ⟨NNT : 2014ESMA0027⟩. ⟨tel-01127551⟩

Share

Metrics

Record views

361

Files downloads

873