-
公开(公告)号:US20200334226A1
公开(公告)日:2020-10-22
申请号:US16918057
申请日:2020-07-01
Applicant: SAP SE
Inventor: Chang Gyoo Park
IPC: G06F16/23 , G06F16/22 , G06F16/2455
Abstract: Lock table management is provided for a lock manager of a database system, in which lock management is provided in a manner that is fast and efficient, and that conserves processing, memory, and other computational resources. For example, the lock table management can use a hashmap in which keys and values are stored in separate arrays, which can be loaded into separate CPU cache lines.
-
公开(公告)号:US20200250169A1
公开(公告)日:2020-08-06
申请号:US16851227
申请日:2020-04-17
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyoung Jun Na
Abstract: Techniques are described for use in database and data management systems to efficiently capture and replicate changes that occur in database tables. The changes are captured in a transaction-consistent order, and in a format that may easily be searched and accessed using common relational queries.
-
公开(公告)号:US10733171B2
公开(公告)日:2020-08-04
申请号:US15944447
申请日:2018-04-03
Applicant: SAP SE
Inventor: Chang Gyoo Park
IPC: G06F16/23 , G06F16/22 , G06F16/2455
Abstract: Lock table management is provided for a lock manager of a database system, in which lock management is provided in a manner that is fast and efficient, and that conserves processing, memory, and other computational resources. For example, the lock table management can use a hashmap in which keys and values are stored in separate arrays, which can be loaded into separate CPU cache lines.
-
公开(公告)号:US10545995B2
公开(公告)日:2020-01-28
申请号:US15601008
申请日:2017-05-22
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyejeong Lee , Kyu Hwan Kim , Mihnea Andrei
Abstract: 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
Applicant: SAP SE
Inventor: Chang Gyoo Park , Deok Koo Kim , Kyu Hwan Kim , Juchang Lee
Abstract: 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.
-
公开(公告)号:US20180349418A1
公开(公告)日:2018-12-06
申请号:US15615196
申请日:2017-06-06
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park
CPC classification number: G06F17/30575 , G06F17/30283
Abstract: Technologies are described for facilitating the processing of requests for database operations in a distributed database environment. Criteria are defined for processing a request for a database operation according to first or second snapshot isolation protocols. A request for a database operation is received and it is determined if the snapshot isolation protocol criteria are met. If the criteria are met, the request can be processed using a local snapshot identifier value of a worker node. If the criteria are not met, the local snapshot identifier value is synchronized with another node, and the request processed using the updated snapshot identifier value.
-
公开(公告)号:US11874746B2
公开(公告)日:2024-01-16
申请号:US16944015
申请日:2020-07-30
Applicant: SAP SE
Inventor: Christian Bensberg , Steffen Geissinger , Juchang Lee , Chang Gyoo Park , Kyu Hwan Kim , Deok Koo Kim
IPC: G06F11/14
CPC classification number: G06F11/1464 , G06F2201/87
Abstract: Technologies are described for facilitating database system recovery in a distributed database environment having a master node and at least one slave node. The master node maintains an in-memory reference that includes transaction identifiers and their corresponding commit identifiers. When a slave node requests that a commit identifier be assigned to a transaction, the transaction and commit identifiers for the transaction are added to the in-memory reference. The commit identifier is sent by the master node to the slave node. The slave node writes a log entry to a commit log that includes the transaction identifier and the assigned commit identifier. If the database system is interrupted before the slave node writes the commit log entry, the slave node can request the commit identifier for the transaction from the master node, which retrieves the identifier from the in-memory reference.
-
公开(公告)号:US11734253B2
公开(公告)日:2023-08-22
申请号:US17701185
申请日:2022-03-22
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyoung Jun Na
CPC classification number: G06F16/2358 , G06F16/2282 , G06F16/27 , G06F16/284
Abstract: Techniques are described for use in database and data management systems to efficiently capture and replicate changes that occur in database tables. The changes are captured in a transaction-consistent order, and in a format that may easily be searched and accessed using common relational queries.
-
公开(公告)号:US11681684B2
公开(公告)日:2023-06-20
申请号:US17150868
申请日:2021-01-15
Applicant: SAP SE
Inventor: Juchang Lee , Deok Koo Kim , Chang Gyoo Park , Nosub Sung
CPC classification number: G06F16/2365 , G06F16/28
Abstract: Technologies are described for facilitating transaction processing in a distributed database environment. A database client sends database operations to a slave node, which mediates execution of the transaction. A connection between the database client and the slave node is associated with an identifier, and the transaction has an identifier. The database client sends a commit request to a master node over a network connection between the master node and the database client. The commit request includes the transaction identifier. The commit request can also include an indication of database nodes executing operations in the transaction.
-
公开(公告)号:US20220276991A1
公开(公告)日:2022-09-01
申请号:US17746326
申请日:2022-05-17
Applicant: SAP SE
Inventor: Chang Gyoo Park
IPC: G06F16/23 , G06F16/2455 , G06F16/22
Abstract: Lock table management is provided for a lock manager of a database system, in which lock management is provided in a manner that is fast and efficient, and that conserves processing, memory, and other computational resources. For example, the lock table management can use a hashmap in which keys and values are stored in separate arrays, which can be loaded into separate CPU cache lines.
-
-
-
-
-
-
-
-
-