DATABASE RECOVERY BASED ON LOGICAL TIMESTAMP

    公开(公告)号:US20230185676A1

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

    申请号:US17547423

    申请日:2021-12-10

    Applicant: SAP SE

    Inventor: Changgyoo PARK

    CPC classification number: G06F11/1469 G06F11/1471 G06F16/2379

    Abstract: A system includes reception of a request for recovery of a database to a recovery time, determination of a recovery logical timestamp corresponding to the recovery time, identification of database log records associated with a logical timestamp preceding the recovery logical timestamp, application of the identified database log records to the database sequentially according to log sequence number, identification, after applying the identified database log records, of one or more open transactions on the database, identification of a first one or more of the one or more open transactions which are associated with a commit log record associated with a logical timestamp preceding the recovery logical timestamp, and, in response to identification of the first one or more of the one or more open transactions, committing of the first one or more of the one or more open transactions.

    VERIFICATION OF DATABASE SYSTEM USING DETERMINISTIC READ WORKLOADS

    公开(公告)号:US20230185792A1

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

    申请号:US17548973

    申请日:2021-12-13

    Applicant: SAP SE

    CPC classification number: G06F16/2365 G06F16/273

    Abstract: Systems and methods include reception of a workload statement, determination of whether the workload statement is a read statement or write statement, and, if the workload statement is a read statement, execution of the read statement to generate a first result set and transmission of the read statement for execution by a second database system to generate a second result set. If the workload statement is a write statement, the write statement is executed to change data of the first database system and the changed data is replicated to the second database system.

Patent Agency Ranking