Inventor
PURCELL TERENCE P
US44 patents
⚠️ This page may combine multiple inventors who share the name “PURCELL TERENCE P”. Patents are grouped by organization below to help distinguish them — per-person disambiguation is on the roadmap.
IBM
39 patentsUS8359316B2Jan 22, 2013
Database table look-up
IBM42 citations94
US8380680B2Feb 19, 2013
Piecemeal list prefetch
IBM7 citations83
US7921085B2Apr 5, 2011
Method and system for quantifying a data page repetition pattern for a database index in a database management system
IBM12 citations83
US7725448B2May 25, 2010
Method and system for disjunctive single index access
IBM8 citations83
US9134975B1Sep 15, 2015
Determining which computer programs are candidates to be recompiled after application of updates to a compiler
IBM14 citations81
US11386086B2Jul 12, 2022
Permutation-based machine learning for database query optimization
IBM7 citations80
US11048703B2Jun 29, 2021
Minimizing processing using an index when non leading columns match an aggregation key
IBM2 citations73
US11010380B2May 18, 2021
Minimizing processing using an index when non-leading columns match an aggregation key
IBM4 citations73
US11556534B2Jan 17, 2023
Subquery predicate generation to reduce processing in a multi-table join
IBM1 citations72
US9652497B2May 16, 2017
Processing queries using hybrid access paths
IBM3 citations72
US9652498B2May 16, 2017
Processing queries using hybrid access paths
IBM2 citations72
US10909116B2Feb 2, 2021
Optimizing query processing and routing in a hybrid workload optimized database system
IBM5 citations71
US9256643B2Feb 9, 2016
Technique for factoring uncertainty into cost-based query optimization
IBM3 citations71
US11036732B2Jun 15, 2021
Subquery predicate generation to reduce processing in a multi-table join
IBM1 citations62
US11030193B2Jun 8, 2021
Subquery predicate generation to reduce processing in a multi-table join
IBM0 citations62
US11907220B2Feb 20, 2024
Optimizing query processing and routing in a hybrid workload optimized database system
IBM0 citations60
US11222015B2Jan 11, 2022
Helper scan in a database management system
IBM0 citations60
US11144547B2Oct 12, 2021
Case statement optimization
IBM0 citations59
US10459933B2Oct 29, 2019
Identification and elimination of non-essential statistics for query optimization
IBM1 citations59
US9519662B2Dec 13, 2016
Boolean term conversion for null-tolerant disjunctive predicates
IBM2 citations59
US9582540B2Feb 28, 2017
Feedback mechanism providing row-level filtering earlier in a plan
IBM0 citations52
US9569495B2Feb 14, 2017
Feedback mechanism providing row-level filtering earlier in a plan
IBM0 citations52
US9846712B2Dec 19, 2017
Index-only multi-index access
IBM0 citations51
US9846713B2Dec 19, 2017
Index-only multi-index access
IBM0 citations51
US10936625B2Mar 2, 2021
Progressive optimization for implicit cast predicates
IBM0 citations50
US10691690B2Jun 23, 2020
Helper scan in a database management system
IBM0 citations50
US9208198B2Dec 8, 2015
Technique for factoring uncertainty into cost-based query optimization
IBM0 citations50
US11182386B2Nov 23, 2021
Offloading statistics collection
IBM0 citations49
US10754858B2Aug 25, 2020
Adaptive multi-index access plan for database queries
IBM0 citations49
US10545972B2Jan 28, 2020
Identification and elimination of non-essential statistics for query optimization
IBM0 citations49
US10210210B2Feb 19, 2019
Adaptive multi-index access plan for database queries
IBM0 citations49
US9524305B2Dec 20, 2016
Boolean term conversion for null-tolerant disjunctive predicates
IBM0 citations49
US10394812B2Aug 27, 2019
Case statement optimization
IBM0 citations48
US9928274B2Mar 27, 2018
Dynamically adjust duplicate skipping method for increased performance
IBM1 citations48
US9892158B2Feb 13, 2018
Dynamically adjust duplicate skipping method for increased performance
IBM0 citations48
US12189627B2Jan 7, 2025
Query optimization using reinforcement learning
IBM0 citations46
US10929370B2Feb 23, 2021
Index maintenance management of a relational database management system
IBM0 citations46
US10671587B2Jun 2, 2020
Reduced fixed length sort of variable length columns
IBM0 citations38
US9940359B2Apr 10, 2018
Data-partitioned secondary index (DPSI) partition level join
IBM0 citations38