Inventor
LEUNG TING YU
US26 patents
⚠️ This page may combine multiple inventors who share the name “LEUNG TING YU”. Patents are grouped by organization below to help distinguish them — per-person disambiguation is on the roadmap.
IBM
25 patentsUS7080062B1Jul 18, 2006
Optimizing database queries using query execution plans derived from automatic summary table determining cost based queries
IBM184 citations99
US6339769B1Jan 15, 2002
Query optimization by transparently altering properties of relational tables using materialized views
IBM190 citations99
US6996557B1Feb 7, 2006
Method of optimizing SQL queries where a predicate matches nullable operands
IBM109 citations98
US6625593B1Sep 23, 2003
Parallel query optimization strategies for replicated and partitioned tables
IBM133 citations98
US6574623B1Jun 3, 2003
Query transformation and simplification for group by queries with rollup/grouping sets in relational database management systems
IBM132 citations98
US6460027B1Oct 1, 2002
Automatic recognition and rerouting of queries for optimal performance
IBM101 citations98
US5963933AOct 5, 1999
Efficient implementation of full outer join and anti-join
IBM95 citations98
US6529896B1Mar 4, 2003
Method of optimizing a query having an existi subquery and a not-exists subquery
IBM122 citations97
US5822750AOct 13, 1998
Optimization of correlated SQL queries in a relational database management system
IBM345 citations97
US6847962B1Jan 25, 2005
Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tables
IBM85 citations96
US6581205B1Jun 17, 2003
Intelligent compilation of materialized view maintenance for query processing systems
IBM68 citations96
US6560594B2May 6, 2003
Cube indices for relational database management systems
IBM56 citations96
US6496828B1Dec 17, 2002
Support for summary tables in a heterogeneous database environment
IBM67 citations96
US6339770B1Jan 15, 2002
Query simplification and optimization involving eliminating grouping column from group by operation corresponds to group by item that is constant
IBM64 citations96
US6339768B1Jan 15, 2002
Exploitation of subsumption in optimizing scalar subqueries
IBM73 citations96
US5864840AJan 26, 1999
Evaluation of existential and universal subquery in a relational database management system for increased efficiency
IBM94 citations96
US6032143AFeb 29, 2000
Evaluation of existential and universal subquery in a relational database management system for increased efficiency
IBM73 citations94
US6826562B1Nov 30, 2004
Method of simplifying and optimizing scalar subqueries and derived tables that return exactly or at most one tuple
IBM54 citations92
US6438542B1Aug 20, 2002
Method of optimally determining lossless joins
IBM16 citations92
US6636846B1Oct 21, 2003
Method for providing a system maintained materialized functionally dependent column for a database management system
IBM34 citations91
US6513034B1Jan 28, 2003
Deriving uniqueness for indices on summary tables
IBM15 citations84
US7945578B2May 17, 2011
Optimizing scalar search in a text indexing and search server
IBM8 citations79
US6532470B1Mar 11, 2003
Support for summary tables in a database system that does not otherwise support summary tables
IBM13 citations79
US6856996B2Feb 15, 2005
Method, system, and program for accessing rows in one or more tables satisfying a search criteria
IBM11 citations72
US6601063B2Jul 29, 2003
Method of optimally determining lossless joins
IBM2 citations62