-
公开(公告)号：US11630832B2
公开(公告)日：2023-04-18
申请号：US15616567
申请日：2017-06-07
申请人： SAP SE
发明人： Jaeyoung Choi , Chul Won Lee , Jeong Hee Won , Norman May
摘要： 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.
-
公开(公告)号：US20170322972A1
公开(公告)日：2017-11-09
申请号：US15150075
申请日：2016-05-09
申请人： SAP SE
发明人： Chul Won Lee , Juchang Lee , Myunggon Park , Wonyoung Kwak , Jeong Hee Won , Ki Hong Kim , Kyu Hwan Kim , Beomsoo Kim
IPC分类号： G06F17/30
CPC分类号： G06F16/24532 , G06F16/116 , G06F16/137 , G06F16/1727 , G06F16/21
摘要： Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.
-
公开(公告)号：US11829360B2
公开(公告)日：2023-11-28
申请号：US17678720
申请日：2022-02-23
申请人： SAP SE
发明人： Chul Won Lee , Juchang Lee , Myunggon Park , Wonyoung Kwak , Jeong Hee Won , Ki Hong Kim , Kyu Hwan Kim , Beomsoo Kim
IPC分类号： G06F16/2453 , G06F16/11 , G06F16/13 , G06F16/17 , G06F16/21
CPC分类号： G06F16/24532 , G06F16/116 , G06F16/137 , G06F16/1727 , G06F16/21
摘要： Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.
-
公开(公告)号：US11068506B2
公开(公告)日：2021-07-20
申请号：US15150815
申请日：2016-05-10
申请人： SAP SE
发明人： Chul Won Lee , Jeong Hee Won , Jaeyoung Choi , Nosub Sung
IPC分类号： G06F16/28 , G06F9/50 , G06F9/46 , G06F16/2455
摘要： 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.
-
公开(公告)号：US20200183929A1
公开(公告)日：2020-06-11
申请号：US16715882
申请日：2019-12-16
申请人： SAP SE
发明人： Chul Won Lee , Juchang Lee , Myunggon Park , Wonyoung Kwak , Jeong Hee Won , Ki Hong Kim , Kyu Hwan Kim , Beomsoo Kim
IPC分类号： G06F16/2453 , G06F16/21 , G06F16/17 , G06F16/13 , G06F16/11
摘要： Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.
-
公开(公告)号：US11663091B2
公开(公告)日：2023-05-30
申请号：US16222775
申请日：2018-12-17
申请人： SAP SE
发明人： Dongin Shin , Yeonghun Jeong , Jeong Hee Won , Juchang Lee
IPC分类号： G06F11/14 , G06F16/2455
CPC分类号： G06F11/1469 , G06F16/24552 , G06F2201/84
摘要： A client computer establishes one or more sessions with a DBMS. Session context information for each session is cached in a client-side session cache. When a session disconnection is detected, the session recovery includes establishing a new session with the DBMS, and restoring the session context of the disconnected session from the session information of the disconnected session that is stored in the session cache.
-
公开(公告)号：US20220179860A1
公开(公告)日：2022-06-09
申请号：US17678720
申请日：2022-02-23
申请人： SAP SE
发明人： Chul Won Lee , Juchang Lee , Myunggon Park , Wonyoung Kwak , Jeong Hee Won , Ki Hong Kim , Kyu Hwan Kim , Beomsoo Kim
IPC分类号： G06F16/2453 , G06F16/11 , G06F16/13 , G06F16/17 , G06F16/21
摘要： Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.
-
公开(公告)号：US20170329835A1
公开(公告)日：2017-11-16
申请号：US15150815
申请日：2016-05-10
申请人： SAP SE
发明人： Chul Won Lee , Jeong Hee Won , Jaeyoung Choi , Nosub Sung
CPC分类号： G06F16/283 , G06F9/466 , G06F9/5083 , G06F16/2455
摘要： 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.
-
公开(公告)号：US11294897B2
公开(公告)日：2022-04-05
申请号：US16715882
申请日：2019-12-16
申请人： SAP SE
发明人： Chul Won Lee , Juchang Lee , Myunggon Park , Wonyoung Kwak , Jeong Hee Won , Ki Hong Kim , Kyu Hwan Kim , Beomsoo Kim
IPC分类号： G06F16/2453 , G06F16/11 , G06F16/13 , G06F16/17 , G06F16/21
摘要： Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.
-
公开(公告)号：US10552413B2
公开(公告)日：2020-02-04
申请号：US15150075
申请日：2016-05-09
申请人： SAP SE
发明人： Chul Won Lee , Juchang Lee , Myunggon Park , Wonyoung Kwak , Jeong Hee Won , Ki Hong Kim , Kyu Hwan Kim , Beomsoo Kim
IPC分类号： G06F16/2453 , G06F16/11 , G06F16/13 , G06F16/17
摘要： Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.
-
-
-
-
-
-
-
-
-
搜索结果
11 条记录 (耗时 0.016 秒)
