Sélection simultanée d'index et de vues matérialisées

Details Sélection simultanée d'index et de vues matérialisées Sélection simultanée d'index et de vues matérialisées

2007-07-09

arxiv.org/abs/0707.1306v1

Computer Science

Databases

Scientific paper

Indices and materialized views are physical structures that accelerate data access in data warehouses. However, these data structures generate some maintenance overhead. They also share the same storage space. The existing studies about index and materialized view selection consider these structures separately. In this paper, we adopt the opposite stance and couple index and materialized view selection to take into account the interactions between them and achieve an efficient storage space sharing. We develop cost models that evaluate the respective benefit of indexing and view materialization. These cost models are then exploited by a greedy algorithm to select a relevant configuration of indices and materialized views. Experimental results show that our strategy performs better than the independent selection of indices and materialized views.

Affiliated with

Also associated with

No associations

Rating

Sélection simultanée d'index et de vues matérialisées 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 Sélection simultanée d'index et de vues matérialisées, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Sélection simultanée d'index et de vues matérialisées will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-159674