Issued Patents All Time
Showing 1–12 of 12 patents
| Patent # | Title | Co-Inventors | Date |
|---|---|---|---|
| 6847962 | Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tables | Roberta Jo Cochrane, George Lapis, Ting Yu Leung, Mark Paskin, Mir Hamid Pirahesh +2 more | 2005-01-25 |
| 6826562 | Method of simplifying and optimizing scalar subqueries and derived tables that return exactly or at most one tuple | Ting Yu Leung, Swati Vora | 2004-11-30 |
| 6529896 | Method of optimizing a query having an existi subquery and a not-exists subquery | Ting Yu Leung, Tuong Chanh Truong | 2003-03-04 |
| 6460027 | Automatic recognition and rerouting of queries for optimal performance | Roberta Jo Cochrane, George Lapis, Ting Yu Leung, Mir Hamid Pirahesh | 2002-10-01 |
| 6345267 | Method and system for look ahead query evaluation planning based on interesting partition properties | Guy M. Lohman, Eugene J. Shekita, David E. Simmen | 2002-02-05 |
| 6339769 | Query optimization by transparently altering properties of relational tables using materialized views | Roberta Jo Cochrane, George Lapis, Ting Yu Leung, Mir Hamid Pirahesh, Richard S. Sidle +2 more | 2002-01-15 |
| 6112198 | Optimization of data repartitioning during parallel query optimization | Guy M. Lohman, Mir Hamid Pirahesh, Eugene J. Shekita, David E. Simmen | 2000-08-29 |
| 6092062 | Relational database query optimization to perform query evaluation plan, pruning based on the partition properties | Guy M. Lohman, Eugene J. Shekita, David E. Simmen | 2000-07-18 |
| 6081801 | Shared nothing parallel execution of procedural constructs in SQL | Roberta Jo Cochrane, George Lapis, Mir Hamid Pirahesh, Richard S. Sidle, David E. Simmen +1 more | 2000-06-27 |
| 5960428 | Star/join query optimization | Bruce G. Lindsay, Guy M. Lohman, Mir Hamid Pirahesh, Eugene J. Shekita, David E. Simmen | 1999-09-28 |
| 5930785 | Method for detecting and optimizing queries with encoding/decoding tables | Guy M. Lohman, Bernhard Schiefer | 1999-07-27 |
| 5873075 | Synchronization of SQL actions in a relational database system | Roberta Jo Cochrane, George Lapis, Mir Hamid Pirahesh, Richard S. Sidle, David E. Simmen +1 more | 1999-02-16 |