ZERO DOWNTIME UPGRADE OF SYSTEMS WITH DATABASE-SIDE REPLICATION

    公开(公告)号:US20200159852A1

    公开(公告)日:2020-05-21

    申请号:US16197888

    申请日:2018-11-21

    Applicant: SAP SE

    Abstract: Implementations include providing, by a deploy tool, clone data components in the first database system, each clone data component being a copy of a data component, defining, by the deploy tool, a source-side green access schema in the first database system, the green access schema providing views to the clone data components, providing, by a replication system and based on statements received from the deploy tool, consumer-side clone data components in the first database system, each consumer-side clone data component being a copy of a respective data component, defining, by a replication system and based on statements received from the deploy tool, a consumer-side green access schema in the first database system, the green access schema providing views to the source-side clone data components, and, during execution of the upgrade, replicating, by a handler of the replication system, data from at least one source-side data component to a consumer-side component.

    Zero downtime for frequent software updates

    公开(公告)号:US10656933B2

    公开(公告)日:2020-05-19

    申请号:US15471550

    申请日:2017-03-28

    Applicant: SAP SE

    Abstract: In order to perform relatively frequent, zero-downtime software updates, a bridge schema corresponding to an original schema of a database system may be generated. Within the bridge schema, a plurality of views corresponding to a plurality of database tables of an application executing on an application server may be generated. A connection from the application to the original schema may be changed to the bridge schema, to thereby continue executing the application using the plurality of views. When a change file defining update changes to at least one original database table of the plurality of database tables is received, content of the at least one original database table may be synchronized with a target table reflecting the update changes. Then, the connection may be changed back to the original database schema to continue executing the software application, using the plurality of database tables and including the target table.

    Zero downtime upgrade of systems with database-side replication

    公开(公告)号:US11232126B2

    公开(公告)日:2022-01-25

    申请号:US16197888

    申请日:2018-11-21

    Applicant: SAP SE

    Abstract: Implementations include providing, by a deploy tool, clone data components in the first database system, each clone data component being a copy of a data component, defining, by the deploy tool, a source-side green access schema in the first database system, the green access schema providing views to the clone data components, providing, by a replication system and based on statements received from the deploy tool, consumer-side clone data components in the first database system, each consumer-side clone data component being a copy of a respective data component, defining, by a replication system and based on statements received from the deploy tool, a consumer-side green access schema in the first database system, the green access schema providing views to the source-side clone data components, and, during execution of the upgrade, replicating, by a handler of the replication system, data from at least one source-side data component to a consumer-side component.

    Precision locking a database server during the upgrade of a system landscape

    公开(公告)号:US10402185B2

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

    申请号:US14852119

    申请日:2015-09-11

    Applicant: SAP SE

    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.

    ZERO DOWNTIME FOR FREQUENT SOFTWARE UPDATES
    5.
    发明申请

    公开(公告)号:US20180285097A1

    公开(公告)日:2018-10-04

    申请号:US15471550

    申请日:2017-03-28

    Applicant: SAP SE

    Abstract: In order to perform relatively frequent, zero-downtime software updates, a bridge schema corresponding to an original schema of a database system may be generated. Within the bridge schema, a plurality of views corresponding to a plurality of database tables of an application executing on an application server may be generated. A connection from the application to the original schema may be changed to the bridge schema, to thereby continue executing the application using the plurality of views. When a change file defining update changes to at least one original database table of the plurality of database tables is received, content of the at least one original database table may be synchronized with a target table reflecting the update changes. Then, the connection may be changed back to the original database schema to continue executing the software application, using the plurality of database tables and including the target table.

    Enabling corrections during upgrade procedure

    公开(公告)号:US10055215B2

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

    申请号:US15285715

    申请日:2016-10-05

    Applicant: SAP SE

    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.

    ENABLING CORRECTIONS DURING UPGRADE PROCEDURE

    公开(公告)号:US20180095743A1

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

    申请号:US15285715

    申请日:2016-10-05

    Applicant: SAP SE

    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.

    Precision Locking a Database Server During the Upgrade of a System Landscape
    8.
    发明申请
    Precision Locking a Database Server During the Upgrade of a System Landscape 审中-公开
    在升级系统风景期间精确锁定数据库服务器

    公开(公告)号:US20170075939A1

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

    申请号:US14852119

    申请日:2015-09-11

    Applicant: SAP SE

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

Patent Agency Ranking