International Business Machines Corporation

Wing Yan Lau

Calisto Paul Zuzarte

Ihab Francis Ilyas

Volker Gerhard Markl

John Frederick Hornibrook

Qi Cheng

Ivan Popivanov

Michael Joshua Snowbell

Xiaoyan Qian

Amr El-Helw

Michael Arthur Franciscus Stuy

A method, system, and computer program product for managing database statistics are provided. The method, system, and computer program product provide for receiving a query for optimizing, collecting statistics specific to the query prior to generating any access plans for executing the query, and generating an access plan for executing the query based on the collected statistics.

Management of interesting database statistics

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.

Optimized collection of just-in-time statistics for database query optimization

Growing community of inventors

Toronto, Canada

Wing Yan Lau