UNIFIED ARCHITECTURE FOR HYBRID DATABASE STORAGE USING FRAGMENTS
    61.
    发明申请
    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.

    BACKUP AND RECOVERY UNDER GROUP-LEVEL ENCRYPTION

    公开(公告)号:US20230185675A1

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

    申请号:US17546406

    申请日:2021-12-09

    Applicant: SAP SE

    Inventor: Dirk Thomsen

    CPC classification number: G06F11/1469 G06F21/64 G06F21/602 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.

    Performant dropping of snapshots by converter branch pruning

    公开(公告)号:US11657046B1

    公开(公告)日:2023-05-23

    申请号:US17554506

    申请日:2021-12-17

    Applicant: SAP SE

    Inventor: Dirk Thomsen

    CPC classification number: G06F16/2453 G06F16/24552 G06F16/24557

    Abstract: Computer-readable media, methods, and systems are disclosed for improving performance when dropping database snapshots in an in-memory database by pruning tree branches in one or more converters associated with a snapshot of an in-memory database. A request to compare at least two database snapshots is received. Physical pages associated with at least one of the two database snapshots are loaded. First and second converter streams are iterated. Physical block numbers of intermediate converter pages to which the first and second converter streams currently point are compared. If the physical page numbers are all non-equal, the physical pages referenced by the second converter stream are set to free. If any of the physical page numbers are equal, subsequent traversal of a corresponding converter subtree in the first and second converter streams may be skipped to improve performance.

    PROCESSING DATA PAGES UNDER GROUP-LEVEL ENCRYPTION

    公开(公告)号:US20220382898A1

    公开(公告)日:2022-12-01

    申请号:US17333578

    申请日:2021-05-28

    Applicant: SAP SE

    Inventor: Dirk Thomsen

    Abstract: Computer-readable media, methods, and systems are disclosed for encrypting and decrypting data pages in connection with a database employing group-level encryption. A request to load a group-level encrypted logical data page into main memory is received, the data page being identified by a logical page number. A block of group-level encrypted data is loaded into the main memory of the database system from an address corresponding to the physical block number. A block of group-level encrypted data is loaded into the main memory of the database system. A header associated with the block of group-level encrypted data is decrypted using a data-volume encryption key, and an encryption-group identifier is accessed from the decrypted header. A group-level encryption key is retrieved from a key manager, and the remainder of the block of group-level encrypted data is decrypted using the group-level encryption key.

    MINIMIZING DATA VOLUME GROWTH UNDER ENCRYPTION CHANGES

    公开(公告)号:US20220382712A1

    公开(公告)日:2022-12-01

    申请号:US17333484

    申请日:2021-05-28

    Applicant: SAP SE

    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.

    Parallel load of mapping containers for database system start and restart operations

    公开(公告)号:US11429388B2

    公开(公告)日:2022-08-30

    申请号:US16883241

    申请日:2020-05-26

    Applicant: SAP SE

    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.

    Database snapshot checking
    70.
    发明授权

    公开(公告)号:US11222007B2

    公开(公告)日:2022-01-11

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