1
Karen L Anderson, Ian R Finlay, Joan L Mitchell, Davey S Thornton: Multi-mode data stream generator. International Business Machines Corporation, Mark S Walker, September 20, 1994: US05349348 (65 worldwide citation)

Improved apparatus and method for encoding and decoding information is disclosed herein. The invention uses the same marker segment information to engage an encoder or a decoder. The technique eliminates many of the complexities associated with building parameter lists, and generating various types ...


2
Ian R Finlay, Bruce G Lindsay, Guy M Lohman, David C Sharpe, Daniel C Zilio: Query execution in query processing systems. International Business Machines Corporation, Sawyer Law Group, August 1, 2006: US07085751 (3 worldwide citation)

A query processing system having a data manager, and a query manager also includes a buffer. The query manager calls the data manager to access data based on a query. Where there is no predicate check or consumption operation on the record accessed, the data manager will notionally return the record ...


3
Ian R Finlay, Calisto P Zuzarte: Method and system for index sampled tablescan. International Business Machines Corporation, Sawyer Law Group P C, March 16, 2010: US07680821 (1 worldwide citation)

An optimized query processing system and method for a database system. The database system includes a table of data and an index correlated to both the query and to the table. The optimized query processing system includes an index accessing module adapted to access the index to determine if the tab ...


4
Ronald J Barber, Naresh K Chainani, Kiran K Chinta, Ian R Finlay, Vijayshankar Raman, Liping Zhang: Efficient join-filters for parallel processing. INTERNATIONAL BUSINESS MACHINES CORPORATION, Erik K Johnson, SVL IPLaw Edell Shapiro & Finnan, April 10, 2018: US09940356

According to one embodiment of the present invention, a method of transferring filters for operations in a distributed system comprises generating at each source node a first filter of a first size. The first filter indicates elements of objects that need not be processed for an operation. Each sour ...


5
Ronald J Barber, Naresh K Chainani, Kiran K Chinta, Ian R Finlay, Vijayshankar Raman, Liping Zhang: Efficient join-filters for parallel processing. INTERNATIONAL BUSINESS MACHINES CORPORATION, Erik K Johnson, SVL IPLAW, April 17, 2018: US09946748

According to one embodiment of the present invention, a method of transferring filters for operations in a distributed system comprises generating at each source node a first filter of a first size. The first filter indicates elements of objects that need not be processed for an operation. Each sour ...


6
Ian R Finlay, Douglas James Doole: Direct call threaded code. International Business Machines Corporation, Kunzler Needham Massey & Thorpe, July 5, 2011: US07974968

A pre-pass and direct call mechanism which replaces the interpreter. The mechanism moves static decisions out of the repeated runtime path, into a pre-pass operation. Advantageously, the mechanism reduces runtime overhead, and improves overall performance of the DBMS during runtime, while maintainin ...


7
Ian R Finlay, Douglas James Doole: Direct call threaded code. International Business Machines Corporation, Kunzler & Mckenzie, June 24, 2008: US07392245

A pre-pass and direct call mechanism which replaces the interpreter. The mechanism moves static decisions out of the repeated runtime path into a pre-pass operation. Advantageously, the mechanism reduces runtime overhead and improves overall performance of the DBMS during runtime, while maintaining ...


8
Ian R Finlay: Predicate application through partial compression dictionary match. International Business Machines Corporation, Molborn Patents, Fredrik Mollborn, October 3, 2017: US09780805

Methods and apparatus, including computer program products, implementing and using techniques for predicate application using partial compression dictionary match. A search strategy is developed for each predicate to be applied to compressed data. The compressed data is searched using the search str ...


9
Ian R Finlay: Predicate application through partial compression dictionary match. International Business Machines Corporation, Mollborn Patents, Fredrik Mollborn, October 3, 2017: US09780806

Apparatus and systems, including computer program products, implementing and using techniques for predicate application using partial compression dictionary match. A search strategy is developed for each predicate to be applied to compressed data. The compressed data is searched using the search str ...


10
Ian R Finlay, Tony Wen Hsun Lai, Daniel C Zilio, Calisto Paul Zuzarte: Method for unordered relational database retrieval returning distinct values. International Business Machines Corporation, Sawyer Law Group P C, July 6, 2010: US07752160

The retrieval of distinct tuples in a relational database management system. In response to a request from a consumer process for distinct tuples in a relational database table matching a defined criteria, a distinct operator component sequentially requests tuples from a source component. The source ...