Automatic database testing method and system based on grammar generation

• Main Authors: ZHANG JINGCHEN, BAI YIYUAN
• Format: Patent
• Language: Chinese; English
• Published: 28.03.2023
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention discloses an automatic database testing method and system based on grammar generation, the system is generally composed of a dfuzz actuator, a mutator and a result deduplication module, the dfuzz actuator is a main function module for sql execution, the mutator comprises sql analysis and sql mutation, and the result deduplication module is used for analyzing and deduplication results. On one hand, the database is adapted through the grammar file of the specific database, due to the specificity of the grammar file, the adaptation degree of the scheme to the database is higher, and the adaptation difficulty degree can be greatly reduced; and on the other hand, through the specific grammar files, some common sql is subjected to grammar-level analysis, and the analyzed sql is subjected to secondary assembly, so that the complex sql which is not frequently used can be generated, and the test effect of the database can be greatly improved. 本发明公开了一种基于文法生成的数据库自动测试方法及系统，总体由dfuzz执行器、突变器以及结果去重模块三部分组成，dfuzz