DDB Expert: A Recommender for Distributed Databases Design
Rim Moussa · 2011
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.