Synchronized backup and recovery of heterogeneous DBMSs using third party backup tool

    公开(公告)号:US10255139B2

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

    申请号:US15220044

    申请日:2016-07-26

    Applicant: SAP SE

    Abstract: Synchronized backup and recovery of heterogeneous DBMSs is described herein. An embodiment operates by receiving, by at least one processor, a request for a data backup process at a first server; creating, by at least one processor, a pipe between processes of the first sever and the data backup process; performing, by at least one processor, the data backup process according to an execution command sent from a second server; and sending, by at least one processor, a result of the data backup process from the second server to the first server when the data backup process has terminated.

    OPTIMIZATION OF RELOCATED QUERIES IN FEDERATED DATABASES USING CROSS DATABASE TABLE REPLICAS

    公开(公告)号:US20200320094A1

    公开(公告)日:2020-10-08

    申请号:US16373691

    申请日:2019-04-03

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for appropriately routing requests for data stored in multiple storage mediums. An embodiment operates by maintaining a first and second data stored on a first storage medium in communication with a second storage medium. Thereafter, a replicate of the first data stored in the first storage medium may be created for the second storage medium to store a replica data mirroring the first data. Subsequently, a request for retrieval of the first data may be received. Afterward, a previous update time of the second storage medium in receiving the replicate of the first data stored in the first storage medium may be determined. Lastly, based on the previous update time, the request may be forwarded to the first storage medium or second storage medium.

    Coordinated Replication of Heterogeneous Database Stores

    公开(公告)号:US20190155705A1

    公开(公告)日:2019-05-23

    申请号:US15877074

    申请日:2018-01-22

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for coordinated replication of heterogeneous database stores. An embodiment operates by determining a synchronization point based on a commit log of a primary data center. A current log position of each of a plurality of secondary slave servers associated with a secondary master server of a secondary data center is requested. It is determined that the current log position of at least one of the secondary slave servers does not correspond to the logged position of a corresponding primary slave server relative to the synchronization point. An update indicating that the current log position of each of the secondary slave servers corresponds to the logged position of each of the relative corresponding primary slave servers is received. A replay of each of the secondary slave servers up to the synchronization point is initiated.

    High throughput cross database table synchronization and transactional replication in federated databases

    公开(公告)号:US11182405B2

    公开(公告)日:2021-11-23

    申请号:US16373725

    申请日:2019-04-03

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a lock-free parallel log replay and synchronization scheme to support asynchronous table replication. By synchronizing a replica table with the server-side data and conducting subsequent updates using transaction logs via a replayer, locking of tables may be avoided. A consistent transactional state may be maintained by employing a replayer to mark the table as enabled instead of a synchronizer. The replayer may also deduce transitive closures among transactions and replay the transactions in parallel based on the deduced transitive closures to optimize playback. These techniques provide enhanced data availability and minimize database blocking and deadlocking while improving query performance.

    Optimization of relocated queries in federated databases using cross database table replicas

    公开(公告)号:US11061927B2

    公开(公告)日:2021-07-13

    申请号:US16373691

    申请日:2019-04-03

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for appropriately routing requests for data stored in multiple storage mediums. An embodiment operates by maintaining a first and second data stored on a first storage medium in communication with a second storage medium. Thereafter, a replicate of the first data stored in the first storage medium may be created for the second storage medium to store a replica data mirroring the first data. Subsequently, a request for retrieval of the first data may be received. Afterward, a previous update time of the second storage medium in receiving the replicate of the first data stored in the first storage medium may be determined. Lastly, based on the previous update time, the request may be forwarded to the first storage medium or second storage medium.

    Coordinated replication of heterogeneous database stores

    公开(公告)号:US11216346B2

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

    申请号:US15877074

    申请日:2018-01-22

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for coordinated replication of heterogeneous database stores. An embodiment operates by determining a synchronization point based on a commit log of a primary data center. A current log position of each of a plurality of secondary slave servers associated with a secondary master server of a secondary data center is requested. It is determined that the current log position of at least one of the secondary slave servers does not correspond to the logged position of a corresponding primary slave server relative to the synchronization point. An update indicating that the current log position of each of the secondary slave servers corresponds to the logged position of each of the relative corresponding primary slave servers is received. A replay of each of the secondary slave servers up to the synchronization point is initiated.

    High Throughput Cross Database Table Synchronization and Transactional Replication in Federated Databases

    公开(公告)号:US20200320098A1

    公开(公告)日:2020-10-08

    申请号:US16373725

    申请日:2019-04-03

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a lock-free parallel log replay and synchronization scheme to support asynchronous table replication. By synchronizing a replica table with the server-side data and conducting subsequent updates using transaction logs via a replayer, locking of tables may be avoided. A consistent transactional state may be maintained by employing a replayer to mark the table as enabled instead of a synchronizer. The replayer may also deduce transitive closures among transactions and replay the transactions in parallel based on the deduced transitive closures to optimize playback. These techniques provide enhanced data availability and minimize database blocking and deadlocking while improving query performance.

Patent Agency Ranking