Testing Very Large Database Management Systems: The Case of SAP HANA-Reference-Cited by-同舟云学术

Testing Very Large Database Management Systems: The Case of SAP HANA

Published:2022-11 Issue:3 Volume:22 Page:195-215
ISSN:1618-2162
Container-title:Datenbank-Spektrum
language:en
Short-container-title:Datenbank Spektrum

Author:

Bach Thomas^ORCID,Andrzejak Artur,Seo Changyun,Bierstedt Christian,Lemke Christian,Ritter Daniel,Hwang Dong Won,Sheshi Erda,Schabernack Felix,Renkes Frank,Gaumnitz Gordon,Martens Jakob,Hoemke Lars,Felderer Michael,Rudolf Michael,Jambigi Neetha,May Norman,Joy Robin,Scheja Ruben,Schwedes Sascha,Seibel Sebastian,Seifert Sebastian,Haas Stefan,Kraft Stephan,Kroll Thomas,Scheuer Tobias,Lehner Wolfgang

Abstract

AbstractSoftware Testing is an established activity in the software development process to ensure and improve the quality of a software. Consequently, there exists a wide range of literature, popular information, and even multiple ISO standards covering this topic. However, we found that testing very large database management systems (DBMS) requires special adaptations of the generally available guidance for software testing and requires to solve specific challenges that may not be relevant for other areas or smaller software projects. We therefore discuss the testing of SAP HANA, a very large software project with millions of lines of code, to share insights about our approach, best practices, and unsolved challenges that are open for further research.

Funder

Ruprecht-Karls-Universität Heidelberg

Publisher

Springer Science and Business Media LLC

Subject

General Earth and Planetary Sciences,General Environmental Science

Link

https://link.springer.com/content/pdf/10.1007/s13222-022-00426-x.pdf

Reference91 articles.

1. An G, Yoon J, Sohn J, Hong J, Hwang D, Yoo S (2022) Automatically identifying shared root causes of test breakages in SAP HANA. In: Proceedings of the 44th International Conference on Software Engineering, ICSE-SEIP 2022

2. Anonymous oraguy (2018) Experience report of how the Oracle database is tested internally. archived by Internet Archive at https://web.archive.org/web/20220514124832/, https://news.ycombinator.com/item?id=18442941 from https://news.ycombinator.com/item?id=18442941. Accessed: 14.05.2022

3. Arruda F, Sampaio A, Barros FA (2016) Capture & replay with text-based reuse and framework agnosticism. In: SEKE, pp 420–425

4. Bach T (2020) Testing in very large software projects. PhD thesis, Heidelberg University, Germany, https://archiv.ub.uni-heidelberg.de/volltextserver/31757/

5. Bach T, Andrzejak A, Pannemans R (2017a) Coverage-based reduction of test execution time: Lessons from a very large industrial project. In: 2017 IEEE International Conference on Software Testing, Verification and Validation Workshops (ICSTW), IEEE, pp 3–12

Cited by 9 articles. 订阅此论文施引文献订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献

1. A Quantitative and Qualitative Evaluation of LLM-Based Explainable Fault Localization;Proceedings of the ACM on Software Engineering;2024-07-12

2. Unleashing real-time analytics: A comparative study of in-memory computing vs. traditional disk-based systems;Brazilian Journal of Science;2024-04-24

3. Taming Timeout Flakiness: An Empirical Study of SAP HANA;Proceedings of the 46th International Conference on Software Engineering: Software Engineering in Practice;2024-04-14

4. CERT: Finding Performance Issues in Database Systems Through the Lens of Cardinality Estimation;Proceedings of the IEEE/ACM 46th International Conference on Software Engineering;2024-04-12

5. ABAP Unit Testing Performance and Quality Analysis in SAP HANA;Communications in Computer and Information Science;2024