公开(公告)号：US12147558B2

公开(公告)日：2024-11-19

申请号：US17968136

申请日：2022-10-18

Applicant: SAP SE

Inventor： Patrick Voelker ,  Holger Mack ,  Meinolf Block ,  Thorsten Glebe ,  Mihnea Andrei ,  Yong Sik Kwon ,  Dirk Thomsen ,  Martin Schindewolf ,  Martin Kittel ,  Myung Sun Park ,  Beomsoo Kim ,  Martin Heidel ,  Christian Bensberg ,  Fabian Garagnon ,  Michael Muehle ,  Sergej Hardock ,  Johannes Beigel ,  Sascha Zorn ,  Christoph Hohner ,  Andreas Hartel

IPC: G06F21/00 ,  G06F21/62 ,  H04L9/08

Abstract: A database system includes a persistent storage system, a memory storing metadata defining a tenant object and a plurality of database artifacts, a first instance of the tenant object, the first instance associated with a first plurality of the database artifacts including first data associated with the first instance of the tenant object, and a second instance of the tenant object, the second instance associated with a second plurality of the database artifacts including second data associated with the second instance of the tenant object. A processing unit is to execute program code of a database instance to cause the database system to encrypt the first data associated with the first instance of the tenant object using a first public encryption key and store the encrypted first data in the persistent storage system, and encrypt the second data associated with the second instance of the tenant object using a second public encryption key and store the encrypted second data in the persistent storage system.

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

公开(公告)号：US11886424B2

公开(公告)日：2024-01-30

申请号：US17481644

申请日：2021-09-22

Applicant: SAP SE

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

IPC: G06F16/20 ,  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.

公开(公告)号：US20230086162A1

公开(公告)日：2023-03-23

申请号：US17481644

申请日：2021-09-22

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

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.

公开(公告)号：US10769034B2

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

申请号：US15452391

申请日：2017-03-07

Applicant: SAP SE

Inventor： Sarika Iyer ,  Vivek Kandiyanallur ,  Martin Heidel ,  Rolando Blanco ,  Stephan Kottler ,  Carsten Thiel ,  Peter Steinemann ,  Jörn Schmidt ,  Colin Florendo ,  Michael Muehle ,  Chaitanya Gottipati

IPC: G06F17/30 ,  G06F11/14 ,  G06F16/23 ,  G06F16/2453

Abstract: Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.

公开(公告)号：US10565228B2

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

申请号：US15451322

申请日：2017-03-06

Applicant: SAP SE

Inventor： Martin Heidel ,  Michael Muehle ,  Reiner Singer ,  Johannes Haeussler ,  Timo Hochberger ,  Mohamed Ali Chriki ,  Sascha Bastke

IPC: G06F17/00 ,  G06F16/27 ,  G06F11/14 ,  G06F11/36

Abstract: Testing a database replication system within a multi-container system architecture comprises receiving a first request for creating a database recovery system within a multi-container system architecture. The multi-container system architecture is configured to contain a plurality of tenant databases and a system database, and the database recovery system includes a primary system and a secondary system. The primary system is then identified from the information in the first request. Upon identification, a first tenant database included in the plurality of tenant databases is determined that corresponds to the identified primary system. Upon determining the first tenant database, a second tenant database of the plurality of tenant database is generated that corresponds to the secondary system, and which is enabled to test replicating information that would otherwise be associated with the first tenant database. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US10534797B2

公开(公告)日：2020-01-14

申请号：US15365693

申请日：2016-11-30

Applicant: SAP SE

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

IPC: G06F16/27 ,  G06F16/23

Abstract: A first store and a second store can be configured to store a first partition of a table of a database and a second partition of the table of the database, respectively. A database management system can be configured to at least update at least a first portion of the first partition where the update includes an update to a first primary key column in the first partition and verify that the first primary key column is unique across the first partition and the second partition. A first row having a first primary key value of the first primary key column from the first partition can be deleted, when the first primary key value in the first partition conflicts with a second primary key value of a second primary key column in the second partition.

公开(公告)号：US20180260287A1

公开(公告)日：2018-09-13

申请号：US15452391

申请日：2017-03-07

Applicant: SAP SE

Inventor： Sarika Iyer ,  Vivek Kandiyanallur ,  Martin Heidel ,  Rolando Blanco ,  Stephan Kottler ,  Carsten Thiel ,  Peter Steinemann ,  Jörn Schmidt ,  Colin Florendo ,  Michael Muehle ,  Chaitanya Gottipati

IPC: G06F11/14 ,  G06F17/30

Abstract: Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.

公开(公告)号：US20180150544A1

公开(公告)日：2018-05-31

申请号：US15365693

申请日：2016-11-30

Applicant: SAP SE

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

IPC: G06F17/30

CPC classification number: G06F16/278 ,  G06F16/2365 ,  G06F16/2379

Abstract: A first store and a second store can be configured to store a first partition of a table of a database and a second partition of the table of the database, respectively. A database management system can be configured to at least update at least a first portion of the first partition where the update includes an update to a first primary key column in the first partition and verify that the first primary key column is unique across the first partition and the second partition. A first row having a first primary key value of the first primary key column from the first partition can be deleted, when the first primary key value in the first partition conflicts with a second primary key value of a second primary key column in the second partition.