Invention Grant
- Patent Title: Database recovery and optimization with batch processing
-
Application No.: US15953856Application Date: 2018-04-16
-
Publication No.: US10824519B2Publication Date: 2020-11-03
- Inventor: Martin Heidel , Xin Liu , Christoph Roterring , Shiping Chen , Vivek Kandiyanallur , Stephan Kottler , Joern Schmidt
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Sterne, Kessler, Goldstein & Fox P.L.L.C.
- Main IPC: G06F11/14
- 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.
Public/Granted literature
- US20190317865A1 Database Recovery and Optimization with Batch Processing Public/Granted day:2019-10-17
Information query