Richard Paul Cole

US Patent:

6374263, Apr 16, 2002

Filed:

Jul 19, 1999

Appl. No.:

09/356486

Inventors:

Craig J. Bunger - San Francisco CA
Latha S. Colby - Mountain View CA
Richard L. Cole - Los Gatos CA
Galt Johnson - San Francisco CA
William J. McKenna - Santa Cruz CA
Gopal B. Mulagund - San Jose CA

Assignee:

International Business Machines Corp. - Armonk NY

International Classification:

G06F 1730

US Classification:

707201, 707 2, 707 3, 707 8, 707 10, 707203, 709203, 709219

Abstract:

A system and a method maintain a precomputed view corresponding to detail data in a database server by: determining a maintenance plan to refresh the precomputed view when detail data is changed; integrating the maintenance plan with a query execution plan in the database server; and executing the query execution plan.

US Patent:

6480836, Nov 12, 2002

Filed:

Mar 25, 1999

Appl. No.:

09/277041

Inventors:

Latha S. Colby - Los Altos CA
Richard L. Cole - Los Gatos CA
Edward P. Haslam - San Francisco CA
Nasi Jazayeri - Santa Clara CA
Galt Johnson - Campbell CA
William J. McKenna - Santa Cruz CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 3, 707 2, 707102, 707201

Abstract:

The invention features methods and apparatus for processing precomputed views for answering user queries on a database. In accordance with one aspect, a user query on the database is analyzed, and a candidate view based upon the user query is generated.

US Patent:

6493699, Dec 10, 2002

Filed:

Mar 25, 1999

Appl. No.:

09/277034

Inventors:

Latha S. Colby - Los Altos CA
Richard L. Cole - Los Gatos CA
Edward P Haslam - San Francisco CA
Nasi Jazayeri - Santa Clara CA
Galt Johnson - San Francisco CA
William J. McKenna - Santa Cruz CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 2, 707 3, 707200

Abstract:

Methods and apparatus for processing precomputed views for answering user queries on a database are described. In accordance with one aspect, a user database query on precomputation strategy effectiveness is responded to by defining, based upon user database query history, an analysis space consisting of a subset of all possible views for the database, and by characterizing the views in the analysis space. In accordance with a second aspect, a structure is imposed on an analysis space consisting of a subset of all possible views for the database based upon the capabilities of a query rewriting facility, and the views in the analysis space are characterized. In accordance with a third aspect, an analysis space consisting of a subset of all possible views for the database is defined, and a cost formula is applied to the analysis space based upon a user-defined subset of the data contained in the database. In accordance with a fourth aspect, an analysis space that includes a candidate view composed of a combination of two or more constituent views is defined, and the views in the analysis space are characterized.

US Patent:

6594653, Jul 15, 2003

Filed:

Mar 25, 1999

Appl. No.:

09/277040

Inventors:

Latha S. Colby - Los Altos CA
Richard L. Cole - Los Gatos CA
Edward P. Haslam - San Francisco CA
Nasi Jazayeri - Santa Clara CA
Galt Johnson - Campbell CA
William J. McKenna - Santa Cruz CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 3, 707 2, 707 4, 707 10, 707102, 709203

Abstract:

Server-integrated methods and apparatus for processing precomputed views for answering user queries on a database are described. In accordance with one embodiment, a system for answering user queries on a database stored on a server includes a query processing system integrated into the server and configured to respond to user queries, and a query processing system integrated into the server and configured to process precomputed results of user queries on the database. In another aspect, a method of answering user queries on a database stored on a server includes responding to user queries received at the server, and processing, at the server, precomputed results of user queries on the database.

US Patent:

6629094, Sep 30, 2003

Filed:

Sep 1, 2000

Appl. No.:

09/654208

Inventors:

Latha S. Colby - Los Altos CA
Richard L. Cole - Los Gatos CA
Edward P. Haslam - San Francisco CA
Nasi Jazayeri - Santa Clara CA
Galt Johnson - Campbell CA
William McKenna - Santa Cruz CA
Lee E. Schumacher - Los Altos CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 4, 707 2, 707102, 707103 R, 7071041

Abstract:

A system and method for answering a relational database query is presented. According to an embodiment of the present invention, a database query is received. It is then determined whether that query can be rewritten in such a manner as to be able to utilize a precomputed view, such that an answer to the rewritten query is equivalent to an answer to the original query. If the query can be rewritten, it is determined whether the rewritten query can more efficiently derive the answer than the original query. The query which has the most efficiently derived answer is the query which is utilized to derive that answer.

US Patent:

6629095, Sep 30, 2003

Filed:

Oct 13, 1998

Appl. No.:

09/170990

Inventors:

William M. Wagstaff - Saratoga CA
Donovan A. Schneider - San Francisco CA
Ann M. Koehler - San Jose CA
Craig J. Bunger - San Francisco CA
Richard L. Cole - Los Gatos CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1700

US Classification:

707 5, 707 3, 707 4, 707 6, 706 45

Abstract:

An integrated data mining and relational database management system is provided on a server. The data mining engine determines characteristics of relationships between input data values and an output data value that are obtained from a relational database (managed by the relational database management system). The integration allows direct conversion of data values from the relational database to data mining identifiers used for data mining operations by the data mining engine, and vice-versa. The integrated server also makes patterns uncovered during data mining (e. g. , âunderstandâ and âpredictâ information) available in virtual relational database tables that can be queried.

US Patent:

8244715, Aug 14, 2012

Filed:

Apr 9, 2010

Appl. No.:

12/757639

Inventors:

Richard L. Cole - Los Gatos CA, US
Yijou Chen - Cupertino CA, US
William J. McKenna - Oceanside CA, US
Sergei Perfilov - San Jose CA, US
Aman Sinha - San Jose CA, US
Eugene Szedenits, Jr. - Ypsilanti MI, US

Assignee:

Paraccel, Inc. - Campbell CA

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707714, 707716, 707718, 707719

Abstract:

A system and/or method are implemented to process queries to a database. In particular, the processing of queries to the database is enhanced by enhancing the determination of join orders of tables implicated in queries. Join orders between relatively large numbers of tables are determined by dividing the set of tables to be ordered into a plurality of subsets of tables, and ordering the individual subsets of tables.

US Patent:

8510291, Aug 13, 2013

Filed:

Jul 11, 2012

Appl. No.:

13/546989

Inventors:

Richard L. Cole - Los Gatos CA, US
Yijou Chen - Cupertino CA, US
William J. McKenna - Oceanside CA, US
Sergei Perfilov - Sunnyvale CA, US
Aman Sinha - San Jose CA, US
Eugene Szedenits, Jr. - Ypsilanti MI, US

Assignee:

Paraccel, Inc. - Campbell CA

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707714, 707716, 707718, 707719

Abstract:

A system and/or method are implemented to process queries to a database. In particular, the processing of queries to the database is enhanced by enhancing the determination of join orders of tables implicated in queries. Join orders between relatively large numbers of tables are determined by dividing the set of tables to be ordered into a plurality of subsets of tables, and ordering the individual subsets of tables.

Address:

5182 Estasi St, Las Vegas, NV 89135

VIN:

1FMFU18597LA39047

Make:

FORD

Model:

EXPEDITION

Year:

2007