公开(公告)号：US20160098443A1

公开(公告)日：2016-04-07

申请号：US14504241

申请日：2014-10-01

申请人： Juergen Specht ,  Lars-Eric Biewald ,  Heiko Konrad ,  Steffen Meissner ,  Wieland Hoprich ,  Volker Driesen

发明人： Juergen Specht ,  Lars-Eric Biewald ,  Heiko Konrad ,  Steffen Meissner ,  Wieland Hoprich ,  Volker Driesen

IPC分类号： G06F17/30

CPC分类号： G06F17/30377 ,  G06F8/65 ,  G06F8/656 ,  G06F17/30292

摘要： A zero downtime upgrade procedure upgrading a source system to a target system is initiated that prepares software for the target system in parallel to the operation of the source system. As part of the upgrade procedure, source tables of the source system are renamed. Thereafter, the renamed source tables are cloned for the target system. Further, the renamed source tables are equipped with database triggers to transfer data from the renamed source tables to the cloned tables used by the source system according to a source database schema. Next, the target tables are generated that include updated software content for later use by the target system while the source tables are used via a bridge database schema. Tables can then be shared between the source database schema accessed via the bridge database schema and the target system.

摘要翻译： 启动将源系统升级到目标系统的零停机升级过程，为目标系统准备与源系统运行并行的软件。 作为升级过程的一部分，源系统的源表被重命名。 此后，为目标系统克隆重新命名的源表。 此外，重命名的源表配有数据库触发器，以将数据从重命名的源表传输到源系统根据源数据库模式使用的克隆表。 接下来，生成包含更新的软件内容的目标表，供目标系统稍后使用，同时通过桥接数据库模式使用源表。 然后可以在通过桥接数据库模式访问的源数据库模式和目标系统之间共享表。

公开(公告)号：US20160098267A1

公开(公告)日：2016-04-07

申请号：US14504235

申请日：2014-10-01

申请人： Steffen Meissner ,  Wieland Hoprich ,  Heiko Konrad ,  Lars-Eric Biewald ,  Volker Driesen

发明人： Steffen Meissner ,  Wieland Hoprich ,  Heiko Konrad ,  Lars-Eric Biewald ,  Volker Driesen

IPC分类号： G06F9/445 ,  G06F17/30

CPC分类号： G06F8/656 ,  G06F11/14 ,  G06F11/1433 ,  G06F17/30292 ,  G06F17/30339 ,  G06F17/30345

摘要： Revocation of a zero downtime upgrade of an upgrade procedure of a source system to a target system is initiated. Thereafter, upgrade activities are stopped at the target system and production activities are stopped at the source system. At least a portion of the target tables can be subsequently dropped and any associated table structure changes can be revoked. At least a portion of the target tables are then switched from use by the target system to use by the source system. Next, the source system is connected to the source database schema to enable use of the source system in its state prior to the initiation of the upgrade procedure. Related apparatus, systems, techniques and articles are also described.

摘要翻译： 启动将源系统的升级过程的零停机升级撤销到目标系统。 此后，在目标系统停止升级活动，并在源系统停止生产活动。 可以随后丢弃至少一部分目标表，并且可以撤销任何相关的表结构更改。 目标表的至少一部分然后从目标系统的使用切换到源系统使用。 接下来，源系统连接到源数据库模式，以便在启动升级过程之前使其能够处于其状态的源系统。 还描述了相关设备，系统，技术和物品。

公开(公告)号：US09519675B2

公开(公告)日：2016-12-13

申请号：US14504241

申请日：2014-10-01

申请人： Juergen Specht ,  Lars-Eric Biewald ,  Heiko Konrad ,  Steffen Meissner ,  Wieland Hoprich ,  Volker Driesen

发明人： Juergen Specht ,  Lars-Eric Biewald ,  Heiko Konrad ,  Steffen Meissner ,  Wieland Hoprich ,  Volker Driesen

IPC分类号： G06F7/02 ,  G06F17/30 ,  G06F9/445

CPC分类号： G06F17/30377 ,  G06F8/65 ,  G06F8/656 ,  G06F17/30292

