Paged hybrid LOBs
    1.
    发明授权

    公开(公告)号:US11514027B2

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

    申请号:US16857982

    申请日:2020-04-24

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for storing a large object (LOB) in a database. An embodiment operates by identifying the LOB to be stored in an on-disk store of the database and determining the size of the LOB. Thereafter, an index vector for the on-disk store to include an identifier corresponding to the LOB is created. Additionally, a dictionary for the on-disk store to include a copy of the identifier and corresponding LOB data is also created. The LOB data corresponds to the LOB itself or a LOB location inside of the on-disk store based on the LOB's size.

    Database Processing After a Lock Condition
    3.
    发明申请

    公开(公告)号:US20170083538A1

    公开(公告)日:2017-03-23

    申请号:US14861438

    申请日:2015-09-22

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for performing database processing after a lock condition. An embodiment operates by receiving a release of a lock on data of a database. It is determined whether the data was modified by a processing of a first transaction associated with the first request. The lock is provided to a second transaction associated with a second request to access the data. If the first transaction did not modify the data, a second transaction associated with the second request is retried without refreshing a snapshot of the data. If the first transaction modified the data, the snapshot of the data is refreshed before the second transaction is retried.

    Test continuous log replay
    4.
    发明授权

    公开(公告)号:US11176004B2

    公开(公告)日:2021-11-16

    申请号:US16371889

    申请日:2019-04-01

    Applicant: SAP SE

    Abstract: A method, a system, and a computer program product for performing testing of continuous log replays in a database system. A redo log generated for a data record in a database is received. The redo log is indicative of a change in persistency of the data record in the database. Based on the change in persistency recorded in the redo log, a redo handler in the plurality of handlers is selected for execution of a replay of the received redo log. Using the selected redo log, replay of the redo log is executed to generate a state of the data record prior to the change in persistency recoded in the redo log.

    TEST CONTINUOUS LOG REPLAY
    5.
    发明申请

    公开(公告)号:US20200310925A1

    公开(公告)日:2020-10-01

    申请号:US16371889

    申请日:2019-04-01

    Applicant: SAP SE

    Abstract: A method, a system, and a computer program product for performing testing of continuous log replays in a database system. A redo log generated for a data record in a database is received. The redo log is indicative of a change in persistency of the data record in the database. Based on the change in persistency recorded in the redo log, a redo handler in the plurality of handlers is selected for execution of a replay of the received redo log. Using the selected redo log, replay of the redo log is executed to generate a state of the data record prior to the change in persistency recoded in the redo log.

    Database Recovery and Optimization with Batch Processing

    公开(公告)号:US20190317865A1

    公开(公告)日:2019-10-17

    申请号:US15953856

    申请日:2018-04-16

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for a database recovery and optimization with batch processing system. An embodiment operates by retrieving a database log that includes a plurality of operations for modifying data of a database stored across a plurality of tables. From the database log, a plurality of consecutive insert operations for inserting data into the database are identified. The consecutive insert operations are sorted by table. The sorted insert operations are grouped into a batch message. The batch message is transmit to the database for replay. An acknowledgement is received that the replay has completed.

    Database redo log optimization by skipping MVCC redo log records

    公开(公告)号:US10915413B2

    公开(公告)日:2021-02-09

    申请号:US15410701

    申请日:2017-01-19

    Applicant: SAP SE

    Abstract: Restoring of a database table in the database system (e.g., an in-memory insert-only database system, etc.) is initiated. Thereafter, a transaction log volume storing data log records and multi-version concurrency control (MVCC) log records corresponding to the database table is accessed. Based on such access, data log records corresponding to the database table are replayed while insert and update MVCC log records corresponding to the database table are skipped. Subsequently, restoring of the database table in the database system is finalized. Related apparatus, systems, techniques and articles are also described.

    Database processing after a lock condition

    公开(公告)号:US10706019B2

    公开(公告)日:2020-07-07

    申请号:US14861438

    申请日:2015-09-22

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for performing database processing after a lock condition. An embodiment operates by receiving a release of a lock on data of a database. It is determined whether the data was modified by a processing of a first transaction associated with the first request. The lock is provided to a second transaction associated with a second request to access the data. If the first transaction did not modify the data, a second transaction associated with the second request is retried without refreshing a snapshot of the data. If the first transaction modified the data, the snapshot of the data is refreshed before the second transaction is retried.

Patent Agency Ranking