公开(公告)号：US20230409731A1

公开(公告)日：2023-12-21

申请号：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/62 ,  H04L9/08

CPC classification number: G06F21/6227 ,  H04L9/0825 ,  H04L9/0822 ,  H04L9/0891

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.

公开(公告)号：US20240193006A1

公开(公告)日：2024-06-13

申请号：US18063451

申请日：2022-12-08

Applicant: SAP SE

Inventor： Robin JOY ,  Ruediger KARL ,  Norman MAY ,  Tobias SCHEUER ,  Patrick VOELKER ,  Jaeyoung CHOI ,  Hyogi JUNG

IPC: G06F9/50

CPC classification number: G06F9/5077 ,  G06F9/505 ,  G06F2209/5011 ,  G06F2209/5016

Abstract: Systems and methods include reception, at a database instance hosting a plurality of database tenants, of a statement for execution in a first database session associated with a first tenant, determination of first tenant-level resource limits associated with the database session, determination, for one or more resources, of a total amount consumed by the first database session, determination, based on the first tenant-level resource limits and the total amount of the one or more resources consumed by the first database session, of whether the statement can be executed by the database instance in compliance with the first tenant-level resource limits, and execution of the statement if it is determined that the statement can be executed by the database instance in compliance with the first tenant-level resource limits.

公开(公告)号：US20230004541A1

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

申请号：US17410234

申请日：2021-08-24

Applicant: SAP SE

Inventor： Patrick VOELKER ,  Alexander BOEHM ,  Mihnea ANDREI ,  Johannes ALBERTI

IPC: G06F16/22 ,  G06F16/23 ,  G06F11/14 ,  G06F16/25 ,  G06F16/21

Abstract: A computer-implemented method for database management is provided. The method comprises: receiving, from a client device, first data to be stored in a database system that comprises first data storage configured to store a data table and a deletion history table; storing the first data in second data storage that is external to the database system and that is in communication with the database system via a network; obtaining a link that enables access, via the network, to the first data stored in the second data storage; storing the link in the data table; and performing a deletion operation of the first data, in response to a request from the client device to delete the first data from the database system, wherein the deletion operation comprises: deleting the link from the data table without deleting the first data from the second data storage; and storing the link in the deletion history table with a timestamp corresponding to a point in time when the link is deleted from the data table.

公开(公告)号：US20240362354A1

公开(公告)日：2024-10-31

申请号：US18307244

申请日：2023-04-26

Applicant: SAP SE

Inventor： Hyunjun KIM ,  Patrick VOELKER ,  Urs KLINGSPORN ,  Yong Sik KWON ,  Jaeyoung CHOI ,  Myunggon PARK ,  Yeonghun JEONG ,  Yong Wook JEONG ,  Chawon KO ,  Yin LONG ,  Mihnea ANDREI

IPC: G06F21/62 ,  G06F21/60

CPC classification number: G06F21/6227 ,  G06F21/604 ,  G06F2221/2141

Abstract: Systems and methods include reception of a call to an application programming interface, the call comprising a request to create a database tenant in a database instance executing on a database platform, determination, at an operator executing on the database platform, to create the tenant based on the received call, retrieval, in response to the determination, by the operator of credentials of a tenant manager user from a storage external to the database platform, connection of the operator to the database instance using the credentials, transmission, from the operator to the database instance, of a Structured Query Language command to create the tenant and, in response to the command, creation of the tenant in the database instance.

公开(公告)号：US20230409730A1

公开(公告)日：2023-12-21

申请号：US17892597

申请日：2022-08-22

Applicant: SAP SE

Inventor： Mihnea ANDREI ,  Alexander BOEHM ,  Norman MAY ,  Urs KLINGSPORN ,  Meinolf BLOCK ,  Patrick VOELKER ,  Hyunjun KIM ,  Thorsten GLEBE ,  Jonathan BREGLER ,  Jaeyoung CHOI ,  Martin KITTEL ,  Yong Sik KWON ,  Uwe HAHN ,  Henning ZAHN ,  Melanie HANDRECK ,  Holger MACK ,  Eunsang KIM ,  Frank RENKES ,  Juchang LEE ,  Martin SCHINDEWOLF ,  Ivan BOWMAN ,  Lars DANNECKER

