Sap Se

Xin Liu

Vivek Kandiyanallur

Mihnea Andrei

Neeraj Kulkarni

Panfeng Zhou

Martin Heidel

Christoph Roterring

Shiping Chen

Joern Schmidt

Stephan Kottler

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.

Smart rollover

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 recovery and optimization with batch processing

Growing community of inventors

San Ramon, CA, United States of America

Xin Liu