Dynamic index selection in data warehouses

Details Dynamic index selection in data warehouses Dynamic index selection in data warehouses

2008-09-11

arxiv.org/abs/0809.1965v1

4th International Conference on Innovations in Information Technology (Innovations 07), Dubai : \'Emirats arabes unis (2006)

Computer Science

Databases

Scientific paper

Analytical queries defined on data warehouses are complex and use several join operations that are very costly, especially when run on very large data volumes. To improve response times, data warehouse administrators casually use indexing techniques. This task is nevertheless complex and fastidious. In this paper, we present an automatic, dynamic index selection method for data warehouses that is based on incremental frequent itemset mining from a given query workload. The main advantage of this approach is that it helps update the set of selected indexes when workload evolves instead of recreating it from scratch. Preliminary experimental results illustrate the efficiency of this approach, both in terms of performance enhancement and overhead.

Affiliated with

Also associated with

No associations

Rating

Dynamic index selection in data warehouses does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with Dynamic index selection in data warehouses, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamic index selection in data warehouses will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-473772