公开(公告)号：US12292883B1

公开(公告)日：2025-05-06

申请号：US18611833

申请日：2024-03-21

Applicant: SAP SE

Inventor： Lars-Eric Biewald ,  Andrea Klein ,  Stefan Runge

IPC: G06F16/23 ,  G06F11/14

Abstract: Implementations can include providing a snapshot table, replacing, in a first access schema, a first projection view with a union view, creating, in a second access schema, a snapshot projection view, a second projection view, and a set of database triggers, and during execution of an upgrade procedure that results in changes to records of the data table: recording the changes to the records of the data table in the snapshot table, for each record of the data table changed, providing the record in the snapshot table in an unchanged state through at least one database trigger and the snapshot projection view, and returning a set of records through the union view in response to a query, the set of records including a first sub-set of records of the data table and a second sub-set of records of the snapshot table.

公开(公告)号：US10013315B2

公开(公告)日：2018-07-03

申请号：US14810080

申请日：2015-07-27

Applicant: SAP SE

Inventor： Lars-Eric Biewald

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F11/1469 ,  G06F16/214

Abstract: Embodiments described herein relate to an improved technique for maintaining a consistent state during data migration operations in an active database system. Data can be copied from database table(s) of the active database system into a corresponding database table(s) in the shadow system. Snapshots of the active system can be taken at a specified point in time and used to establish a point of consistency. Later, the snapshot data can be compared with the data in the shadow database system. If the data matches, then the active and shadow database systems are at a consistent state and the data migration process completes. If the data does not match, embodiments are configured to restore the consistent state at the specified point in time by copying the snapshot data into the shadow database table(s).

公开(公告)号：US10402185B2

公开(公告)日：2019-09-03

申请号：US14852119

申请日：2015-09-11

Applicant: SAP SE

Inventor： Lars-Eric Biewald ,  Juergen Specht ,  Thomas Ullrich ,  Steffen Meissner

IPC: G06F8/65

Abstract: Various techniques are described for precisely locking database objects within a database during a system upgrade with the use of database freeze triggers. Some database freeze triggers can be utilized to lock transport requests while other database freeze triggers can be utilized to lock database objects such as exchange tables. For transport requests, techniques describe the use of a whitelist identify transport objects or transport object types which shall remain unblocked. As a result, a database freeze trigger can be generated for transport objects or transport object types that are not included in the whitelist. For database objects, techniques describe the identification of a tool or service which has been allowed during the upgrade. Database objects which can be modified during execution of the tool or service can be identified. Database freeze triggers can be generated for the database objects besides those identified.

公开(公告)号：US20170031780A1

公开(公告)日：2017-02-02

申请号：US14810080

申请日：2015-07-27

Applicant: SAP SE

Inventor： Lars-Eric Biewald

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1469 ,  G06F17/303

Abstract: Embodiments described herein relate to an improved technique for maintaining a consistent state during data migration operations in an active database system. Data can be copied from database table(s) of the active database system into a corresponding database table(s) in the shadow system. Snapshots of the active system can be taken at a specified point in time and used to establish a point of consistency. Later, the snapshot data can be compared with the data in the shadow database system. If the data matches, then the active and shadow database systems are at a consistent state and the data migration process completes. If the data does not match, embodiments are configured to restore the consistent state at the specified point in time by copying the snapshot data into the shadow database table(s).

Abstract translation: 本文描述的实施例涉及用于在活动数据库系统中的数据迁移操作期间维持一致状态的改进技术。 可以将数据从活动数据库系统的数据库表复制到影子系统中的相应数据库表中。 活动系统的快照可以在指定的时间点进行，并用于建立一致性点。 之后，可将快照数据与影子数据库系统中的数据进行比较。 如果数据匹配，则活动和影子数据库系统处于一致状态，数据迁移过程完成。 如果数据不匹配，则实施例被配置为通过将快照数据复制到影子数据库表中来在指定的时间点恢复一致状态。

公开(公告)号：US10803030B2

公开(公告)日：2020-10-13

申请号：US14541581

申请日：2014-11-14

Applicant: SAP SE

Inventor： Heiko Konrad ,  Joerg Schoen ,  Lars-Eric Biewald ,  Juergen Specht

IPC: G06F16/21

Abstract: A system and method for database migration is provided. In an example embodiment, the database migration technique may include execution modules having a first connection to a source database and a second connection to a target database, and orchestration modules adapted to identify first and second subsets of statements from a single storage table, wherein the first and second subsets of statements are executed by the execution modules during an uptime period of the source database.

公开(公告)号：US10055215B2

公开(公告)日：2018-08-21

申请号：US15285715

申请日：2016-10-05

Applicant: SAP SE

Inventor： Juergen Specht ,  Lars-Eric Biewald ,  Thomas Ullrich ,  Ralf-Juergen Hauck ,  Volker Driesen

IPC: G06F9/44 ,  G06F8/65 ,  G06F8/70

CPC classification number: G06F8/65 ,  G06F8/71

Abstract: Methods, systems, and computer-readable storage media for applying corrections during an upgrade procedure of a software management system include actions of receiving a set of white-listed object types, receiving a set of corrections to be imported, the set of corrections including a set of objects, to which corrections are to be applied during the upgrade procedure, determining a set of object types included in the set of corrections, the set of object types including one or more object types, and selectively permitting one or more transport requests to effect corrections of the set of corrections to be issued during the upgrade procedure based on the set of object types and the set of white-listed object types.

公开(公告)号：US20180095743A1

公开(公告)日：2018-04-05

申请号：US15285715

申请日：2016-10-05

Applicant: SAP SE

Inventor： Juergen Specht ,  Lars-Eric Biewald ,  Thomas Ullrich ,  Ralf-Juergen Hauck ,  Volker Driesen

IPC: G06F9/445 ,  G06F9/44

CPC classification number: G06F8/65 ,  G06F8/70

Abstract: Methods, systems, and computer-readable storage media for applying corrections during an upgrade procedure of a software management system include actions of receiving a set of white-listed object types, receiving a set of corrections to be imported, the set of corrections including a set of objects, to which corrections are to be applied during the upgrade procedure, determining a set of object types included in the set of corrections, the set of object types including one or more object types, and selectively permitting one or more transport requests to effect corrections of the set of corrections to be issued during the upgrade procedure based on the set of object types and the set of white-listed object types.

公开(公告)号：US20170075939A1

公开(公告)日：2017-03-16

申请号：US14852119

申请日：2015-09-11

Applicant: SAP SE

Inventor： Lars-Eric Biewald ,  Juergen Specht ,  Thomas Ullrich ,  Steffen Meissner

IPC: G06F17/30 ,  G06F9/445

CPC classification number: G06F8/65

Abstract: Various techniques are described for precisely locking database objects within a database during a system upgrade with the use of database freeze triggers. Some database freeze triggers can be utilized to lock transport requests while other database freeze triggers can be utilized to lock database objects such as exchange tables. For transport requests, techniques describe the use of a whitelist identify transport objects or transport object types which shall remain unblocked. As a result, a database freeze trigger can be generated for transport objects or transport object types that are not included in the whitelist. For database objects, techniques describe the identification of a tool or service which has been allowed during the upgrade. Database objects which can be modified during execution of the tool or service can be identified. Database freeze triggers can be generated for the database objects besides those identified.

Abstract translation: 描述了使用数据库冻结触发器在系统升级期间精确地锁定数据库内的数据库对象的各种技术。 某些数据库冻结触发器可用于锁定传输请求，而其他数据库冻结触发器可用于锁定数据库对象（如交换表）。 对于传输请求，技术描述了使用白名单来识别传输对象或传输对象类型，这些对象将保持未被阻止。 因此，可以为未列入白名单的传输对象或传输对象类型生成数据库冻结触发器。 对于数据库对象，技术描述了升级期间允许的工具或服务的标识。 可以识别在执行工具或服务期间可以修改的数据库对象。 除了识别的数据库对象之外，还可以生成数据库冻结触发器。