Patents by Inventor John Hornibrook

John Hornibrook 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).

  • Method for automated design of row compression on tables in a relational database
    Patent number: 8626724
    Abstract: A workload specification is obtained for the database. Based on the workload specification, candidate ones of the tables are identified and ranked. Compression impact is evaluated for the candidate ones of the tables. A design for the database is developed, specifying at least one of: (i) which of the tables should be compressed, and (ii) which of the tables should not be compressed.
    Type: Grant
    Filed: January 29, 2008
    Date of Patent: January 7, 2014
    Assignee: International Business Machines Corporation
    Inventors: John Hornibrook, Laurent S. Mignet, William R. Minor, Sumit Negi, Daniele C. Zilio
  • SYSTEM AND COMPUTER PROGRAM PRODUCT FOR AUTOMATED DESIGN OF ROW COMPRESSION ON TABLES IN A RELATIONAL DATABASE
    Publication number: 20090193042
    Abstract: A workload specification is obtained for the database. Based on the workload specification, candidate ones of the tables are identified and ranked. Compression impact is evaluated for the candidate ones of the tables. A design for the database is developed, specifying at least one of: (i) which of the tables should be compressed, and (ii) which of the tables should not be compressed.
    Type: Application
    Filed: January 29, 2008
    Publication date: July 30, 2009
    Applicant: International Business Machines Corporation
    Inventors: John Hornibrook, Laurent S. Mignet, William R. Minor, Sumit Negi, Daniele C. Zilio
  • METHOD FOR AUTOMATED DESIGN OF ROW COMPRESSION ON TABLES IN A RELATIONAL DATABASE
    Publication number: 20090193041
    Abstract: A workload specification is obtained for the database. Based on the workload specification, candidate ones of the tables are identified and ranked. Compression impact is evaluated for the candidate ones of the tables. A design for the database is developed, specifying at least one of: (i) which of the tables should be compressed, and (ii) which of the tables should not be compressed.
    Type: Application
    Filed: January 29, 2008
    Publication date: July 30, 2009
    Applicant: International Business Machines Corporation
    Inventors: John Hornibrook, Laurent S. Mignet, William R. Minor, Sumit Negi, Daniele C. Zilio
  • METHOD AND SYSTEM FOR ESTIMATING CARDINALITY IN A DATABASE SYSTEM
    Publication number: 20070233634
    Abstract: A method and system for estimating cardinalities for a plurality of columns in a database system is disclosed. The method and system include obtaining statistics collected for the plurality of columns. A first portion of the statistics indicates at least one relationship between at least a portion of the plurality of columns, while a second portion of the statistics includes single column statistics. The method and system also include utilizing the first portion and the second portion of the statistics to estimate the cardinality for the plurality of columns.
    Type: Application
    Filed: April 3, 2006
    Publication date: October 4, 2007
    Inventors: Vincent Corvinelli, Yuri Deigin, John Hornibrook, Tam Tran
  • METHODS OF COST ESTIMATION USING PARTIALLY APPLIED PREDICATES
    Publication number: 20070233637
    Abstract: In accordance with aspects of the present invention, provided are methods, systems, and computer program products for incrementally estimating the cardinality of a derived relation including statistically correlated partially applicable predicates for a range-partitioned table. During the generation of a QEP a cardinality estimate is calculated in which one or more partially applicable predicates is correlated to another partially applicable predicate and/or to one or more fully applicable predicates. The cardinality includes a number of rows expected to be returned by the QEP and is computed in an incremental fashion for each operator of the QEP.
    Type: Application
    Filed: March 30, 2006
    Publication date: October 4, 2007
    Applicant: International Business Machines Corporation
    Inventors: Vincent Corvinelli, John Hornibrook, Bingjie Miao