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.

Patent Agency Ranking