Simultaneous operation of multiple versions of an application using bidirectional synchronization and separated read write channels

Patent metadata

Field	Value
Publication number	US-9910665-B2
Application number	US-201514622174-A
Country	US
Kind code	B2
Filing date	Feb 13, 2015
Priority date	Feb 13, 2015
Publication date	Mar 6, 2018
Grant date	Mar 6, 2018

Abstract

An upgrade of a first version of a database application to a second version of a database application that both have a same data schema is initiated. The first database application has a first access schema such that at least one table in the data schema is linked to the first access schema. The second version of the database application has a second access schema such that at least one table in the data schema is linked to the second access schema. The first access schema differs from the second access schema. Subsequently, concurrent access is provided for each access schema to at least one database table in the data schema to both the first version of the database application and the second version of the database application. The concurrent access is enabled by using separate read and write channels. Related apparatus, systems, techniques and articles are also described.

First claim

What is claimed is:

1. A method for implementation by one or more data processors forming part of at least one computing device, the method comprising:
initiating an upgrade of a first version of a database application to a second version of a database application that both have a same data schema, the first database application having a first access schema such that at least one table in the data schema is linked to the first access schema, the second version of the database application having a second access schema such that at least one database table in the data schema is linked to the second access schema, the first access schema differing from the second access schema;
providing, for each access schema using separate read and write channels, concurrent access to at least one database table in the data schema to both the first version of the database application and the second version of the database application; and
updating the at least one database table in the data schema, the updating comprising:
cloning data of the first version and data of the second version;
transmitting cloned data of the first version from the first access schema to the data schema;
transmitting cloned data of the second version from the second access schema to the data schema;
replicating and bi-directionally transforming the cloned data of the first version and second version between the first version of the database application and the second version of the database application at the at least one database table in the data schema; and
wherein replicating and bi-directionally transforming comprises updating the at least one database table in the data schema to reflect changes made via at least one stored procedure in the first access schema and changes made via at least one stored procedure in the second access schema.

2. The method of claim 1 , wherein the database application is executed using an in-memory database system.

3. The method of claim 1 , wherein the read and write channels includes using view and stored procedures.

4. The method of claim 1 , wherein transmitting cloned data of the first version comprises transmitting without affecting a view of the first version in the first access schema.

5. The method of claim 1 , wherein transmitting cloned data of the second version comprises transmitting without affecting a view of the second version in the second access schema.

6. The method of claim 1 , wherein the database comprises an in-memory column-oriented database.

7. A non-transitory computer program product storing instructions which, when executed by at least one hardware data processors, result in operations comprising:
initiating an upgrade of a first version of a database application to a second version of a database application that both have a same data schema, the first database application having a first access schema such that at least one table in the data schema is linked to the first access schema, the second version of the database application having a second access schema such that at least one database table in the data schema is linked to the second access schema, the first access schema differing from the second access schema; and
providing, for each access schema using separate read and write channels, concurrent access to at least one database table in the data schema to both the first version of the database application and the second version of the database application; and
updating the at least one database table in the data schema, the updating comprising: cloning data of the first version and data of the second version;
transmitting cloned data of the first version from the first access schema to the data schema;
transmitting cloned data of the second version from the second access schema to the data schema;
replicating and bi-directionally transforming the cloned data of the first version and second version between the first version of the database application and the second version of the database application at the at least one database table in the data schema; and
wherein replicating and bi-directionally transforming comprises updating the at least one database table in the data schema to reflect changes made via at least one stored procedure in the first access schema and changes made via at least one stored procedure in the second access schema.

8. The non-transitory computer program product of claim 7 , wherein the database application is executed using an in-memory database system.

9. The non-transitory computer program product of claim 7 , wherein the read and write channels includes using view and stored procedures.

10. The non-transitory computer program product of claim 7 , wherein transmitting cloned data of the first version comprises transmitting without affecting a view of the first version in the first access schema.

11. The non-transitory computer program product of claim 7 , wherein transmitting cloned data of the second version comprises transmitting without affecting a view of the second version in the second access schema.

12. The non-transitory computer program product of claim 7 , wherein the database comprises an in-memory column-oriented database.

13. A system comprising:
at least one hardware data processor; and
memory storing instructions which, when executed by the at least one data processor, result in operations comprising:
initiating an upgrade of a first version of a database application to a second version of a database application that both have a same data schema, the first database application having a first access schema such that at least one table in the data schema is linked to the first access schema, the second version of the database application having a second access schema such that at least one database table in the data schema is linked to the second access schema, the first access schema differing from the second access schema; and
providing, for each access schema using separate read and write channels, concurrent access to at least one database table in the data schema to both the first version of the database application and the second version of the database application; and
updating the at least one database table in the data schema, the updating comprising:
cloning data of the first version and data of the second version;
transmitting cloned data of the first version from the first access schema to the data schema;
transmitting cloned data of the second version from the second access schema to the data schema;
replicating and bi-directionally transforming the cloned data of the first version and second version between the first version of the database application and the second version of the database application at the at least one database table in the data schema; and
wherein replicating and bi-directionally transforming comprises updating the at least one database table in the data schema to reflect changes made via at least one stored procedure in the first access schema and changes made via at least one stored procedure in the second access schema.

14. The system of claim 13 , wherein the database application is executed using an in-memory database system.

15. The system of claim 13 , wherein the read and write channels includes using view and stored procedures.

16. The system of claim 13 , wherein transmitting cloned data of the first version comprises transmitting without affecting a view of the first version in the first access schema.

17. The system of claim 13 , wherein transmitting cloned data of the second version comprises transmitting without affecting a view of th

Assignees

• Haferkorn Andre
• Engelko Andrey
• Sap Se

Inventors

• Haferkorn Andre
• Engelko Andrey

Classifications

• G06F16/213

  with details for schema evolution support · CPC title

• G06F8/656 Primary

  while running · CPC title

• G06F8/67 Primary

  Physics · mapped topic

• G06F17/30297

  Physics · mapped topic