Database Savepoint With Shortened Critical Phase Time

    公开(公告)号:US20190018740A1

    公开(公告)日:2019-01-17

    申请号:US15646904

    申请日:2017-07-11

    Applicant: SAP SE

    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.

    Self-Adaptive Continuous Flushing of Pages to Disk

    公开(公告)号:US20180307570A1

    公开(公告)日:2018-10-25

    申请号:US15496743

    申请日:2017-04-25

    Applicant: SAP SE

    Inventor: Dirk Thomsen

    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.

    Optimized Savepoint During Database Recovery
    13.
    发明申请

    公开(公告)号:US20180260286A1

    公开(公告)日:2018-09-13

    申请号:US15452439

    申请日:2017-03-07

    Applicant: SAP SE

    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.

    Encrypting intermediate data under group-level encryption

    公开(公告)号:US11962686B2

    公开(公告)日:2024-04-16

    申请号:US17549164

    申请日:2021-12-13

    Applicant: SAP SE

    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.

    Minimizing data volume growth under encryption changes

    公开(公告)号:US11907162B2

    公开(公告)日:2024-02-20

    申请号:US17333484

    申请日:2021-05-28

    Applicant: SAP SE

    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.

    Small database page recovery
    17.
    发明授权

    公开(公告)号:US11157371B2

    公开(公告)日:2021-10-26

    申请号:US16261172

    申请日:2019-01-29

    Applicant: SAP SE

    Inventor: Dirk Thomsen

    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.

    Savepoint Critical Phase Lock Job Inhibitor
    19.
    发明申请

    公开(公告)号:US20190354615A1

    公开(公告)日:2019-11-21

    申请号:US15980525

    申请日:2018-05-15

    Applicant: SAP SE

    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.

    Database Snapshot Checking
    20.
    发明申请

    公开(公告)号:US20190340277A1

    公开(公告)日:2019-11-07

    申请号:US15970727

    申请日:2018-05-03

    Applicant: SAP SE

    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.

Patent Agency Ranking