Some remarks on self-tuning logical database design

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 querie...

Full description

Saved in:
Bibliographic Details
Main Authors: De Marchi, F., Hacid, M.-S., Petit, J.-M.
Format: Conference Proceeding
Language:English
Subjects:
Data engineering
Data mining
Design optimization
Hardware
Indexes
Prototypes
Relational databases
Software performance
Statistics
Tuning
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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.
DOI:10.1109/ICDE.2005.287