Refresco: Improving Query Performance Through Freshness Control in a Database Cluster - Archive ouverte HAL
Communication Dans Un Congrès Année : 2004

Refresco: Improving Query Performance Through Freshness Control in a Database Cluster

Cécile Le Pape
  • Fonction : Auteur
  • PersonId : 965544
Stéphane Gançarski
Patrick Valduriez

Résumé

We consider the use of a cluster system for managing autonomous databases. In order to improve the performance of read-only queries, we strive to exploit user requirements on replica freshness. Assuming mono-master lazy replication, we propose a freshness model to help specifying the required freshness level for queries. We propose an algorithm to optimize the routing of queries on slave nodes based on the freshness requirements. Our approach uses non intrusive techniques that preserve application and database autonomy. We provide an experimental validation based on our prototype Refresco. The results show that freshness control can help increase query throughput significantly. They also show significant improvement when freshness requirements are specified at the relation level rather than at the database level.

Dates et versions

hal-01497770 , version 1 (29-03-2017)

Identifiants

Citer

Cécile Le Pape, Stéphane Gançarski, Patrick Valduriez. Refresco: Improving Query Performance Through Freshness Control in a Database Cluster. International Conference on Cooperative Information Systems (CoopIS), Oct 2004, Agia Napa, Cyprus. pp.174-193, ⟨10.1007/978-3-540-30468-5_13⟩. ⟨hal-01497770⟩
64 Consultations
0 Téléchargements

Altmetric

Partager

More