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

公开(公告)号：US20210318834A1

公开(公告)日：2021-10-14

申请号：US16896033

申请日：2020-06-08

Applicant: SAP SE

Inventor： Vivek Kandiyanallur ,  Jia Feng ,  Alexander Chernavin ,  Chitong Chung ,  Shyam Sunder Reddy Avula ,  Xin Guo ,  Scott Hamilton ,  Clay Jacobs ,  Christopher de Castro ,  Kaushik Ghosh

IPC: G06F3/06

Abstract: A distributed storage system includes a primary storage system and a secondary storage system. The secondary storage system stores the actual data and the primary storage system stores metadata for the actual data. The metadata references at the primary storage system may be deleted without deleting the corresponding data at the secondary storage system. Snapshots of the metadata at the primary storage system are sent to the secondary storage system. The secondary storage system can compare two metadata snapshots received from the primary storage in order to determine whether data stored at the secondary storage system has been deleted at the primary storage system for longer than a retention period. Such data may be deleted to free up storage space at the secondary storage server.

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

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