摘要： A zero downtime upgrade procedure upgrading a source system to a target system is initiated that prepares software for the target system in parallel to the operation of the source system. As part of the upgrade procedure, source tables of the source system are renamed. Thereafter, the renamed source tables are cloned for the target system. Further, the renamed source tables are equipped with database triggers to transfer data from the renamed source tables to the cloned tables used by the source system according to a source database schema. Next, the target tables are generated that include updated software content for later use by the target system while the source tables are used via a bridge database schema. Tables can then be shared between the source database schema accessed via the bridge database schema and the target system.

摘要翻译： 启动将源系统升级到目标系统的零停机升级过程，为目标系统准备与源系统运行并行的软件。 作为升级过程的一部分，源系统的源表重命名。 此后，为目标系统克隆重新命名的源表。 此外，重命名的源表配有数据库触发器，以将数据从重命名的源表传输到源系统根据源数据库模式使用的克隆表。 接下来，生成包含更新的软件内容的目标表，供目标系统稍后使用，同时通过桥接数据库模式使用源表。 然后可以在通过桥接数据库模式访问的源数据库模式和目标系统之间共享表。

公开(公告)号：US09436724B2

公开(公告)日：2016-09-06

申请号：US14059380

申请日：2013-10-21

申请人： Volker Driesen ,  Andre Haferkorn ,  Nicolai Jordt ,  Juergen Specht ,  Steffen Meissner ,  Lars-Eric Biewald

发明人： Volker Driesen ,  Andre Haferkorn ,  Nicolai Jordt ,  Juergen Specht ,  Steffen Meissner ,  Lars-Eric Biewald

IPC分类号： G06F17/30

CPC分类号： G06F17/30377

摘要： 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.

摘要翻译： 用于在数据库中迁移数据的技术包括标识对源表的一个或多个数据条目的更新; 确定与源表相关联的触发器的状态指示更新记录表，并且作为响应：在第一事务中更新（i）源表的一个或多个数据条目，以及（ii）源表中的一个或多个 基于用户输入的记录表的更多数据条目，以及将源表的内容复制到目标表; 并且确定所述状态指示更新所述目标表，并且作为响应：在第二事务中更新所述源表的所述一个或多个数据条目，以及（ii）所述目标表的一个或多个数据条目 在用户输入上，并且基于记录表的一个或多个数据条目来更新目标表的内容。

公开(公告)号：US10248408B2

公开(公告)日：2019-04-02

申请号：US14490529

申请日：2014-09-18

申请人： Steffen Meissner ,  Juergen Specht

发明人： Steffen Meissner ,  Juergen Specht

IPC分类号： G06F17/30 ,  G06F8/656

摘要： A zero downtime upgrade of a source system to a target system is initiated. The source system and the target system operate in a first database layer and a second database layer. Thereafter, differences in structure and/or database type are computed between a source table in the source system and a target table in the target system in each of the two different database layers. The data is then migrated, using the computing differences and in the second database layer, from the source table to the target table. The upgrade procedure is later terminated after completion of the migration of the data. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20160085542A1

公开(公告)日：2016-03-24

申请号：US14490529

申请日：2014-09-18

申请人： Steffen Meissner ,  Juergen Specht

发明人： Steffen Meissner ,  Juergen Specht

IPC分类号： G06F9/445 ,  G06F17/30

CPC分类号： G06F8/656 ,  G06F17/3023 ,  G06F17/30292 ,  G06F17/303 ,  G06F17/30575

摘要： A zero downtime upgrade of a source system to a target system is initiated. The source system and the target system operate in a first database layer and a second database layer. Thereafter, differences in structure and/or database type are computed between a source table in the source system and a target table in the target system in each of the two different database layers. The data is then migrated, using the computing differences and in the second database layer, from the source table to the target table. The upgrade procedure is later terminated after completion of the migration of the data. Related apparatus, systems, techniques and articles are also described.

摘要翻译： 启动源系统到目标系统的零停机升级。 源系统和目标系统在第一数据库层和第二数据库层中操作。 此后，在源系统中的源表和目标系统中的两个不同数据库层中的每一个中的目标表之间计算结构和/或数据库类型的差异。 然后使用计算差异和第二个数据库层将数据从源表迁移到目标表。 完成迁移数据后，升级过程稍后终止。 还描述了相关设备，系统，技术和物品。