Patents by Inventor Michael Arthur Franciscus Stuy

Michael Arthur Franciscus Stuy 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).

  • Optimized collection of just-in-time statistics for database query optimization
    Patent number: 7917502
    Abstract: A system and method are provided for updating database statistics for use in generating query execution plans. A first query for a database is received, for example by a compiler, and the compiler accesses statistics associated with the first query for optimizing a query execution plan for the first query. The statistics may be accessed from a first cache. If the statistics retrieved from the first cache are determined to be stale, the system obtains updated statistics and may store them in a temporary cache. The stale statistics in the first cache are marked as invalid. Existing queries using the first cache may continue to use the first cache, while new queries may be provided with updated statistics.
    Type: Grant
    Filed: February 27, 2008
    Date of Patent: March 29, 2011
    Assignee: International Business Machines Corporation
    Inventors: Qi Cheng, John Frederick Hornibrook, Wing Yan Lau, Ivan Popivanov, Xiaoyan Qian, Michael Joshua Snowbell, Michael Arthur Franciscus Stuy, Calisto Paul Zuzarte
  • OPTIMIZED COLLECTION OF JUST-IN-TIME STATISTICS FOR DATABASE QUERY OPTIMIZATION
    Publication number: 20090216709
    Abstract: A system and method are provided for updating database statistics for use in generating query execution plans. A first query for a database is received, for example by a compiler, and the compiler accesses statistics associated with the first query for optimizing a query execution plan for the first query. The statistics may be accessed from a first cache. If the statistics retrieved from the first cache are determined to be stale, the system obtains updated statistics and may store them in a temporary cache. The stale statistics in the first cache are marked as invalid. Existing queries using the first cache may continue to use the first cache, while new queries may be provided with updated statistics.
    Type: Application
    Filed: February 27, 2008
    Publication date: August 27, 2009
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Qi Cheng, John Frederick Hornibrook, Wing Yan Lau, Ivan Popivanov, Xiaoyan Qian, Michael Joshua Snowbell, Michael Arthur Franciscus Stuy, Calisto Paul Zuzarte