-
公开(公告)号: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.
-
公开(公告)号: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
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.
-
公开(公告)号:US20240004855A1
公开(公告)日:2024-01-04
申请号:US18462513
申请日:2023-09-07
Applicant: SAP SE
Inventor: Michael BRENDLE , Norman MAY , Robert SCHULZE , Alexander BOEHM , Michael GROSSNIKLAUS , Guido MOERKOTTE
CPC classification number: G06F16/2282 , G06F11/3414 , G06F16/213 , G06F16/256
Abstract: According to some embodiments, methods and systems may be associated with a cloud computing environment. A workload prediction framework may receive observed workload information associated with a database in the cloud computing environment (e.g., a DataBase as a Service (“DBaaS”)). Based on the observed workload information, a Statement Arrival Rate (“SAR”) prediction may be generated. In addition, a host variable assignment prediction may be generated based on the observed workload information. The workload prediction framework may then use the SAR prediction and the host variable assignment prediction to automatically create a workload prediction for the database. A physical database design advisor (e.g., a table partitioning advisor) may receive the workload prediction and, responsive to the workload prediction, automatically generate a recommended physical layout for the database (e.g., using a cost model, the current physical layout, and an objective function).
-
公开(公告)号: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
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.
-
公开(公告)号:US20230306009A1
公开(公告)日:2023-09-28
申请号:US17705728
申请日:2022-03-28
Applicant: SAP SE
Inventor: Michael BRENDLE , Norman MAY , Robert SCHULZE , Alexander BOEHM , Michael GROSSNIKLAUS , Guido MOERKOTTE
CPC classification number: G06F16/2282 , G06F16/213 , G06F16/256 , G06F11/3414
Abstract: According to some embodiments, methods and systems may be associated with a cloud computing environment. A workload prediction framework may receive observed workload information associated with a database in the cloud computing environment (e.g., a DataBase as a Service (“DBaaS”)). Based on the observed workload information, a Statement Arrival Rate (“SAR”) prediction may be generated. In addition, a host variable assignment prediction may be generated based on the observed workload information. The workload prediction framework may then use the SAR prediction and the host variable assignment prediction to automatically create a workload prediction for the database. A physical database design advisor (e.g., a table partitioning advisor) may receive the workload prediction and, responsive to the workload prediction, automatically generate a recommended physical layout for the database (e.g., using a cost model, the current physical layout, and an objective function).
-
-
-
-
-