Ian R. Finlay

Person

Uxbridge, CA

People

Patents Grantslast 30 patents

Information Patent Grant
Generating a global delta in distributed databases
- Patent number 11,727,022
- Issue date Aug 15, 2023
- International Business Machines Corporation
- Robert Neugebauer
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Querying distributed databases
- Patent number 11,704,327
- Issue date Jul 18, 2023
- International Business Machines Corporation
- Robert Neugebauer
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Optimization of metadata via lossy compression
- Patent number 11,216,436
- Issue date Jan 4, 2022
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Derived data dictionary for optimizing transformations of encoded data
- Patent number 11,042,544
- Issue date Jun 22, 2021
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Partitioned bloom filter merge for massively parallel processing cl...
- Patent number 11,036,737
- Issue date Jun 15, 2021
- International Business Machines Corporation
- Naresh K. Chainani
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Reducing temp size over a base table
- Patent number 11,023,464
- Issue date Jun 1, 2021
- International Business Machines Corporation
- Ian Richard Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Database resource scaling
- Patent number 10,942,784
- Issue date Mar 9, 2021
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Page filtering via compression dictionary filtering
- Patent number 10,903,850
- Issue date Jan 26, 2021
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Page filtering via compression dictionary filtering
- Patent number 10,903,851
- Issue date Jan 26, 2021
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Automatically revising synopsis table structure
- Patent number 10,725,994
- Issue date Jul 28, 2020
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Automatically revising synopsis table structure
- Patent number 10,725,995
- Issue date Jul 28, 2020
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Partitioned bloom filter merge for massively parallel processing cl...
- Patent number 10,719,512
- Issue date Jul 21, 2020
- International Business Machines Corporation
- Naresh K. Chainani
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Pruning of columns in synopsis tables
- Patent number 10,691,687
- Issue date Jun 23, 2020
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Pruning of columns in synopsis tables
- Patent number 10,649,991
- Issue date May 12, 2020
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Tuning memory across database clusters for distributed query stability
- Patent number 10,620,837
- Issue date Apr 14, 2020
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Partitioned join with dense inner table representation
- Patent number 10,606,837
- Issue date Mar 31, 2020
- International Business Machines Corporation
- Garth A. Dickie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Database resource scaling
- Patent number 10,585,707
- Issue date Mar 10, 2020
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Page filtering via compression dictionary filtering
- Patent number 10,439,638
- Issue date Oct 8, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Page filtering via compression dictionary filtering
- Patent number 10,432,217
- Issue date Oct 1, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Optimization of metadata via lossy compression
- Patent number 10,372,698
- Issue date Aug 6, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Optimization of metadata via lossy compression
- Patent number 10,366,068
- Issue date Jul 30, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Data-partitioning for processing loosely ordered relations
- Patent number 10,331,645
- Issue date Jun 25, 2019
- International Business Machines Corporation
- Garth A. Dickie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Data-partitioning for processing loosely ordered relations
- Patent number 10,324,918
- Issue date Jun 18, 2019
- International Business Machines Corporation
- Garth A. Dickie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Scan optimization using bloom filter synopsis
- Patent number 10,318,484
- Issue date Jun 11, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Optimizer problem determination
- Patent number 10,229,358
- Issue date Mar 12, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Optimizer problem determination
- Patent number 10,229,359
- Issue date Mar 12, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Tuning memory across database clusters for distributed query stability
- Patent number 10,228,855
- Issue date Mar 12, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Expression based synopsis of database tables
- Patent number 10,067,961
- Issue date Sep 4, 2018
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Expression based synopsis of database tables
- Patent number 10,067,962
- Issue date Sep 4, 2018
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Grant
Query processing using a dimension table implemented as decompressi...
- Patent number 9,953,025
- Issue date Apr 24, 2018
- International Business Machines Corporation
- Naresh K. Chainani
- G06 - COMPUTING CALCULATING COUNTING

Patents Applicationslast 30 patents

Information Patent Application
QUERYING DISTRIBUTED DATABASES
- Publication number 20220300503
- Publication date Sep 22, 2022
- International Business Machines Corporation
- Robert Neugebauer
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
GENERATING A GLOBAL DELTA IN DISTRIBUTED DATABASES
- Publication number 20220300504
- Publication date Sep 22, 2022
- International Business Machines Corporation
- Robert Neugebauer
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
REDUCING TEMP SIZE OVER A BASE TABLE
- Publication number 20210064617
- Publication date Mar 4, 2021
- International Business Machines Corporation
- Ian Richard Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DERIVED DATA DICTIONARY FOR OPTIMIZING TRANSFORMATIONS OF ENCODED DATA
- Publication number 20200183933
- Publication date Jun 11, 2020
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DATABASE RESOURCE SCALING
- Publication number 20200159585
- Publication date May 21, 2020
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PAGE FILTERING VIA COMPRESSION DICTIONARY FILTERING
- Publication number 20190386680
- Publication date Dec 19, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PAGE FILTERING VIA COMPRESSION DICTIONARY FILTERING
- Publication number 20190386681
- Publication date Dec 19, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
OPTIMIZATION OF METADATA VIA LOSSY COMPRESSION
- Publication number 20190303358
- Publication date Oct 3, 2019
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PARTITIONED BLOOM FILTER MERGE FOR MASSIVELY PARALLEL PROCESSING CL...
- Publication number 20190266159
- Publication date Aug 29, 2019
- International Business Machines Corporation
- Naresh K. Chainani
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PARTITIONED BLOOM FILTER MERGE FOR MASSIVELY PARALLEL PROCESSING CL...
- Publication number 20190121890
- Publication date Apr 25, 2019
- International Business Machines Corporation
- Naresh K. Chainani
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DATABASE RESOURCE SCALING
- Publication number 20180373567
- Publication date Dec 27, 2018
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PRUNING OF COLUMNS IN SYNOPSIS TABLES
- Publication number 20180107710
- Publication date Apr 19, 2018
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PAGE FILTERING VIA COMPRESSION DICTIONARY FILTERING
- Publication number 20170371972
- Publication date Dec 28, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PAGE FILTERING VIA COMPRESSION DICTIONARY FILTERING
- Publication number 20170371973
- Publication date Dec 28, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PRUNING OF COLUMNS IN SYNOPSIS TABLES
- Publication number 20170308572
- Publication date Oct 26, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
EXPRESSION BASED SYNOPSIS OF DATABASE TABLES
- Publication number 20170300515
- Publication date Oct 19, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
AUTOMATICALLY REVISING SYNOPSIS TABLE STRUCTURE
- Publication number 20170293649
- Publication date Oct 12, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
AUTOMATICALLY REVISING SYNOPSIS TABLE STRUCTURE
- Publication number 20170293642
- Publication date Oct 12, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TUNING MEMORY ACROSS DATABASE CLUSTERS FOR DISTRIBUTED QUERY STABILITY
- Publication number 20170285964
- Publication date Oct 5, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
TUNING MEMORY ACROSS DATABASE CLUSTERS FOR DISTRIBUTED QUERY STABILITY
- Publication number 20170285965
- Publication date Oct 5, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
METHOD OF REUSING EXISTING STATISTICS TO LOAD DATABASE TABLES
- Publication number 20170185633
- Publication date Jun 29, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
METHOD OF REUSING EXISTING STATISTICS TO LOAD DATABASE TABLES
- Publication number 20170185624
- Publication date Jun 29, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
EXPRESSION BASED SYNOPSIS OF DATABASE TABLES
- Publication number 20170091315
- Publication date Mar 30, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DATA-PARTITIONING FOR PROCESSING LOOSELY ORDERED RELATIONS
- Publication number 20170052991
- Publication date Feb 23, 2017
- International Business Machines Corporation
- Garth A. Dickie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
DATA-PARTITIONING FOR PROCESSING LOOSELY ORDERED RELATIONS
- Publication number 20170052990
- Publication date Feb 23, 2017
- International Business Machines Corporation
- Garth A. Dickie
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Optimizer Problem Determination
- Publication number 20170039474
- Publication date Feb 9, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
Optimizer Problem Determination
- Publication number 20170039240
- Publication date Feb 9, 2017
- International Business Machines Corporation
- Ian R. Finlay
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
QUERY PROCESSING USING A DIMENSION TABLE IMPLEMENTED AS DECOMPRESSI...
- Publication number 20160378833
- Publication date Dec 29, 2016
- International Business Machines Corporation
- Naresh K. Chainani
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
QUERY PROCESSING USING A DIMENSION TABLE IMPLEMENTED AS DECOMPRESSI...
- Publication number 20160378783
- Publication date Dec 29, 2016
- International Business Machines Corporation
- Naresh K. Chainani
- G06 - COMPUTING CALCULATING COUNTING
Information Patent Application
PARTITIONED JOIN WITH DENSE INNER TABLE REPRESENTATION
- Publication number 20160371337
- Publication date Dec 22, 2016
- International Business Machines Corp.
- Garth A. Dickie
- G06 - COMPUTING CALCULATING COUNTING

