-
公开(公告)号：US11379323B2
公开(公告)日：2022-07-05
申请号：US16704727
申请日：2019-12-05
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.
-
公开(公告)号：US20180246928A1
公开(公告)日：2018-08-30
申请号：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.
-
公开(公告)号：US20250094620A1
公开(公告)日：2025-03-20
申请号：US18468570
申请日：2023-09-15
Applicant: SAP SE
Inventor： Dirk Thomsen , Christoph Roterring , Martin Schindewolf
Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program takes a first snapshot of a first set of data stores configured to store data associated with a database system. After taking the first snapshot of the first set of data stores, the program further takes a second snapshot of a second set of data stores configured to store a set of encryption keys for a set of tenants of the database system. The program also transmits data included in the first snapshot of the first set of data stores to a secondary system. The program further transmits data included in the second snapshot of the second set of data stores to the secondary system.
-
公开(公告)号：US20190018742A1
公开(公告)日：2019-01-17
申请号：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.
-
公开(公告)号：US20180239676A1
公开(公告)日：2018-08-23
申请号：US15436535
申请日：2017-02-17
Applicant: SAP SE
Inventor： Thorsten Glebe , Werner Thesing , Christoph Roterring
CPC classification number: G06F11/1469 , G06F11/1471 , G06F11/2038 , G06F11/2094 , G06F11/2097 , G06F12/0253 , G06F2212/1041 , G06F2212/1044 , G06F2212/702
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
公开(公告)号：US20250045178A1
公开(公告)日：2025-02-06
申请号：US18228395
申请日：2023-07-31
Applicant: SAP SE
Inventor： Markus Behrens , Reiner Singer , Werner Thesing , Yue Zhu , Mitja Kleider , Omran Saleh , Timo Sulg , Marcel Birn , Christoph Roterring
Abstract: A scale-out computing cluster may include a large number of computing servers and storage devices. In order to provide high reliability, the computing cluster must be able to handle failures of individual devices. Reliability of the computing cluster may be improved by providing a standby server for each active server in the computing cluster. If any active server fails, the corresponding standby server is activated. The failed server may be brought back online or replaced, at which time the restored server becomes the standby server for the now-active original standby server. During the restoration period, if any other active server fails, the standby server for that active server is immediately activated. As a result, the recovery ability of the computing cluster is only challenged if both servers of an active/standby pair fail during the restoration period, substantially improving reliability.
-
公开(公告)号：US11301341B2
公开(公告)日：2022-04-12
申请号：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.
-
公开(公告)号：US20180260286A1
公开(公告)日：2018-09-13
申请号：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.
-
公开(公告)号：US11200221B2
公开(公告)日：2021-12-14
申请号：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/00 , G06F16/23 , G06F16/245 , G06F16/27
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.
-
公开(公告)号：US10824519B2
公开(公告)日：2020-11-03
申请号：US15953856
申请日：2018-04-16
Applicant: SAP SE
Inventor： Martin Heidel , Xin Liu , Christoph Roterring , Shiping Chen , Vivek Kandiyanallur , Stephan Kottler , Joern Schmidt
IPC: G06F11/14 , G06F16/21 , G06F16/22 , G06F16/23 , G06F16/2455
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.012 seconds)
