Some remarks on self-tuning logical database design

F. De Marchi, M.-S. Hacid, J.-M. Petit
2005 21st International Conference on Data Engineering Workshops (ICDEW'05)  
Whereas self-tuning physical database design has received a lot of attention recently, self-tuning logical database design seems to be under-studied. Roughly speaking, database administrators (DBA) have to maintain on a daily basis "efficient databases", i.e. databases for which SQL queries have to perform efficiently for end-users, while keeping "coherent" databases, i.e. databases without update problems. Moreover, the huge number of null values occurring in practice may incur a significant
more » ... erhead on his daily work, either to optimize the memory layout or to maintain (or design new) SQL queries. In order to reach a trade-off between the desire to maintain efficient databases and coherent databases, we propose a framework in which a database should be able to self-tuning its logical database schema with respect to SQL workloads and the data themselves. We discuss the main points of this framework, its feasibility and its relationships with some data mining problems.
doi:10.1109/icde.2005.287 dblp:conf/icde/MarchiHP05 fatcat:6aupc5bpbjarlnlqhxirrhhyaa