数据库模式自动测试方法的研究

Study on approach of automated testing to database schema

数据库在现代应用软件系统中具有重要的作用,数据库的正确性直接影响应用软件的功能正确性和性能可靠性,而传统的软件测试往往忽略对数据库数据结构的测试。针对这个问题,提出了一种自动检查数据库模式的方法,提取需求分析的E-R模型和数据库逻辑模型的信息,将概念模型与逻辑模型进行比较,发现数据和数据之间的不一致或冲突。实验结果表明,采用这种方法能够尽早地发现数据库设计和实现的错误,使系统功能测试能建立在正确的数据库基础上。

Database play an important role in modern application systems.Its correctness directly affects the functional correctness and performance reliability of the application system.However,the test to database structure has always been overlooked in traditional software test.Aiming at this problem,an approach which could inspect the database schema automatically is proposed.It extracted the information of both the E-R model and the logic model in the database,compared the concept model and the logic model,and then found out the inconsistency or conflict between the data.Results of experiments show that this approach can discover the errors of database de-sign and implementation as early as possible,so the system function test can be built based on correct database.