Enhancement of a data warehouse performance using association rules technique

Abstract : The data warehouse holds information management and turns it into meaningful management information, from which, very interesting patterns can be discovered by applying knowledge discovery process. As the update of the Data Warehouse is not too frequent, it is possible to improve query performance while storing the data retrieved by them in a cache. However, the most powerful systems have a small capacity to store the entire database in memory cache. The caching chunks technique is designed to keep in cache the query results in the form of chunks of values, instead of storing them in large tables. In this paper, we propose a new technique for caching multidimensional queries based on association rules. Using this technique will allow all users to enjoy the benefits of Data Warehousing in the best manner, and also to improve performance and also increase the use of the system while reducing the response time. The technique is build using an architecture comprising a data warehouse, a memory cache on the server and a one on each user's machine, in which the association rules and query results are stored. These results are kept in the form of chunks to enjoy all the advantages of the technique of fragmentation into chunks. This approach has been implemented and tested over a real huge data followed by displaying the results and analyzes.
Type de document :
Article dans une revue
International Journal of Computer Applications, IJCA, 2011, 21 (7), pp 29-37. 〈http://www.ijcaonline.org/volume21/number7/pxc3873428.pdf〉
Liste complète des métadonnées

Littérature citée [17 références]  Voir  Masquer  Télécharger

https://hal-enac.archives-ouvertes.fr/hal-01021590
Contributeur : Laurence Porte <>
Soumis le : vendredi 31 octobre 2014 - 15:03:59
Dernière modification le : lundi 21 mars 2016 - 17:27:42
Document(s) archivé(s) le : lundi 2 février 2015 - 15:19:10

Fichier

26.pdf
Fichiers éditeurs autorisés sur une archive ouverte

Identifiants

  • HAL Id : hal-01021590, version 1

Collections

Citation

Walid Moudani, Mohammad Hussein, Mirna Moukhtar, Felix Antonio Claudio Mora-Camino. Enhancement of a data warehouse performance using association rules technique. International Journal of Computer Applications, IJCA, 2011, 21 (7), pp 29-37. 〈http://www.ijcaonline.org/volume21/number7/pxc3873428.pdf〉. 〈hal-01021590〉

Partager

Métriques

Consultations de la notice

223

Téléchargements de fichiers

82