Design And Implementation Of SQL Standard Compatibility Automatic Test System For Database

In recent years,with the development of domestic computer technology,domestic software and domestic operating systems have sprung up and gradually penetrated into people's daily lives.Due to the wide variety and versions of domestic software and domestic operating systems,the compatibility of domestic operating systems and domestic software needs to be resolved urgently.As an important means to ensure the compatibility of software and operating system,compatibility testing plays an irreplaceable role.As the underlying support of many software,database software plays an important role in supporting the normal running of the software.The compatibility of database software determines the compatibility of many software,but the traditional database and operating system compatibility test has High test costs,low test efficiency,low repeatability,and lack of standard test sets.This thesis proposes an automated testing technology for database SQL standard compatibility,which is used to automatically generate database compatibility test reports,design and implement a database compatibility test system,aiming to establish an automated testing process for database software and provide database developers with Reference value.In order to solve the problem of the lack of standard test sets and test the functional correctness of the database,this article defines a SQL test set containing 206 items according to the ANSI SQL:1999 standard,covering 18 data types,and at the same time according to ANSI The SQL-92 standard defines a SQL test set containing 187 items,covering 14 data types,both of which cover a variety of query conditions.In order to solve the problem of high test cost and low test efficiency caused by manual deployment of operating systems and databases on physical machines in traditional database testing,this article uses Docker container technology to automate the deployment of operating systems and databases.The test execution module verifies the functionality of the deployed database by automatically executing SQL and collecting results,and generates test reports.The system is a java web project.Users can use it by visiting the website,test uploading the database or database connection URL,run the automated evaluation results through the service,and generate the corresponding compatibility test report.Provide effective advice to database developers and testers.