Inventor
MUKAI JERRY
US16 patents
⚠️ This page may combine multiple inventors who share the name “MUKAI JERRY”. Patents are grouped by organization below to help distinguish them — per-person disambiguation is on the roadmap.
IBM
14 patentsUS6006220ADec 21, 1999
Determining the optimal access path for a query at execution time using an actual value for each variable in a query for estimating a filter factor
IBM119 citations97
US6374235B1Apr 16, 2002
Method, system, and program for a join operation on a multi-column table and satellite tables including duplicate values
IBM168 citations96
US6219660B1Apr 17, 2001
Access path selection for SQL with variables in a RDBMS
IBM103 citations96
US6571233B2May 27, 2003
Optimization of SQL queries using filtering predicates
IBM75 citations95
US5978792ANov 2, 1999
Method and apparatus for generating dynamic and hybrid sparse indices for workfiles used in SQL queries
IBM69 citations95
US5758145AMay 26, 1998
Method and apparatus for generating dynamic and hybrid sparse indices for workfiles used in SQL queries
IBM74 citations95
US6385603B1May 7, 2002
Joined table expression optimization by query transformation
IBM55 citations94
US6421663B1Jul 16, 2002
Optimization of joined table expressions by extended access path selection
IBM38 citations91
US7181446B2Feb 20, 2007
Query transformation for queries involving correlated subqueries having correlation join predicates with local filtering predicates involving predicate transitive closure and predicate pull-out
IBM16 citations82
US10262025B2Apr 16, 2019
Managing a temporal key property in a database management system
IBM2 citations73
US7376646B2May 20, 2008
Cost-based subquery correlation and decorrelation
IBM5 citations60
US7840552B2Nov 23, 2010
Cost-based subquery correlation and decorrelation
IBM0 citations50
US9910869B2Mar 6, 2018
Dropping columns from a table with minimized unavailability
IBM0 citations48
US9317543B2Apr 19, 2016
Dropping columns from a table with minimized unavailability
IBM0 citations48