The QOL approach for optimizing distributed queries without complete knowledge - Archive ouverte HAL Accéder directement au contenu
Communication Dans Un Congrès Année : 2012

The QOL approach for optimizing distributed queries without complete knowledge

Résumé

This paper concerns the integration of the Case Based Reasoning (CBR) paradigm in query processing, providing a way to optimize queries when there is no prior knowledge on queried data sources and certainly no related metadata such as data statistics. Our Query Optimization by Learning (QOL) approach optimizes queries using cases generated from the evaluation of similar past queries. A query case comprises: (i) the query, (ii) the query plan and (iii) the measures (computational resources consumed) of the query plan. The work also concerns the way the CBR process interacts with the query plan generation process. This process uses classical heuristics and makes decisions randomly (e.g. when there is no statistics for join ordering and selection of algorithms, routing protocols); It also (re)uses cases (existing query plans) for similar queries parts, improving the query optimization and evaluation efficiency.
Fichier non déposé

Dates et versions

hal-00922886 , version 1 (01-01-2014)

Identifiants

Citer

Lourdes Martínez, Christine Collet, Christophe Bobineau, Etienne Dublé. The QOL approach for optimizing distributed queries without complete knowledge. IDEAS 2012 - International Database Engineering & Applications Sysmposium, Aug 2012, Prague, Czech Republic. pp.91-99, ⟨10.1145/2351476.2351487⟩. ⟨hal-00922886⟩
90 Consultations
0 Téléchargements

Altmetric

Partager

Gmail Facebook X LinkedIn More