-
公开(公告)号：US11599543B2
公开(公告)日：2023-03-07
申请号：US17826060
申请日：2022-05-26
申请人： SAP SE
发明人： 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
摘要： 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.
-
公开(公告)号：US11036540B2
公开(公告)日：2021-06-15
申请号：US16223888
申请日：2018-12-18
申请人： SAP SE
发明人： Kyu Hwan Kim , Juchang Lee
摘要： Innovations in the area of server-side processing when committing transactions to disk in a distributed database system can improve computational efficiency at database nodes and/or reduce network bandwidth utilization. For example, when transactions are committed in a database system, at a master node of the database system, a server uses different threads for certain processor-intensive operations and certain I/O-intensive operations. Or, as another example, when transactions are committed in a database system, at a master node of the database system, a server groups jobs for I/O requests.
-
3.发明申请公开(公告)号：US20200320051A1
公开(公告)日：2020-10-08
申请号：US16372644
申请日：2019-04-02
申请人： SAP SE
发明人： Juchang Lee , Hyejeong Lee , Kyu Hwan Kim , Friedrich Keller , Mihnea Andrei
摘要： Implementations of the present disclosure include providing, at each node in a set of nodes of a database system, a table partition of a plurality of table partitions, the plurality of table partitions being provided by partitioning a table using a primary key, providing, at each node in the set of nodes of the database system, a secondary index partition of a plurality of secondary index partitions, each secondary index partition including a replicate table of at least a portion of the table, the plurality of secondary index partitions being provided by partitioning the table using one or more secondary keys, and for at least one operation executed on a table partition, executing a replication protocol to replicate the at least one operation on a secondary index partition that corresponds to the table partition.
-
公开(公告)号：US10545995B2
公开(公告)日：2020-01-28
申请号：US15601008
申请日：2017-05-22
申请人： SAP SE
发明人： Juchang Lee , Chang Gyoo Park , Hyejeong Lee , Kyu Hwan Kim , Mihnea Andrei
摘要： An oldest version timestamp is received from a first database. A current commit timestamp is received from a second database configured to asynchronously replicate the first database. The current global commit timestamp corresponds to a commit transaction executed in the first database and subsequently replicated in the second database. A first test query is then issued to the second database including a request for a current timestamp of the second database. A second test query is issued to the primary database requesting records associated with a target update version that has a target timestamp equal to the current snapshot timestamp. A determination is then made that a first return associated with the first test query and a second return associated with the second test query are identical indicating a successful validation. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：US10296632B2
公开(公告)日：2019-05-21
申请号：US14871765
申请日：2015-09-30
申请人： SAP SE
发明人： Chang Gyoo Park , Deok Koo Kim , Kyu Hwan Kim , Juchang Lee
摘要： Technologies are described for performing synchronization within a database environment. A source host stores multiple database tables and a replica host stores copies of the multiple database tables. During synchronization, replication log replay is blocked at the replica node, and a multithreaded process locks the multiple database tables of the source hosts, reactivates replication log generation for each of the multiple database tables, and then unlocks the database tables. A synchronization timestamp is acquired and used to synchronize the multiple database tables with the copies of the multiple database tables. After synchronization, replication log replay is reactivated at the replica host for the copies of the multiple database tables.
-
公开(公告)号：US20190121657A1
公开(公告)日：2019-04-25
申请号：US16223888
申请日：2018-12-18
申请人： SAP SE
发明人： Kyu Hwan Kim , Juchang Lee
摘要： Innovations in the area of server-side processing when committing transactions to disk in a distributed database system can improve computational efficiency at database nodes and/or reduce network bandwidth utilization. For example, when transactions are committed in a database system, at a master node of the database system, a server uses different threads for certain processor-intensive operations and certain I/O-intensive operations. Or, as another example, when transactions are committed in a database system, at a master node of the database system, a server groups jobs for I/O requests.
-
公开(公告)号：US20180150360A1
公开(公告)日：2018-05-31
申请号：US15361946
申请日：2016-11-28
申请人： SAP SE
发明人： Yong Sik Kwon , Hyeong Seog Kim , Kyu Hwan Kim , Seyeong Bae , Joo Yeon Lee , Beomsoo Kim , Juchang Lee , Marcel Birn
CPC分类号： G06F11/1451 , G06F17/30309 , G06F17/30371 , G06F2201/84
摘要： A computer implemented method is provided. The method comprises initializing a first database image of a first database system based on a recovery image comprising committed transactions, visible uncommitted transactions, and undo logs associated with the visible uncommitted transactions, undoing the visible uncommitted transactions using the undo logs, generating redo logs from the undo logs, replaying the redo logs to create invisible uncommitted transactions, and after replaying the redo logs, replaying transaction logs received from a second database system. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：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.
-
公开(公告)号：US11914572B2
公开(公告)日：2024-02-27
申请号：US18087712
申请日：2022-12-22
申请人： SAP SE
发明人： Juchang Lee , Kyu Hwan Kim , Joo Yeon Lee , Kyungyul Park , Deok Hoe Kim
IPC分类号： G06F16/23 , G06F16/248 , G06F16/27 , G06F16/2458 , G06F11/20 , H04L67/1095 , G06F11/16
CPC分类号： G06F16/2329 , G06F11/2035 , G06F11/2094 , G06F11/2097 , G06F16/2322 , G06F16/2379 , G06F16/248 , G06F16/2471 , G06F16/27 , H04L67/1095 , G06F11/1658 , G06F11/2048 , G06F2201/80
摘要： Technologies are described providing adaptive query routing in a replicated database environment. The technologies can be used with a variety of replication protocols. Prepared statements, such as for queries, from a database client can be routed to a source node, or a source node and available replica nodes, when a replica node becomes unavailable. When a replica node becomes available again, a prepared statement can be updated to indicate that the updated prepared statement can be executed at nodes including the replica node that is available again. Prepared statement routing can also be used when a portion of replicated data becomes unavailable at a replica node, but a portion of replicated data remains available.
-
公开(公告)号：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.
-
-
-
-
-
-
-
-
-
搜索结果
62 条记录 (耗时 0.027 秒)
