公开(公告)号：US11500928B2

公开(公告)日：2022-11-15

申请号：US16734907

申请日：2020-01-06

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Mihnea Andrei ,  Vivek Kandiyanallur ,  Xin Liu ,  Neeraj Kulkarni

IPC: G06F16/835 ,  G06F16/84 ,  G06F16/25 ,  G06F16/174 ,  G06F16/21 ,  G06F16/90 ,  G06F16/907

Abstract: A system and method, including determining, by a processor, a data type for each column of a database table; determining, by the processor and based on the determined data type for each column of the database table, an indication of a size of the database table; calculating, by the processor and based on the determined indication of the size of the database table, a start nbit size for a nbit compression process to be used on the database table; specifying, by the processor, the calculated start nbit size for the nbit compression process; and compressing the database table by executing the nbit data compression process using the specified start nbit size.

公开(公告)号：US10558704B2

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

申请号：US15692267

申请日：2017-08-31

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Mihnea Andrei ,  Vivek Kandiyanallur ,  Xin Liu ,  Neeraj Kulkarni

IPC: G06F16/00 ,  G06F16/835 ,  G06F16/84 ,  G06F16/25 ,  G06F16/174 ,  G06F16/21 ,  G06F16/90 ,  G06F16/907

Abstract: A system and method, including determining, by a processor, a data type for each column of a database table; determining, by the processor and based on the determined data type for each column of the database table, an indication of a size of the database table; calculating, by the processor and based on the determined indication of the size of the database table, a start nbit size for a nbit compression process to be used on the database table; specifying, by the processor, the calculated start nbit size for the nbit compression process; and compressing the database table by executing the nbit data compression process using the specified start nbit size.

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

公开(公告)号：US20190026387A1

公开(公告)日：2019-01-24

申请号：US15692267

申请日：2017-08-31

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Mihnea Andrei ,  Vivek Kandiyanallur ,  Xin Liu ,  Neeraj Kulkarni

IPC: G06F17/30

CPC classification number: G06F16/835 ,  G06F16/1744 ,  G06F16/21 ,  G06F16/258 ,  G06F16/86 ,  G06F16/90 ,  G06F16/907

Abstract: A system and method, including determining, by a processor, a data type for each column of a database table; determining, by the processor and based on the determined data type for each column of the database table, an indication of a size of the database table; calculating, by the processor and based on the determined indication of the size of the database table, a start nbit size for a nbit compression process to be used on the database table; specifying, by the processor, the calculated start nbit size for the nbit compression process; and compressing the database table by executing the nbit data compression process using the specified start nbit size.

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