Sap Se

Andre Haferkorn

Volker Driesen

Juergen Specht

Andrey Engelko

Steffen Meissner

Lars-Eric Biewald

Martin Hartig

Martin Mayer

Wieland Hoprich

Nicolai Jordt

Heiko Konrad

Christoph Luettge

Matthias Mittelstein

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.

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

The present disclosure describes methods, systems, and computer program products for providing multi-level user interface theming. One computer-implemented method includes instantiating a shadow system and database schema for a new version software application in a shared database, the shadow system database schema containing aliases pointing to tables instantiated in a production database schema, instantiating a bridge database schema containing aliases pointing to each database table within the production database schema, preparing a bridge sub-system connected to the bridge database schema aliases, replicating database tables within the production database schema, for use by the bridge sub-system and adjusting the original database tables for structure and content consistent with the new version software application, deploying an upgrade sub-system and tools to complete adjustment of structure and content of the original database tables, and connecting an instantiated instance of the new version software application to adjusted database tables.

Zero downtime maintenance with maximum business functionality

Techniques for migrating data in a database include identifying an update to one or more data entries of a source table; determining that a status of a trigger associated with the source table indicates to update a logging table, and in response: updating, in a first transaction, (i) the one or more data entries of the source table, and (ii) one or more data entries of the logging table based on the user input, and copying content of the source table to a target table; and determining that the status indicates to update the target table, and in response: updating, in a second transaction, (i) the one or more data entries of the source table and (ii) one or more data entries of the target table based on the user input, and updating the content of the target table based on the one or more data entries of the logging table.

Migrating data in tables in a database

Growing community of inventors

Heidelberg, Germany

Andre Haferkorn