Patent | Date |
---|
Materialized Views For Database Query Optimization App 20210019318 - Leung; Ting Yu ;   et al. | 2021-01-21 |
Systems And Methods For Graph-based Query Analysis App 20200356599 - Xia; Yinglong ;   et al. | 2020-11-12 |
Predictive table pre-joins in large scale data management system using graph community detection Grant 10,528,563 - Xia , et al. J | 2020-01-07 |
Predictive Table Pre-joins In Large Scale Data Management System Using Graph Community Detection App 20180173763 - Xia; Yinglong ;   et al. | 2018-06-21 |
Predicting Reference Frequency/urgency For Table Pre-loads In Large Scale Data Management System Using Graph Community Detection App 20180173755 - Xia; Yinglong ;   et al. | 2018-06-21 |
Optimizing scalar search in a text indexing and search server Grant 7,945,578 - Leung , et al. May 17, 2 | 2011-05-17 |
Optimizing Scalar Search In A Text Indexing And Search Server App 20090319485 - Leung; Ting Yu ;   et al. | 2009-12-24 |
Optimizing database queries using query execution plans derived from automatic summary table determining cost based queries Grant 7,080,062 - Leung , et al. July 18, 2 | 2006-07-18 |
Method of optimizing SQL queries where a predicate matches nullable operands Grant 6,996,557 - Leung , et al. February 7, 2 | 2006-02-07 |
Method, system, and program for accessing rows in one or more tables satisfying a search criteria Grant 6,856,996 - Chow , et al. February 15, 2 | 2005-02-15 |
Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tables Grant 6,847,962 - Cochrane , et al. January 25, 2 | 2005-01-25 |
Method of simplifying and optimizing scalar subqueries and derived tables that return exactly or at most one tuple Grant 6,826,562 - Leung , et al. November 30, 2 | 2004-11-30 |
Method for providing a system maintained materialized functionally dependent column for a database management system Grant 6,636,846 - Leung , et al. October 21, 2 | 2003-10-21 |
Parallel query optimization strategies for replicated and partitioned tables Grant 6,625,593 - Leung , et al. September 23, 2 | 2003-09-23 |
Method of optimally determining lossless joins Grant 6,601,063 - Koo , et al. July 29, 2 | 2003-07-29 |
Intelligent compilation of materialized view maintenance for query processing systems Grant 6,581,205 - Cochrane , et al. June 17, 2 | 2003-06-17 |
Query transformation and simplification for group by queries with rollup/grouping sets in relational database management systems Grant 6,574,623 - Leung , et al. June 3, 2 | 2003-06-03 |
Cube indices for relational database management systems Grant 6,560,594 - Cochrane , et al. May 6, 2 | 2003-05-06 |
Support for summary tables in a database system that does not otherwise support summary tables Grant 6,532,470 - Cochrane , et al. March 11, 2 | 2003-03-11 |
Method of optimizing a query having an existi subquery and a not-exists subquery Grant 6,529,896 - Leung , et al. March 4, 2 | 2003-03-04 |
Support for summary tables in a heterogeneous database environment Grant 6,496,828 - Cochrane , et al. December 17, 2 | 2002-12-17 |
Method of optimally determining lossless joins App 20020147714 - Koo, Fred ;   et al. | 2002-10-10 |
Method, system, and program for accessing rows in one or more tables satisfying a search criteria App 20020143751 - Chow, Jyh-Herng ;   et al. | 2002-10-03 |
Automatic recognition and rerouting of queries for optimal performance Grant 6,460,027 - Cochrane , et al. October 1, 2 | 2002-10-01 |
Cube Indices For Relational Database Management Systems App 20020138460 - COCHRANE, ROBERTA JO ;   et al. | 2002-09-26 |
Exploitation of subsumption in optimizing scalar subqueries Grant 6,339,768 - Leung , et al. January 15, 2 | 2002-01-15 |
Query simplification and optimization involving eliminating grouping column from group by operation corresponds to group by item that is constant Grant 6,339,770 - Leung , et al. January 15, 2 | 2002-01-15 |
Query optimization by transparently altering properties of relational tables using materialized views Grant 6,339,769 - Cochrane , et al. January 15, 2 | 2002-01-15 |
Evaluation of existential and universal subquery in a relational database management system for increased efficiency Grant 6,032,143 - Leung , et al. February 29, 2 | 2000-02-29 |
Evaluation of existential and universal subquery in a relational database management system for increased efficiency Grant 5,864,840 - Leung , et al. January 26, 1 | 1999-01-26 |
Optimization of correlated SQL queries in a relational database management system Grant 5,822,750 - Jou , et al. October 13, 1 | 1998-10-13 |