Updating database schemas in a zero-downtime environment

Patent metadata

Field	Value
Publication number	US-9507810-B2
Application number	US-201314102280-A
Country	US
Kind code	B2
Filing date	Dec 10, 2013
Priority date	Dec 10, 2013
Publication date	Nov 29, 2016
Grant date	Nov 29, 2016

Abstract

A system is described for processing schema updated in a zero-downtime environment. A technique includes establishing an application session to access a database, receiving a schema update, converting the database to an updated database according to the schema update after establishing the application session, generating a temporary compensation view from the schema update, the temporary compensation view containing compensation logic to locate database objects belonging to the database, receiving a database transaction from the application session to access a database object in the database; and processing the compensation logic to locate the database object.

First claim

What is claimed is:

1. A computer-implemented method, comprising:
Establishing, by a processor, a first application session to access a database;
Receiving, by the processor, a first schema update;
Converting, by the processor, the database to a first updated database according to a first schema update after establishing the first application session, wherein converting the database to an updated database includes generating, by the processor, a first auxiliary database to store database objects that are missing in the updated database;
Generating, by the processor, a first temporary compensation view from the first schema update, the first temporary compensation view containing first compensation logic to locate database objects belonging to the database;
Establishing, by the processor, a second application session to access the database;
Receiving, by the processor, a second schema update;
Converting, by the processor, the database to a second updated database according to the second schema update after establishing the second application session;
Generating, by the processor, a second temporary compensation view from the second schema update, the second temporary compensation view containing second compensation logic to locate database objects belonging to the first auxiliary database;
Receiving, by the processor, a database transaction form the second application session to access a database object in the database; and
Processing, by the processor, the first compensation logic and the second compensation logic to locate the database object.

2. The computer-implemented method of claim 1 , further comprising:
Terminating, by the processor, the first application session; and
Deleting, by the processor, the first temporary compensation view when the first application session is terminated.

3. The computer-implemented method of claim 1 , wherein the database object is stored in the first auxiliary database and the second compensation logic locates the database object in the first auxiliary database.

4. The computer-implemented method of claim 1 , wherein the first compensation logic references a session cookie and a session identifier.

5. A non-transitory computer readable storage medium storing one or more programs, the one or more programs comprising instructions for:
Establishing a first application session to access a database;
Receiving a first schema update;
Converting the database to a first updated database according to a first schema update after establishing the first application session, wherein converting the database to an updated database includes generating, by the processor, a first auxiliary database to store database objects that are missing in the updated database;
Generating a first temporary compensation view from the first schema update, the first temporary compensation view containing first compensation logic to locate database objects belonging to the database;
Establishing a second application session to access the database;
Receiving a second schema update;
Converting the database to a second updated database according to the second schema update after establishing the second application session;
Generating a second temporary compensation view from the second schema update, the second temporary compensation view containing second compensation logic to locate database objects belonging to the first auxiliary database;
Receiving a database transaction form the second application session to access a database object in the database; and
Processing the first compensation logic and the second compensation logic to locate the database object.

6. The non-transitory computer readable storage medium of claim 5 , further comprising:
Terminating the first application session; and
Deleting the first temporary compensation view when the first application session is terminated.

7. The non-transitory computer readable storage medium of claim 5 , wherein the database object is stored in the first auxiliary database and the first compensation logic locates the database object in the first auxiliary database.

8. The non-transitory computer readable storage medium of claim 5 , wherein the first compensation logic references a session cookie and a session identifier.

9. A computer implemented system, comprising:
One or more computer processors; and
A non-transitory computer-readable storage medium comprising instructions;
that when executed, control the one or more computer processors to be configured for:
Establishing a first application session to access a database;
Receiving a first schema update;
Converting the database to a first updated database according to a first schema update after establishing the first application session, wherein converting the database to an updated database includes generating, by the processor, a first auxiliary database to store database objects that are missing in the updated database;
Generating a first temporary compensation view from the first schema update, the first temporary compensation view containing first compensation logic to locate database objects belonging to the database;
Establishing a second application session to access the database;
Receiving a second schema update;
Converting the database to a second updated database according to the second schema update after establishing the second application session;
Generating a second temporary compensation view from the second schema update, the second temporary compensation view containing second compensation logic to locate database objects belonging to the first auxiliary database;
Receiving a database transaction form the second application session to access a database object in the database; and
Processing the first compensation logic and the second compensation logic to locate the database object.

10. The computer implemented system of claim 9 , further comprising:
Terminating the first application session; and
Deleting the first temporary compensation view when the first application session is terminated.

11. The computer implemented system of claim 9 , wherein the database object is stored in the first auxiliary database and the first compensation logic locates the database object in the first auxiliary database.

12. The computer implemented system of claim 9 , wherein the first compensation logic references a session cookie and a session identifier.

Assignees

• Baeuerle Stefan
• Lehner Wolfgang
• Goel Anil Kumar
• Renkes Frank
• Das Joydeep
• Sap Se

Inventors

• Baeuerle Stefan
• Lehner Wolfgang
• Goel Anil Kumar
• Renkes Frank
• Das Joydeep

Classifications

• G06F16/213 Primary

  with details for schema evolution support · CPC title

• H04L67/141

  Setup of application sessions (admission control or resource allocation in data switching networks H04L47/70) · CPC title

• G06F17/30297 Primary

  Physics · mapped topic