Inventor

Terence P. Purcell

Inventor

Springfield, IL, US

Overview

2008–2021

Patent span

Physics

Primary field (CPC G)

Patents· 48 as inventor

Public. Assignee & technology derived from the patent record. Each patent links to its LexDana page.

G06Fprimary

G06FElectric digital data processing84%

Y10STechnical subjects covered by former uspc cross-reference art collections [xracs] and digests12%

H03MCoding4%

PatentTitleYear

11,048,703Minimizing processing using an index when non leading columns match an aggregation key2021 11,036,732Subquery predicate generation to reduce processing in a multi-table join2021 11,030,193Subquery predicate generation to reduce processing in a multi-table join2021 11,010,380Minimizing processing using an index when non-leading columns match an aggregation key2021 10,936,625Progressive optimization for implicit cast predicates2021 10,929,370Index maintenance management of a relational database management system2021 10,909,116Optimizing query processing and routing in a hybrid workload optimized database system2021 10,754,858Adaptive multi-index access plan for database queries2020 10,691,690Helper scan in a database management system2020 10,671,587Reduced fixed length sort of variable length columns2020 10,545,972Identification and elimination of non-essential statistics for query optimization2020 10,459,933Identification and elimination of non-essential statistics for query optimization2019 10,394,812Case statement optimization2019 10,210,210Adaptive multi-index access plan for database queries2019 9,940,359Data-partitioned secondary index (DPSI) partition level join2018 9,928,274'Dynamically adjust duplicate skipping method for increased performance'2018 9,892,158'Dynamically adjust duplicate skipping method for increased performance'2018 9,846,712Index-only multi-index access2017 9,846,713Index-only multi-index access2017 9,652,498'Processing queries using hybrid access paths'2017 9,652,497'Processing queries using hybrid access paths'2017 9,582,540'Feedback mechanism providing row-level filtering earlier in a plan'2017 9,569,495'Feedback mechanism providing row-level filtering earlier in a plan'2017 9,524,305'Boolean term conversion for null-tolerant disjunctive predicates'2016 9,519,662'Boolean term conversion for null-tolerant disjunctive predicates'2016 9,256,643'Technique for factoring uncertainty into cost-based query optimization'2016 9,208,198'Technique for factoring uncertainty into cost-based query optimization'2015 9,134,975'Determining which computer programs are candidates to be recompiled after application of updates to a compiler'2015 8,832,046'Encoded data processing'2014 8,756,208'Encoded data processing'2014 8,620,899'Generating materialized query table candidates'2013 8,380,680'Piecemeal list prefetch'2013 8,364,677'Method and apparatus for generating partitioning keys for a range-partitioned database'2013 8,359,316'Database table look-up'2013 8,200,657'Processing cross-table non-boolean term conditions in database queries'2012 8,185,701'System and method for an adaptive list prefetch'2012 8,140,522'Method, apparatus, and computer program product for adaptive query parallelism partitioning with look-ahead probing and feedback'2012 8,060,495'Query execution plan efficiency in a database management system'2011 7,970,756'Generalized partition pruning in a database system'2011 7,953,726'Generated predicates from materialized result'2011 7,930,294'Method for partitioning a query'2011 7,921,085'Method and system for quantifying a data page repetition pattern for a database index in a database management system'2011 7,895,185'Row-identifier list processing management'2011 7,725,448'Method and system for disjunctive single index access'2010 7,565,342'Dynamic semi-join processing with runtime optimization'2009 7,536,379'Performing a multiple table join operating based on generated predicates from materialized results'2009 7,499,917'Processing cross-table non-Boolean term conditions in database queries'2009 7,461,060'Generalized partition pruning in a database system'2008

Career & activity timeline

Assembled from patent assignee/location history and declaration credentials.

2008–2021Patents assigned to IBM (48)· patent assignee history

2008–2012Based in New Berlin, IL, US· patent location history

2010–2021Based in Springfield, IL, US· patent location history

2011–2014Patents assigned to PURCELL TERENCE P (7)· patent assignee history

2011–2013Patents assigned to FUH YOU-CHIN (4)· patent assignee history

2012–2014Patents assigned to MIN HONG (6)· patent assignee history

2013–2014Patents assigned to FRANKE HUBERTUS (3)· patent assignee history

Inventor activity

Assignee and location history derived from the patent record.

Assignees

Assignee	Patents	Span
IBM	48	2008–2021
PURCELL TERENCE Pself	7	2011–2014
MIN HONG	6	2012–2014
FUH YOU-CHIN	4	2011–2013
FRANKE HUBERTUS	3	2013–2014

Locations

Location	Patents	Span
Springfield, Illinois, US	40	2010–2021
New Berlin, Illinois, US	8	2008–2012