公开(公告)号：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.

公开(公告)号：US20180246948A1

公开(公告)日：2018-08-30

申请号：US15445593

申请日：2017-02-28

Applicant: SAP SE

Inventor： Colin Florendo ,  Michael Muehle ,  Thorsten Glebe ,  Rolando Blanco ,  Chaitanya Gottipati ,  Nirvik Basak ,  Martin Heidel ,  Peter Steinemann ,  Vivek Kandiyanallur ,  Shiping Chen ,  Sarika Iyer ,  Jörn Schmidt

IPC: G06F17/30

CPC classification number: G06F16/273 ,  G06F11/2094 ,  G06F11/2097 ,  G06F16/2365 ,  G06F16/2455 ,  G06F2201/80 ,  G06F2201/855

Abstract: A computer implemented method for manipulating data comprises receiving log transaction information from a primary database system at a secondary database system and parsing the log transaction information to identify data objects that have been modified on the primary database system. The secondary database system determines whether the data objects are present in main memory on the secondary database system and whether the log transaction corresponds to a data manipulation language (DML) query or a data definition language (DDL) query. If the data objects are not in the main memory and the query is a DML query, they are copied from persistence data volumes to the main memory. The data objects in main memory are modified by replaying the log transactions on the data objects in the main memory. Then, the data objects in the persistence data volumes are modified. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US10915413B2

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

申请号：US15410701

申请日：2017-01-19

Applicant: SAP SE

Inventor： Martin Heidel ,  Andreas Tonder ,  Shiping Chen

IPC: G06F11/14 ,  G06F16/21

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.

公开(公告)号：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.

公开(公告)号：US20180203771A1

公开(公告)日：2018-07-19

申请号：US15410701

申请日：2017-01-19

Applicant: SAP SE

Inventor： Martin Heidel ,  Andreas Tonder ,  Shiping Chen

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1471 ,  G06F16/211 ,  G06F2201/80

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.

公开(公告)号：US20180150539A1

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

申请号：US15365396

申请日：2016-11-30

Applicant: SAP SE

Inventor： Mihnea Andrei ,  Rolando Blanco ,  Shiping Chen ,  Martin Heidel ,  Vivek Kandiyanallur ,  Thomas Peh ,  Joern Schmidt ,  Liang Song ,  Peter Steinemann

IPC: G06F17/30

CPC classification number: G06F16/2379 ,  G06F16/2358

Abstract: A computer implemented method for manipulating data comprises receiving log transaction information from a primary database system at a secondary database system and parsing the log transaction information to identify data objects that have been modified on the primary database system. The secondary database system determines whether the data objects are present in main memory on the secondary database system. If the data objects are not in the main memory, they are copied from persistence data volumes to the main memory. The data objects are modified by replaying the log transactions on the data objects in the main memory. Then, the data objects in the persistence data volumes are modified. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US11170023B2

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

申请号：US15445593

申请日：2017-02-28

Applicant: SAP SE

Inventor： Colin Florendo ,  Michael Muehle ,  Thorsten Glebe ,  Rolando Blanco ,  Chaitanya Gottipati ,  Nirvik Basak ,  Martin Heidel ,  Peter Steinemann ,  Vivek Kandiyanallur ,  Shiping Chen ,  Sarika Iyer ,  Jörn Schmidt

IPC: G06F16/27 ,  G06F16/23 ,  G06F16/2455 ,  G06F11/20

Abstract: A computer implemented method for manipulating data comprises receiving log transaction information from a primary database system at a secondary database system and parsing the log transaction information to identify data objects that have been modified on the primary database system. The secondary database system determines whether the data objects are present in main memory on the secondary database system and whether the log transaction corresponds to a data manipulation language (DML) query or a data definition language (DDL) query. If the data objects are not in the main memory and the query is a DML query, they are copied from persistence data volumes to the main memory. The data objects in main memory are modified by replaying the log transactions on the data objects in the main memory. Then, the data objects in the persistence data volumes are modified. Related apparatus, systems, techniques and articles are also described.