PHYSIO-LOGICAL LOGGING FOR IN-MEMORY ROW-ORIENTED DATABASE SYSTEM

    公开(公告)号:US20180150363A1

    公开(公告)日:2018-05-31

    申请号:US15362714

    申请日:2016-11-28

    Applicant: SAP SE

    CPC classification number: G06F11/1469 G06F16/2308 G06F16/2365 G06F2201/84

    Abstract: Restoring a database image of a secondary database system comprises initializing the database image from a recovery image that includes metadata logs and non-metadata logs, of which at least one metadata log includes an undo log of non-committed data that is applied to the initialized database image. A first pagelist and first indexes are then rebuilt based on first data segments of the database image and the corresponding metadata objects. The database image is then updated by replaying the metadata redo log generated from the undo log, the metadata logs, and the non-metadata logs. Then, a second pagelist and second indexes for the database system are rebuilt based on second data segments of the database image and the corresponding non-metadata objects, while each of the first data segments is statically separated from the second data segments in physical memory space. Related apparatus, systems, techniques and articles are also described.

    HANDLING OF DATABASE ENCRYPTION KEY REVOCATION

    公开(公告)号:US20240195617A1

    公开(公告)日:2024-06-13

    申请号:US18065048

    申请日:2022-12-13

    Applicant: SAP SE

    CPC classification number: H04L9/0891 G06F21/602 G06F21/6218

    Abstract: Systems and methods include storage of a plurality of encrypted data pages of a row store database table in a persistent storage system, determination of a first encryption key associated with one of the plurality of encrypted data pages based on a header of the one of the plurality of encrypted data pages, determination of whether the first encryption key has been revoked, and, if it is determined that the first encryption key has been revoked, adding of a portion of volatile memory allocated to the one of the plurality of data pages to a free list.

    DATABASE TENANT-LEVEL MOVE
    4.
    发明公开

    公开(公告)号:US20240356762A1

    公开(公告)日:2024-10-24

    申请号:US18303065

    申请日:2023-04-19

    Applicant: SAP SE

    CPC classification number: H04L9/3268 G06F16/214 G06F21/6218

    Abstract: Systems and methods include reception of a request to move a first database tenant from a first database instance to a second database instance, the first database tenant comprising a first tenant object instance associated with a plurality of artifacts of the first database instance, the plurality of artifacts including a tenant-level catalog and data. In response to the request, the tenant-level catalog is exported from the first database instance to a shared storage system, the tenant-level catalog is imported to a second tenant of the second database instance from the shared storage system, the data is exported from the first database instance to the shared storage system, the data is imported to the second tenant of the second database instance from the shared storage system, and the first database tenant is dropped from the first database instance.

    TENANT-LEVEL DATABASE RECOVERY
    5.
    发明公开

    公开(公告)号:US20240281344A1

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

    申请号:US18185872

    申请日:2023-03-17

    Applicant: SAP SE

    CPC classification number: G06F11/1469 G06F11/1451 G06F11/1464

    Abstract: Systems and methods include reception of an instruction to recover a first database tenant of a first database instance to a first point in time, the first database tenant associated with first database artifacts of the first database instance, and the first database instance including two or more database tenants and, in response to the instruction, creation of a second database instance, selection of backup data of the first database instance based on the first point in time, execution of a recovery of the backup data on the second database instance, export of second database artifacts of the first database tenant from the second database instance to a storage, truncation of the first database artifacts from the first database instance, import of the second database artifacts from the storage to the first database instance, and deletion of the second database instance.

Patent Agency Ranking