Replica Refresh Strategies in a Database Cluster

DMCA

Replica Refresh Strategies in a Database Cluster (2005)

Cached

Download Links

Other Repositories/Bibliography

DBLP

by Cecile Le Pape , Stephane Gancarski , Patrick Valduriez

Venue:	in "Journées Bases de Données Avancées (BDA05
Citations:	1 - 0 self

BibTeX

@INPROCEEDINGS{Pape05replicarefresh,
    author = {Cecile Le Pape and Stephane Gancarski and Patrick Valduriez},
    title = {Replica Refresh Strategies in a Database Cluster},
    booktitle = {in "Journées Bases de Données Avancées (BDA05},
    year = {2005}
}

OpenURL

Abstract

We consider the use of a cluster system for managing autonomous databases. In order to improve the performance of read-only queries, we study the impact of refresh strategies on the query response time. Assuming mono-master lazy replication, we propose a model for refresh strategies and a workload generator which allows for testing refresh strategies against various application types. We provide an experimental validation based on our prototype Refresco. The results show that the choice of the best strategy depends not only on the workload intensity (update and query frequencies), but also on the workload conflict rate (ratio of queries conflicting with running update transactions) and on the level of freshness required by transactions.

Keyphrases

database cluster refresh strategy replica refresh strategy cluster system prototype refresco query response time read-only query experimental validation workload generator various application type autonomous database query frequency workload intensity mono-master lazy replication workload conflict rate update transaction

DMCA