On-demand database catalog upgrade
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.
1. 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 of the first version;
receiving a request from an application to access the first system catalog table, wherein the request contains a set of requirements;
responsive to receiving the request from the application:
identifying a set of rows in the first system catalog table matching the set of requirements of the request; and
modifying, while the database instance referring to the second version of the database is running, the set of rows to match a corresponding set of rows of the second version of the database by performing, for the set of rows, implicit catalog row conversion including:
making the set of rows compatible with the second version of the database; and
updating the set 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.