International Journal of Advanced Research in Computer Science and Software Engineering (IJARCSSE)
The Data Warehouse's (DW) fragmentation has been widely studied by industry and academic researchers. The selection and implementation of a fragmentation schema requires a lot of expertise, a task that is not often simple to carry out by DW's administrators. In this paper, the authors have proposed an approach to select a schema of horizontal fragmentation and generate necessary scripts automatically. Finally to show the effectiveness of their approach, two parameters have been taken into consideration namely the time to implement a DW's fragmentation schema, and the response time of queries against fragmented DW.