Vers l'auto-administration des entrepôts de données

Details Vers l'auto-administration des entrepôts de données Vers l'auto-administration des entrepôts de données

2007-04-26

arxiv.org/abs/0704.3520v1

XXXV\`emes Journ\'ees de Statistique, Session sp\'eciale Entreposage et Fouille de Donn\'ees, Lyon (02/06/2003) 105-108

Computer Science

Databases

Version courte de 4 pages

Scientific paper

With the wide development of databases in general and data warehouses in particular, it is important to reduce the tasks that a database administrator must perform manually. The idea of using data mining techniques to extract useful knowledge for administration from the data themselves has existed for some years. However, little research has been achieved. The aim of this study is to search for a way of extracting useful knowledge from stored data to automatically apply performance optimization techniques, and more particularly indexing techniques. We have designed a tool that extracts frequent itemsets from a given workload to compute an index configuration that helps optimizing data access time. The experiments we performed showed that the index configurations generated by our tool allowed performance gains of 15% to 25% on a test database and a test data warehouse.

Affiliated with

Also associated with

No associations

Rating

Vers l'auto-administration des entrepôts de donné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 Vers l'auto-administration des entrepôts de données, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Vers l'auto-administration des entrepôts de données will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-373030