Issued Patents All Time
Showing 51–75 of 75 patents
| Patent # | Title | Co-Inventors | Date |
|---|---|---|---|
| 7788241 | Method for reducing overhead of validating constraints in a database | Qi Cheng, Haider A. Rizvi | 2010-08-31 |
| 7752160 | Method for unordered relational database retrieval returning distinct values | Ian R. Finlay, Tony Lai, Daniel C. Zilio | 2010-07-06 |
| 7725461 | Management of statistical views in a database system | Mokhtar Kandil, Alberto Lerner, Volker Gerhard Markl, Daniele Costante Zilio | 2010-05-25 |
| 7680821 | Method and system for index sampled tablescan | Ian R. Finlay | 2010-03-16 |
| 7668804 | Recommending statistical views using cost/benefit metrics | Amr El-Helw, Ihab Francis Ilyas | 2010-02-23 |
| 7593931 | Apparatus, system, and method for performing fast approximate computation of statistics on query expressions | Xiaohui Yu | 2009-09-22 |
| 7539667 | Method, system and program for executing a query having a union operator | Bruce G. Lindsay, Linqi Liu, Robert Neugebauer, Mir Hamid Pirahesh, David C. Sharpe +1 more | 2009-05-26 |
| 7533087 | Method, system, and program for executing a query having a union all operator and data modifying operations | Linqi Liu, Robert Neugebauer, David C. Sharpe, Nattavut Sutyanyong | 2009-05-12 |
| 7512625 | Method, system and program for joining source table rows with target table rows | Josep L. Lariba-Pey, Victor Muntés-Mulero, Hebert W. Pereyra, Josep Aguilar-Saborit | 2009-03-31 |
| 7478080 | Canonical abstraction for outerjoin optimization | Mir Hamid Pirahesh, Jun Rao | 2009-01-13 |
| 7454416 | Method for aggregation subquery join elimination | Qi Cheng, Wenbin Ma | 2008-11-18 |
| 7447681 | Method, system and program for selection of database characteristics | Sam S. Lightstone, Guy M. Lohman, William T. O'Connell, Jun Rao, Robin D. Van Boeschoten +1 more | 2008-11-04 |
| 7409385 | Method, system and program for executing a query having a UNION operator | Bruce G. Lindsay, Linqi Liu, Robert Neugebauer, Mir Hamid Pirahesh, David C. Sharpe +1 more | 2008-08-05 |
| 7275056 | System and method for transforming queries using window aggregation | Qi Cheng, Linqi Liu, Wenbin Ma, Mir Hamid Pirahesh | 2007-09-25 |
| 7240078 | Method, system, and program for query optimization with algebraic rules | Qi Cheng, Mir Hamid Pirahesh, Yang Sun | 2007-07-03 |
| 7181449 | Method, system, and program product for executing a scalar function on a varying number of records within a RDBMS using SQL | Mark S. Ramsey, Milind Chitgupakar | 2007-02-20 |
| 7171408 | Method of cardinality estimation using statistical soft constraints | — | 2007-01-30 |
| 7136850 | Self tuning database retrieval optimization using regression functions | Martin Keller | 2006-11-14 |
| 7007006 | Method for recommending indexes and materialized views for a database workload | Daniel C. Zilio, Gary Valentin, Guy M. Lohman, Roberta Jo Cochrane, Hamid Pirahesh +6 more | 2006-02-28 |
| 6778976 | Selectivity estimation for processing SQL queries containing having clauses | Peter J. Haas, John E. Lumby | 2004-08-17 |
| 6738755 | Query optimization method for incrementally estimating the cardinality of a derived relation when statistically correlated predicates are applied | Johann-Christoph Freytag, Guy M. Lohman, David E. Simmen | 2004-05-18 |
| 6615222 | System and process for evaluating the performance of a database system | John Frederick Hornibrook, John E. Lumby, Walid Rjaibi | 2003-09-02 |
| 6453314 | System and method for selective incremental deferred constraint processing after bulk loading data | Petrus Chan, Roberta Jo Cochrane, Sam S. Lightstone, Mir Hamid Pirahesh, Richard S. Sidle +2 more | 2002-09-17 |
| 6339769 | Query optimization by transparently altering properties of relational tables using materialized views | Roberta Jo Cochrane, George Lapis, Ting Yu Leung, Mir Hamid Pirahesh, Monica Sachiye Urata +2 more | 2002-01-15 |
| 5706494 | System and method for constraint checking bulk data in a database | Roberta Jo Cochrane, Mir Hamid Pirahesh, Richard S. Sidle | 1998-01-06 |