Back to results
US 2018/0004792 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.
Claims20
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 of at least one catalog object of the first version;
- receiving a request from an application to access the at least one catalog object;
- identifying a set of rows in the at least one catalog object of the first version, the set of rows matching requirements of the request;
- and
- modifying the set of rows in the at least one catalog object of the first version to match a corresponding set of rows in a corresponding catalog object of the second version of the database.
2 more elements
A computer program product comprising a computer readable storage medium having stored a set of instructions stored therein which, when executed by a processor, causes the processor to upgrade a database by:
- 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 of at least one catalog object of the first version;
- receiving a request from an application to access the at least one catalog object;
- identifying a set of rows in the at least one catalog object of the first version, the set of rows matching requirements of the request;
- and
- modifying the set of rows in the at least one catalog object of the first version to match a corresponding set of rows in a corresponding catalog object of the second version of the database.
2 more elements
A computer system comprising:
- a processor set;
- and
- a computer readable storage medium;
- wherein:
- the processor set is structured, located, connected, and/or programmed to run program instructions stored on the computer readable storage medium;
- and
- the program instructions which, when executed by the processor set, cause the processor set to upgrade a database by:
- 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 of at least one catalog object of the first version;
- receiving a request from an application to access the at least one catalog object;
- identifying a set of rows in the at least one catalog object of the first version, the set of rows matching requirements of the request;
- and
- modifying the set of rows in the at least one catalog object of the first version to match a corresponding set of rows in a corresponding catalog object of the second version of the database.
9 more elements
Dependencies are inferred from the claim text.