Title :
DDB Expert: A Recommender for Distributed Databases Design
Author_Institution :
CS Dept., UTIC Lab., Univ. of Tunis, Carthage, Tunisia
fDate :
Aug. 29 2011-Sept. 2 2011
Abstract :
This paper proposes a framework based on expert systems for distributed database design. The DB fragmentation advisor recommends table fragmentation or full/partial replication through DB schema analysis, DB workload analysis and DB statistics. The advisor is low cost, has a low memory footprint, and is very fast. The framework is flexible since it´s open to workload changes with new business requirements or query/interaction´s frequency changes as well as recommender enhancements with new rules.
Keywords :
distributed databases; expert systems; recommender systems; database fragmentation advisor; database schema analysis; database statistics; database workload analysis; distributed databases design; expert system; full replication; partial replication; recommender enhancement; table fragmentation; Benchmark testing; Distributed databases; Knowledge based systems; Parallel processing; Partitioning algorithms; Production; distributed database design; queries recommendations; recommender systems; workload analysis;
Conference_Titel :
Database and Expert Systems Applications (DEXA), 2011 22nd International Workshop on
Conference_Location :
Toulouse
Print_ISBN :
978-1-4577-0982-1
DOI :
10.1109/DEXA.2011.25
