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

公开(公告)号：US20180203771A1

公开(公告)日：2018-07-19

申请号：US15410701

申请日：2017-01-19

Applicant: SAP SE

Inventor： Martin Heidel ,  Andreas Tonder ,  Shiping Chen

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1471 ,  G06F16/211 ,  G06F2201/80

Abstract: Restoring of a database table in the database system (e.g., an in-memory insert-only database system, etc.) is initiated. Thereafter, a transaction log volume storing data log records and multi-version concurrency control (MVCC) log records corresponding to the database table is accessed. Based on such access, data log records corresponding to the database table are replayed while insert and update MVCC log records corresponding to the database table are skipped. Subsequently, restoring of the database table in the database system is finalized. Related apparatus, systems, techniques and articles are also 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.

公开(公告)号：US11249968B2

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

申请号：US15150301

申请日：2016-05-09

Applicant: SAP SE

Inventor： Thorsten Glebe ,  Martin Heidel ,  Michael Muehle ,  Felix Knittel ,  Reza Sherkat

IPC: G06F16/22 ,  G06F3/06

Abstract: A method, computer program product and system are provided. The method, computer program product and system execute a process for storing an object in an object container that is stored in a persistency of a disk storage. The object container has size criteria whereby objects meeting the size criteria of the object container can be assigned to the object container. The object container can facilitate storing multiple objects to optimize disk storage usage by facilitating the assigning of multiple objects to the same disk storage page.

公开(公告)号：US11170023B2

公开(公告)日：2021-11-09

申请号：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: G06F16/27 ,  G06F16/23 ,  G06F16/2455 ,  G06F11/20

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.

公开(公告)号：US10885062B2

公开(公告)日：2021-01-05

申请号：US15361337

申请日：2016-11-25

Applicant: SAP SE

Inventor： Mihnea Andrei ,  Christian Bensberg ,  Alexander Boehm ,  Adrian Dragusanu ,  Xun Chen ,  Reza Sherkat ,  Anisoara Nica ,  Martin Heidel ,  Rolando Blanco

IPC: G06F16/28 ,  G06F16/21

Abstract: Persisting data in logical tiers of an in-memory database based on aging rules of the database system. The database system can be configured to age data by moving the data from a first logical tier supporting high performance data access to a second logical tier supporting lower performance data access, thereby improving the operational efficiency of the database system.

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

公开(公告)号：US20170322960A1

公开(公告)日：2017-11-09

申请号：US15150301

申请日：2016-05-09

Applicant: SAP SE

Inventor： Thorsten Glebe ,  Martin Heidel ,  Michael Muehle ,  Felix Knittel ,  Reza Sherkat

IPC: G06F17/30 ,  G06F3/06

CPC classification number: G06F16/2228 ,  G06F3/0608 ,  G06F3/064 ,  G06F3/0674 ,  G06F16/2219

Abstract: A method, computer program product and system are provided. The method, computer program product and system execute a process for storing an object in an object container that is stored in a persistency of a disk storage. The object container has size criteria whereby objects meeting the size criteria of the object container can be assigned to the object container. The object container can facilitate storing multiple objects to optimize disk storage usage by facilitating the assigning of multiple objects to the same disk storage page.

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