Odbc Standard Database Management System Compliance Testing

With the development of the database technology and the wide application of the database systems, the ODBC conformance level gradually become an important standard to measure the quality and performance of the database management system. Consequently, the ODBC conformance tests paves the way for the application of the domestic database software.ODBC conformance test aims to test the SQL and ODBC conformity of the DBMS and its ODBC driver and verify the correctness and reasonableness of the SQL conformance level as well as the interface conformance level declared by the rhodbc. ODBC conformance test includes SQL conformance test and interface conformance test. In this dissertation, The Xugu database is a domestic RDBMS and its ODBC driver is named rhodbc.SQL conformance test is used to test the conformity for SQL92 grammar and semantic of the Xugu database and rhodbc by the supportability test of the SQL grammar and the conformance test of the SQLGetInfo. With the help of the SQL Test Suite 6.0 and the interactive testing approach, the supportability test of the SQL grammar were finished through a series of certain SQL statements that were executed by the SQL query analyzer. In the conformance test of the SQLGetInfo, the testing tool named ODBC Test was directly used by calling the SQLGetInfo along with specific input parameters.Interface conformance test verifies the conformity of the ODBC standard by function conformance test and attribute conformance test, as well as the descriptor field conformance test. And the QuikTest framework was frequently used in the function conformance test to fragmenting test. Furthermore, the interface conformance level of the rhodbc was finally improved by the modification of the source code of rhodbc with implementing functions unsupported before and standardizing the functionality of certain interfaces.After the SQL conformance test, it was found that several features of the SQL grammar have not been supported by the Xugu database, therefore, the SQL conformance level declared by rhodbc is unreasonable so that the improvement on Xugu database needs to be done by database manufacturers. Meanwhile, after several modifications and enhancements, many problems found in the interface conformance test were solved finally, along with the improvement of the interface conformance level. Therefore, the interface conformance level declared by the rhodbc is both correct and reasonable.