Journal of East China Normal University(Natural Sc ›› 2018, Vol. 2018 ›› Issue (2): 77-88.doi: 10.3969/j.issn.1000-5641.2018.02.008

Previous Articles     Next Articles

Woodpecker: Fine-grained contention simulation database testing framework

LI Jie-ying, LI Yu-ming, ZHANG Xiao-lei, ZHANG Rong   

  1. School of Data Science and Engineering, East China Normal University, Shanghai 200062, China
  • Received:2017-06-19 Online:2018-03-25 Published:2018-03-22

Abstract: With the rich and the growing peformance requirement of applications, various database developments appear, such as row-based, column-based, main memory database and so on. Hence database testing becomes more and more important. Existing automated testing frameworks of database have some problems in flexibility of test, integrality of function and the granularity of test. Firstly they can't support functional test, performance test and DBMS functional test at the same time. Secondly popular benchmark TPC-C simulates workload contention by warehouse which can't quantify contention and maybe execution is different with expectation. Finally the use of test case is static, they can't organize and run test case dynamically. As a consequence this paper presents a flexible database testing framework which is called Woodpecker, its test task descriptive language has abundant primitives, easy-to-use and could write test case efficiently. Woodpecker is the first test framework that can mix three above-mentioned tests in one test case, and simulates workload contention in fine granularity which include read-write contention and write-write contention. We use a simple case in auto increment testing to show the descriptive language's advantage, last we verify the capacity of mixing three tests in Woodpecker, and besides, we show the results of workload contention simulation in performance test.

Key words: database, testing framework, contention simulation

CLC Number: