Back to results
US 2016/0098438 A1Published application
Managing Write Accesses During Database Upgrade Procedure
AssigneeSap SE
InventorsPeter Eberlein, Volker Driesen
Life of this patent
Estimating the term…
Abstract
As part of an upgrade procedure transitioning from a source system to a target system, table entries used by both the source system and the target system can be selectively locked on a row-by-row basis using a lock table and one or more select triggers. Related apparatus, systems, techniques and articles are also described.
Claims19
A method comprising:
- initiating an upgrade procedure that updates a source system to a target system, the upgrade procedure preparing software for the target system in parallel to operation of an application on the source system;
- determining, by a select trigger, that the upgrade procedure reads a first key in a production table being used both by the upgrade procedure and the application;
- writing, by the select trigger, the first key into a lock table;
- determining, by a freeze trigger after the first key is written into a lock table, that the application initiated a write request for the first key in the production table;
- accessing, by the freeze trigger, the lock table to identify the first key as being locked;
- and
- preventing the application from writing to the first key in the production table based on the identification in the lock table.
4 more elements
A method comprising:
- initiating an upgrade procedure that updates a source system to a target system, the upgrade procedure preparing software for the target system in parallel to operation of an application on the source system;
- cloning, by a clone trigger, changes to a production table used by the application to a table being used by the upgrade procedure;
- determining, by a select trigger, that the upgrade procedure read a first key in the production table;
- writing, by the select trigger, the first key into a lock table;
- determining, by a freeze trigger after the first key is written into a lock table, that the application initiated a write request for the first key in the production table;
- accessing, by the freeze trigger, the lock table to identify the first key as being locked;
- and
- preventing the application from writing to the first key based on the identification in the lock table.
5 more elements
A system comprising:
- a source system comprising at least one data processor and memory storing instructions for execution by the corresponding at least one data processor;
- and
- a target system comprising at least one data processor and memory storing instructions for execution by the corresponding at least one data processor;
- wherein:
- an upgrade procedure is initiated that updates the source system to the target system, the upgrade procedure prepares software for the target system in parallel to operation of an application on the source system;
- a select trigger determines that the upgrade procedure reads a first key in a production table being used both by the upgrade procedure and the application;
- the select trigger writes the first key into a lock table;
- a freeze trigger determines, after the first key is written into a lock table, that the application initiated a write request for the first key in the production table;
- the freeze trigger accesses the lock table to identify the first key as being locked;
- and
- the application is prevented from writing to the first key in the production table based on the identification in the lock table.
8 more elements
Dependencies are inferred from the claim text.