Back to results
US 2018/0004793 A1Published application
On-demand database catalog upgrade
AssigneeInternational Business Machines Corporation
InventorsSamar T. Desai, Dattatreya Govindappanavar, Prashant N. Kapse
Life of this patent
Estimating the term…
Abstract
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.
Claims1
A method comprising:
- performing a selective upgrade of a database instance from a first version of a database to a second version of the database, wherein the selective upgrade causes the database instance to refer to the second version of the database, and the selective upgrade does not modify, in the database instance, a reference to a first system catalog table and a second catalog table of the first version;
- receiving a first request from an application to access the first system catalog table and a second request from another application to access the second system catalog table;
- identifying a first set of rows in the first system catalog table by searching every row of the first system catalog table, the first set of rows matching requirements of the first request;
- identifying a second set of rows in the second system catalog table by searching every row of the second system catalog table, the second set of rows matching requirements of the second request;
- and
- modifying, while the database instance referring to the second version of the database is running, the first set of rows and the second set of rows to match corresponding sets of rows of the second version of the database by performing, for the first and second sets of rows, implicit catalog row conversion including:
- making the first and second sets of rows compatible with the second version of the database;
- and
- updating the first and second sets of rows to refer to the second version of the database instead of the first version;
- wherein:
- the database instance includes processes and memory structures of a database engine.
8 more elements
Dependencies are inferred from the claim text.