Sciweavers

Share
COOPIS
2004
IEEE

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

10 years 1 months ago
Refresco: Improving Query Performance Through Freshness Control in a Database Cluster
Abstract. 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.
Cécile Le Pape, Stéphane Ganç
Added 20 Aug 2010
Updated 20 Aug 2010
Type Conference
Year 2004
Where COOPIS
Authors Cécile Le Pape, Stéphane Gançarski, Patrick Valduriez
Comments (0)
books