SQL语句模型及其在生成DA交互性测试需求中的应用

SQL Sentence Model and Use in Building of Testing Requirement for the DA Interaction

与DBMS发生的交互,是导致数据库中数据正确性和完整性破坏的主要原因。因此,测试待测程序中DML的正确性成为了DA测试的重要内容。文中给出了该交互过程测试需求的形式化表示,构建了一种DML的SQL语句模型,将SQL语句中所有与数据库实体(Database Entity)相关的元素,按语义划分为不同集合,并将模型对象映射为测试需求,为数据库交互性测试用例的编写提供依据。

In Database Application （DA）, the interaction through DML（ Data Manipulation Language ） between program and DBMS is the main cause for the violation of data correctness and completeness. As a result, testing the correctness of DML in the program becomes an important part of the testing of DA. The testing requirement is firstly formalized of the interaction process, constructed a sentence model of DML SQL,which classifies all of the database entities based on their semantic function in the SQL sentence into different aggregates, and then maps the model object to testing requirements, based on which the testing suite will be designed.