International Business Machines Corporation

Samar T Desai

Dattatreya Govindappanavar

Prashant N Kapse

Mahadev Khapali

Vaibhav S Dantale

Mohan Narayanswamy

Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects.

On-demand database catalog upgrade

One or more processors receive operational data. The operational data includes two or more fields that contain an identical type of data as two or more fields within a master table. One or more processors generate a plurality of first unique identifiers from the two or more fields within the operational data and the master table. One or more processors determine a match between a pair of the plurality of first unique identifiers. The match is between a first unique identifier included in a operational data record and a first unique identifier included in a master table record. One or more processors determine a second unique identifier from the master table record. One or more processors generate an operational table record that includes the second unique identifier and at least a portion of the operational data.

Automatic updating of operational tables

A method for updating a plurality of database statistics during a query execution is provided. The method may include receiving a compiled query. The method may also include determining if the received compiled query requires at least one table scan operation on a full table to resolve the received compiled query. The method may further include determining if a plurality of table statistics associated with the full table has not been updated within a pre-defined time-period, whereby the determining is based on the determination that the received compiled query requires at least one table scan operation on the full table to resolve the received compiled query. The method may additionally include collecting a plurality of statistics associated with the full table based on the determination that the plurality of table statistics associated with the full table has not been updated within the pre-defined time-period.

Updating database statistics during query execution

A method for determining and providing aggregate functions is provided. The method may include scanning database tables. The method may further include determining the aggregate functions. Additionally, the method may include storing the determined aggregate functions on system catalog tables. The method may also include providing indications that the stored determined aggregate functions are valid. The method may further include receiving database queries. The method may also include, determining whether the stored determined aggregate functions are valid. The method may further include, in response to the stored determined aggregate functions being valid, retrieving the stored determined aggregate functions from the system catalog tables. The method may also include, in response to the stored determined aggregate functions being invalid, re-scanning the database tables. The method may further include determining the aggregate functions based on the re-scanned database tables. The method may further include presenting the aggregate functions to clients.

Growing community of inventors

Pune, India

Samar T Desai