Skip to main content
SpringerLink
Log in

A Framework for Analyzing Monetary Cost of Database Systems in the Cloud

  • Conference paper
Web-Age Information Management (WAIM 2013)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 7923))

Included in the following conference series:

  • 3453 Accesses

Abstract

In this paper, we propose to develop a framework to analyze the monetary cost of running database systems in the public cloud. The framework offers guidelines and methodologies in analyzing and estimating monetary cost of database systems. It consists of multiple components including categorizing database performance tuning knobs, benchmarking the price/performance of computation resources offered by the cloud provider, and building a monetary cost model. As a case study of our proposed framework, we conduct an in-depth study on two popular open-source database systems with respect to two cloud providers. We find that evaluating a query spans a wide range of monetary costs (with a difference up to 91%), and the experimental results demonstrate the accuracy of our monetary cost estimation.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. http://aws.amazon.com/ec2/instance-types/

  2. Assunção, M.D., di Costanzo, A., Buyya, R.: Evaluating the cost-benefit of using cloud computing to extend the capacity of clusters. In: HPDC (2009)

    Google Scholar 

  3. Coates, J., Gray, J., Nyberg, C.: Performance/price soft and pennysort. Tech. Rep. MSR-TR-98-45, Microsoft Research (1998)

    Google Scholar 

  4. Gong, Y., He, B., Zhong, J.: CMPI: Network performance aware MPI in the cloud. IEEE TPDS (2013)

    Google Scholar 

  5. Ibrahim, S., He, B., Jin, H.: Towards pay-as-you-consume cloud computing. In: IEEE SCC 2011, pp. 370–377 (2011)

    Google Scholar 

  6. IOzone: http://www.iozone.org/

  7. Kllapi, H., Sitaridi, E., Tsangaris, M.M., Ioannidis, Y.: Schedule optimization for data processing flows on the cloud. In: SIGMOD (2011)

    Google Scholar 

  8. Kossmann, D., Kraska, T., Loesing, S.: An evaluation of alternative architectures for transaction processing in the cloud. In: SIGMOD (2010)

    Google Scholar 

  9. Palankar, M.R., Iamnitchi, A., Ripeanu, M., Garfinkel, S.: Amazon S3 for science grids: a viable solution? In: DADC (2008)

    Google Scholar 

  10. Schad, J., Dittrich, J., Quiane-Ruiz, J.-A.: Runtime measurements in the cloud: Observing, analyzing, and reducing variance. In: PVLDB (2010)

    Google Scholar 

  11. Tak, B.C., Urgaonkar, B., Sivasubramaniam, A.: To move or not to move: The economics of cloud computing. In: HotCloud (2011)

    Google Scholar 

  12. Ubench: http://phystech.com/download/ubench.html

  13. Wang, H., Jing, Q., Chen, R., He, B., Qian, Z., Zhou, L.: Distributed systems meet economics: Pricing in the cloud. In: HotCloud (2010)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. School of Computer Engineering, Nanyang Technological University, Singapore

    Changbing Chen & Bingsheng He

Authors
  1. Changbing Chen
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Bingsheng He
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science and Technology, Tsinghua University, 100084, Beijing, China

    Jianyong Wang

  2. Management Science and Information Systems Department, Rutgers, the State University of New Jersey, 1, Washington Park, 07102, Newark, NJ, USA

    Hui Xiong

  3. Department of Information Engineering, Nagoya University, 464-8601, Nagoya, Japan

    Yoshiharu Ishikawa

  4. Department of Computer Science, Hong Kong Baptist University, Hong Kong

    Jianliang Xu

  5. School of Information Science and Engineering, Yanshan University, Qinhuangdao, China

    Junfeng Zhou

Rights and permissions

Reprints and permissions

Copyright information

© 2013 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Chen, C., He, B. (2013). A Framework for Analyzing Monetary Cost of Database Systems in the Cloud. In: Wang, J., Xiong, H., Ishikawa, Y., Xu, J., Zhou, J. (eds) Web-Age Information Management. WAIM 2013. Lecture Notes in Computer Science, vol 7923. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-38562-9_13

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-38562-9_13

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-38561-2

  • Online ISBN: 978-3-642-38562-9

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation