Terence P. Purcell

Person

Springfield, IL, US

People

Patents Grantslast 30 patents

Information Patent Grant
Query optimization using reinforcement learning
- Patent number 12,189,627
- Issue date Jan 7, 2025
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Optimizing query processing and routing in a hybrid workload optimi...
- Patent number 11,907,220
- Issue date Feb 20, 2024
- International Business Machines Corporation
- Al Chakra
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Subquery predicate generation to reduce processing in a multi-table...
- Patent number 11,556,534
- Issue date Jan 17, 2023
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Permutation-based machine learning for database query optimization
- Patent number 11,386,086
- Issue date Jul 12, 2022
- International Business Machines Corporation
- Terence P. Purcell
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Helper scan in a database management system
- Patent number 11,222,015
- Issue date Jan 11, 2022
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Offloading statistics collection
- Patent number 11,182,386
- Issue date Nov 23, 2021
- International Business Machines Corporation
- Dennis Butterstein
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Case statement optimization
- Patent number 11,144,547
- Issue date Oct 12, 2021
- International Business Machines Corporation
- Andrei F. Lurie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Minimizing processing using an index when non leading columns match...
- Patent number 11,048,703
- Issue date Jun 29, 2021
- International Business Machines Corporation
- Terence P. Purcell
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Subquery predicate generation to reduce processing in a multi-table...
- Patent number 11,036,732
- Issue date Jun 15, 2021
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Subquery predicate generation to reduce processing in a multi-table...
- Patent number 11,030,193
- Issue date Jun 8, 2021
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Minimizing processing using an index when non-leading columns match...
- Patent number 11,010,380
- Issue date May 18, 2021
- International Business Machines Corporation
- Terence P. Purcell
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Progressive optimization for implicit cast predicates
- Patent number 10,936,625
- Issue date Mar 2, 2021
- International Business Machines Corporation
- Terence P. Purcell
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Index maintenance management of a relational database management sy...
- Patent number 10,929,370
- Issue date Feb 23, 2021
- International Business Machines Corporation
- Saghi Amirsoleymani
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Optimizing query processing and routing in a hybrid workload optimi...
- Patent number 10,909,116
- Issue date Feb 2, 2021
- International Business Machines Corporation
- Al Chakra
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Adaptive multi-index access plan for database queries
- Patent number 10,754,858
- Issue date Aug 25, 2020
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Helper scan in a database management system
- Patent number 10,691,690
- Issue date Jun 23, 2020
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Reduced fixed length sort of variable length columns
- Patent number 10,671,587
- Issue date Jun 2, 2020
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Identification and elimination of non-essential statistics for quer...
- Patent number 10,545,972
- Issue date Jan 28, 2020
- International Business Machines Corporation
- Jason L. Alpers
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Identification and elimination of non-essential statistics for quer...
- Patent number 10,459,933
- Issue date Oct 29, 2019
- International Business Machines Corporation
- Jason L. Alpers
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Case statement optimization
- Patent number 10,394,812
- Issue date Aug 27, 2019
- International Business Machines Corporation
- Andrei F. Lurie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Adaptive multi-index access plan for database queries
- Patent number 10,210,210
- Issue date Feb 19, 2019
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Data-partitioned secondary index (DPSI) partition level join
- Patent number 9,940,359
- Issue date Apr 10, 2018
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Dynamically adjust duplicate skipping method for increased performance
- Patent number 9,928,274
- Issue date Mar 27, 2018
- International Business Machines Corporation
- Terence P. Purcell
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Dynamically adjust duplicate skipping method for increased performance
- Patent number 9,892,158
- Issue date Feb 13, 2018
- International Business Machines Corporation
- Terence P. Purcell
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Index-only multi-index access
- Patent number 9,846,712
- Issue date Dec 19, 2017
- International Business Machines Corporation
- Andrei F. Lurie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Index-only multi-index access
- Patent number 9,846,713
- Issue date Dec 19, 2017
- International Business Machines Corporation
- Andrei F. Lurie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Processing queries using hybrid access paths
- Patent number 9,652,498
- Issue date May 16, 2017
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Processing queries using hybrid access paths
- Patent number 9,652,497
- Issue date May 16, 2017
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Feedback mechanism providing row-level filtering earlier in a plan
- Patent number 9,582,540
- Issue date Feb 28, 2017
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Feedback mechanism providing row-level filtering earlier in a plan
- Patent number 9,569,495
- Issue date Feb 14, 2017
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING

Patents Applicationslast 30 patents

Information Patent Application
QUERY OPTIMIZATION USING REINFORCEMENT LEARNING
- Publication number 20230401207
- Publication date Dec 14, 2023
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Offloading statistics collection
- Publication number 20210303575
- Publication date Sep 30, 2021
- International Business Machines Corporation
- Dennis Butterstein
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SUBQUERY PREDICATE GENERATION TO REDUCE PROCESSING IN A MULTI-TABLE...
- Publication number 20210256023
- Publication date Aug 19, 2021
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
OPTIMIZING QUERY PROCESSING AND ROUTING IN A HYBRID WORKLOAD OPTIMI...
- Publication number 20210191943
- Publication date Jun 24, 2021
- International Business Machines Corporation
- Al Chakra
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PERMUTATION-BASED MACHINE LEARNING FOR DATABASE QUERY OPTIMIZATION
- Publication number 20200073986
- Publication date Mar 5, 2020
- International Business Machines Corporation
- Terence P. Purcell
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
MINIMIZING PROCESSING USING AN INDEX WHEN NON-LEADING COLUMNS MATCH...
- Publication number 20190324965
- Publication date Oct 24, 2019
- International Business Machines Corporation
- Terence P. Purcell
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
CASE STATEMENT OPTIMIZATION
- Publication number 20190278772
- Publication date Sep 12, 2019
- International Business Machines Corporation
- Andrei F. Lurie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
OPTIMIZING QUERY PROCESSING AND ROUTING IN A HYBRID WORKLOAD OPTIMI...
- Publication number 20190258732
- Publication date Aug 22, 2019
- International Business Machines Corporation
- Al Chakra
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
HELPER SCAN IN A DATABASE MANAGEMENT SYSTEM
- Publication number 20190258633
- Publication date Aug 22, 2019
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
MINIMIZING PROCESSING USING AN INDEX WHEN NON-LEADING COLUMNS MATCH...
- Publication number 20190251195
- Publication date Aug 15, 2019
- International Business Machines Corporation
- Terence P. Purcell
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PROGRESSIVE OPTIMIZATION FOR IMPLICIT CAST PREDICATES
- Publication number 20190197175
- Publication date Jun 27, 2019
- International Business Machines Corporation
- Terence P. Purcell
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
HELPER SCAN IN A DATABASE MANAGEMENT SYSTEM
- Publication number 20190129999
- Publication date May 2, 2019
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SUBQUERY PREDICATE GENERATION TO REDUCE PROCESSING IN A MULTI-TABLE...
- Publication number 20190087460
- Publication date Mar 21, 2019
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
REDUCED FIXED LENGTH SORT OF VARIABLE LENGTH COLUMNS
- Publication number 20180285428
- Publication date Oct 4, 2018
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SUBQUERY PREDICATE GENERATION TO REDUCE PROCESSING IN A MULTI-TABLE...
- Publication number 20180285415
- Publication date Oct 4, 2018
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
CASE STATEMENT OPTIMIZATION
- Publication number 20180157707
- Publication date Jun 7, 2018
- International Business Machines Corporation
- Andrei F. Lurie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
INDEX MAINTENANCE MANAGEMENT OF A RELATIONAL DATABASE MANAGEMENT SY...
- Publication number 20170300517
- Publication date Oct 19, 2017
- International Business Machines Corporation
- Saghi Amirsoleymani
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
SKEW SENSITIVE ESTIMATING OF RECORD CARDINALITY OF A JOIN PREDICATE...
- Publication number 20170249360
- Publication date Aug 31, 2017
- International Business Machines Corporation
- Jason L. Alpers
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
ADAPTIVE MULTI-INDEX ACCESS PLAN FOR DATABASE QUERIES
- Publication number 20170116264
- Publication date Apr 27, 2017
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
ADAPTIVE MULTI-INDEX ACCESS PLAN FOR DATABASE QUERIES
- Publication number 20170116275
- Publication date Apr 27, 2017
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
IDENTIFICATION AND ELIMINATION OF NON-ESSENTIAL STATISTICS FOR QUER...
- Publication number 20170116288
- Publication date Apr 27, 2017
- International Business Machines Corporation
- Jason L. Alpers
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
IDENTIFICATION AND ELIMINATION OF NON-ESSENTIAL STATISTICS FOR QUER...
- Publication number 20170075954
- Publication date Mar 16, 2017
- International Business Machines Corporation
- Jason L. Alpers
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
INDEX-ONLY MULTI-INDEX ACCESS
- Publication number 20160314154
- Publication date Oct 27, 2016
- International Business Machines Corporation
- Andrei F. LURIE
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
INDEX-ONLY MULTI-INDEX ACCESS
- Publication number 20160314171
- Publication date Oct 27, 2016
- International Business Machines Corporation
- Andrei F. LURIE
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
FEEDBACK MECHANISM PROVIDING ROW-LEVEL FILTERING EARLIER IN A PLAN
- Publication number 20160055208
- Publication date Feb 25, 2016
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
FEEDBACK MECHANISM PROVIDING ROW-LEVEL FILTERING EARLIER IN A PLAN
- Publication number 20160055210
- Publication date Feb 25, 2016
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DATA-PARTITIONED SECONDARY INDEX (DPSI) PARTITION LEVEL JOIN
- Publication number 20150339350
- Publication date Nov 26, 2015
- International Business Machines Corporation
- Brian L. Baggett
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PROCESSING QUERIES USING HYBRID ACCESS PATHS
- Publication number 20150310066
- Publication date Oct 29, 2015
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PROCESSING QUERIES USING HYBRID ACCESS PATHS
- Publication number 20150310063
- Publication date Oct 29, 2015
- International Business Machines Corporation
- Thomas A. Beavin
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DYNAMICALLY ADJUST DUPLICATE SKIPPING METHOD FOR INCREASED PERFORMANCE
- Publication number 20150220596
- Publication date Aug 6, 2015
- International Business Machines Corporation
- Terence P. PURCELL
- G06 - COMPUTING CALCULATING COUNTING

