Robert E Thorpe

US Patent:

6457003, Sep 24, 2002

Filed:

Aug 16, 1999

Appl. No.:

09/375111

Inventors:

Kimberly Lynn Gajda - Raleigh NC
Robert Tod Thorpe - Cary NC

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 4, 707 3, 707 1, 707100

Abstract:

Methods, systems and computer program products are provided which allow for accessing at least one data source by intercepting a command to a standard relational database management system and determining if the intercepted command accesses the data source utilizing a logical table name. If the intercepted command accesses the data source utilizing the logical table name, then the logical table name is translated to a physical table name. The intercepted command is the provided to the relational database management system utilizing the physical table name translated from the logical table name so as to provide access the data source utilizing the logical table name. Furthermore, if the intercepted command accesses the data source utilizing a logical table name and a logical column name, then the logical table name is translated to the physical table name and the logical column name translated to a physical column name.

US Patent:

6502088, Dec 31, 2002

Filed:

Jul 8, 1999

Appl. No.:

09/349607

Inventors:

Kimberly Lynn Gajda - Raleigh NC
Bradley Allan Hess - Rockville MD
Julie Anne Hill Kemp - Raleigh NC
Jerry Jay Lewis - Raleigh NC
Robert Tod Thorpe - Cary NC

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 2, 707 1, 707 4, 707 10

Abstract:

The method and system of the present invention provides improved access to databases in a computer system. The present invention includes a plurality of data sources, the data sources including at least one non-relational data source; a server coupled to the plurality of data sources, the server capable of providing client access to the plurality of data sources; and a store place data access layer (SPDAL) coupled to the server and the at least one non-relational data source, the SPDAL providing relational features to the at least one non-relational data source. In the preferred embodiment, the relational features provided include a two-phase commit process; a process for performing Structured Query Language (SQL) operations from within a single application; a referential integrity process; and a process for providing indices for non-relational data source files. These features allow the computer system to perform data changes across multiple database sources within a single operation; perform SQL operations from a single application across heterogeneous file systems; provide referential integrity of data in both relational and non-relational databases; and perform ad-hoc queries of data and other queries efficiently in non-relational databases. By adding these features, significant flexibility is added to the computer system.

US Patent:

6877000, Apr 5, 2005

Filed:

Aug 22, 2001

Appl. No.:

09/934887

Inventors:

Kimberly Lynn Gajda - Raleigh NC, US
Bradley Allan Hess - Rockville MD, US
Robert Tod Thorpe - Cary NC, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F017/30
G06F007/00

US Classification:

707 3, 707 4

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.

US Patent:

20010056428, Dec 27, 2001

Filed:

May 3, 2001

Appl. No.:

09/848181

Inventors:

Kimberly Gajda - Raleigh NC, US
Bradley Hess - Rockville MD, US
Julie Hill Kemp - Raleigh NC, US
Jerry Lewis - Raleigh NC, US
Robert Thorpe - Cary NC, US

International Classification:

G06F007/00

US Classification:

707/100000

Abstract:

The method and system of the present invention provides improved access to databases in a computer system. The present invention includes a plurality of data sources, the data sources including at least one non-relational data source; a server coupled to the plurality of data sources, the server capable of providing client access to the plurality of data sources; and a store place data access layer (SPDAL) coupled to the server and the at least one non-relational data source, the SPDAL providing relational features to the at least one non-relational data source. In the preferred embodiment, the relational features provided include a two-phase commit process; a process for performing Structured Query Language (SQL) operations from within a single application; a referential integrity process; and a process for providing indices for non-relational data source files. These features allow the computer system to perform data changes across multiple database sources within a single operation; perform SQL operations from a single application across heterogeneous file systems; provide referential integrity of data in both relational and non-relational databases; and perform ad-hoc queries of data and other queries efficiently in non-relational databases. By adding these features, significant flexibility is added to the computer system.

US Patent:

6304871, Oct 16, 2001

Filed:

Dec 18, 1998

Appl. No.:

9/216613

Inventors:

Kimberly Lynn Gajda - Raleigh NC
Michael Joseph Johnson - Raleigh NC
Robert Tod Thorpe - Cary NC

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 4

Abstract:

A system and method for allowing a user to characterize an application are disclosed. In one aspect, the method and system allow a user to characterize a database engine. The database engine utilizes a particular interface for communicating with an application. The method and system include determining a query spectrum including plurality of queries corresponding to a plurality of query types. The plurality of query types are chosen such that any possible query can be classified as being of one query type. The plurality of queries is compatible with the particular interface. The method and system include running the query spectrum on the database engine and determining a time taken to run each of the plurality of queries on the database engine. In another aspect, the method and system are for characterizing the application. In this aspect, the method and system include characterizing the database engine using a query spectrum including a first plurality of queries compatible with the particular interface.