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
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Brucato, M., Beltran, F.J., Abouzied, A., Meliou, A.: Scalable package queries in relational database systems. Proc. VLDB Endow. 9(7), 576–587 (2016)
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)
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)
Yoon, Y.D., Mozafari, B., Brown, P.D.: DBSeer: pain-free database administration through workload intelligence. Proc. VLDB Endow. 8(12), 2036–2039 (2015)
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)
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)
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)
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)
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)
Makreshanski, D., Giannikis, G., Alonso, G., Kossmann, D.: MQJoin: efficient shared execution of main-memory joins. Proc. VLDB Endow. 9(6), 480–491 (2016)
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)
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)
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
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG, part of Springer Nature
About this paper
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)