-
公开(公告)号:US20200257672A1
公开(公告)日:2020-08-13
申请号:US16730528
申请日:2019-12-30
Applicant: SAP SE
Inventor: Juchang Lee , Joo Yeon Lee , Michael Muehle , Myung Sun Park , Hyoung Jun Na
IPC: G06F16/23 , G06F16/21 , G06F15/167 , G06F9/46
Abstract: Technologies are described for facilitating transaction processing within a database environment. A commit protocol provides for the atomic commit or rollback of a transaction that includes an operation that modifies a metadata entity of the database system and one or more other operations that modify metadata entities or data records of the database system. Innovations are provided for detecting and resolving deadlocks that may arise during transaction processing. Innovations are also provided for providing versioning of metadata entities, including invalidating metadata entities cached at a slave node during the commit at a master node of a transaction that creates a new version of the metadata entity.
-
公开(公告)号:US10698892B2
公开(公告)日:2020-06-30
申请号:US15950013
申请日:2018-04-10
Applicant: SAP SE
Inventor: Nosub Sung , Myunggon Park , Taehyung Lee , Chul Won Lee , Juchang Lee , Sung Heun Wi
IPC: G06F15/16 , G06F16/2453 , G06F16/14 , G06F16/2455
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.
-
公开(公告)号:US10585873B2
公开(公告)日:2020-03-10
申请号:US15589740
申请日:2017-05-08
Applicant: SAP SE
Inventor: Juchang Lee , Joo Yeon Lee , Michael Muehle , Myung Sun Park , Hyoung Jun Na
IPC: G06F16/23 , G06F9/46 , G06F15/167 , G06F16/21
Abstract: Technologies are described for facilitating transaction processing within a database environment. A commit protocol provides for the atomic commit or rollback of a transaction that includes an operation that modifies a metadata entity of the database system and one or more other operations that modify metadata entities or data records of the database system. Innovations are provided for detecting and resolving deadlocks that may arise during transaction processing. Innovations are also provided for providing versioning of metadata entities, including invalidating metadata entities cached at a slave node during the commit at a master node of a transaction that creates a new version of the metadata entity.
-
公开(公告)号:US20190236081A1
公开(公告)日:2019-08-01
申请号:US16376963
申请日:2019-04-05
Applicant: SAP SE
Inventor: Chang Gyoo Park , Deok Koo Kim , Kyu Hwan Kim , Juchang Lee
IPC: G06F16/27 , G06F16/2458 , G06F16/23 , G06F16/951 , G06F16/28
CPC classification number: G06F16/273 , G06F11/1451 , G06F16/2343 , G06F16/2379 , G06F16/2471 , G06F16/285 , G06F16/951
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.
-
公开(公告)号:US20190222658A1
公开(公告)日:2019-07-18
申请号: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/08 , G06F16/2455 , G06F16/20
CPC classification number: H04L67/22 , G06F16/20 , G06F16/2455 , H04L45/742
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.
-
公开(公告)号:US10346298B2
公开(公告)日:2019-07-09
申请号:US15231553
申请日:2016-08-08
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Jaeyun Noh , Wolfgang Stephan , Hyungyu Shin , Seongyun Ko
Abstract: Technologies for performing garbage collection in database systems, such as multi-version concurrency control (MVCC) database systems, are described. For example, different garbage collection techniques can be used separately or in various combinations, including interval garbage collection, group garbage collection, table garbage collection, and combinations. For example, a particular type of combination, called hybrid garbage collection, uses technique from interval garbage collection and group garbage collection, or from interval, group, and table garbage collection.
-
公开(公告)号:US10275401B2
公开(公告)日:2019-04-30
申请号: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: G06F16/27 , G06F16/23 , G06F16/2455 , G06F16/903
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.
-
公开(公告)号:US20190108182A1
公开(公告)日:2019-04-11
申请号:US16212915
申请日:2018-12-07
Applicant: SAP SE
Inventor: Frank Renkes , Juchang Lee
IPC: G06F16/332 , G06F16/35 , G06F16/34
Abstract: A system, method and computer product for managing distributed transactions of a database. A transaction manager is provided for each of a plurality of transactions of the database. Each transaction manager is configured to perform functions that include generating a transaction token that specifies data to be visible for a transaction on the database. The database contains both row and column storage engines, and the transaction token includes a transaction identifier (TID) for identifying committed transactions and uncommitted transactions. A last computed transaction is designated with a computed identifier (CID), record-level locking of records of the database is performed using the TID and CID to execute the transaction, and the plurality of transactions of the database are executed with each transaction manager.
-
公开(公告)号:US20190005105A1
公开(公告)日:2019-01-03
申请号:US16122617
申请日:2018-09-05
Applicant: SAP SE
Inventor: Chang Gyoo Park , Juchang Lee , Kyu Hwan Kim , Hyoung Jun Na , Hyejeong Lee
Abstract: Technologies are described for performing replication within a database environment. Where a database transaction is replicated at multiple replica nodes, a replica node is selected as a coordinator replica node for the transaction. The other replica node or nodes are designated as follower replica nodes for the transaction. A follower replica node sends the coordinator replica node a precommit notification when the follower replica node has precommitted the transaction. The coordinator replica node sends the follower replica node a postcommit notification to commit the transaction when the transaction has been precommitted by all of the replica nodes to which the transaction is to be replicated.
-
公开(公告)号:US10169439B2
公开(公告)日:2019-01-01
申请号:US14871717
申请日:2015-09-30
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyoung Jun Na
Abstract: Technologies are described for performing replication within a database environment. Where database operations are carried out at multiple source nodes, the operations can be ordered by the source node on which they were executable prior to being replayed at a replica node. In addition, the operations can be precommitted, so that the operations can be reviewed by a replayer at the replica node before the transaction containing the operations has been fully committed.
-
-
-
-
-
-
-
-
-