Skip to main content
SpringerLink
Log in

Schema-Driven Performance Evaluation for Highly Concurrent Scenarios

  • Conference paper
  • First Online:
Database Systems for Advanced Applications (DASFAA 2018)

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

Included in the following conference series:

  • 928 Accesses

Abstract

Online applications needs to support highly concurrent access and to response to users as soon as possible. Two primary factors make the above requirements to be a technical challenge, one is the large user base, the other is the sharp rise in traffic caused by some specific activities, such as ticketing on 12306.cn during Spring Festival season, shopping on taobao.com during its dual 11 promotions, etc. For the latter, a core focus is how to expand the performance of those existing hardware and software and then to ensure the quality of services when a sharp rise on access happened. Since database schemas have a direct link with data access granularity, etc., this paper considers database schemas as an important factor for performance optimization on highly concurrent access and also covers other elements affecting access performance, such as cache, concurrency, etc., to analyze the performance factors for databases. Extensive experiments are designed to conduct both performance testing and analyzing under different schemas. The experimental results show that a reasonable configuration can contribute a good database performance, which provides factual basis for optimizing highly concurrent applications.

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 EPUB and 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

References

  1. Brucato, M., Beltran, F.J., Abouzied, A., Meliou, A.: Scalable package queries in relational database systems. Proc. VLDB Endow. 9(7), 576–587 (2016)

    Article  Google Scholar 

  2. Loesing, S., Pilman, M., Etter, T., Kossmann, D.: On the design and scalability of distributed shared-data databases. In: Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data (SIGMOD 2015), pp. 663–676 (2015)

    Google Scholar 

  3. Zhu, Q., Wu, B., Shen, X.P., Shen, K., Shen, L., Wang, Z.Y.: Understanding co-run performance on CPU-GPU integrated processors: observations, insights, directions. Front. Comput. Sci. 11(1), 130–146 (2017)

    Article  Google Scholar 

  4. Yoon, Y.D., Mozafari, B., Brown, P.D.: DBSeer: pain-free database administration through workload intelligence. Proc. VLDB Endow. 8(12), 2036–2039 (2015)

    Article  Google Scholar 

  5. Mior, J.M., Salem, K., Aboulnaga, A., Liu, R.: NoSE: schema design for NoSQL applications. In: Proceeding of IEEE 32nd International Conference on Data Engineering (ICDE 2016), pp. 181–192 (2016)

    Google Scholar 

  6. Wu, Y.J., Chan, Y.C., Tan, K.L.: Transaction healing: scaling optimistic concurrency control on multicores. In: Proceedings of the 2016 ACM SIGMOD International Conference on Management of Data (SIGMOD 2016), pp. 1689–1704 (2016)

    Google Scholar 

  7. Arasu, A., Eguro, K., Kaushik, R., Kossmann, D., Meng, P.F., Pandey, V., Ramamurthy, R.: Concerto: a high concurrency key-value store with integrity. In: Proceedings of the 2017 ACM SIGMOD International Conference on Management of Data(SIGMOD 2017), pp. 251–266 (2017)

    Google Scholar 

  8. Mozafari, B., Curino, C., Jindal, A., Madden, S.: Performance and resource modeling in highly-concurrent OLTP workloads. In: Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data (SIGMOD 2013), pp. 301–312 (2013)

    Google Scholar 

  9. Dong, B., Li, X.Q., Xiao, L.M., Ruan, L.: A new file-specific stripe size selection method for highly concurrent data access. In: Proceedings of ACM/IEEE 13th International Conference on Grid Computing (GRID 2012), pp. 22–30 (2012)

    Google Scholar 

  10. Makreshanski, D., Giannikis, G., Alonso, G., Kossmann, D.: MQJoin: efficient shared execution of main-memory joins. Proc. VLDB Endow. 9(6), 480–491 (2016)

    Article  Google Scholar 

  11. Olma, M., Karpathiotakis, M., Alagiannis, I., Athanassoulis, M., Ailamaki, A.: Slalom: coasting through raw data via adaptive partitioning and indexing. Proc. VLDB Endow. 10(10), 1106–1117 (2017)

    Article  Google Scholar 

  12. Zheng, J.J., Lin, Q., Xu, J.T., Wei, C., Zeng, C.W., Yang, P.A., Zhang, F.: PaxosStore: high-availability storage made practical in WeChat. Proc. VLDB Endow. 10(12), 1730–1741 (2017)

    Article  Google Scholar 

Download references

Acknowledgments

This study is supported by the National Natural Science Foundation of China (No. 61462017, 61363005, U1501252), Guangxi Natural Science Foundation of China (No. 2017GXNSFAA198035), and Guangxi Cooperative Innovation Center of Cloud Computing and Big Data.

Author information

Authors and Affiliations

  1. Guangxi Cooperative Innovation Center of Cloud Computing and Big Data, Guilin University of Electronic Technology, Guilin, 541004, China

    Jingwei Zhang

  2. Guangxi Key Laboratory of Trusted Software, Guilin University of Electronic Technology, Guilin, 541004, China

    Jingwei Zhang, Li Feng & Yuming Lin

  3. Guangxi Key Laboratory of Automatic Measurement Technology and Instrument, Guilin University of Electronic Technology, Guilin, 541004, China

    Qing Yang

Authors
  1. Jingwei Zhang
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Li Feng
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Qing Yang
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Yuming Lin
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Qing Yang .

Editor information

Editors and Affiliations

  1. Swinburne University of Technology, Hawthorn, VIC, Australia

    Chengfei Liu

  2. Peking University, Beijing, China

    Lei Zou

  3. University of Western Australia, Crawley, WA, Australia

    Jianxin Li

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG, part of Springer Nature

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Zhang, J., Feng, L., Yang, Q., Lin, Y. (2018). Schema-Driven Performance Evaluation for Highly Concurrent Scenarios. In: Liu, C., Zou, L., Li, J. (eds) Database Systems for Advanced Applications. DASFAA 2018. Lecture Notes in Computer Science(), vol 10829. Springer, Cham. https://doi.org/10.1007/978-3-319-91455-8_2

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-91455-8_2

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-91454-1

  • Online ISBN: 978-3-319-91455-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation