Inventor
FINLAY IAN R
CA42 patents
Patents
42 patentsUS5349348ASep 20, 1994
Multi-mode data stream generator
IBM86 citations94
US10649991B2May 12, 2020
Pruning of columns in synopsis tables
IBM15 citations85
US11042544B2Jun 22, 2021
Derived data dictionary for optimizing transformations of encoded data
IBM7 citations84
US10903851B2Jan 26, 2021
Page filtering via compression dictionary filtering
IBM1 citations73
US10372698B2Aug 6, 2019
Optimization of metadata via lossy compression
IBM1 citations73
US10366068B2Jul 30, 2019
Optimization of metadata via lossy compression
IBM1 citations73
US10318484B2Jun 11, 2019
Scan optimization using bloom filter synopsis
IBM6 citations73
US9953057B2Apr 24, 2018
Partitioned join with dense inner table representation
IBM2 citations73
US9780806B2Oct 3, 2017
Predicate application through partial compression dictionary match
IBM2 citations73
US9780805B2Oct 3, 2017
Predicate application through partial compression dictionary match
IBM2 citations73
US7085751B2Aug 1, 2006
Query execution in query processing systems
IBM9 citations73
US11036737B2Jun 15, 2021
Partitioned bloom filter merge for massively parallel processing clustered data management
IBM2 citations72
US10719512B2Jul 21, 2020
Partitioned bloom filter merge for massively parallel processing clustered data management
IBM3 citations72
US10229358B2Mar 12, 2019
Optimizer problem determination
IBM2 citations71
US10228855B2Mar 12, 2019
Tuning memory across database clusters for distributed query stability
IBM2 citations71
US10229359B2Mar 12, 2019
Optimizer problem determination
IBM4 citations71
US7392245B1Jun 24, 2008
Direct call threaded code
IBM7 citations68
US7680821B2Mar 16, 2010
Method and system for index sampled tablescan
IBM5 citations63
US11216436B2Jan 4, 2022
Optimization of metadata via lossy compression
IBM0 citations62
US10903850B2Jan 26, 2021
Page filtering via compression dictionary filtering
IBM0 citations62
US10725994B2Jul 28, 2020
Automatically revising synopsis table structure
IBM1 citations62
US10725995B2Jul 28, 2020
Automatically revising synopsis table structure
IBM1 citations62
US10691687B2Jun 23, 2020
Pruning of columns in synopsis tables
IBM1 citations62
US10942784B2Mar 9, 2021
Database resource scaling
IBM0 citations60
US10606837B2Mar 31, 2020
Partitioned join with dense inner table representation
IBM0 citations52
US10439638B2Oct 8, 2019
Page filtering via compression dictionary filtering
IBM0 citations52
US10432217B2Oct 1, 2019
Page filtering via compression dictionary filtering
IBM0 citations52
US9946748B2Apr 17, 2018
Efficient join-filters for parallel processing
IBM1 citations52
US9940356B2Apr 10, 2018
Efficient join-filters for parallel processing
IBM0 citations52
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
US9953025B2Apr 24, 2018
Query processing using a dimension table implemented as decompression dictionaries
IBM0 citations51
US9946705B2Apr 17, 2018
Query processing using a dimension table implemented as decompression dictionaries
IBM0 citations51
US7752160B2Jul 6, 2010
Method for unordered relational database retrieval returning distinct values
IBM1 citations51
US10620837B2Apr 14, 2020
Tuning memory across database clusters for distributed query stability
IBM0 citations50
US10585707B2Mar 10, 2020
Database resource scaling
IBM0 citations50
US10067961B2Sep 4, 2018
Expression based synopsis of database tables
IBM0 citations50
US10067962B2Sep 4, 2018
Expression based synopsis of database tables
IBM0 citations50
US9916318B2Mar 13, 2018
Method of reusing existing statistics to load database tables
IBM1 citations50
US10331645B2Jun 25, 2019
Data-partitioning for processing loosely ordered relations
IBM0 citations49
US10324918B2Jun 18, 2019
Data-partitioning for processing loosely ordered relations
IBM0 citations49
US7974968B2Jul 5, 2011
Direct call threaded code
IBM1 citations47