Inventor · disambiguated record
Ting Yu Leung
Also filed as: LEUNG TING Y · LEUNG TING YU · LEUNG TING YU CLIFF
43 granted patents·4 pending applications·2,830 citations·filing 1995–2022
99Inventor score
Files withIBM36FUTUREWEI TECHNOLOGIES INC3HUAWEI TECH CO LTD3MICROSOFT TECHNOLOGY LICENSING LLC3CHENG QI1
Top patents by PatentIndex Score
47 records- 0196US7080062B1Optimizing database queries using query execution plans derived from automatic summary table determining cost based queriesIBM·Filed 2000·Granted Jul 18, 2006·184 cites·57 claims
- 0296US6574623B1Query transformation and simplification for group by queries with rollup/grouping sets in relational database management systemsIBM·Filed 2000·Granted Jun 3, 2003·132 cites·21 claims
- 0396US5822750AOptimization of correlated SQL queries in a relational database management systemIBM·Filed 1997·Granted Oct 13, 1998·345 cites·21 claims
- 0495US6996557B1Method of optimizing SQL queries where a predicate matches nullable operandsIBM·Filed 2000·Granted Feb 7, 2006·109 cites·39 claims
- 0595US6529896B1Method of optimizing a query having an existi subquery and a not-exists subqueryIBM·Filed 2000·Granted Mar 4, 2003·122 cites·12 claims
- 0692US6847962B1Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tablesIBM·Filed 2000·Granted Jan 25, 2005·85 cites·198 claims
- 0791US7007006B2Method for recommending indexes and materialized views for a database workloadIBM·Filed 2002·Granted Feb 28, 2006·90 cites·14 claims
- 0891US6339769B1Query optimization by transparently altering properties of relational tables using materialized viewsIBM·Filed 1998·Granted Jan 15, 2002·190 cites·72 claims
- 0990US7587383B2Redundant join elimination and sub-query elimination using subsumptionIBM·Filed 2003·Granted Sep 8, 2009·66 cites·27 claims
- 1088US5548755ASystem for optimizing correlated SQL queries in a relational database using magic decorrelationIBM·Filed 1995·Granted Aug 20, 1996·153 cites·39 claims
- 1187US11366808B2Query processing method, data source registration method, and query engineHUAWEI TECH CO LTD·Filed 2019·Granted Jun 21, 2022·4 cites·20 claims
- 1287US6625593B1Parallel query optimization strategies for replicated and partitioned tablesIBM·Filed 1999·Granted Sep 23, 2003·133 cites·108 claims
- 1387US6460027B1Automatic recognition and rerouting of queries for optimal performanceIBM·Filed 1998·Granted Oct 1, 2002·101 cites·66 claims
- 1485US9727608B2Generating statistical views in a database systemCHENG QI·Filed 2012·Granted Aug 8, 2017·11 cites·20 claims
- 1583US6339768B1Exploitation of subsumption in optimizing scalar subqueriesIBM·Filed 1998·Granted Jan 15, 2002·73 cites·54 claims
- 1683US5590324AOptimization of SQL queries using universal quantifiers, set intersection, and max/min aggregation in the presence of nullable columnsIBM·Filed 1995·Granted Dec 31, 1996·113 cites·38 claims
- 1782US6339770B1Query simplification and optimization involving eliminating grouping column from group by operation corresponds to group by item that is constantIBM·Filed 1999·Granted Jan 15, 2002·64 cites·18 claims
- 1882US5864840AEvaluation of existential and universal subquery in a relational database management system for increased efficiencyIBM·Filed 1997·Granted Jan 26, 1999·94 cites·90 claims
- 1982US5548758AOptimization of SQL queries using early-out join transformations of column-bound relational tablesIBM·Filed 1995·Granted Aug 20, 1996·91 cites·21 claims
- 2081US5963933AEfficient implementation of full outer join and anti-joinIBM·Filed 1997·Granted Oct 5, 1999·95 cites·52 claims
- 2178US6560594B2Cube indices for relational database management systemsIBM·Filed 1999·Granted May 6, 2003·56 cites·57 claims
- 2277US6032143AEvaluation of existential and universal subquery in a relational database management system for increased efficiencyIBM·Filed 1998·Granted Feb 29, 2000·73 cites·37 claims
- 2376US6636846B1Method for providing a system maintained materialized functionally dependent column for a database management systemIBM·Filed 2000·Granted Oct 21, 2003·34 cites·12 claims
- 2475US7945578B2Optimizing scalar search in a text indexing and search serverIBM·Filed 2008·Granted May 17, 2011·8 cites·20 claims
- 2575US6581205B1Intelligent compilation of materialized view maintenance for query processing systemsIBM·Filed 1999·Granted Jun 17, 2003·68 cites·36 claims
- 2675US6496828B1Support for summary tables in a heterogeneous database environmentIBM·Filed 1999·Granted Dec 17, 2002·67 cites·40 claims
- 2775US5548754AOptimization of SQL queries using early-out join transformationsIBM·Filed 1995·Granted Aug 20, 1996·61 cites·9 claims
- 2874US6826562B1Method of simplifying and optimizing scalar subqueries and derived tables that return exactly or at most one tupleIBM·Filed 1999·Granted Nov 30, 2004·54 cites·27 claims
- 2970US5615361AExploitation of uniqueness properties using a 1-tuple condition for the optimization of SQL queriesIBM·Filed 1995·Granted Mar 25, 1997·68 cites·15 claims
- 3069US11907213B2Query processing method, data source registration method, and query engineHUAWEI TECH CO LTD·Filed 2022·Granted Feb 20, 2024·0 cites·15 claims
- 3169US10157204B2Generating statistical views in a database systemIBM·Filed 2013·Granted Dec 18, 2018·2 cites·20 claims
- 3266US6965894B2Efficient implementation of an index structure for multi-column bi-directional searchesIBM·Filed 2002·Granted Nov 15, 2005·26 cites·48 claims
- 3365US6856996B2Method, system, and program for accessing rows in one or more tables satisfying a search criteriaIBM·Filed 2001·Granted Feb 15, 2005·11 cites·45 claims
- 3460US12026134B2Flow-based data quality monitoringMICROSOFT TECHNOLOGY LICENSING LLC·Filed 2022·Granted Jul 2, 2024·0 cites·20 claims
- 3560US9996582B2Query tuning in the cloudIBM·Filed 2015·Granted Jun 12, 2018·1 cites·10 claims
- 3655US11860853B2Automated data health reasoningMICROSOFT TECHNOLOGY LICENSING LLC·Filed 2021·Granted Jan 2, 2024·0 cites·20 claims
- 3750US11966381B2Event driven data health monitoringMICROSOFT TECHNOLOGY LICENSING LLC·Filed 2021·Granted Apr 23, 2024·0 cites·20 claims
- 3849US10019480B2Query tuning in the cloudIBM·Filed 2014·Granted Jul 10, 2018·0 cites·16 claims
- 3946US6438542B1Method of optimally determining lossless joinsIBM·Filed 1999·Granted Aug 20, 2002·16 cites·105 claims
- 4045US10528563B2Predictive table pre-joins in large scale data management system using graph community detectionFUTUREWEI TECHNOLOGIES INC·Filed 2017·Granted Jan 7, 2020·0 cites·16 claims
- 4144US6532470B1Support for summary tables in a database system that does not otherwise support summary tablesIBM·Filed 1999·Granted Mar 11, 2003·13 cites·42 claims
- 4244US6513034B1Deriving uniqueness for indices on summary tablesIBM·Filed 1999·Granted Jan 28, 2003·15 cites·39 claims
- 4344US2021019318A1Materialized views for database query optimizationLEUNG TING YU·Filed 2020·Application pending·0 cites
- 4443US2020356599A1Systems and methods for graph-based query analysisHUAWEI TECH CO LTD·Filed 2020·Application pending·0 cites
- 4541US2018173755A1Predicting reference frequency/urgency for table pre-loads in large scale data management system using graph community detectionFUTUREWEI TECHNOLOGIES INC·Filed 2017·Application pending·0 cites
- 4637US6601063B2Method of optimally determining lossless joinsIBM·Filed 2002·Granted Jul 29, 2003·2 cites·114 claims
- 4736US2018293272A1Statistics-Based Multidimensional Data CloningFUTUREWEI TECHNOLOGIES INC·Filed 2017·Application pending·0 cites
Identity basis: PatentsView inventor disambiguation (2025Q4-odp release). How scoring works →