6/10/2002

Student Name: Janardhana R Punuru

Committee:
Dr. Jianhua Chen (Chair)
Dr. Aiichro Nakano
Dr. Donal H. Kraft

Date: Friday, June 14, 2002
Time: 2.00 P.M.
Location: 263 A Coates Hall

Title:Database Independent Approach For English to SQL Translation

Abstract:
SQL (Structured Query Language) is the de facto standard used for data definition and data manipulation in relational database systems. Because of the complexity in using SQL for end users, in this project we developed an application, which translates the given English statement to SQL query. This project is designed to be database independent, and it can be used by users with no knowledge of SQL to translate natural language queries to SQL. To achieve database independent translation of English statement toSQL query, system accepts the database information in a declaration file and converts this information to internal structure before processing English statement. Experiments with three different databases and about sixty queries show that the proposed approach works quite well.

This project is developed in C++.