BOUKHALFA, KAMEL University of Science and Technology – Houari Boumediene (USTHB), Algeria , BENAMEUR, ZIANI Laghouat University, Algeria , BELLATRECHE, LADJEL École nationale supérieure de mécanique et d’aérotechnique (ENSMA) Poitiers - LISI, France , ALIMAZIGHI, ZAIA University of Science and Technology – Houari Boumediene (USTHB), Algeria

OPTASSIST: A RELATIONAL DATA WAREHOUSE OPTIMIZATION ADVISOR

21590

Data warehouses store large amounts of data usually accessed by complex decision making queries with many selection, join and aggregation operations. To optimize the performance of the data warehouse, the administrator has to make a physical design. During physical design phase, the Data Warehouse Administrator has to select some optimization techniques to speed up queries. He must make many choices as optimization techniques to perform, their selection algorithms, parameters of these algorithms and the attributes and tables used by some of these techniques. We describe in this paper the nature of the difficulties encountered by the administrator during physical design. We subsequently present a tool which helps the administrator to make the right choices for optimization. We demonstrate the interactive use of this tool using a relational data warehouse created and populated from the APB-1 Benchmark.

93

Optimization , Data Warehouse , physical design , horizontal partitioning , Bitmap join index

Courrier Du Savoir

102