IPC: G06F21/62 ,  H04L9/14 ,  G06F21/60

CPC classification number: G06F21/6227 ,  H04L9/14 ,  G06F21/602

Abstract: Systems and methods include creation of a first instance of a tenant object in a database instance, association of the first instance of the tenant object with a first plurality of database artifacts including first data associated with the first instance of the tenant object, creation of a second instance of the tenant object in the database instance, association of the second instance of the tenant object with a second plurality of database artifacts including second data associated with the second instance of the tenant object, and reception and response to queries on the first data associated with the first instance of the tenant object and to queries on the second data associated with the second instance of the tenant object.

公开(公告)号：US20240356762A1

公开(公告)日：2024-10-24

申请号：US18303065

申请日：2023-04-19

Applicant: SAP SE

Inventor： Hyunjun KIM ,  Eunsang KIM ,  Jian LUO ,  Patrick VOELKER ,  Jaeyoung CHOI ,  Yong Sik KWON ,  Mihnea ANDREI

IPC: H04L9/32 ,  G06F16/21 ,  G06F21/62

CPC classification number: H04L9/3268 ,  G06F16/214 ,  G06F21/6218

Abstract: Systems and methods include reception of a request to move a first database tenant from a first database instance to a second database instance, the first database tenant comprising a first tenant object instance associated with a plurality of artifacts of the first database instance, the plurality of artifacts including a tenant-level catalog and data. In response to the request, the tenant-level catalog is exported from the first database instance to a shared storage system, the tenant-level catalog is imported to a second tenant of the second database instance from the shared storage system, the data is exported from the first database instance to the shared storage system, the data is imported to the second tenant of the second database instance from the shared storage system, and the first database tenant is dropped from the first database instance.

公开(公告)号：US20240281344A1

公开(公告)日：2024-08-22

申请号：US18185872

申请日：2023-03-17

Applicant: SAP SE

Inventor： Uwe HAHN ,  Eunsang KIM ,  Mihnea ANDREI ,  Werner THESING ,  Patrick VOELKER ,  Ruediger KARL ,  Yong Sik KWON ,  Jaeyoung CHOI ,  Jian LUO ,  Hyunjun KIM ,  Andre SCHEFE ,  Urs KLINGSPORN ,  Norman MAY

IPC: G06F11/14

CPC classification number: G06F11/1469 ,  G06F11/1451 ,  G06F11/1464

Abstract: Systems and methods include reception of an instruction to recover a first database tenant of a first database instance to a first point in time, the first database tenant associated with first database artifacts of the first database instance, and the first database instance including two or more database tenants and, in response to the instruction, creation of a second database instance, selection of backup data of the first database instance based on the first point in time, execution of a recovery of the backup data on the second database instance, export of second database artifacts of the first database tenant from the second database instance to a storage, truncation of the first database artifacts from the first database instance, import of the second database artifacts from the storage to the first database instance, and deletion of the second database instance.

公开(公告)号：US20240192996A1

公开(公告)日：2024-06-13

申请号：US18063472

申请日：2022-12-08

Applicant: SAP SE

Inventor： Robin JOY ,  Ruediger KARL ,  Norman MAY ,  Tobias SCHEUER ,  Patrick VOELKER ,  Jaeyoung CHOI ,  Hyogi JUNG

IPC: G06F9/50 ,  G06F16/21 ,  G06F21/62

CPC classification number: G06F9/505 ,  G06F16/211 ,  G06F21/6218

Abstract: Systems and methods include establishment of a first authenticated database session with a first database user of a database instance hosting a plurality of tenants, determination of a first tenant of the plurality of tenants based on a mapping of the first database user to the first tenant, determination of a first workload class based on the first tenant, and management of resource consumption of the first authenticated database session based on the first workload class.