Design And Implementation Of Database Test Case Visualization Tool Based On Process Recommendation

In the context of more and more attention has been paid to software quality,test of database management systems has become increasingly important.Database test requires testers to write a large number of test cases based on standard specifications.Database test cases are mainly represented in a script language in text format,and the writing and manipulation process is complicated.Combining process recommendation technology and visualization technology to edit test scripts will help simplify the writing,reduce the requirements for testers,and improve efficiency.According to the characteristics of the database test case grammar,the flow chart symbol corresponding to script tag is analyzed and designed,and the corresponding relationship between the two is determined.Based on this,the test case can be converted into the flow chart and generate test cases by handling flow chart.The specific test content of the test case is displayed in the flow chart by an intuitive flow chart symbol.Through visualization library,the test flow chart can be edited by dragging and double-clicking flow chart symbol.By modifying the engine and adding tags related to the breakpoint operation,the debugging function of the flow chart in units of symbol is realized.Through the data processing of the existing test cases set,process recommendation tables are generated and updated with process recommendation algorithm.When the tester is operating,the tool recommends the tester by predicting the actions that may need to be added.Based on the above research,a database test script visualization tool based on process recommendation is designed and implemented.The tool is divided into two subsystems: the visualization subsystem and the process recommendation subsystem.The visualization subsystem is responsible for visual display of test case,conversion of test case and test flowchart,debugging of test flowchart,and detection.The process recommendation subsystem is responsible for data processing of existing test cases set,generation and update of process matching tables,and recommendation of flowchart symbol.The test results of the tool show that the tool can effectively convert the test case between the text format and the flow chart format,debug test flow chart and so on,and combine the process recommendation help testers to write test cases,which improves the writing efficiency and accuracy.