Patents by Inventor Thomas A. Beavin

Thomas A. Beavin has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • High performance predicate push-down for non-matching predicate operands
    Publication number: 20040103082
    Abstract: A method, apparatus, and article of manufacture for improving the performance of evaluating predicates with non-matching operands by aggressively casting the input value to the data type of the target column before the data of the target column is accessed.
    Type: Application
    Filed: November 26, 2002
    Publication date: May 27, 2004
    Inventors: Brian T. Tran, Hsiuying Y. Cheng, Shuanglin Guo, Patrick M. Malone, Thomas A. Beavin, Xiazhen Wang, Xun Li
  • Optimization of SQL queries using filtering predicates
    Patent number: 6571233
    Abstract: A technique for optimizing execution of a query that accesses data stored on a data store connected to a computer. Query predicates involving different data types are identified. A second query predicate is generated which includes matching data types, and if necessary, converted operators. The second query predicate with the matching data types and/or converted operators is executed to obtain a subset of records using an index manager or data manager. The subset of records is converted to the data types of the remaining query predicates. The first query predicate is applied against the subset of records to obtain a result, and the remaining query predicates of the original query are applied to the result of the first query predicate and any other additional converted query predicates to obtain a final result.
    Type: Grant
    Filed: December 6, 2000
    Date of Patent: May 27, 2003
    Assignee: International Business Machines Corporation
    Inventors: Thomas A. Beavin, Patrick M. Malone, Jerry Mukai, Randy M. Nakagawa
  • Optimization of SQL queries using filtering predicates
    Publication number: 20020069193
    Abstract: A technique for optimizing execution of a query that accesses data stored on a data store connected to a computer. Query predicates involving different data types are identified. A second query predicate is generated which includes matching data types, and if necessary, converted operators. The second query predicate with the matching data types and/or converted operators is executed to obtain a subset of records using an index manager or data manager. The subset of records is converted to the data types of the remaining query predicates. The first query predicate is applied against the subset of records to obtain a result, and the remaining query predicates of the original query are applied to the result of the first query predicate and any other additional converted query predicates to obtain a final result.
    Type: Application
    Filed: December 6, 2000
    Publication date: June 6, 2002
    Inventors: Thomas A. Beavin, Patrick M. Malone, Jerry Mukai, Randy M. Nakagawa