-
公开(公告)号：US10534676B2
公开(公告)日：2020-01-14
申请号：US15442906
申请日：2017-02-27
Applicant: SAP SE
Inventor： Kyu Hwan Kim , Deok Hoe Kim , Beomsoo Kim , Juchang Lee , Werner Thesing , Christoph Roterring
Abstract: A computer implemented method is provided for determining a delay between a first database and an associated replicated database by replicating transactions of the first database in the replicated database, determining a delay between the two databases based on a commit timestamp from the first database and a timestamp associated with the commit transaction becoming visible in the replicated database. Then, after a predefined period of time has elapsed since replicating the commit transaction, determining a second delay based on a timestamp associated with a heartbeat log and a replicated database system time. And, selectively determining to execute or deny a statement received by the replicated database based on the second delay. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：US20200012633A1
公开(公告)日：2020-01-09
申请号：US16576498
申请日：2019-09-19
Applicant: SAP SE
Inventor： Kyu Hwan Kim , Juchang Lee , Beomsoo Kim , Chang Gyoo Park , Reiner Singer , Christoph Roterring , Werner Thesing , Michael Muehle
IPC: G06F16/23 , G06F16/245
Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：US10402389B2
公开(公告)日：2019-09-03
申请号：US15496957
申请日：2017-04-25
Applicant: SAP SE
Inventor： Dirk Thomsen , Christoph Roterring , Werner Thesing
Abstract: Each of a plurality of database transactions are logged (i.e., recorded) in a log. Concurrent with the logging, one or more characteristics of the log are monitored. Thereafter, a savepoint is triggered when a pre-defined condition is met as indicated by the monitoring. The triggered savepoint can override or accelerate a savepoint that would have otherwise been triggered based on pre-specified parameters.
-
公开(公告)号：US11416349B2
公开(公告)日：2022-08-16
申请号：US17008380
申请日：2020-08-31
Applicant: SAP SE
Inventor： Thorsten Glebe , Werner Thesing , Christoph Roterring
Abstract: Recovery of a database system by taking the database system offline is initiated. Thereafter, recovery operations specified by a redo log of the database system are replayed. A cleanup log is generated that identifies cleanup operations occurring during the replay of the recovery operations for garbage collection. Concurrent with the startup of the database, garbage collection of the cleanup operations as specified in the database savepoint is initiated. In addition, concurrent with the replay of the recovery operations, garbage collection of the cleanup operations specified by the cleanup log is initiated. The database system is later brought online after all of the recovery operations are replayed.
-
Patent Agency Ranking
公开(公告)号：US20210303421A1
公开(公告)日：2021-09-30
申请号：US16834317
申请日：2020-03-30
Applicant: SAP SE
Inventor： Christoph Roterring , Reiner Singer , Werner Thesing
Abstract: A method, a system, and a computer program product for executing a takeover process. A takeover process of a primary computing system by a secondary computing system is triggered. The secondary computing system stores transaction data replicated from the primary computing system. Writing of a redo log of transaction data of one or more transactions into storage by the primary computing system is suspended. The redo log is written by the primary computing system prior to the suspending is transmitted to the secondary computing system. The takeover process of the primary computing system by the secondary computing system is executed upon receiving and persisting the redo log at the secondary computing system.
-
公开(公告)号：US10795779B2
公开(公告)日：2020-10-06
申请号：US15436535
申请日：2017-02-17
Applicant: SAP SE
Inventor： Thorsten Glebe , Werner Thesing , Christoph Roterring
Abstract: Recovery of a database system by taking the database system offline is initiated. Thereafter, recovery operations specified by a redo log of the database system are replayed. A cleanup log is generated that identifies cleanup operations occurring during the replay of the recovery operations for garbage collection. Concurrent with the startup of the database, garbage collection of the cleanup operations as specified in the database savepoint is initiated. In addition, concurrent with the replay of the recovery operations, garbage collection of the cleanup operations specified by the cleanup log is initiated. The database system is later brought online after all of the recovery operations are replayed.
-
公开(公告)号：US10481986B2
公开(公告)日：2019-11-19
申请号：US15647045
申请日：2017-07-11
Applicant: SAP SE
Inventor： Dirk Thomsen , Christoph Roterring , Thorsten Glebe
Abstract: Recovery of a database system by taking the database system offline is initiated. Thereafter, recovery operations specified by a redo log of the database system are replayed. A cleanup log is generated that identifies cleanup operations occurring during the replay of the recovery operations for garbage collection. Concurrent with the startup of the database, garbage collection of the cleanup operations as specified in the database savepoint is initiated. In addition, concurrent with the replay of the recovery operations, garbage collection of the cleanup operations specified by the cleanup log is initiated. The amount of parallelization of the garbage collection can be varied based on utilized processor resources. The database system is later brought online after all of the recovery operations are replayed.
-
公开(公告)号：US10474541B2
公开(公告)日：2019-11-12
申请号：US15452439
申请日：2017-03-07
Applicant: SAP SE
Inventor： Christoph Roterring , Dirk Thomsen , Reiner Singer
Abstract: Recovery of a database system can be initiated by taking the database system offline. Thereafter, recovery operations specified by a redo log of the database system are replayed. During the replaying, updates to pages implicated by the recovery operations are blocked. In parallel, modified pages are flushed to physical disk storage. The database is later brought online after all of the recovery operations are replayed.
-
公开(公告)号：US20190317865A1
公开(公告)日：2019-10-17
申请号：US15953856
申请日：2018-04-16
Applicant: SAP SE
Inventor： Martin Heidel , Xin Liu , Christoph Roterring , Shiping Chen , Vivek Kandiyanallur , Stephan Kottler , Joern Schmidt
Abstract: Disclosed herein are system, method, and computer program product embodiments for a database recovery and optimization with batch processing system. An embodiment operates by retrieving a database log that includes a plurality of operations for modifying data of a database stored across a plurality of tables. From the database log, a plurality of consecutive insert operations for inserting data into the database are identified. The consecutive insert operations are sorted by table. The sorted insert operations are grouped into a batch message. The batch message is transmit to the database for replay. An acknowledgement is received that the replay has completed.
-
-
-
-
-
-
-
-
Search Results
19
records
(took 0.014 seconds)
