Design And Implementation Of DB2 For I Database Testing System Based On Eclipse RCP

The traditional database testing methods need testers one by one log in to different database servers. Editing and running case scripts then catching exceptions. But this often has the following limitations: In the case of network outages can not be tested. The same case can not be copied in different servers and need to edit repeatedly. Mass of cases need manual search and find so that wasting a lot of time. Testers need reanalysis the redundant result set then manual extraction of critical test results. Because of the specificity of the operating system, need to testers have more skills of AS400.To compensate for the shortcomings of traditional testing methods, I developed a set of DB2 for i database testing system CaseEditor. It can cross-platform, away from the network, edit scripts, run scripts and show the results.This paper describes the development process of this database testing system .Including system requirements analysis, system design and implementation of the various functions and discussion and summary of problems encountered.In the system requirements analysis process .From the perspective of users, mainly considering the convenience of editing and running the script, away from the network and cross-platform operability and considering the system's utility, feasibility, and software and hardware conditions. Then propose the functional requirements of the system and according to the functions of the system, I divide it into five function modules. Include the management of the script editor, the management of running the scripts, the script result sets management, local and remote database synchronization management, the management system to distribute. The management of the script editor mainly offers three methods to testers: Table format editing, Text format editing and SQL format editing. In addition provide syntax highlighting, byte search / replace and custom scripts Modules and other ancillary functions. The management of running the scripts includes two forms: CaseEditor locally run and SMART run. The script result sets management including three forms: directly show on console, log and XML files. Local and remote database synchronization management maintain data consistency and facilitate the tester offline operation in the future. Package release management system to facilitate tester away from the tedious code, simply double-click will run the test system.In the system design and implementation process . Consider software expansion and maintenance, utilizing Plug-in technology. The use of existing mature software, the reuse and extension, both to ensure the quality of the system, but also greatly improves the development Efficiency. In the design process, taking into account the performance of the database itself and the data efficiency of batch updates, use of temporary tables update technology, thereby greatly increasing the upload use cases the efficiency of data update, to meet the needs of users. In the system implementation, ongoing optimization of the system, not only to improve the structure of the system and the details from the technology but also improved system efficiency and maintainability.Developing the database testing system CaseEditor can make up for network outages defects, which itself is a C / S architecture, be freed from the shackles of the network, in an offline state to test DB2 for i database. Because of their is a rich client platform that can provide more users to the user experience.At present, the system has been delivered to users and gets the praise. Show that the system meets the user's actual requirements and is expected to become a subsidiary of DB2 for i family of products to the field of database testing.