Leveraging Mediator Cost Models with Heterogeneous Data Sources

Abstract : Distributed systems require declarative access to diverse data sources of information. One approach to solving this heterogeneous distributed database problem is based on mediator architectures. In these architectures, mediators accept queries from users, process them with respect to wrappers, and return answers. Wrapper provide access to underlying data sources. To efficiently process queries, the mediator must optimize the plan used for processing the query. In classical databases, cost-estimate based query optimization is an effective method for optimization. In a heterogeneous distributed databases, cost-estimate based query optimization is difficult to achieve because the underlying data sources do not export cost information. This paper describes a new method that permits the wrapper programmer to export cost estimates (cost estimate formulas and statistics). For the wrapper programmer to describe all cost estimates may be impossible due to lack of information or burdensome due to the amount of information. We ease this responsibility of the wrapper programmer by leveraging the generic cost model of the mediator with specific cost estimates from the wrappers. This paper describes the mediator architecture, the language for specifying cost estimates, the algorithm for the blending of cost estimates during query optimization, and experimental results based on a combination of analytical formulas and real measurements of an object database system.
Type de document :
Rapport
[Research Report] RR-3143, INRIA. 1997
Liste complète des métadonnées

https://hal.inria.fr/inria-00073546
Contributeur : Rapport de Recherche Inria <>
Soumis le : mercredi 24 mai 2006 - 13:10:10
Dernière modification le : vendredi 25 mai 2018 - 12:02:05
Document(s) archivé(s) le : dimanche 4 avril 2010 - 23:49:46

Fichiers

Identifiants

  • HAL Id : inria-00073546, version 1

Collections

Citation

Hubert Naacke, Georges Gardarin, Anthony Tomasic. Leveraging Mediator Cost Models with Heterogeneous Data Sources. [Research Report] RR-3143, INRIA. 1997. 〈inria-00073546〉

Partager

Métriques

Consultations de la notice

208

Téléchargements de fichiers

359