Automatic adoption of parallelized database garbage collection

    公开(公告)号:US10481986B2

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

    申请号:US15647045

    申请日:2017-07-11

    Applicant: SAP SE

    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.

    Optimized savepoint during database recovery

    公开(公告)号:US10474541B2

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

    申请号: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.

    Optimization of Exclusive Access Database Consistent Change Locks

    公开(公告)号:US20190340275A1

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

    申请号:US15970715

    申请日:2018-05-03

    Applicant: SAP SE

    Abstract: Execution of an exclusive lock of a page in a database is initiated. Thereafter, subsequent to the initiation of the execution of the exclusive lock, at least one non-exclusive lock for the page in the database is received. The execution of the exclusive lock is selectively timed out based on at least one savepoint statistic. While the exclusive lock is timed out, at least one of the received non-exclusive locks is executed. Further, the exclusive lock can be restarted after the execution of the at least one of the received non-exclusive locks.

    In-Memory Database with Page Size Adaptation During Loading

    公开(公告)号:US20190004937A1

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

    申请号:US15638189

    申请日:2017-06-29

    Applicant: SAP SE

    Abstract: Loading of a page into memory of an in-memory database system is initiated. Thereafter, a new page size for the page in memory is allocated corresponding to a greater of a current page size and an intended page size. Later, the page is loaded into the allocated memory so that a consistent change can be opened. Content within the page is reorganized according to the new page size followed by the consistent change being closed.

    Parallel Database Page Flusher
    55.
    发明申请

    公开(公告)号:US20180293135A1

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

    申请号:US15482074

    申请日:2017-04-07

    Applicant: SAP SE

    Inventor: Dirk Thomsen

    Abstract: Execution of a page flusher is initiated in an in-memory database system in which pages are loaded into memory and having associated physical disk storage. Thereafter, pages are identified that have been loaded into the memory of the database system and which have been modified. These identified pages are to be flushed to the physical disk storage. Each page is assigned with a different ordered physical page number. Asynchronous write I/O is later triggered causing the identified pages to be flushed to the physical disk storage and stored in the physical disk storage according to their assigned physical page numbers.

    UNIFIED ARCHITECTURE FOR HYBRID DATABASE STORAGE USING FRAGMENTS
    57.
    发明申请
    UNIFIED ARCHITECTURE FOR HYBRID DATABASE STORAGE USING FRAGMENTS 有权
    使用片段的混合数据库存储的统一架构

    公开(公告)号:US20160154815A1

    公开(公告)日:2016-06-02

    申请号:US15015042

    申请日:2016-02-03

    Applicant: SAP SE

    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.

    Abstract translation: 数据集的数据记录可以存储在保留在磁盘存储中的多个主要部分片段中。 每个片段可以包括等于或小于所定义的最大片段大小的多个数据记录。 使用针对每个片段优化的压缩,可以压缩每个片段。 在从磁盘存储器读入主系统存储器中的至少一个片段之后,可以在主系统存储器中对片段或片段执行操作。

    BACKUP AND RECOVERY UNDER GROUP-LEVEL ENCRYPTION

    公开(公告)号:US20240264910A1

    公开(公告)日:2024-08-08

    申请号:US18625687

    申请日:2024-04-03

    Applicant: SAP SE

    Inventor: Dirk Thomsen

    CPC classification number: G06F11/1469 G06F21/602 G06F21/64 G06F2201/84

    Abstract: Computer-readable media, methods, and systems are disclosed for processing backup and recovery of pages in an in-memory database system employing tenant-based, group-level encryption for a plurality of tenants. Page metadata for a page may be collected. The page may comprise a header and a set of page contents. The page metadata may be stored with the page header. When a backup request is received, the page may be loaded into a backup stream. The page may be loaded with the header unencrypted and the page contents encrypted. When a recovery request is received, the data page may be retrieved from the backup stream. A converter may be rebuilt using the page metadata. The data page may then be written to the main memory of the database system. The page contents may be decrypted by the converter.

    HANDLING PRE-EXISTING CONTAINERS UNDER GROUP-LEVEL ENCRYPTION

    公开(公告)号:US20230188327A1

    公开(公告)日:2023-06-15

    申请号:US17547511

    申请日:2021-12-10

    Applicant: SAP SE

    Inventor: Dirk Thomsen

    CPC classification number: H04L9/0833 H04L9/0891 G06F16/2379

    Abstract: Computer-readable media, methods, and systems are disclosed for tenant-specific encryption of container in connection with a database employing group-level encryption. An encryption group identifier may be assigned to container. The encryption group identifier may define how the container is encrypted. A container entry corresponding to the container may be created. A commit operation may be received for committing the assignment of the encryption group identifier to the container. A job may be initialized for encryption the container according to the encryption group identifier. The container may be flagged as modified. A flush operation may be initiated whereby the container is re-encrypted according to the encryption group identifier. Once flushing is complete, the container entry may be deleted.

    INITIALIZATION VECTOR HANDLING UNDER GROUP-LEVEL ENCRYPTION

    公开(公告)号:US20230188324A1

    公开(公告)日:2023-06-15

    申请号:US17546381

    申请日:2021-12-09

    Applicant: SAP SE

    Inventor: Dirk Thomsen

    CPC classification number: H04L9/0637

    Abstract: Computer-readable media, methods, and systems are disclosed for handling initialization vectors in an in-memory database system. Data pages may be written to disk using an encryption key/initialization vector combination that presents security risks when reused during a savepoint cycle. A data page in the database system may be modified. A current savepoint version may be stored in a converter entry for the data page. The data page may be flagged as modified. An instruction to write data page to disk may be received. Thereafter, a physical block number for the data page may be allocated in the converter entry. A counter for the converter entry may be incremented and the data page written to disk. Incrementing the counter may modify an initialization vector used to encrypt the data page.

Patent Agency Ranking