Double Partitioning with global and local Indexing: Effect on Data Warehouse Performance
Mohamed El, Mohamed Larbi, Emany Sidi · International Journal of Computer Applications · 2018
The design of data warehouses is the most important step in their life cycle and is due to its permanent impact on its condition and operation.Strategic decision-making in a timely manner is an objective and a need for decision makers, especially in a production environment with a high frequency of updating.Designers of data warehouses always try to minimize the execution time of the analysis requests and optimize the performance of the warehouse in order to present the reports in the best time and condition.This article shows that during the design phase a double vertical and horizontal partitioning of the fact table and dimension tables with global and local indexing can optimize the logical and physical performance of the data warehouse.