De la conception physique aux outils d'administration et de tuning des entrepôts de données

Abstract : The main goal of this thesis is to propose a set of approaches to optimize performance of data warehouses and assist the data warehouse administrator (DWA) to well perform this optimization. Our approaches use three optimization techniques: primary and derived horizontal partitioning and bitmap join indexes (BJI). First, we propose a partitioning approach, which takes into account both the performance (reducing the response time) and manageability (controlling the number of fragments). Then, we propose a greedy approach that selects a set of BJI. The use of FH and BJI independently cannot exploit the various similarities existing between these two techniques. We propose an approach for multiple selection of FH and BJI. This approach can be used for tuning data warehouses. We conducted several experiments to validate our approaches. Finally, we develop a tool to assist the DWA in physical design and tuning.
Document type :
Theses
Complete list of metadatas

Cited literature [146 references]  Display  Hide  Download

https://tel.archives-ouvertes.fr/tel-00410411
Contributor : Bénédicte Carouge <>
Submitted on : Thursday, August 20, 2009 - 2:18:01 PM
Last modification on : Wednesday, September 5, 2018 - 1:30:06 PM
Long-term archiving on : Tuesday, June 15, 2010 - 8:56:43 PM

Identifiers

  • HAL Id : tel-00410411, version 1

Collections

Citation

Kamel Boukhalfa. De la conception physique aux outils d'administration et de tuning des entrepôts de données. Informatique [cs]. ISAE-ENSMA Ecole Nationale Supérieure de Mécanique et d'Aérotechique - Poitiers, 2009. Français. ⟨tel-00410411⟩

Share

Metrics

Record views

471

Files downloads

3234