-
公开(公告)号：US10554771B2
公开(公告)日：2020-02-04
申请号：US16362286
申请日：2019-03-22
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.
-
公开(公告)号：US10275508B2
公开(公告)日：2019-04-30
申请号：US14946757
申请日：2015-11-19
Applicant: SAP SE
Inventor： Christian Bensberg , Norman May , Alexander Boehm , Juchang Lee , Sung Heun Wi , Jeong Ae Han , Ki Hong Kim , Kyu Hwan Kim , Chul Won Lee , Andreas Kemmler , Christoph Glania , Armin Risch , Kai Morich
IPC: G06F17/30
Abstract: A method may include receiving a query for data to be provided by a database server, wherein the query includes an indication of a maximum lag. The method may further include determining whether a hint is available to apply to the query, wherein the hint affects an execution of the query. When no hint is available, a baseline database server may be selected to be the database server. When the hint is available, a replication server or a cache server may be selected to be the database server based on the hint and the maximum lag. The query may be processed at the selected database server.
-
公开(公告)号：US11829360B2
公开(公告)日：2023-11-28
申请号：US17678720
申请日：2022-02-23
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
CPC classification number: G06F16/24532 , G06F16/116 , G06F16/137 , G06F16/1727 , 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.
-
公开(公告)号：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.
-
公开(公告)号：US20200183929A1
公开(公告)日：2020-06-11
申请号：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/21 , G06F16/17 , G06F16/13 , G06F16/11
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.
-
Patent Agency Ranking
公开(公告)号：US10592528B2
公开(公告)日：2020-03-17
申请号：US15442838
申请日：2017-02-27
Applicant: SAP SE
Inventor： Chul Won Lee , Juchang Lee , Hyogi Jung
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.
-
公开(公告)号：US20180152455A1
公开(公告)日：2018-05-31
申请号：US15363102
申请日：2016-11-29
Applicant: SAP SE
Inventor： Chul Won Lee , Min Ji Yoon
Abstract: A computer system is configured to provide a database system. The computer system comprises 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. The secondary database system is capable of providing at least a minimum amount of essential functionality of the primary database system during a disruption to the primary database system. The secondary database system is configured by programming instructions, executable on the computer system, to cause the one or more processors to accept an authentication request from the client application to allow user access to the secondary database to execute the query and delegate an authentication check to the primary database system using connection credentials received from the client application. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：US20180150504A1
公开(公告)日：2018-05-31
申请号：US15364649
申请日：2016-11-30
Applicant: SAP SE
Inventor： Chul Won Lee , Kyu Hwan Kim , Marcel Birn , Jane Jung Lee , Di Wu , Juchang Lee , Zhi Qiao
IPC: G06F17/30
CPC classification number: G06F17/30377 , G06F17/30283 , G06F17/30353 , G06F17/30365 , G06F17/30368 , G06F17/30477 , G06F17/30964
Abstract: A computer implemented method for initializing a first image of a first database from a recovery image; modifying the first image of the first database by replaying transaction logs of a second database; establishing a connection with a client; receiving a query via the connection, the query including a transaction to be executed on the first database; and rejecting the query when the transaction would cause any one of: updating of the first image of the first database; generating a new transaction log; and modifying the recovery image. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：US12013772B2
公开(公告)日：2024-06-18
申请号：US17554755
申请日：2021-12-17
Applicant: SAP SE
Inventor： Sunyoung Han , Young Hun Kim , Jongheon Park , Ye Fan , Guanghui Qiu , Hui Feng , Chul Won Lee
CPC classification number: G06F11/3495 , G06F9/485
Abstract: Some embodiments include a system, method, and non-transitory medium, with the system including an interface to at least one database product; a stateless ping operator to manage lifecycle events associated with the at least one database product; and a first product-specific ping agent to determine an availability of and generate metrics associated with a plurality of instances of a first specific database product of the at least one database product monitored by the first product-specific ping agent, the first product-specific ping agent receiving an assignment of the plurality of instances of the first specific database product to monitor from the ping operator.
-
公开(公告)号：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.
-
-
-
-
-
-
-
-
-
Search Results
32
records
(took 0.02 seconds)
