Data Mining-based Materialized View and Index Selection in Data Warehouses

Details Data Mining-based Materialized View and Index Selection in Data Warehouses Data Mining-based Materialized View and Index Selection in Data Warehouses

2007-07-11

arxiv.org/abs/0707.1548v1

Computer Science

Databases

Scientific paper

Materialized views and indexes are physical structures for accelerating data access that are casually used in data warehouses. However, these data structures generate some maintenance overhead. They also share the same storage space. Most existing studies about materialized view and index selection consider these structures separately. In this paper, we adopt the opposite stance and couple materialized view and index selection to take view-index interactions into account and achieve efficient storage space sharing. Candidate materialized views and indexes are selected through a data mining process. We also exploit cost models that evaluate the respective benefit of indexing and view materialization, and help select a relevant configuration of indexes and materialized views among the candidates. Experimental results show that our strategy performs better than an independent selection of materialized views and indexes.

Affiliated with

Also associated with

No associations

Rating

Data Mining-based Materialized View and 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 Data Mining-based Materialized View and Index Selection in Data Warehouses, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Data Mining-based Materialized View and Index Selection in Data Warehouses will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-434578