loading...
Some remarks on self-tuning logical database design
Tokyo, Japan April 05-April 08
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2005.28721st International Conference on Data ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Fabien De Marchi, Univ. Claude Bernard Lyon, France
Mohand-Said Hacid, Univ. Claude Bernard Lyon, France
Jean-Marc Petit, Univ. Clermont-Ferrand II, France

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 effi- ciently 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 overhead 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.

Citation:
Fabien De Marchi, Mohand-Said Hacid, Jean-Marc Petit, "Some remarks on self-tuning logical database design," icdew, pp.1219, 21st International Conference on Data Engineering Workshops (ICDEW'05), 2005
Usage of this product signifies your acceptance of the Terms of Use.