公开(公告)号：US11599543B2

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

申请号：US17826060

申请日：2022-05-26

Applicant: SAP SE

Inventor： Jaeyoung Choi ,  Deok Hoe Kim ,  Kyu Hwan Kim ,  Chae Kwang Lee ,  Jane Jung Lee ,  Juchang Lee

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/248 ,  G06F16/2453

Abstract: Technologies are described for routing structured query language (SQL) statements to elastic compute nodes (ECNs) using workload classes within a distributed database environment. The elastic compute nodes do not store persistent database tables. For example, a SQL statement can be received for execution within the distributed database environment. A workload class can be identified that matches properties of the SQL statement. Based on the workload class, a routing location hint can be obtained that identifies a set of elastic compute nodes. The SQL statement can then be routed to one of the identified elastic compute nodes for execution. Execution of the SQL statement at the elastic compute node can involve retrieving database data from other nodes which store persistent database tables.

公开(公告)号：US11288272B2

公开(公告)日：2022-03-29

申请号：US16406945

申请日：2019-05-08

Applicant: SAP SE

Inventor： Chae Kwang Lee ,  Juchang Lee ,  Jaeyoung Choi

IPC: G06F7/00 ,  G06F16/2455 ,  G06F9/48

Abstract: In some embodiments, a method detects a cancelation of a query for an application that is running. The query is being performed on a database system. The method processes the cancellation to determine one or more threads associated with the query and sends a signal to the one or more threads that are associated with the process to suspend the one or more threads. One or more signal handlers for the one or more threads are called and an exception is thrown by the one or more signal handlers to cancel the query. The exception causes the query to be canceled.

公开(公告)号：US11379483B1

公开(公告)日：2022-07-05

申请号：US17217412

申请日：2021-03-30

Applicant: SAP SE

Inventor： Jaeyoung Choi ,  Deok Hoe Kim ,  Kyu Hwan Kim ,  Chae Kwang Lee ,  Jane Jung Lee ,  Juchang Lee

IPC: G06F16/2455 ,  G06F16/22 ,  G06F16/248 ,  G06F16/2453

Abstract: Technologies are described for routing structured query language (SQL) statements to elastic compute nodes (ECNs) using workload classes within a distributed database environment. The elastic compute nodes do not store persistent database tables. For example, a SQL statement can be received for execution within the distributed database environment. A workload class can be identified that matches properties of the SQL statement. Based on the workload class, a routing location hint can be obtained that identifies a set of elastic compute nodes. The SQL statement can then be routed to one of the identified elastic compute nodes for execution. Execution of the SQL statement at the elastic compute node can involve retrieving database data from other nodes which store persistent database tables.

公开(公告)号：US20220318249A1

公开(公告)日：2022-10-06

申请号：US17826060

申请日：2022-05-26

Applicant: SAP SE

Inventor： Jaeyoung Choi ,  Deok Hoe Kim ,  Kyu Hwan Kim ,  Chae Kwang Lee ,  Jane Jung Lee ,  Juchang Lee

IPC: G06F16/2455 ,  G06F16/2453 ,  G06F16/22 ,  G06F16/248

Abstract: Technologies are described for routing structured query language (SQL) statements to elastic compute nodes (ECNs) using workload classes within a distributed database environment. The elastic compute nodes do not store persistent database tables. For example, a SQL statement can be received for execution within the distributed database environment. A workload class can be identified that matches properties of the SQL statement. Based on the workload class, a routing location hint can be obtained that identifies a set of elastic compute nodes. The SQL statement can then be routed to one of the identified elastic compute nodes for execution. Execution of the SQL statement at the elastic compute node can involve retrieving database data from other nodes which store persistent database tables.