-
公开(公告)号：US11630832B2
公开(公告)日：2023-04-18
申请号：US15616567
申请日：2017-06-07
Applicant: SAP SE
Inventor： Jaeyoung Choi , Chul Won Lee , Jeong Hee Won , Norman May
Abstract: Technologies are described for facilitating the processing of requests for database operations within a database environment that includes one or more processing units and a memory. A utilization level of one or more computing resources of a database system is periodically determined. When a request for a database operation is received from a database client, it is determined, such as based on the utilization level, whether the database system has sufficient resources to process the request. If the database system does not have sufficient resources to process the request, the request is enqueued in a request queue for deferred execution. If it is later determined that the database system has sufficient resources to execute the request, the request can be dequeued, executed, and execution results returned to the database client.
-
公开(公告)号：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.
-
公开(公告)号：US10983965B2
公开(公告)日：2021-04-20
申请号：US16544739
申请日：2019-08-19
Applicant: SAP SE
Inventor： Chul Won Lee , Daniel Booss , Jaeyoung Choi , Werner Thesing
Abstract: Receiving a statement including requests for database operations in a secondary database system storing data replicated from a primary database system by replaying transaction output generated by the primary database system; responsive to receiving the statement, requesting an allocation of memory from the secondary database system to support the requested database operations; generating an aggregated statement memory consumption value based on the amount of memory consumed by all statements executing in the secondary database system that are not associated with replaying the transaction logs; determining that the requested allocation of memory in addition to the aggregated statement memory consumption value exceeds a total statement execution memory limit indicating a total amount of memory that may be allocated to all database operations associated with statement execution in a secondary database system, and denying the requested allocation of memory. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：US20180357291A1
公开(公告)日：2018-12-13
申请号：US15616567
申请日：2017-06-07
Applicant: SAP SE
Inventor： Jaeyoung Choi , Chul Won Lee , Jeong Hee Won , Norman May
IPC: G06F17/30
CPC classification number: G06F17/30563 , G06F17/30377
Abstract: Technologies are described for facilitating the processing of requests for database operations within a database environment that includes one or more processing units and a memory. A utilization level of one or more computing resources of a database system is periodically determined. When a request for a database operation is received from a database client, it is determined, such as based on the utilization level, whether the database system has sufficient resources to process the request. If the database system does not have sufficient resources to process the request, the request is enqueued in a request queue for deferred execution. If it is later determined that the database system has sufficient resources to execute the request, the request can be dequeued, executed, and execution results returned to the database client.
-
公开(公告)号：US20180246911A1
公开(公告)日：2018-08-30
申请号：US15444403
申请日：2017-02-28
Applicant: SAP SE
Inventor： Chul Won Lee , Daniel Booss , Jaeyoung Choi , Werner Thesing
CPC classification number: G06F16/21
Abstract: Receiving a statement including requests for database operations in a secondary database system storing data replicated from a primary database system by replaying transaction output generated by the primary database system; responsive to receiving the statement, requesting an allocation of memory from the secondary database system to support the requested database operations; generating an aggregated statement memory consumption value based on the amount of memory consumed by all statements executing in the secondary database system that are not associated with replaying the transaction logs; determining that the requested allocation of memory in addition to the aggregated statement memory consumption value exceeds a total statement execution memory limit indicating a total amount of memory that may be allocated to all database operations associated with statement execution in a secondary database system, and denying the requested allocation of memory. Related apparatus, systems, techniques and articles are also described.
-
Patent Agency Ranking
公开(公告)号：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.
-
公开(公告)号：US11068506B2
公开(公告)日：2021-07-20
申请号：US15150815
申请日：2016-05-10
Applicant: SAP SE
Inventor： Chul Won Lee , Jeong Hee Won , Jaeyoung Choi , Nosub Sung
IPC: G06F16/28 , G06F9/50 , G06F9/46 , G06F16/2455
Abstract: Technologies are described for facilitating transaction processing within a database environment that includes one or more processing units and a memory. A request for a database operation, such as a query, is received from a client. Execution statistics associated with the request are retrieved. At least some of the execution statistics are compared with one or more threshold values. Based on results of the comparing, the request is carried out with a first execution component or delegated to a second execution component. The request is executed and execution results are sent to the client.
-
公开(公告)号：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.
-
公开(公告)号：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.
-
公开(公告)号：US20170329835A1
公开(公告)日：2017-11-16
申请号：US15150815
申请日：2016-05-10
Applicant: SAP SE
Inventor： Chul Won Lee , Jeong Hee Won , Jaeyoung Choi , Nosub Sung
CPC classification number: G06F16/283 , G06F9/466 , G06F9/5083 , G06F16/2455
Abstract: Technologies are described for facilitating transaction processing within a database environment that includes one or more processing units and a memory. A request for a database operation, such as a query, is received from a client. Execution statistics associated with the request are retrieved. At least some of the execution statistics are compared with one or more threshold values. Based on results of the comparing, the request is carried out with a first execution component or delegated to a second execution component. The request is executed and execution results are sent to the client.
-
-
-
-
-
-
-
-
-
Search Results
13
records
(took 0.029 seconds)
