International Business Machines Corporation

Xiaoyan Qian

Serge Philippe Rielau

Linqi Liu

Zhimin Chen

Calisto Paul Zuzarte

John Frederick Hornibrook

Qi Cheng

Ivan Popivanov

Michael Joshua Snowbell

Wing Yan Lau

Michael Arthur Franciscus Stuy

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

For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables. The method includes the steps of making a record copy matching the record, for each base table to be selected from the plurality of base tables: providing a base table candidate indication for a selected base table, the base table candidate indication indicating whether the selected base table is a candidate base table that may receive the record, the base table candidate indication being determined on an outcome of executing before triggers and an outcome of testing constraints in association with the record copy, the before triggers and the constraints being associated with the selected base table; and restoring the record copy so that the record copy matches the record before providing a next subsequent base table candidate indication for another base table to be selected.

Method, system and computer program for inserting records into a database

System and computer program for inserting records into a database

Method for inserting records into a database

Growing community of inventors

Aurora, Canada

Xiaoyan Qian