-
公开(公告)号: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.
-
公开(公告)号:US20180307570A1
公开(公告)日:2018-10-25
申请号:US15496743
申请日:2017-04-25
Applicant: SAP SE
Inventor: Dirk Thomsen
CPC classification number: G06F11/1471 , G06F11/1474 , G06F16/2365 , G06F16/2372 , G06F2201/80 , G06F2201/805 , G06F2201/82
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. During such replay, updates to pages implicated by the recovery operations are blocked. In parallel to such blocking, modified pages are adaptively flushed to physical disk storage using a factor that is based on a number of pages written to the physical disk storage and a number of write I/O operations as part of the flushing of the modified pages. Subsequently, the database system is brought online after all of the recovery operations are replayed.
-
公开(公告)号: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.
-
公开(公告)号:US11962686B2
公开(公告)日:2024-04-16
申请号:US17549164
申请日:2021-12-13
Applicant: SAP SE
Inventor: Dirk Thomsen , Till Merker
CPC classification number: H04L9/0833 , G06F21/6218 , H04L9/0631 , H04L9/0869
Abstract: Computer-readable media, methods, and systems are disclosed for handling intermediate data in connection with a database employing group-level encryption. Intermediate data is used during database operation and stored transiently such that the intermediate data is removed from memory upon database restart. To protect the privacy of the intermediate data, a random encryption key may be generated upon startup of a database instance. The random encryption key may be stored transiently. During database operation, the random encryption key may be used to encrypt and/or decrypt the intermediate data. The transient memory may be wiped upon database shut down such that the random encryption key is no longer accessible upon database restart.
-
公开(公告)号:US11907162B2
公开(公告)日:2024-02-20
申请号:US17333484
申请日:2021-05-28
Applicant: SAP SE
Inventor: Dirk Thomsen , Axel Schroeder
CPC classification number: G06F16/128 , G06F21/602 , H04L9/0891
Abstract: Computer-readable media, methods, and systems are disclosed for minimizing data volume growth in a database system under changes to an encryption status of a plurality of data pages persisted to a database. Initially, a request is received to update an encryption parameter associated with the database. Next, it is determined whether a candidate page requires encryption changes. In response to determining that the candidate page is not currently in use by one or more active database snapshots and not currently loaded in main memory, the candidate page is loaded into main memory. Next, an encryption operation is performed on the candidate page, and the encrypted page is designated for persistence. Finally, based on a current number of candidate pages already encrypted during a current save point cycle, the selective iteration is paused until a subsequent save point cycle.
-
公开(公告)号:US11656953B2
公开(公告)日:2023-05-23
申请号:US17507651
申请日:2021-10-21
Applicant: SAP SE
Inventor: Dirk Thomsen
IPC: G06F16/90 , G06F11/14 , G06F16/908 , G06F3/06 , H04L9/08
CPC classification number: G06F11/1469 , G06F3/064 , G06F3/067 , G06F3/0619 , G06F3/0656 , G06F11/1448 , G06F11/1471 , G06F16/908 , H04L9/0861
Abstract: Recovery of an in-memory database is initiated. Thereafter, pages for recovery having a size equal to or below a pre-defined threshold are copied to a superblock. For each copied page, encryption information is added to a superblock control block for the superblock. The copied pages are encrypted within the superblock using the corresponding encryption information added to the super block control block. The superblock is then flushed from memory (e.g., main memory, etc.) of the database to physical persistence.
-
公开(公告)号:US11157371B2
公开(公告)日:2021-10-26
申请号:US16261172
申请日:2019-01-29
Applicant: SAP SE
Inventor: Dirk Thomsen
IPC: G06F16/16 , G06F11/14 , G06F16/908 , G06F3/06 , H04L9/08
Abstract: Recovery of an in-memory database is initiated. Thereafter, pages for recovery having a size equal to or below a pre-defined threshold are copied to a superblock. For each copied page, encryption information is added to a superblock control block for the superblock. The copied pages are encrypted within the superblock using the corresponding encryption information added to the super block control block. The superblock is then flushed from memory (e.g., main memory, etc.) of the database to physical persistence.
-
公开(公告)号:US10740036B2
公开(公告)日:2020-08-11
申请号:US15632110
申请日:2017-06-23
Applicant: SAP SE
Inventor: Ivan Schreter , Dirk Thomsen , Colin Florendo , Blaine French
IPC: G06F16/22 , G06F3/06 , G06F16/23 , G06F16/174 , G06F16/2455
Abstract: Data records of a data set can be stored in multiple main part fragments retained in on-disk storage. Each fragment can include a number of data records that is equal to or less than a defined maximum fragment size. Using a compression that is optimized for each fragment, each fragment can be compressed. After reading at least one of the fragments into main system memory from the on-disk storage, an operation can be performed on the fragment or fragments while the in the main system memory.
-
公开(公告)号:US20190354615A1
公开(公告)日:2019-11-21
申请号:US15980525
申请日:2018-05-15
Applicant: SAP SE
Inventor: Tobias Scheuer , Dirk Thomsen
Abstract: Systems and methods are described herein for system critical phase lock job inhibitors. Acquisition of a consistent change exclusive lock is initiated. A job request having a scope object is received. Execution of the job request and generation of a replacement job associated with the job request is prohibited based on the scope object indicating that the job requires consistent change access during the consistent change exclusive lock.
-
公开(公告)号:US20190340277A1
公开(公告)日:2019-11-07
申请号:US15970727
申请日:2018-05-03
Applicant: SAP SE
Inventor: Dirk Thomsen , Thorsten Glebe , Blaise Lengrand
Abstract: Checking of a database snapshot of an active database is initiated. Thereafter, an anchor page associated with a most recent snapshot that links to a restart page is read. Subsequently, the linked restart page is read. It is then initially determined, based on the reading of the anchor page and the restart page, whether the snapshot is accurate. If it is initially determined that the snapshot is not accurate, the anchor page and the restart page are re-read until a final determination is made that whether the snapshot is accurate. Alternatively, if not is initially determined that the snapshot is accurate, then data is provided (e.g., displayed, loaded into memory, transmitted to a remote computing system, stored in physical persistence, etc.) that indicates that the snapshot is accurate.
-
-
-
-
-
-
-
-
-