research-article

An evaluation of alternative architectures for transaction processing in the cloud

Authors:

Donald Kossmann,

Simon LoesingAuthors Info & Claims

SIGMOD '10: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data

Pages 579 - 590

https://doi.org/10.1145/1807167.1807231

Published: 06 June 2010 Publication History

Abstract

Cloud computing promises a number of advantages for the deployment of data-intensive applications. One important promise is reduced cost with a pay-as-you-go business model. Another promise is (virtually) unlimited throughput by adding servers if the workload increases. This paper lists alternative architectures to effect cloud computing for database applications and reports on the results of a comprehensive evaluation of existing commercial cloud services that have adopted these architectures. The focus of this work is on transaction processing (i.e., read and update workloads), rather than analytics or OLAP workloads, which have recently gained a great deal of attention. The results are surprising in several ways. Most importantly, it seems that all major vendors have adopted a different architecture for their cloud services. As a result, the cost and performance of the services vary significantly depending on the workload.

References

[1]

Amazon. Amazon WebServices. http://aws.amazon.com/, October 2009.

[2]

C. Binnig, D. Kossmann, T. Kraska, and S. Loesing. How is the Weather Tomorrow? Towards a Benchmark for the Cloud. In Proc. of DBTest, pages 1--6, 2009.

Digital Library

[3]

M. Brantner, D. Florescu, D. A. Graf, D. Kossmann, and T. Kraska. Building a Database on S3. In Proc. of SIGMOD, pages 251--264, 2008.

Digital Library

[4]

E. A. Brewer. (Invited Talk) Towards Robust Distributed Systems. In Proc. of PODC, page 7, 2000.

Digital Library

[5]

R. Buck-Emden. The SAP R/3 System. Addison-Wesley, 2nd edition, 1999.

Digital Library

[6]

M. J. Carey, D. J. DeWitt, and J. F. Naughton. The 007 Benchmark. In Proc. of SIGMOD, pages 12--21, 1993.

Digital Library

[7]

M. J. Carey, D. J. DeWitt, J. F. Naughton, M. Asgarian, P. Brown, J. Gehrke, and D. Shah. The BUCKY Object-Relational Benchmark (Experience Paper). In Proc. of SIGMOD, pages 135--146, 1997.

Digital Library

[8]

S. Ceri and G. Pelagatti. Distributed databases principles and systems. McGraw-Hill, Inc., 1984.

Digital Library

[9]

Danga. MemCached. http://www.danga.com/memcached/, October 2009.

[10]

D. J. DeWitt. The Wisconsin Benchmark: Past, Present, and Future. In J. Gray, editor, The Benchmark Handbook for Database and Transaction Systems, 2nd edition. Morgan Kaufmann, 1993.

[11]

D. J. DeWitt, P. Futtersack, D. Maier, and F. Vélez. A Study of Three Alternative Workstation-Server Architectures for Object Oriented Database Systems. In Proc. of VLDB, pages 107--121, 1990.

Digital Library

[12]

D. Florescu and D. Kossmann. Rethinking Cost and Performance of Database Systems. SIGMOD Rec., 38(1):43--48, 2009.

Digital Library

[13]

J. Furman, J. Karlsson, J. Leon, A. Lloyd, S. Newman, and P. Zeyliger. Megastore: A Scalable Data System for User Facing Applications. In Proc. of SIGMOD, 2008.

[14]

Gartner. Gartner Top Ten Disruptive Technologies for 2008 to 2012. Emerging Trends and Technologies Roadshow, 2008.

[15]

T. Kraska, M. Hentschel, G. Alonso, and D. Kossmann. Consistency Rationing in the Cloud: Pay Only when it Matters. In Proc. of VLDB, volume 2, pages 253--264, 2009.

Digital Library

[16]

U. F. Minhas, J. Yadav, A. Aboulnaga, and K. Salem. Database Systems on Virtual Machines: How Much Do You Lose? In ICDE Workshops, pages 35--41, 2008.

Digital Library

[17]

MySQL-AB. Benchmarking Highly Scalable MySQL Clusters. http://www.mysql.com/why-mysql/white-papers/mysql_cge_benchmarks_wp_april2007.php, October 2009.

[18]

Oracle. Oracle Real Application Clusters. http://www.oracle.com/technology/products/database/clustering/, October 2009.

[19]

