SQL Sentence Model and Use in Building of Testing Requirement for the DA Interaction
Wang Jinyang · Science Technology and Engineering · 2008
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.