-
公开(公告)号：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.
-
公开(公告)号：US11294897B2
公开(公告)日：2022-04-05
申请号：US16715882
申请日：2019-12-16
Applicant: SAP SE
Inventor： 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
Abstract: 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.
-
公开(公告)号：US10884887B2
公开(公告)日：2021-01-05
申请号：US16190019
申请日：2018-11-13
Applicant: SAP SE
Inventor： Chul Won Lee , Yong Wook Jeong , Min Ji Yoon , Ian McHardy , Abhishek Singhi , Jeff Albion , Rich Jones
Abstract: Systems, techniques, and articles are described herein for workload shifting in a database system. A computer system is configured to provide a database system and includes one or more processors, a primary database system implemented by the one or more processors, and a secondary database system implemented by the one or more processors. The secondary database system is configured as a hot-standby system for the primary database system and is capable of providing at least a minimum amount of essential functionality of the primary database system during a disruption. The primary database system is configured by programming instructions, executable on the computer system, to cause the one or more processors to determine from a query request from a client application directed to the primary database system that workload from a query may be shifted to the secondary database system and instruct the client application to execute the query.
-
公开(公告)号：US10552413B2
公开(公告)日：2020-02-04
申请号：US15150075
申请日：2016-05-09
Applicant: SAP SE
Inventor： 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
Abstract: 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.
-
公开(公告)号：US20190311057A1
公开(公告)日：2019-10-10
申请号：US15950013
申请日：2018-04-10
Applicant: SAP SE
Inventor： Nosub Sung , Myunggon Park , Taehyung Lee , Chul Won Lee , Juchang Lee , Sung Heun Wi
IPC: G06F17/30
Abstract: A process is provided for independently hashing and filtering a data set, such as during preprocessing. For the data set, one or more records, separately having one or more fields, may be identified. A record hash value set, containing one or more record hash values for the respective one or more records, may be generated. Generating a given record hash value may be accomplished as follows. For a given record, a hash value set may be generated, having one or more field hash values for the respective one or more fields of the given record. The record hash value for the given record may be generated based on the hash value set. A total hash value for the data set may be generated based on the record hash value set. The records of the data set may be filtered based on classification of the query that generated the records.
-
Patent Agency Ranking
公开(公告)号：US10298702B2
公开(公告)日：2019-05-21
申请号：US15202366
申请日：2016-07-05
Applicant: SAP SE
Inventor： Chang Gyoo Park , Juchang Lee , Kyu Hwan Kim , Chul Won Lee , Myunggon Park , Eunjin Song , Nosub Sung
IPC: H04L29/06 , H04L29/08 , G06F16/20 , G06F16/2455 , H04L12/747
Abstract: Technologies are described for facilitating replay of requests for database operations. A plurality of requests for database operations are received. Each of the plurality of requests includes a type, an access unit identifier, and a chronological identifier. Execution dependencies are determined between the plurality of requests based on the type, access unit identifier, and chronological identifier of each of the plurality of requests. The execution dependencies are stored.
-
公开(公告)号：US20190079841A1
公开(公告)日：2019-03-14
申请号：US16190019
申请日：2018-11-13
Applicant: SAP SE
Inventor： Chul Won Lee , Yong Wook Jeong , Min Ji Yoon , Ian McHardy , Abhishek Singhi , Jeff Albion , Rich Jones
Abstract: Systems, techniques, and articles are described herein for workload shifting in a database system. A computer system is configured to provide a database system and includes one or more processors, a primary database system implemented by the one or more processors, and a secondary database system implemented by the one or more processors. The secondary database system is configured as a hot-standby system for the primary database system and is capable of providing at least a minimum amount of essential functionality of the primary database system during a disruption. The primary database system is configured by programming instructions, executable on the computer system, to cause the one or more processors to determine from a query request from a client application directed to the primary database system that workload from a query may be shifted to the secondary database system and instruct the client application to execute the query.
-
公开(公告)号：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.
-
公开(公告)号：US20180246945A1
公开(公告)日：2018-08-30
申请号：US15442838
申请日：2017-02-27
Applicant: SAP SE
Inventor： Chul Won Lee , Juchang Lee , Hyogi Jung
IPC: G06F17/30
Abstract: A computer implemented method is provided for capturing and replaying a database workload by obtaining a workload capture file comprising execution context information generated in a database system and replayable to replicate the workload, generating a modified workload capture file by generating modified execution context information, replaying the modified workload capture file by generating at least one read statement based on the modified workload execution information and issuing at least one read statement to a primary database system having an associated secondary database system, determining that the at least one read statement may be routed to the secondary database system for execution, and routing the read statement to the secondary database system for execution. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：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.
-
-
-
-
-
-
-
-
-
Search Results
32
records
(took 0.032 seconds)
