J* E* C* N* U* N* S* ›› 2026, Vol. 2026 ›› Issue (5): 13-25.doi: 10.3969/j.issn.1000-5641.2026.05.002

• Data Systems and Platforms • Previous Articles     Next Articles

Survey of testing and benchmarking techniques for modern database systems

Hanghang GENG, Xuhua HUANG, Siyang WENG, Hongyu YANG, Rong ZHANG*()   

  1. School of Data Science and Engineering, East China Normal University, Shanghai 200062, China
  • Received:2026-07-14 Online:2026-09-25 Published:2026-09-12
  • Contact: Rong ZHANG E-mail:rzhang@dase.ecnu.edu.cn

Abstract:

As database systems continue to evolve toward distributed architectures, cloud-native deployments, hybrid transactional/analytical processing workloads, multimodal data management, and agent-driven access, their evaluation frameworks—including target objects, workload characteristics, and quality metrics—have changed significantly. Conventional evaluation methodologies are primarily designed for relational databases with fixed query patterns, stable workloads, and single-dimensional performance metrics, thus rendering them insufficient for comprehensively characterizing modern database systems operating under complex functionalities, hybrid workloads, abnormal operating conditions, ecosystem migration, and security constraints. Hence, this paper presents a systematic taxonomy of database-evaluation techniques across five key quality dimensions: functional correctness, performance, availability, compatibility, and security. Furthermore, the research progress, application scenarios, and limitations of representative evaluation approaches are reviewed. Subsequently, challenges are introduced by large language models and agent-driven database interactions. We argue that future database evaluation must shift from isolated functionality testing to end-to-end quality validation, and from static, benchmark-based assessment to dynamic scenario simulation. Furthermore, evaluation frameworks must encompass emerging evaluation targets, such as multimodal queries, agent interfaces, structured result generation, and end-to-end security verification. This survey aims to provide a comprehensive reference for academic researchers and engineering practitioners in modern database evaluation.

Key words: database systems, database testing, correctness testing

CLC Number: