Patents by Inventor Patrick Bossman

Patrick Bossman 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).

  • Query Workload Statistics Collection in a Database Management System
    Publication number: 20080033912
    Abstract: In various embodiments, a method, apparatus, and article of manufacture collect statistics in a database management system. A workload comprising a plurality of database queries is received. Query statistics for the database queries are identified. The query statistics for the database queries are consolidated to provide consolidated statistics. One or more statistics collection requests are generated based on the consolidated statistics.
    Type: Application
    Filed: October 16, 2007
    Publication date: February 7, 2008
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Patrick Bossman, You-Chin Fuh, Shuanglin Guo, Chan-Hua Liu, Yoichi Tsuji
  • Management of database statistics
    Publication number: 20060149695
    Abstract: Various embodiments of a method, apparatus and article of manufacture of managing statistics in a database management system are provided. A volatility of at least one of statistic is determined. One or more statistics collection tasks are generated based on, at least in part, the volatility.
    Type: Application
    Filed: December 30, 2004
    Publication date: July 6, 2006
    Inventors: Patrick Bossman, You-Chin Fuh, Shuanglin Guo, Chan-hua Liu, Yoichi Tsuji, Changjiu Xian
  • Query workload statistics collection in a database management system
    Publication number: 20050234900
    Abstract: In various embodiments, a method, apparatus, and article of manufacture collect statistics in a database management system. A workload comprising a plurality of database queries is received. Query statistics for the database queries are identified. The query statistics for the database queries are consolidated to provide consolidated statistics. One or more statistics collection requests are generated based on the consolidated statistics.
    Type: Application
    Filed: April 14, 2004
    Publication date: October 20, 2005
    Applicant: International Business Machines Corporation
    Inventors: Patrick Bossman, You-Chin Fuh, Shuanglin Guo, Chan-Hua Liu, Yoichi Tsuji
  • Query transformation for queries involving correlated subqueries having correlation join predicates with local filtering predicates involving predicate transitive closure and predicate pull-out
    Publication number: 20050165751
    Abstract: A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization is performed by identifying a correlated subquery in the query that qualifies for transformation, transitively closing a local filtering predicate within the identified correlated subquery that is on a same column as a correlation join predicate within the identified correlated subquery, and pulling out or bubbling up the transitively closed predicate from the correlated subquery to a parent query block of the query.
    Type: Application
    Filed: January 23, 2004
    Publication date: July 28, 2005
    Inventors: Patrick Bossman, Lee-Chin Hsu Liu, Jerry Mukai, Yumi Tsuji
  • Method, system, and program for statistics management
    Publication number: 20050149505
    Abstract: Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain statistics.
    Type: Application
    Filed: January 7, 2004
    Publication date: July 7, 2005
    Inventors: Patrick Bossman, You-Chin Fuh, Chan-Hua Liu