公开(公告)号：US10769034B2

公开(公告)日：2020-09-08

申请号：US15452391

申请日：2017-03-07

Applicant: SAP SE

Inventor： Sarika Iyer ,  Vivek Kandiyanallur ,  Martin Heidel ,  Rolando Blanco ,  Stephan Kottler ,  Carsten Thiel ,  Peter Steinemann ,  Jörn Schmidt ,  Colin Florendo ,  Michael Muehle ,  Chaitanya Gottipati

IPC: G06F17/30 ,  G06F11/14 ,  G06F16/23 ,  G06F16/2453

Abstract: Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.

公开(公告)号：US20180260287A1

公开(公告)日：2018-09-13

申请号：US15452391

申请日：2017-03-07

Applicant: SAP SE

Inventor： Sarika Iyer ,  Vivek Kandiyanallur ,  Martin Heidel ,  Rolando Blanco ,  Stephan Kottler ,  Carsten Thiel ,  Peter Steinemann ,  Jörn Schmidt ,  Colin Florendo ,  Michael Muehle ,  Chaitanya Gottipati

IPC: G06F11/14 ,  G06F17/30

Abstract: Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.

公开(公告)号：US10824519B2

公开(公告)日：2020-11-03

申请号：US15953856

申请日：2018-04-16

Applicant: SAP SE

Inventor： Martin Heidel ,  Xin Liu ,  Christoph Roterring ,  Shiping Chen ,  Vivek Kandiyanallur ,  Stephan Kottler ,  Joern Schmidt

IPC: G06F11/14 ,  G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455

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.

公开(公告)号：US11176004B2

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

申请号：US16371889

申请日：2019-04-01

Applicant: SAP SE

Inventor： Stephan Kottler ,  Martin Heidel ,  Peter Steinemann ,  Thorsten Glebe ,  Johannes Haeussler

IPC: G06F16/00 ,  G06F11/00 ,  G06F11/14 ,  G06F16/23 ,  G06F16/20 ,  G06F16/22

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.

公开(公告)号：US20200310925A1

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

申请号：US16371889

申请日：2019-04-01

Applicant: SAP SE

Inventor： Stephan Kottler ,  Martin Heidel ,  Peter Steinemann ,  Thorsten Glebe ,  Johannes Haeussler

IPC: G06F11/14 ,  G06F16/23

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.

公开(公告)号：US20190317865A1

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

申请号：US15953856

申请日：2018-04-16

Applicant: SAP SE

Inventor： Martin Heidel ,  Xin Liu ,  Christoph Roterring ,  Shiping Chen ,  Vivek Kandiyanallur ,  Stephan Kottler ,  Joern Schmidt

IPC: G06F11/14 ,  G06F17/30

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.