Seetha M Lakshmi

US Patent:

61086487, Aug 22, 2000

Filed:

Jul 18, 1997

Appl. No.:

8/896931

Inventors:

Seetha M. Lakshmi - Cupertino CA
Shaoyu Zhou - Mountain View CA

Assignee:

Informix Software, Inc. - Menlo Park CA

International Classification:

G06F 1730
G06F 1518

US Classification:

707 2

Abstract:

A computer operated apparatus estimates values needed by an optimizer in a database management system (DBMS). The DBMS has one or more tables for storing data, each table having zero or more columns of user-definable data types and zero or more associated user-defined routines (UDRs). The apparatus has a feature vector extractor connected to the database tables for converting the UDR inputs into a base type representation. A neural network receives the feature vector and generates estimated values which are provided to the optimizer of the DBMS. The neural network can be trained periodically using randomly generated queries, or it can be trained dynamically by capturing data generated during a query. During operation, the optimizer dynamically invokes the neural network to generate estimates such as selectivity and cost per call for determining optimum query search sequence.

US Patent:

60030224, Dec 14, 1999

Filed:

Aug 22, 1997

Appl. No.:

8/916560

Inventors:

Rainer Eberhard - San Jose CA
Harold Hall - San Jose CA
Seetha Lakshmi - San Jose CA

Assignee:

International Buisness Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 2

Abstract:

The software tool of this invention estimates the costs of an application program accessing a database. These costs may be execution costs of the application or of a transaction, SQL statement, and/or a utility. Execution costs include CPU time, I/O time and minimum elapsed time. For estimating the execution costs, the tool receives simplified and partial definitions of tables, utilities, SQL statements, transactions, and applications. The estimator tool requires only a minimal amount of information to calculate the various execution costs.

US Patent:

57581444, May 26, 1998

Filed:

Jun 24, 1994

Appl. No.:

8/265595

Inventors:

Rainer Eberhard - San Jose CA
Harold Hall - San Jose CA
Seetha Lakshmi - San Jose CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

395602

Abstract:

The software tool of this invention estimates the costs of an application program accessing a database. These costs may be execution costs of the application or of a transaction, SQL statement, and/or a utility. Execution costs include CPU time, I/O time and minimum elapsed time. For estimating the execution costs, the tool receives simplified and partial definitions of tables, utilities, SQL statements, transactions, and applications. The estimator tool requires only a minimal amount of information to calculate the various execution costs.

US Patent:

57348847, Mar 31, 1998

Filed:

May 10, 1996

Appl. No.:

8/644593

Inventors:

Rainer Eberhard - San Jose CA
Harold Hall - San Jose CA
Seetha Lakshmi - San Jose CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

395602

Abstract:

The software tool of this invention estimates the costs of an application program accessing a database. These costs may be execution costs of the application or of a transaction, SQL statement, and/or a utility. Execution costs include CPU time, I/O time and minimum elapsed time. For estimating the execution costs, the tool receives simplified and partial definitions of tables, utilities, SQL statements, transactions, and applications. The estimator tool requires only a minimal amount of information to calculate the various execution costs.