Asynchronous Shared Application Upgrade

Patent metadata

Field	Value
Publication number	US-2018075086-A1
Application number	US-201615266917-A
Country	US
Kind code	A1
Filing date	Sep 15, 2016
Priority date	Oct 23, 2015
Publication date	Mar 15, 2018
Grant date	—

Abstract

Techniques are provided for diverting, to cloned metadata, live access to original metadata of an application container that is being concurrently upgraded. In an embodiment, a database server stores, within an application container of an application, original metadata that defines objects for use by pluggable databases of the application. The database server receives a maintenance request to adjust the original metadata. The database server creates, in response to receiving the maintenance request, a reference container that contains cloned metadata that is a copy of the original metadata. The database server receives, during or after creating the reference container, a read request to read one of the objects. The database server concurrently performs both of: executing the maintenance request upon the original metadata, and executing the read request upon the cloned metadata of the reference container.

First claim

What is claimed is:

1 . A method comprising:
storing, within an application container of a database application, original metadata that defines one or more objects for use by one or more pluggable databases of the database application; receiving a maintenance request to adjust the original metadata; creating, in response to receiving the maintenance request, a reference container that contains cloned metadata that is a copy of the original metadata; receiving, during or after creating the reference container, a read request to read an object of the one or more objects; concurrently performing both of:
executing the maintenance request upon the original metadata, and
executing the read request upon the cloned metadata of the reference container.

2 . The method of claim 1 wherein creating the reference container comprises associating the application container or the original metadata to an identifier of the reference container or an identifier of the cloned metadata.

3 . The method of claim 1 wherein executing the maintenance request comprises:
issuing one or more database statements to the application container, and
creating a recording of the one or more database statements;
issuing the one or more database statements to the application pluggable database by replaying the recording.

4 . The method of claim 1 wherein creating the reference container comprises making the reference container consistent by applying an undo record to roll back a transaction.

5 . The method of claim 4 wherein:
creating the reference container comprises assigning a new identifier to an object within the reference container;
the undo record contains an old identifier of the object;
applying the undo record comprises translating the old identifier into the new identifier.

6 . The method of claim 1 further comprising:
receiving, after executing the maintenance request, an additional request to read the original metadata;
executing the additional request upon the original metadata of the application container.

7 . The method of claim 6 wherein after executing the maintenance request comprises after receiving a command to cease using the reference container.

8 . The method of claim 1 wherein the reference container is read only or does not accept client connections.

9 . The method of claim 1 wherein a container database contains the application container.

10 . The method of claim 1 wherein executing the maintenance request comprises at least one of:
executing data definition language (DDL), or
creating or modifying a database view.

11 . The method of claim 1 wherein the cloned metadata comprises one or more metadata rows contained in one or more relational tables.

12 . A system comprising:
database storage configured to store and retrieve, within an application container of an application, original metadata that defines one or more objects for use by one or more pluggable databases of the application; a processor connected to the database storage and configured to:
receive a maintenance request to adjust the original metadata;
create, in response to receiving the maintenance request and within the database storage, a reference container that contains cloned metadata that is a copy of the original metadata;
receive, during or after creating the reference container, a read request to read an object of the one or more objects;
concurrently perform both of:
executing the maintenance request upon the original metadata, and
executing the read request upon the cloned metadata of the reference container.

13 . One or more non-transitory computer-readable media storing instructions comprising:
first instructions that, when executed by one or more processors, cause storing, within an application container of an application, original metadata that defines one or more objects for use by one or more pluggable databases of the application; second instructions that, when executed by one or more processors, cause receiving a maintenance request to adjust the original metadata; third instructions that, when executed by one or more processors, cause creating, in response to receiving the maintenance request, a reference container that contains cloned metadata that is a copy of the original metadata; fourth instructions that, when executed by one or more processors, cause receiving, during or after creating the reference container, a read request to read an object of the one or more objects; fifth instructions that, when executed by one or more processors, cause concurrently performing both of:
executing the maintenance request upon the original metadata, and
executing the read request upon the cloned metadata of the reference container.

14 . The one or more non-transitory computer-readable media of claim 13 wherein creating the reference container comprises associating the application container or the original metadata to an identifier of the reference container or an identifier of the cloned metadata.

14 . The one or more non-transitory computer-readable media of claim 13 wherein executing the maintenance request comprises:
issuing one or more database statements to the application container, and
creating a recording of the one or more database statements;
issuing the one or more database statements to the application pluggable database by replaying the recording.

15 . The one or more non-transitory computer-readable media of claim 13 wherein creating the reference container comprises making the reference container consistent by applying an undo record to roll back a transaction.

16 . The one or more non-transitory computer-readable media of claim 15 wherein:
creating the reference container comprises assigning a new identifier to an object within the reference container;
the undo record contains an old identifier of the object;
applying the undo record comprises translating the old identifier into the new identifier.

17 . The one or more non-transitory computer-readable media of claim 13 wherein the instructions further comprise:
sixth instructions that, when executed by one or more processors, cause receiving, after executing the maintenance request, an additional request to read the original metadata;
seventh instructions that, when executed by one or more processors, cause executing the additional request upon the original metadata of the application container.

18 . The one or more non-transitory computer-readable media of claim 17 wherein after executing the maintenance request comprises after receiving a command to cease using the reference container.

19 . The one or more non-transitory computer-readable media of claim 13 wherein a container database contains the application container.

20 . The one or more non-transitory computer-readable media of claim 13 wherein executing the maintenance request comprises at least one of:
executing data definition language (DDL), or
creating or modifying a database view.

Assignees

• Oracle Int Corp

Inventors

• Yam Philip
• Baby Thomas
• Kruglikov Andre
• Rajamani Kumar

Classifications

• G06F16/2379 Primary

  Updates performed during online database operations; commit processing · CPC title

• G06F11/1474

  in transactions (updating of structured data in databases G06F16/23) · CPC title

• G06F2201/87

  Monitoring of transactions · CPC title

• G06F8/65

  Updates (security arrangements therefor G06F21/57) · CPC title

• G06F17/30377 Primary

  Physics · mapped topic