Terence P. Purcell

Person

Patents Grantslast 30 patents

Query optimization using reinforcement learning

Optimizing query processing and routing in a hybrid workload optimi...

Subquery predicate generation to reduce processing in a multi-table...

Permutation-based machine learning for database query optimization

Helper scan in a database management system

Offloading statistics collection

Case statement optimization

Minimizing processing using an index when non leading columns match...

Subquery predicate generation to reduce processing in a multi-table...

Subquery predicate generation to reduce processing in a multi-table...

Minimizing processing using an index when non-leading columns match...

Progressive optimization for implicit cast predicates

Index maintenance management of a relational database management sy...

Optimizing query processing and routing in a hybrid workload optimi...

Adaptive multi-index access plan for database queries

Helper scan in a database management system

Reduced fixed length sort of variable length columns

Identification and elimination of non-essential statistics for quer...

Identification and elimination of non-essential statistics for quer...

Case statement optimization

Adaptive multi-index access plan for database queries

Data-partitioned secondary index (DPSI) partition level join

Dynamically adjust duplicate skipping method for increased performance

Dynamically adjust duplicate skipping method for increased performance

Index-only multi-index access

Index-only multi-index access

Processing queries using hybrid access paths

Processing queries using hybrid access paths

Feedback mechanism providing row-level filtering earlier in a plan

Feedback mechanism providing row-level filtering earlier in a plan

Patents Applicationslast 30 patents

QUERY OPTIMIZATION USING REINFORCEMENT LEARNING

Offloading statistics collection

SUBQUERY PREDICATE GENERATION TO REDUCE PROCESSING IN A MULTI-TABLE...

OPTIMIZING QUERY PROCESSING AND ROUTING IN A HYBRID WORKLOAD OPTIMI...

PERMUTATION-BASED MACHINE LEARNING FOR DATABASE QUERY OPTIMIZATION

MINIMIZING PROCESSING USING AN INDEX WHEN NON-LEADING COLUMNS MATCH...

CASE STATEMENT OPTIMIZATION

OPTIMIZING QUERY PROCESSING AND ROUTING IN A HYBRID WORKLOAD OPTIMI...

HELPER SCAN IN A DATABASE MANAGEMENT SYSTEM

MINIMIZING PROCESSING USING AN INDEX WHEN NON-LEADING COLUMNS MATCH...

PROGRESSIVE OPTIMIZATION FOR IMPLICIT CAST PREDICATES

HELPER SCAN IN A DATABASE MANAGEMENT SYSTEM

SUBQUERY PREDICATE GENERATION TO REDUCE PROCESSING IN A MULTI-TABLE...

REDUCED FIXED LENGTH SORT OF VARIABLE LENGTH COLUMNS

SUBQUERY PREDICATE GENERATION TO REDUCE PROCESSING IN A MULTI-TABLE...

CASE STATEMENT OPTIMIZATION

INDEX MAINTENANCE MANAGEMENT OF A RELATIONAL DATABASE MANAGEMENT SY...

SKEW SENSITIVE ESTIMATING OF RECORD CARDINALITY OF A JOIN PREDICATE...

ADAPTIVE MULTI-INDEX ACCESS PLAN FOR DATABASE QUERIES

ADAPTIVE MULTI-INDEX ACCESS PLAN FOR DATABASE QUERIES

IDENTIFICATION AND ELIMINATION OF NON-ESSENTIAL STATISTICS FOR QUER...

IDENTIFICATION AND ELIMINATION OF NON-ESSENTIAL STATISTICS FOR QUER...

INDEX-ONLY MULTI-INDEX ACCESS

INDEX-ONLY MULTI-INDEX ACCESS

FEEDBACK MECHANISM PROVIDING ROW-LEVEL FILTERING EARLIER IN A PLAN

FEEDBACK MECHANISM PROVIDING ROW-LEVEL FILTERING EARLIER IN A PLAN

DATA-PARTITIONED SECONDARY INDEX (DPSI) PARTITION LEVEL JOIN

PROCESSING QUERIES USING HYBRID ACCESS PATHS

PROCESSING QUERIES USING HYBRID ACCESS PATHS

DYNAMICALLY ADJUST DUPLICATE SKIPPING METHOD FOR INCREASED PERFORMANCE