A. Pavlo, E. Paulson, A. Rasin, D. J. Abadi, D. J. DeWitt, S. Madden, and M. Stonebraker. A Comparison of Approaches to Large-Scale Data Analysis. In Proc. of SIGMOD, pages 165--178, 2009.

Digital Library

[20]

C. Plattner and G. Alonso. Ganymed: Scalable Replication for Transactional Web Applications. In Proc. of Middleware, pages 155--174, 2004.

Digital Library

[21]

A. Schmidt, F. Waas, M. L. Kersten, M. J. Carey, I. Manolescu, and R. Busse. XMark: A Benchmark for XML Data Management. In Proc. of VLDB, pages 974--985, 2002.

Digital Library

[22]

S. Sengupta. SQL Data Services: A Lap Around. In Microsoft Professional Developers Conference (PDC), 2008.

[23]

W. Sobel, S. Subramanyam, A. Sucharitakul, J. Nguyen, H. Wong, A. Klepchukov, S. Patil, A. Fox, and D. Patterson. Cloudstone: Multi-Platform, Multi-Language Benchmark and Measurement Tools for Web 2.0. In Proc. of CAA, 2008.

[24]

M. Stonebraker. The Case for Shared Nothing. IEEE Database Eng. Bull., 9(1):4--9, 1986.

[25]

M. Stonebraker, J. Frew, K. Gardels, and J. Meredith. The Sequoia 2000 Benchmark. In Proc. of SIGMOD, pages 2--11, 1993.

Digital Library

[26]

M. Stonebraker and J. M. Hellerstein, editors. Readings in Database Systems. Morgan Kaufmann, 4th edition, 2005.

Digital Library

[27]

A. Tanenbaum and M. van Steen. Distributed Systems: Principles and Paradigms. Prentice Hall, 2002.

Digital Library

[28]

TPC. TPC-W 1.8. TPC Council, 2002.

[29]

W. Vogels. Eventually Consistent. Commun. ACM, 52(1):40--44, 2009.

Digital Library

Cited By

Zhu BHua YLong ZLiu X(2023)CATS: A Computation-Aware Transaction Processing System with Proactive Unlocking2023 IEEE/ACM 31st International Symposium on Quality of Service (IWQoS)10.1109/IWQoS57198.2023.10188780(1-10)Online publication date: 19-Jun-2023
https://doi.org/10.1109/IWQoS57198.2023.10188780
Wu TGu RLi YMa HChen YZhu YYu XXu THuang Y(2023)Raven: Benchmarking Monetary Expense and Query Efficiency of OLAP Engines on the CloudDatabase Systems for Advanced Applications10.1007/978-3-031-30678-5_45(593-605)Online publication date: 14-Apr-2023
https://doi.org/10.1007/978-3-031-30678-5_45
Khoshaba OGrechaninov VMolodetska TLopushanskyi AZavertailo K(2023)Study of the Workspace Model in Distributed Structures Using CAP TheoremMathematical Modeling and Simulation of Systems10.1007/978-3-031-30251-0_18(229-242)Online publication date: 3-Jun-2023
https://doi.org/10.1007/978-3-031-30251-0_18
Show More Cited By

Index Terms

An evaluation of alternative architectures for transaction processing in the cloud
1. Information systems
  1. Data management systems
    1. Database management system engines
      1. Parallel and distributed DBMSs
  2. Information retrieval
    1. Evaluation of retrieval results
2. Social and professional topics
  1. Professional topics
    1. Management of computing and information systems
      1. Information system economics

Recommendations

All You Need is Trust --- An Analysis of Trust Measures Communicated by Cloud Providers
Proceedings of the Confederated International Conferences on On the Move to Meaningful Internet Systems: OTM 2015 Conferences - Volume 9415

Cloud computing represents an information technology IT provisioning model in which IT resources are consumed as a service. They are no longer installed and run on premises of consuming organizations, but at cloud providers. Cloud computing poses unique ...
Evaluation of cloud providers for VPH applications
CCGRID '13: Proceedings of the 13th IEEE/ACM International Symposium on Cluster, Cloud, and Grid Computing

Infrastructure as a Service (IaaS) clouds are considered interesting sources of computing and storage resources for scientific applications. However, given the large number of cloud vendors and their diverse offerings, it is not trivial for research ...
Cloud Computing Adoption Factors and Processes for Enterprises
CLOSER 2014: Proceedings of the 4th International Conference on Cloud Computing and Services Science

