公开(公告)号：US11882008B1

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

申请号：US18063433

申请日：2022-12-08

Applicant: SAP SE

Inventor： Ruediger Karl ,  Norman May ,  Jaeyoung Choi ,  Hyogi Jung ,  Tobias Scheuer ,  Robin Joy ,  Patrick Voelker

IPC: H04L41/5009 ,  G06F9/50 ,  H04L9/40 ,  H04L41/0806

CPC classification number: H04L41/5009 ,  G06F9/505 ,  H04L63/1416 ,  G06F2209/504 ,  H04L41/0806

Abstract: Systems and methods include establishment of a first database session with a first database user, determine first session variable values associated with the first database session, the first session variable values including a first tenant value, determine a first workload class based on the first tenant value and on zero or more of the other first session variable values, the first workload class including first parameter values specifying first resource consumption limits, and manage resource consumption of the first database session based on the first parameter values.

公开(公告)号：US20160371329A1

公开(公告)日：2016-12-22

申请号：US14746193

申请日：2015-06-22

Applicant: SAP SE

Inventor： Christian Bensberg ,  Wolfgang Stephan ,  Robin Joy ,  Adrian Dragusanu

IPC: G06F17/30

CPC classification number: G06F16/24542 ,  G06F16/2456

Abstract: A computer-implemented method for preparing and executing a plan for a query containing joins against one or more tables having multiple partitions includes receiving a query containing joins to execute against one or more tables in a database, where at least one of the tables includes multiple partitions. Prior to executing the query, the method includes preparing a plan to join the multiple partitions using paths between the joined partitions and storing the plan in a cache. During execution of the query, the method includes analyzing one or more clauses of the query to determine which of the joined partitions to prune from the plan, removing from the plan the paths connecting the pruned partitions and executing the plan without the pruned partitions to return a result to the query.

Abstract translation: 一种用于准备和执行包含与具有多个分区的一个或多个表的联接的查询的计划的计算机实现的方法，包括接收包含连接以对数据库中的一个或多个表执行的查询，其中至少一个表包括多个 分区。 在执行查询之前，该方法包括准备使用连接的分区之间的路径来连接多个分区并将该计划存储在高速缓存中的计划。 在执行查询期间，该方法包括分析查询的一个或多个子句，以确定从计划中剪除哪个已连接的分区，从计划中删除连接已修剪分区的路径并执行计划，而不需要修剪的分区返回 查询的结果。