Ian R. Finlay

Person

Patents Grantslast 30 patents

Generating a global delta in distributed databases

Querying distributed databases

Optimization of metadata via lossy compression

Derived data dictionary for optimizing transformations of encoded data

Partitioned bloom filter merge for massively parallel processing cl...

Reducing temp size over a base table

Database resource scaling

Page filtering via compression dictionary filtering

Page filtering via compression dictionary filtering

Automatically revising synopsis table structure

Automatically revising synopsis table structure

Partitioned bloom filter merge for massively parallel processing cl...

Pruning of columns in synopsis tables

Pruning of columns in synopsis tables

Tuning memory across database clusters for distributed query stability

Partitioned join with dense inner table representation

Database resource scaling

Page filtering via compression dictionary filtering

Page filtering via compression dictionary filtering

Optimization of metadata via lossy compression

Optimization of metadata via lossy compression

Data-partitioning for processing loosely ordered relations

Data-partitioning for processing loosely ordered relations

Scan optimization using bloom filter synopsis

Optimizer problem determination

Optimizer problem determination

Tuning memory across database clusters for distributed query stability

Expression based synopsis of database tables

Expression based synopsis of database tables

Query processing using a dimension table implemented as decompressi...

Patents Applicationslast 30 patents

QUERYING DISTRIBUTED DATABASES

GENERATING A GLOBAL DELTA IN DISTRIBUTED DATABASES

REDUCING TEMP SIZE OVER A BASE TABLE

DERIVED DATA DICTIONARY FOR OPTIMIZING TRANSFORMATIONS OF ENCODED DATA

DATABASE RESOURCE SCALING

PAGE FILTERING VIA COMPRESSION DICTIONARY FILTERING

PAGE FILTERING VIA COMPRESSION DICTIONARY FILTERING

OPTIMIZATION OF METADATA VIA LOSSY COMPRESSION

PARTITIONED BLOOM FILTER MERGE FOR MASSIVELY PARALLEL PROCESSING CL...

PARTITIONED BLOOM FILTER MERGE FOR MASSIVELY PARALLEL PROCESSING CL...

DATABASE RESOURCE SCALING

PRUNING OF COLUMNS IN SYNOPSIS TABLES

PAGE FILTERING VIA COMPRESSION DICTIONARY FILTERING

PAGE FILTERING VIA COMPRESSION DICTIONARY FILTERING

PRUNING OF COLUMNS IN SYNOPSIS TABLES

EXPRESSION BASED SYNOPSIS OF DATABASE TABLES

AUTOMATICALLY REVISING SYNOPSIS TABLE STRUCTURE

AUTOMATICALLY REVISING SYNOPSIS TABLE STRUCTURE

TUNING MEMORY ACROSS DATABASE CLUSTERS FOR DISTRIBUTED QUERY STABILITY

TUNING MEMORY ACROSS DATABASE CLUSTERS FOR DISTRIBUTED QUERY STABILITY

METHOD OF REUSING EXISTING STATISTICS TO LOAD DATABASE TABLES

METHOD OF REUSING EXISTING STATISTICS TO LOAD DATABASE TABLES

EXPRESSION BASED SYNOPSIS OF DATABASE TABLES

DATA-PARTITIONING FOR PROCESSING LOOSELY ORDERED RELATIONS

DATA-PARTITIONING FOR PROCESSING LOOSELY ORDERED RELATIONS

Optimizer Problem Determination

Optimizer Problem Determination

QUERY PROCESSING USING A DIMENSION TABLE IMPLEMENTED AS DECOMPRESSI...

QUERY PROCESSING USING A DIMENSION TABLE IMPLEMENTED AS DECOMPRESSI...

PARTITIONED JOIN WITH DENSE INNER TABLE REPRESENTATION