Some remarks on self-tuning logical database design

Abstract : 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 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.
Document type :
Conference papers
Complete list of metadatas

https://hal.archives-ouvertes.fr/hal-01586269
Contributor : Équipe Gestionnaire Des Publications Si Liris <>
Submitted on : Tuesday, September 12, 2017 - 4:30:39 PM
Last modification on : Friday, January 11, 2019 - 4:54:12 PM

Identifiers

  • HAL Id : hal-01586269, version 1

Citation

Fabien de Marchi, Mohand-Said Hacid, Jean-Marc Petit. Some remarks on self-tuning logical database design. International workshop on self-managing database systems, SMDB'05, in conjunction with IEEE ICDE'05, Apr 2005, Tokyo, Japan. pp.1-12. ⟨hal-01586269⟩

Share

Metrics

Record views

78