Design And Implementation Of Testing Tools For DBMS Based On TETware

Database technology plays an important and foundation role in the modern informationsystem and uses widely in finance, telecommunications, web and other industries.Nowadays, DBMS products always with huge release size, various features and complexstructure, so the quality of DBMS becomes an important issue. Also function testing is animportant part of software testing cycles, but it costs large human resource and working time.The automated software functional testing not only enhances the quality of the DBMS, butalso reduces the development costs, human resource costs and the release interval.In this thesis, it takes the automated testing for DBMS as its background. Based onthe basis researching of the related technologies, a muti-platform automated testing toolsfor DBMS is designed. And a application system under the tools against ASE (AdaptiveServer Enterprise, Sybase company database product) is implemented. This researchintegrate theories including automated software testing, testing tools and technologiessuch as test tool protocol, test script language in DBMS automated functional testing.According to the DBMS functional test requirements, the tools was designed. It compriseof tool structure, automated process flow control, test case control module, test case codeextension module, system resource management module, operating system functionalcontrol module and Database connection management module. Finally, all these modulesimplemented and combined as a system against ASE database.This automated testing tools can be used against different DBMS products, in whichto construct different automated test systems. These systems implement automated testprocess control, resource management, DBMS connection management and test codesupport. Practical system running shows that the function and performance of this toolsatisfied the requirements in DBMS development.