公开(公告)号：US20200320060A1

公开(公告)日：2020-10-08

申请号：US16373052

申请日：2019-04-02

Applicant: SAP SE

Inventor： SungGun Jung ,  Sukhyeun Cho ,  Taesik Yoon ,  Joern Schmidt

IPC: G06F16/23 ,  G06F16/22 ,  G06F16/2455

Abstract: A system includes reception of a query to update a partition key value of a first set of rows of a database table, determination that the updated partition key value is associated with a first partition of the database table stored on a first database server node, fetching of row identifiers of each of the first set of rows from two or more database server nodes in which each of the first set of rows is respectively stored, determination, based on the row identifiers, of a first subset of the first rows which are not stored on the first database server node and a second subset of the first rows which are stored on the first database server node, fetching of the first subset of rows from the database server nodes in which each of the first set of rows is respectively stored, update of the partition key value of each row of the fetched first subset of rows, instructing of the first database server node to store the updated rows of the fetched first subset in the first partition stored on the first database server node, and instructing of the first database server node to update the partition key value of each of the second subset of rows of the partition stored on the first database server node.

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

公开(公告)号：US09858310B2

公开(公告)日：2018-01-02

申请号：US14853260

申请日：2015-09-14

Applicant: SAP SE

Inventor： Martin Heidel ,  Ivan Schreter ,  Joern Schmidt

IPC: G06F17/00 ,  G06F17/30

CPC classification number: G06F17/30368 ,  G06F17/30371

Abstract: A database operation is initiated in an in-memory database that stores persistent data in a secondary storage and has at least one associated log. The database operation involves data having a size above a pre-defined threshold. Thereafter, the data is split into a plurality of chunks and the database operation is executed by parallelizing each chunk over a plurality of hierarchically arranged threads. Related systems, apparatus, methods and computer program products are also described.

公开(公告)号：US20170177700A1

公开(公告)日：2017-06-22

申请号：US14973596

申请日：2015-12-17

Applicant: SAP SE

Inventor： Christian Bensberg ,  Lars Fricke ,  Martin Heidel ,  Holger Bischoff ,  Joern Schmidt ,  Edward-Robert Tyercha ,  Andreas Tonder

IPC: G06F17/30

CPC classification number: G06F16/278 ,  G06F16/2282 ,  G06F16/2386

Abstract: An update to a partitioning column for a partitioned table in a database can be performed by handling rows for which the update will not require moving to a different partition separately (e.g. “locally”) for each partition followed by re-inserting those rows that will require moving to a different partition and deleting them from the original partition. The re-inserted rows are directed to a correct partition by application of the partitioning criteria for the table. Methods, articles, and systems are described.

公开(公告)号：US20170075943A1

公开(公告)日：2017-03-16

申请号：US14853260

申请日：2015-09-14

Applicant: SAP SE

Inventor： Martin Heidel ,  Ivan Schreter ,  Joern Schmidt

IPC: G06F17/30

CPC classification number: G06F17/30368 ,  G06F17/30371

Abstract: A database operation is initiated in an in-memory database that stores persistent data in a secondary storage and has at least one associated log. The database operation involves data having a size above a pre-defined threshold. Thereafter, the data is split into a plurality of chunks and the database operation is executed by parallelizing each chunk over a plurality of hierarchically arranged threads. Related systems, apparatus, methods and computer program products are also described.

Abstract translation: 数据库操作在内存数据库中启动，该数据库将持久数据存储在辅助存储器中，并具有至少一个关联的日志。 数据库操作涉及具有大于预定阈值的大小的数据。 此后，数据被分割成多个块，并且通过在多个分层布置的线程上并行化每个块来执行数据库操作。 还描述了相关的系统，装置，方法和计算机程序产品。

公开(公告)号：US11048692B2

公开(公告)日：2021-06-29

申请号：US16373052

申请日：2019-04-02

Applicant: SAP SE

Inventor： SungGun Jung ,  Sukhyeun Cho ,  Taesik Yoon ,  Joern Schmidt

IPC: G06F16/23 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/27

Abstract: A system includes reception of a query to update a partition key value of a first set of rows of a database table, determination, based on fetched row identifiers, of a first subset of the first rows which are not stored on the first database server node and a second subset of the first rows which are stored on the first database server node, fetching of the first subset of rows from the database server nodes, update of the partition key value of each row of the fetched first subset of rows, instructing of the first database server node to: store the updated rows of the fetched first subset in the first partition stored on the first database server node, and update the partition key value of each of the second subset of rows of the partition stored on the first database server node.

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

公开(公告)号：US10474697B2

公开(公告)日：2019-11-12

申请号：US14973596

申请日：2015-12-17

Applicant: SAP SE

Inventor： Christian Bensberg ,  Lars Fricke ,  Martin Heidel ,  Holger Bischoff ,  Joern Schmidt ,  Edward-Robert Tyercha ,  Andreas Tonder

IPC: G06F16/22 ,  G06F16/23 ,  G06F16/27

Abstract: An update to a partitioning column for a partitioned table in a database can be performed by handling rows for which the update will not require moving to a different partition separately (e.g. “locally”) for each partition followed by re-inserting those rows that will require moving to a different partition and deleting them from the original partition. The re-inserted rows are directed to a correct partition by application of the partitioning criteria for the table. Methods, articles, and systems are 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.

公开(公告)号：US20240111757A1

公开(公告)日：2024-04-04

申请号：US18530819

申请日：2023-12-06

Applicant: SAP SE

Inventor： Bernhard Scheirle ,  Andreas Tonder ,  Carsten Thiel ,  Guenter Radestock ,  Thomas Legler ,  Martin Heidel ,  Robert Schulze ,  Joern Schmidt ,  Rolando Blanco

IPC: G06F16/23

CPC classification number: G06F16/2379

Abstract: A method may include receiving a first transaction inserting a record into a database and a second transaction deleting the record from the database. A validity period for the record may be determined based on a first commit time at which the first transaction is committed and a second commit time at which the second transaction is committed. A current table and/or a history table of a system versioned table may be updated to include the record based on the validity period of the record. One or more temporal operations may be performed based on the system versioned table. For example, a time travel operation may be performed to retrieve, based on the system versioned table, one or more records that are valid at a given point in time. Related systems and computer program products are also provided.