Patents by Inventor Hyoung-Jun Na
Hyoung-Jun Na has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 11734253Abstract: 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.Type: GrantFiled: March 22, 2022Date of Patent: August 22, 2023Assignee: SAP SEInventors: Juchang Lee, Chang Gyoo Park, Hyoung Jun Na
-
Publication number: 20220215011Abstract: 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.Type: ApplicationFiled: March 22, 2022Publication date: July 7, 2022Inventors: Juchang Lee, Chang Gyoo Park, Hyoung Jun Na
-
Patent number: 11327958Abstract: Technologies are described for performing replication of data within a database environment having a source node and a replica node. The source node executes a database operation on at least one database table stored by the source node. The source node asynchronously sends the database operation to the replica node. A prepare commit request is synchronously sent from the source node to the replica node. The source node receives a synchronous precommit acknowledgement from the replica node. The precommit acknowledgement indicates that the database operation was executed at the replica node. The source node commits a transaction associated with the database operation.Type: GrantFiled: August 27, 2020Date of Patent: May 10, 2022Assignee: SAP SEInventors: Juchang Lee, Chang Gyoo Park, Kyu Hwan Kim, Hyoung Jun Na, Deok Koo Kim, Joo Yeon Lee
-
Patent number: 11314716Abstract: 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.Type: GrantFiled: December 30, 2019Date of Patent: April 26, 2022Assignee: SAP SEInventors: Juchang Lee, Joo Yeon Lee, Michael Muehle, Myung Sun Park, Hyoung Jun Na
-
Patent number: 11308070Abstract: 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.Type: GrantFiled: April 17, 2020Date of Patent: April 19, 2022Assignee: SAP SEInventors: Juchang Lee, Chang Gyoo Park, Hyoung Jun Na
-
Patent number: 11263236Abstract: RTR of a database transaction to a replica table may include receiving replication and transaction commit log entries (representing a database transaction). The replication log entry has a row-ID value, and the row at the replica table has a row-ID value. The replication log entry may be dispatched to a parallel log replayer and the associated transaction commit log entry to a transaction commit log replayer. The row-ID values may be compared, and the replication log entry is replayed at the parallel log replayer based on the comparison. The database transaction may then be committed to the replica table by replaying the associated transaction commit log entry at the transaction log replayer, wherein the database transaction is associated with row-level parallel replay having transactional consistency and DDL replication and reconstruction of a DDL statement at the replica system is associated with one or multiple metadata update log entries.Type: GrantFiled: November 18, 2019Date of Patent: March 1, 2022Assignee: SAP SEInventors: Juchang Lee, Seoyoon Choi, Eunsang Kim, Kyu Hwan Kim, Joo Yeon Lee, Hyoung Jun Na
-
Publication number: 20210149915Abstract: RTR of a database transaction to a replica table may include receiving replication and transaction commit log entries (representing a database transaction). The replication log entry has a row-ID value, and the row at the replica table has a row-ID value. The replication log entry may be dispatched to a parallel log replayer and the associated transaction commit log entry to a transaction commit log replayer. The row-ID values may be compared, and the replication log entry is replayed at the parallel log replayer based on the comparison. The database transaction may then be committed to the replica table by replaying the associated transaction commit log entry at the transaction log replayer, wherein the database transaction is associated with row-level parallel replay having transactional consistency and DDL replication and reconstruction of a DDL statement at the replica system is associated with one or multiple metadata update log entries.Type: ApplicationFiled: November 18, 2019Publication date: May 20, 2021Inventors: Juchang Lee, Seoyoon Choi, Eunsang Kim, Kyu Hwan Kim, Joo Yeon Lee, Hyoung Jun Na
-
Publication number: 20200394182Abstract: Technologies are described for performing replication of data within a database environment having a source node and a replica node. The source node executes a database operation on at least one database table stored by the source node. The source node asynchronously sends the database operation to the replica node. A prepare commit request is synchronously sent from the source node to the replica node. The source node receives a synchronous precommit acknowledgement from the replica node. The precommit acknowledgement indicates that the database operation was executed at the replica node. The source node commits a transaction associated with the database operation.Type: ApplicationFiled: August 27, 2020Publication date: December 17, 2020Applicant: SAP SEInventors: Juchang Lee, Chang Gyoo Park, Kyu Hwan Kim, Hyoung Jun Na, Deok Koo Kim, Joo Yeon Lee
-
Patent number: 10866967Abstract: 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.Type: GrantFiled: September 5, 2018Date of Patent: December 15, 2020Assignee: SAP SEInventors: Chang Gyoo Park, Juchang Lee, Kyu Hwan Kim, Hyoung Jun Na, Hyejeong Lee
-
Patent number: 10860612Abstract: Disclosed herein are system, method, and computer readable device embodiments for parallel replication of databases across row-store and column-store table formats. An embodiment operates by maintaining a replication log and a storage-level recovery log formatted according to separate respective log formats, logging a record-level SQL execution result, and replicating at least one database table from a primary server to at least one replica server. The primary server and the at least one replica server may each be configured to store data according to one table format of a row-store table format and a column-store table format, such that the primary server's table format is different from the at least one replica server's table format.Type: GrantFiled: June 21, 2018Date of Patent: December 8, 2020Assignee: SAP SEInventors: Juchang Lee, Hyoung Jun Na, Kyu Hwan Kim, Deok Hoe Kim, Chang Gyoo Park
-
Patent number: 10795881Abstract: Technologies are described for performing replication of data within a database environment having a source node and a replica node. The source node executes a database operation on at least one database table stored by the source node. The source node asynchronously sends the database operation to the replica node. A prepare commit request is synchronously sent from the source node to the replica node. The source node receives a synchronous precommit acknowledgement from the replica node. The precommit acknowledgement indicates that the database operation was executed at the replica node. The source node commits a transaction associated with the database operation.Type: GrantFiled: December 18, 2015Date of Patent: October 6, 2020Assignee: SAP SEInventors: Juchang Lee, Chang Gyoo Park, Kyu Hwan Kim, Hyoung Jun Na, Deok Koo Kim, Joo Yeon Lee
-
Publication number: 20200257672Abstract: 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.Type: ApplicationFiled: December 30, 2019Publication date: August 13, 2020Applicant: SAP SEInventors: Juchang Lee, Joo Yeon Lee, Michael Muehle, Myung Sun Park, Hyoung Jun Na
-
Publication number: 20200250169Abstract: 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.Type: ApplicationFiled: April 17, 2020Publication date: August 6, 2020Inventors: Juchang Lee, Chang Gyoo Park, Hyoung Jun Na
-
Patent number: 10664465Abstract: 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.Type: GrantFiled: April 3, 2018Date of Patent: May 26, 2020Assignee: SAP SEInventors: Juchang Lee, Chang Gyoo Park, Hyoung Jun Na
-
Patent number: 10585873Abstract: 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.Type: GrantFiled: May 8, 2017Date of Patent: March 10, 2020Assignee: SAP SEInventors: Juchang Lee, Joo Yeon Lee, Michael Muehle, Myung Sun Park, Hyoung Jun Na
-
Publication number: 20190325055Abstract: Disclosed herein are system, method, and computer readable device embodiments for parallel replication of databases across row-store and column-store table formats. An embodiment operates by maintaining a replication log and a storage-level recovery log formatted according to separate respective log formats, logging a record-level SQL execution result, and replicating at least one database table from a primary server to at least one replica server. The primary server and the at least one replica server may each be configured to store data according to one table format of a row-store table format and a column-store table format, such that the primary server's table format is different from the at least one replica server's table format.Type: ApplicationFiled: June 21, 2018Publication date: October 24, 2019Inventors: Juchang LEE, Hyoung Jun NA, Kyu Hwan KIM, Deok Hoe KIM, Chang Gyoo PARK
-
Publication number: 20190303470Abstract: 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.Type: ApplicationFiled: April 3, 2018Publication date: October 3, 2019Inventors: Juchang Lee, Chang Gyoo Park, Hyoung Jun Na
-
Publication number: 20190005105Abstract: 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.Type: ApplicationFiled: September 5, 2018Publication date: January 3, 2019Applicant: SAP SEInventors: Chang Gyoo Park, Juchang Lee, Kyu Hwan Kim, Hyoung Jun Na, Hyejeong Lee
-
Patent number: 10169439Abstract: 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.Type: GrantFiled: September 30, 2015Date of Patent: January 1, 2019Assignee: SAP SEInventors: Juchang Lee, Chang Gyoo Park, Hyoung Jun Na
-
Publication number: 20180322156Abstract: 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.Type: ApplicationFiled: May 8, 2017Publication date: November 8, 2018Applicant: SAP SEInventors: Juchang Lee, Joo Yeon Lee, Michael Muehle, Myung Sun Park, Hyoung Jun Na