Cloud computing has received an increasing interest from enterprises since its inception. With its innovative Information Technology (IT) services delivery model, cloud computing could add technical and strategic business values to enterprises. However, ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '10: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data

June 2010

1286 pages

ISBN:9781450300322

DOI:10.1145/1807167

General Chair:
Ahmed Elmagarmid
Purdue University, USA
,
Program Chair:
Divyakant Agrawal
University of California at Santa Barbara, USA

Copyright © 2010 ACM.

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 ACM 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

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 06 June 2010

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

SIGMOD/PODS '10

Sponsor:

SIGMOD

SIGMOD/PODS '10: International Conference on Management of Data

June 6 - 10, 2010

Indiana, Indianapolis, USA

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

170
Total Citations
View Citations
3,820
Total Downloads

Downloads (Last 12 months)61
Downloads (Last 6 weeks)7

Reflects downloads up to 05 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Zhu BHua YLong ZLiu X(2023)CATS: A Computation-Aware Transaction Processing System with Proactive Unlocking2023 IEEE/ACM 31st International Symposium on Quality of Service (IWQoS)10.1109/IWQoS57198.2023.10188780(1-10)Online publication date: 19-Jun-2023
https://doi.org/10.1109/IWQoS57198.2023.10188780
Wu TGu RLi YMa HChen YZhu YYu XXu THuang Y(2023)Raven: Benchmarking Monetary Expense and Query Efficiency of OLAP Engines on the CloudDatabase Systems for Advanced Applications10.1007/978-3-031-30678-5_45(593-605)Online publication date: 14-Apr-2023
https://doi.org/10.1007/978-3-031-30678-5_45
Khoshaba OGrechaninov VMolodetska TLopushanskyi AZavertailo K(2023)Study of the Workspace Model in Distributed Structures Using CAP TheoremMathematical Modeling and Simulation of Systems10.1007/978-3-031-30251-0_18(229-242)Online publication date: 3-Jun-2023
https://doi.org/10.1007/978-3-031-30251-0_18
Rashmi Ashtagi Jyoti R. Maranur Afsha Akkalkot Shweta M Madiwal Sridevi Hosmani Arunadevi Khaple (2022)Competitive Analysis for the Auditing Cloud ConsistencyInternational Journal of Scientific Research in Science and Technology10.32628/IJSRST229396(408-414)Online publication date: 1-Jun-2022
https://doi.org/10.32628/IJSRST229396
Anzai SMisono MNakamura RKuga YShinagawa TSerafini MXu H(2022)Towards isolated execution at the machine levelProceedings of the 13th ACM SIGOPS Asia-Pacific Workshop on Systems10.1145/3546591.3547530(68-77)Online publication date: 23-Aug-2022
https://dl.acm.org/doi/10.1145/3546591.3547530
Tay Y(2022)Analytical Performance Modeling for Computer Systems10.1007/978-3-031-01803-9Online publication date: 19-Mar-2022
https://doi.org/10.1007/978-3-031-01803-9
Henning SHasselbring WBourcier JJiang ZBezemer CCortellessa V(2021)How to Measure Scalability of Distributed Stream Processing Engines?Companion of the ACM/SPEC International Conference on Performance Engineering10.1145/3447545.3451190(85-88)Online publication date: 19-Apr-2021
https://dl.acm.org/doi/10.1145/3447545.3451190
Kaur HBhadoria R(2021)WITHDRAWN: A review on modeling techniques of quality-of-serviceMaterials Today: Proceedings10.1016/j.matpr.2020.12.536Online publication date: Feb-2021
https://doi.org/10.1016/j.matpr.2020.12.536
Pfandzelter THasenburg JBermbach D(2021)From zero to fog: Efficient engineering of fog‐based Internet of Things applicationsSoftware: Practice and Experience10.1002/spe.300351:8(1798-1821)Online publication date: Jun-2021
https://doi.org/10.1002/spe.3003
Uta ACustura ADuplyakin DJimenez IRellermeyer JMaltzahn CRicci RIosup ABhagwan RPorter G(2020)Is big data performance reproducible in modern cloud networks?Proceedings of the 17th Usenix Conference on Networked Systems Design and Implementation10.5555/3388242.3388280(513-528)Online publication date: 25-Feb-2020
https://dl.acm.org/doi/10.5555/3388242.3388280
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten