skip to main content
10.1145/2516588.2516590acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
research-article

SO-1SR: towards a self-optimizing one-copy serializability protocol for data management in the cloud

Published: 28 October 2013 Publication History

Abstract

Clouds are very attractive environments for deploying different types of applications due to their pay-as-you-go cost model and their highly available and scalable infrastructure. Data management is an integral part of the applications deployed in the Cloud. Thus, it is of outmost importance to provide highly available and scalable data management solutions tailored to the needs of the Cloud. Data availability can be increased by using well-known replication techniques. Data replication also increases scalability in case of read-only transactions, but generates a considerable overhead for keeping the replicas consistent in case of update transactions. In order to meet the scalability demands of their customers, current Cloud providers use DBMSs that only support weak data consistency. While weak consistency is considered to be sufficient for many of the currently deployed applications in the Cloud, more and more applications with strong consistency guarantees, like traditional online stores, are moved to the Cloud. In the presence of replicated data, these applications require one-copy serializability (1SR). Hence, in order to exploit the advantages of the Cloud also for these applications, it is essential to provide scalable, available, low-cost, and strongly consistent data management, which is able to adapt dynamically based on application and system conditions. In this paper, we present SO-1SR (self-optimizing 1SR), a novel customizable load balancing approach to transaction execution on top of replicated data in the Cloud which is able to efficiently use existing resources and to optimize transaction execution in an adaptive and dynamic manner without a dedicated load balancing component. The evaluation of SO-1SR on the basis of the TPC-C benchmark in the AWS Cloud environment has shown that the SO-1SR load balancer is much more efficient compared to existing load balancing techniques.

References

[1]
Transactions across datacenters (and other weekend projects). http://www.google.com/intl/de/events/io/2009/sessions/TransactionsAcrossDatacenters.html, 2009. {Online; accessed 20-June-2013}.
[2]
D. Agrawal et al. Managing geo-replicated data in multi-datacenters. In Databases in Networked Information Systems, volume 7813 of Lecture Notes in Computer Science, pages 23--43. Springer Berlin Heidelberg, 2013.
[3]
M. Andreolini and S. Casolari. Load Prediction Models in Web-based Systems. In Proc. VALUETOOLS, 2006.
[4]
P. A. Bernstein and N. Goodman. An algorithm for concurrency control and recovery in replicated distributed databases. ACM Trans. Database Syst., 9(4):596--615, Dec. 1984.
[5]
P. A. Bernstein and N. Goodman. Serializability Theory for Replicated Databases. Journal of Computer and System Sciences, 1985.
[6]
E. A. Brewer. Towards Robust Distributed Systems. In Proc. PODC, Portland, Oregon, USA, 2000.
[7]
M. J. Cahill, U. Röhm, and A. D. Fekete. Serializable Isolation for Snapshot Databases. In Proc. SIGMOD, Vancouver, Canada, 2008.
[8]
F. Chang et al. Bigtable: a distributed storage system for structured data. In Proc. OSDI, 2006.
[9]
B. F. Cooper et al. Pnuts: Yahoo!'s hosted data serving platform. In Proc. VLDB, 2008.
[10]
J. C. Corbett et al. Spanner: Google's globally-distributed database. In Proc. OSDI, Hollywood, CA, USA, 2012.
[11]
I. Fetai and H. Schuldt. Cost-based data consistency in a data-as-a-service cloud environment. In Proc. CLOUD, Honolulu, HI, USA, 2012.
[12]
J. Gray et al. The dangers of replication and a solution. In Proc. SIGMOD, 1996.
[13]
T. Hastie, R. Tibshirani, and J. Friedman. The Elements of Statistical Learning; Data Mining, Inference, and Prediction. Springer, 2013.
[14]
B. Kemme and G. Alonso. Don't Be Lazy, Be Consistent: Postgres-R, A New Way to Implement Database Replication. In Proc. VLDB, 2000.
[15]
T. Kraska et al. Consistency rationing in the cloud: pay only when it matters. In Proc. VLDB, 2009.
[16]
J. D. C. Little. A proof for the queuing formula: L = λW. Operations Research, 9(3):pp. 383--387, 1961.
[17]
F. D. Muñoz Escoí et al. Revising 1-copy equivalence in replicated databases with snapshot isolation. In Proc. CoopIS, DOA, IS, and ODBASE: Part I, 2009.
[18]
B. G. Robert. Smoothing, Forecasting and Prediction of Discrete Time Serie. Prentice-Hall, 1963.
[19]
U. Röhm et al. FAS - a Freshness-Sensitive Coordination Middleware. In Proc. VLDB, 2002.
[20]
M. Ruiz-Fuertes et al. 1-copy equivalence: Atomic commit versus atomic broadcast in termination protocols. 2010.
[21]
M. Sladescu et al. Event aware workload prediction: A study using auction events. In Proc. WISE, 2012.
[22]
TPC-C Benchmark. http://www.tpc.org/tpcc/. Accessed: 04/2013.
[23]
L. C. Voicu et al. Re: GRIDiT - Coordinating distributed update transactions on replicated data in the Grid. In Proc. GRID, 2009.
[24]
L. C. Voicu et al. Flexible data access in a cloud based on freshness requirements. In Proc. CLOUD, 2010.

Cited By

View all
  • (2016)SLA-basierte Konfiguration eines modularen Datenbanksystems für die CloudBig Data10.1007/978-3-658-11589-0_9(179-194)Online publication date: 22-Jun-2016
  • (2014)PolarDBMS: Towards a cost-effective and policy-based data management in the cloud2014 IEEE 30th International Conference on Data Engineering Workshops10.1109/ICDEW.2014.6818323(170-177)Online publication date: Mar-2014

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
CloudDB '13: Proceedings of the fifth international workshop on Cloud data management
October 2013
42 pages
ISBN:9781450324168
DOI:10.1145/2516588
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 28 October 2013

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. data consistency
  2. data replication
  3. load balancing
  4. transaction management

Qualifiers

  • Research-article

Conference

CIKM'13
Sponsor:

Acceptance Rates

CloudDB '13 Paper Acceptance Rate 4 of 6 submissions, 67%;
Overall Acceptance Rate 12 of 17 submissions, 71%

Upcoming Conference

CIKM '25

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)2
  • Downloads (Last 6 weeks)0
Reflects downloads up to 07 Mar 2025

Other Metrics

Citations

Cited By

View all
  • (2016)SLA-basierte Konfiguration eines modularen Datenbanksystems für die CloudBig Data10.1007/978-3-658-11589-0_9(179-194)Online publication date: 22-Jun-2016
  • (2014)PolarDBMS: Towards a cost-effective and policy-based data management in the cloud2014 IEEE 30th International Conference on Data Engineering Workshops10.1109/ICDEW.2014.6818323(170-177)Online publication date: Mar-2014

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media