IP Library › Granted Patent US 10,747,743

Granted Patent B2

US 10,747,743 · App. 15/197,856 · Granted Aug 18, 2020

On-demand database catalog upgrade

Inventors: Samar T. Desai (Pune, IN); Dattatreya Govindappanavar (Hirekerur, IN); Prashant N. Kapse (Pune, IN)

Assignee: International Business Machines Corporation

G06F16/2336 G06F16/21 G06F16/219 G06F16/252

View Patent ↗

Loading inventors, assignments & file history…

Monitor This Case

Get email alerts when status or documents change.

Order Certified Copies

Most orders are placed with the USPTO same day — all within 24 business hours.

Order via The Patent Place →

Pre-filled with this patent's details

Quick Facts

Patent No.: US 10,747,743
App. No.: 15/197,856
Filed: Jun 30, 2016
Granted: Aug 18, 2020
Kind: B2
Examiner: ALAM, SHAHID AL
Art Unit: 2161
USPC: 707/638

External Links

USPTO Patent Center↗ Full Patent PDF↗

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.

Claims (64)

1. A computer-implemented 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 enables the database to remain available to applications during database catalog upgrade, wherein the second version of the database is continually running and the selective upgrade causes the database instance to refer to the second version of the database, the selective upgrade does not modify, in the database instance, a reference of at least one catalog object of the first version of the database;

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 of the database, 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 of the database to match a corresponding set of rows in a corresponding catalog object of the second version of the database; and

updating the set of rows in the at least one catalog object of the first version of the database to the second version of the database, wherein the upgrade of the database is run on a need-basis and enables applications to connect to the second version of the database while the upgrade of the first version of the database is performed.

2. The method of claim 1 , wherein the at least one catalog object is a system catalog table.

3. The method of claim 1 , wherein:

the at least one catalog object includes a first catalog object and a second catalog object, the request being to access the first catalog object; and

further comprising:

determining whether an additional request is received from the application to access the second catalog object.

4. The method of claim 1 , wherein:

the at least one catalog object includes a first catalog object and a second catalog object, the request being to access the first catalog object; and

further comprising:

determining whether an additional request is received from another application to access the second catalog object.

5. The method of claim 1 , wherein the identifying one or more rows from the catalog object includes searching every row of the catalog object.

6. The method of claim 1 , wherein the modifying the set of rows includes performing an implicit catalog row conversion including:

making the set of rows compatible to 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 of the database.

7. The method of claim 1 , wherein the modifying the set of rows is performed while the database instance referring to the second version of the database is running.

8. 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:

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 of the database, the set of rows matching requirements of the request; and

9. The computer program product of claim 8 , wherein the at least one catalog object is a system catalog table.

10. The computer program product of claim 8 , wherein:

the at least one catalog object includes a first catalog object and a second catalog object, the request being to access the first catalog object; and

further comprising:

determining whether an additional request is received from the application to access the second catalog object.

11. The computer program product of claim 8 , wherein:

the at least one catalog object includes a first catalog object and a second catalog object, the request being to access the first catalog object; and

further comprising:

determining whether an additional request is received from another application to access the second catalog object.

12. The computer program product of claim 8 , wherein the identifying one or more rows from the catalog object includes searching every row of the catalog object.

13. The computer program product of claim 8 , wherein the modifying the set of rows includes performing an implicit catalog row conversion including:

making the set of rows compatible to 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 of the database.

14. The computer program product of claim 8 , wherein the modifying the set of rows is performed while the database instance referring to the second version of the database is running.

15. 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:

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 of the database, the set of rows matching requirements of the request; and

16. The computer system of claim 15 , wherein the at least one catalog object is a system catalog table.

17. The computer system of claim 15 , wherein:

the at least one catalog object includes a first catalog object and a second catalog object, the request being to access the first catalog object; and

further comprising:

determining whether an additional request is received from the application to access the second catalog object.

18. The computer system of claim 15 , wherein:

the at least one catalog object includes a first catalog object and a second catalog object, the request being to access the first catalog object; and

further comprising:

determining whether an additional request is received from another application to access the second catalog object.

19. The computer system of claim 15 , wherein the identifying one or more rows from the catalog object includes searching every row of the catalog object.

20. The computer system of claim 15 , wherein the modifying the set of rows includes performing an implicit catalog row conversion including:

making the set of rows compatible to 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 of the database.

Assignments (1)

ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 30, 2016

From: DESAI, SAMAR T.; GOVINDAPPANAVAR, DATTATREYA; KAPSE, PRASHANT N.

To: INTERNATIONAL BUSINESS MACHINES CORPORATION

Reel/Frame 039052/0713 →

Continuity (1)

Related Publication 20180004792A1 · Jan 4, 2018