-
公开(公告)号：US10769040B2
公开(公告)日：2020-09-08
申请号：US15357689
申请日：2016-11-21
Applicant: SAP SE
Inventor： Reiner Singer , Werner Thesing
Abstract: A computer implemented method for replication includes registering a first database system with a second database system and performing a failback operation on the first database system. The failback operation includes opening a snapshot that includes data known to have existed on the first database system and the second database system at a first time. Transaction log information is requested from the second database system. The transaction log information corresponds to transactions performed on the second database system beginning with the first time. The transaction log information is applied to the snapshot data on the first database system. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：US20190018740A1
公开(公告)日：2019-01-17
申请号：US15646904
申请日：2017-07-11
Applicant: SAP SE
Inventor： Dirk Thomsen , Werner Thesing
Abstract: A savepoint is initiated in an in-memory database system that is associated with a plurality of modified pages and comprises a pre-critical phase, a critical phase, and a post-critical phase. Thereafter, as part of the critical phase, a physical page number is assigned to each page in the critical phase. Further, as part of the critical phase, each page assigned a physical page number is individually locked. Subsequently, each page is handed over from a corresponding first thread to a corresponding second thread to copy such page into a corresponding shadow page as part of the post-critical phase.
-
公开(公告)号：US20180246809A1
公开(公告)日：2018-08-30
申请号：US15695621
申请日：2017-09-05
Applicant: SAP SE
Inventor： Oliver Rebholz , Ivan Schreter , Abdelkader Sellami , Daniel Booss , Gunter Radestock , Peter Bumbulis , Alexander Boehm , Frank Renkes , Werner Thesing , Thomas Willhalm
Abstract: A system includes a non-volatile random access memory storing a column store main fragment of a column of a database table, and a processing unit to read the column store main fragment from the non-volatile random access memory. A volatile random access memory storing a column store delta fragment of the column of the database table may also be included, in which the processing unit is to write to the column store delta fragment. According to some systems, the stored column store main fragment is byte-addressable, and is copied from the volatile random access memory to the non-volatile random access memory without using a filesystem cache.
-
公开(公告)号：US11429388B2
公开(公告)日：2022-08-30
申请号：US16883241
申请日：2020-05-26
Applicant: SAP SE
Inventor： Dirk Thomsen , Thorsten Glebe , Tobias Scheuer , Werner Thesing , Johannes Gloeckle
Abstract: Aspects of the current subject matter are directed to an approach in which a parallel load operation of file ID mapping containers is accomplished at start and/or restart of a database system. Parallel load operation of file ID mapping and/or large binary object (LOB) file ID mapping is done among a plurality of scanning engines into a plurality of data buffers that are associated with each of the plurality of scanning engines. Each scanning engine operates on a certain path of a page chain of a page structure including the mapping, causing the page chain to be split among scanning engines to process maps. Contents of the data buffers are pushed to mapping engines via a queue. The mapping engines load the file ID mapping and the LOB file ID mapping into maps for in-system access.
-
公开(公告)号：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.
-
Patent Agency Ranking
公开(公告)号：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.
-
公开(公告)号：US10387398B2
公开(公告)日：2019-08-20
申请号：US15479094
申请日：2017-04-04
Applicant: SAP SE
Inventor： Dirk Thomsen , Werner Thesing
Abstract: Execution of a page flusher is initiated in an in-memory database system in which pages are loaded into memory and which has associated physical disk storage. Thereafter, the page flusher identifies pages that were last modified outside a pre-defined time window. The page flusher then flushes the identified modified pages to the physical disk storage.
-
公开(公告)号：US20180307718A1
公开(公告)日：2018-10-25
申请号：US15496957
申请日：2017-04-25
Applicant: SAP SE
Inventor： Dirk Thomsen , Christoph Rottering , Werner Thesing
CPC classification number: G06F16/2358 , G06F11/0766 , G06F11/1471 , G06F11/1474 , G06F11/1662 , G06F11/2035 , G06F11/2097 , G06F11/3476 , G06F16/27 , G06F17/40 , G06F2201/80 , G06F2211/1038
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.
-
-
-
-
-
-
-
-
-
Search Results
31
records
(took 0.026 seconds)
