Some remarks on self-tuning logical database design - Archive ouverte HAL Accéder directement au contenu
Communication Dans Un Congrès Année : 2005

Some remarks on self-tuning logical database design

Fabien de Marchi
Mohand-Said Hacid

Résumé

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.
Fichier non déposé

Dates et versions

hal-01586269 , version 1 (12-09-2017)

Identifiants

  • HAL Id : hal-01586269 , version 1

Citer

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⟩
49 Consultations
0 Téléchargements

Partager

Gmail Facebook X LinkedIn More