Issued Patents All Time
Showing 26–43 of 43 patents
| Patent # | Title | Co-Inventors | Date |
|---|---|---|---|
| 6532470 | Support for summary tables in a database system that does not otherwise support summary tables | Roberta Jo Cochrane, James C. Kleewein, Mir Hamid Pirahesh, Narayana Subramanina, Shivkumar Venkataraman | 2003-03-11 |
| 6529896 | Method of optimizing a query having an existi subquery and a not-exists subquery | Tuong Chanh Truong, Monica Sachiye Urata | 2003-03-04 |
| 6513034 | Deriving uniqueness for indices on summary tables | David E. Simmen | 2003-01-28 |
| 6496828 | Support for summary tables in a heterogeneous database environment | Roberta Jo Cochrane, James C. Kleewein, Mir Hamid Pirahesh, Narayana Subramanian, Shivakumar Venkataraman | 2002-12-17 |
| 6460027 | Automatic recognition and rerouting of queries for optimal performance | Roberta Jo Cochrane, George Lapis, Mir Hamid Pirahesh, Monica Sachiye Urata | 2002-10-01 |
| 6438542 | Method of optimally determining lossless joins | Fred Koo | 2002-08-20 |
| 6339770 | Query simplification and optimization involving eliminating grouping column from group by operation corresponds to group by item that is constant | Mir Hamid Pirahesh | 2002-01-15 |
| 6339769 | Query optimization by transparently altering properties of relational tables using materialized views | Roberta Jo Cochrane, George Lapis, Mir Hamid Pirahesh, Monica Sachiye Urata, Richard S. Sidle +2 more | 2002-01-15 |
| 6339768 | Exploitation of subsumption in optimizing scalar subqueries | Mir Hamid Pirahesh | 2002-01-15 |
| 6032143 | Evaluation of existential and universal subquery in a relational database management system for increased efficiency | Alex Chak-tsang Lui, Mir Hamid Pirahesh, Tuong Chanh Truong | 2000-02-29 |
| 5963933 | Efficient implementation of full outer join and anti-join | Josephine M. Cheng, Mir Hamid Pirahesh | 1999-10-05 |
| 5864840 | Evaluation of existential and universal subquery in a relational database management system for increased efficiency | Alex Chak-tsang Lui, Mir Hamid Pirahesh, Tuong Chanh Truong | 1999-01-26 |
| 5822750 | Optimization of correlated SQL queries in a relational database management system | Michelle Meichiou Jou, Mir Hamid Pirahesh | 1998-10-13 |
| 5615361 | Exploitation of uniqueness properties using a 1-tuple condition for the optimization of SQL queries | Mir Hamid Pirahesh, David E. Simmen, Lori G. Strain, Sanjai Tiwari | 1997-03-25 |
| 5590324 | Optimization of SQL queries using universal quantifiers, set intersection, and max/min aggregation in the presence of nullable columns | Mir Hamid Pirahesh, Michelle Meichiou Jou, David E. Simmen | 1996-12-31 |
| 5548754 | Optimization of SQL queries using early-out join transformations | Mir Hamid Pirahesh, Guy M. Lohman, Eugene J. Shekita, David E. Simmen | 1996-08-20 |
| 5548755 | System for optimizing correlated SQL queries in a relational database using magic decorrelation | Mir Hamid Pirahesh, Praveen Seshadri | 1996-08-20 |
| 5548758 | Optimization of SQL queries using early-out join transformations of column-bound relational tables | Mir Hamid Pirahesh, Guy M. Lohman, Eugene J. Shekita, David E. Simmen | 1996-08-20 |