Tool for converting SQL queries into portable ODBC

Details Tool for converting SQL queries into portable ODBC Tool for converting SQL queries into portable ODBC

2005-04-05

2005-04-05

Metjahic, Safet (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

06877000

ABSTRACT:
A method, computer program product and system for converting Structured Query Language (SQL) statements into the Open Database Connectivity (ODBC) standard. The source code of a database application may be parsed to identify one or more keywords. These keywords may be used to identify SQL statements as well as variables that are used to process the SQL statements. Upon identifying the SQL statements, the SQL statements may be evaluated. The SQL statements evaluated may then be matched with particular functions in a function library, i.e., a collection of functions stored in data files. These functions may implement particular ODBC calls thereby enabling SQL statements to be converted into the ODBC standard. A function call, i.e., a call to that function, may be substituted for the corresponding SQL statement. The function call may then be implemented resulting in the execution of the ODBC calls.

REFERENCES:
patent: 5664173 (1997-09-01), Fast
patent: 5749079 (1998-05-01), Yong et al.
patent: 5761494 (1998-06-01), Smedley et al.
patent: 6016499 (2000-01-01), Ferguson
patent: 6052685 (2000-04-01), Eastwick et al.
patent: 6182029 (2001-01-01), Friedman
patent: 6363391 (2002-03-01), Rosensteel, Jr.
patent: 6560592 (2003-05-01), Reid et al.
patent: 6658429 (2003-12-01), Dorsett, Jr.
patent: 20020087327 (2002-07-01), Lee et al.
patent: 20020161801 (2002-10-01), Hind et al.
patent: 20030048673 (2003-03-01), Copeland et al.
patent: 20040015890 (2004-01-01), Wong et al.
Fangju Wang, “Parsing, (2001), Grammatically Incomplete” Natural Language Queries to Spatial Databases, pp. 2400-2404.*
Neil Coburn, Per-Ake Larson, T.Patrick Martin, and Jacob Slonim (1993), CORDS Multidatabase Project: Research and Prototype Overview, pp. 767-778.*
Boris Katz, Deniz Yuret, Jimmy Lin, Sue Felshin, Rebecca Schuman, Adnan Ilik, Ali Ibrahim, Philip Osafo-Kwaako (1999), Intergrating Web Resources and Lexicons into a Natural Language Query System, pp. 255-261.

Affiliated with

Also associated with

Rating

Tool for converting SQL queries into portable ODBC does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Tool for converting SQL queries into portable ODBC, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Tool for converting SQL queries into portable ODBC will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3411120