Issued Patents All Time
Showing 26–50 of 78 patents
| Patent # | Title | Co-Inventors | Date |
|---|---|---|---|
| 7383246 | System, method, and computer program product for progressive query processing | Guy M. Lohman, Marki Volker, Vijayshankar Raman, David E. Simmen | 2008-06-03 |
| 7315852 | XPath containment for index and materialized view matching | Audrey L. Balmin, Kevin Scott Beyer, Roberta Jo Cochrane, Fatma Ozcan | 2008-01-01 |
| 7275056 | System and method for transforming queries using window aggregation | Qi Cheng, Linqi Liu, Wenbin Ma, Calisto P. Zuzarte | 2007-09-25 |
| 7240078 | Method, system, and program for query optimization with algebraic rules | Qi Cheng, Yang Sun, Calisto P. Zuzarte | 2007-07-03 |
| 7185004 | System and method for reverse routing materialized query tables in a database | David E. Simmen | 2007-02-27 |
| 7167853 | Matching and compensation tests for optimizing correlated subqueries within query using automatic summary tables | Markos Zaharioudakis, Roberta Jo Cochrane, George Lapis, Yang Sun | 2007-01-23 |
| 7020649 | System and method for incrementally maintaining non-distributive aggregate functions in a relational database | Roberta Jo Cochrane, Themistoklis Palpanas, Richard S. Sidle | 2006-03-28 |
| 6993516 | Efficient sampling of a relational database | Peter J. Haas, Guy M. Lohman, David E. Simmen, Ashutosh Singh, Michael J. Winer +1 more | 2006-01-31 |
| 6983291 | Incremental maintenance of aggregated and join summary tables | Roberta Jo Cochrane, Richard S. Sidle | 2006-01-03 |
| 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, Yang Sun +2 more | 2005-01-25 |
| 6763352 | Incremental maintenance of summary tables with complex grouping expressions | Roberta Jo Cochrane, Wolfgang Lehner, Richard S. Sidle | 2004-07-13 |
| 6665663 | Outerjoin and antijoin reordering using extended eligibility lists | Bruce G. Lindsay, Guy M. Lohman, Jun Rao | 2003-12-16 |
| 6625593 | Parallel query optimization strategies for replicated and partitioned tables | Ting Yu Leung, David E. Simmen, Tuong Chanh Truong | 2003-09-23 |
| 6581205 | Intelligent compilation of materialized view maintenance for query processing systems | Roberta Jo Cochrane, Ting Yu Leung, Chandrasekaran Mohan, Richard S. Sidle | 2003-06-17 |
| 6560594 | Cube indices for relational database management systems | Roberta Jo Cochrane, George Lapis, Ting Yu Leung, Yang Sun, Markos Zaharioudakis | 2003-05-06 |
| 6532470 | Support for summary tables in a database system that does not otherwise support summary tables | Roberta Jo Cochrane, James C. Kleewein, Ting Yu Leung, Narayana Subramanina, Shivkumar Venkataraman | 2003-03-11 |
| 6496828 | Support for summary tables in a heterogeneous database environment | Roberta Jo Cochrane, James C. Kleewein, Ting Yu Leung, Narayana Subramanian, Shivakumar Venkataraman | 2002-12-17 |
| 6460027 | Automatic recognition and rerouting of queries for optimal performance | Roberta Jo Cochrane, George Lapis, Ting Yu Leung, Monica Sachiye Urata | 2002-10-01 |
| 6453314 | System and method for selective incremental deferred constraint processing after bulk loading data | Petrus Chan, Roberta Jo Cochrane, Sam S. Lightstone, Richard S. Sidle, Tuong Chanh Truong +2 more | 2002-09-17 |
| 6421658 | Efficient implementation of typed view hierarchies for ORDBMS | Michael J. Carey, George Lapis, Serge Philippe Rielau, Bennet Vance | 2002-07-16 |
| 6339768 | Exploitation of subsumption in optimizing scalar subqueries | Ting Yu Leung | 2002-01-15 |
| 6339769 | Query optimization by transparently altering properties of relational tables using materialized views | Roberta Jo Cochrane, George Lapis, Ting Yu Leung, Monica Sachiye Urata, Richard S. Sidle +2 more | 2002-01-15 |
| 6339770 | Query simplification and optimization involving eliminating grouping column from group by operation corresponds to group by item that is constant | Ting Yu Leung | 2002-01-15 |
| 6112198 | Optimization of data repartitioning during parallel query optimization | Guy M. Lohman, Eugene J. Shekita, David E. Simmen, Monica Sachiye Urata | 2000-08-29 |
| 6085189 | Database system and method for supporting current of cursor updates and deletes from a select query from one or more updatable tables in single node and MPP environments | David E. Simmen, Tuong Chanh Truong | 2000-07-04 |