How to exploit the device diversity and database interaction to propose a generic cost model?

Ladjel Bellatreche 1 Salmi Cheikh 1 Sebastien Breß Amira Kerkad 1 Ahcène Boukhorca 1 Jalil Boukhobza 2
2 Lab-STICC_UBO_CACS_MOCS
UBO - Université de Brest, Lab-STICC - Laboratoire des sciences et techniques de l'information, de la communication et de la connaissance
Abstract : Cost models have been following the life cycle of databases. In the first generation, they have been used by query optimizers, where the cost-based optimization paradigm has been developed and supported by most of important optimizers. The spectacular development of complex decision queries amplifies the interest of the physical design phase (PhD), where cost models are used to select the relevant optimization techniques such as indexes, materialized views, etc. Most of these cost models are usually developed for one storage device (usually disk) with a well identified storage model and ignore the interaction between the different components of databases: interaction between optimization techniques, interaction between queries, interaction between devices, etc. In this paper, we propose a generic cost model for the physical design that can be instantiated for each need. We contribute an ontology describing storage devices. Furthermore, we provide an instantiation of our meta model for two interdependent problems: query scheduling and buffer management. The evaluation results show the applicability of our model as well as its effectiveness.
Type de document :
Communication dans un congrès
International Database Engineering & Applications Symposium IDEAS '13, Oct 2013, Barcelona, Spain. pp.142-147, 2013, 〈10.1145/2513591.2513660〉
Liste complète des métadonnées

http://hal.univ-brest.fr/hal-00917882
Contributeur : Jalil Boukhobza <>
Soumis le : jeudi 12 décembre 2013 - 15:56:35
Dernière modification le : mardi 16 janvier 2018 - 15:54:23

Identifiants

Citation

Ladjel Bellatreche, Salmi Cheikh, Sebastien Breß, Amira Kerkad, Ahcène Boukhorca, et al.. How to exploit the device diversity and database interaction to propose a generic cost model?. International Database Engineering & Applications Symposium IDEAS '13, Oct 2013, Barcelona, Spain. pp.142-147, 2013, 〈10.1145/2513591.2513660〉. 〈hal-00917882〉

Partager

Métriques

Consultations de la notice

174