Dissertation > Excellent graduate degree dissertation topics show

ODBC standard database management system compliance testing

Author: YangXiaoDong
Tutor: LiYi
School: University of Electronic Science and Technology
Course: Computer System Architecture
Keywords: ODBC driver ODBC conformance level ODBC conformance test SQL conformance test interface conformance test
CLC: TP311.13
Type: Master's thesis
Year: 2010
Downloads: 143
Quote: 2
Read: Download Dissertation

Abstract


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.

Related Dissertations

  1. The Research on Protocol of Air Interface in TD-SCDMA and the Implement of the Test Cases,TN929.533
  2. Based-on-linux Management System for Network Address,TP393.07
  3. Research on F&B Index Structure Supporting XML Query,TP311.13
  4. Query Processing and Optimization in Massive Multi-Database Integration,TP311.13
  5. Research on Compression, Operation and Query Processing Methods of Massive Datasets,TP311.13
  6. Implementation of Data Compression, Operation and Query Processing System Based on BAP,TP311.13
  7. Research and Improvement on K-Means Clustering Algorithm,TP311.13
  8. Research on K-means Optimization Clustering Algorithm,TP311.13
  9. Clustering Method Research Based on Divided and Conquered Method,TP311.13
  10. Incomplete information on the completeness of the system and its knowledge acquisition,TP311.13
  11. Evolutionary Clustering Algorithm and Its Application,TP311.13
  12. Study on the Key Technologies of Domain Database-Oriented Question and Answering System,TP311.13
  13. Web Usage Mining and the Research of Personalized Recommendation,TP311.13
  14. Application of the Technique of Data Mining in Educational Administration,TP311.13
  15. Research on Determining the Number of Clusters Based on Information Entropy,TP311.13
  16. A Research on Prediction of Academic Record Based on Neural Network and Cover Algorithm,TP311.13
  17. Research on Mapping Relational Database to RDF (S),TP311.13
  18. Based on community structure found in the data warehouse subject extraction studies,TP311.13
  19. Research of Bi-directional Transformation between XML Data and Relational Data with Semantic Constraints,TP311.13
  20. Domain Ontology-based Marine Environmental Data Warehouse Design,TP311.13
  21. Study on Discovering the Relationships among Data Resources in DataSpace,TP311.13

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems
© 2012 www.DissertationTopic.Net  Mobile