公开(公告)号：US10977227B2

公开(公告)日：2021-04-13

申请号：US15615196

申请日：2017-06-06

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park

IPC: G06F16/00 ,  G06F16/21 ,  G06F11/14 ,  G06F16/27 ,  G06F11/20 ,  G06F16/185

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.

公开(公告)号：US20200320051A1

公开(公告)日：2020-10-08

申请号：US16372644

申请日：2019-04-02

Applicant: SAP SE

Inventor： Juchang Lee ,  Hyejeong Lee ,  Kyu Hwan Kim ,  Friedrich Keller ,  Mihnea Andrei

IPC: G06F16/22 ,  G06F16/27

Abstract: 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.

公开(公告)号：US20200250169A1

公开(公告)日：2020-08-06

申请号：US16851227

申请日：2020-04-17

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Hyoung Jun Na

IPC: G06F16/23 ,  G06F16/27 ,  G06F16/28 ,  G06F16/22

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.

公开(公告)号：US10545995B2

公开(公告)日：2020-01-28

申请号：US15601008

申请日：2017-05-22

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Hyejeong Lee ,  Kyu Hwan Kim ,  Mihnea Andrei

IPC: G06F16/00 ,  G06F16/27 ,  G06F16/21 ,  G06F16/23 ,  G06F16/2455 ,  G06F11/36

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.

公开(公告)号：US20190324648A1

公开(公告)日：2019-10-24

申请号：US16503122

申请日：2019-07-03

Applicant: SAP SE

Inventor： Yong Sik Kwon ,  Jaeyun Noh ,  Juchang Lee ,  Ji Hoon Jang ,  Sang Kyun Cha

IPC: G06F3/06 ,  G06F9/54 ,  G06F9/46

Abstract: Technologies are described for restarting an application while maintaining data in memory (e.g., using shared memory). For example, shared memory can be associated with an application. The shared memory can also be associated with a holder process to maintain the shared memory from the time the application stops to the time the application starts again. When the application starts, the shared memory can be associated with the started application. In addition, restart of in-memory databases can be provided using shared memory. For example, in-memory data can be maintained when a database process or database management system stops and starts (e.g., during a restart).

公开(公告)号：US10346383B2

公开(公告)日：2019-07-09

申请号：US15260181

申请日：2016-09-08

Applicant: SAP SE

Inventor： Yongsik Yoon ,  Chanho Jeong ,  Juchang Lee ,  Chang Bin Song ,  Yong Sik Kwon ,  Sang Kyun Cha

IPC: G06F16/27 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/9535 ,  G06F16/23 ,  G06F16/22

Abstract: A hybrid database table is stored as both a row and a column store. One or more techniques may be employed alone or in combination to enhance performance of the hybrid table by regulating access to, and/or the size of, the processing-intensive column store data. For example during an insert operation, the column store data may be searched for a uniqueness violation only after certain filtering and/or boundary conditions have been considered. In another technique, a hybrid table manager may control movement of data to the column store based upon considerations such as frequency of access, or underlying business logic. In still another technique, querying of the hybrid table may result in a search of the column store data only after an initial search of row store data fails to return a result.

公开(公告)号：US10296632B2

公开(公告)日：2019-05-21

申请号：US14871765

申请日：2015-09-30

Applicant: SAP SE

Inventor： Chang Gyoo Park ,  Deok Koo Kim ,  Kyu Hwan Kim ,  Juchang Lee

IPC: G06F7/00 ,  G06F17/00 ,  G06F17/30 ,  G06F11/14

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.

公开(公告)号：US20190121657A1

公开(公告)日：2019-04-25

申请号：US16223888

申请日：2018-12-18

Applicant: SAP SE

Inventor： Kyu Hwan Kim ,  Juchang Lee

IPC: G06F9/46 ,  G06F16/22 ,  G06F16/23 ,  G06F3/06

Abstract: 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.

公开(公告)号：US20180349418A1

公开(公告)日：2018-12-06

申请号：US15615196

申请日：2017-06-06

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park

IPC: G06F17/30 ,  G06F11/14

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.

公开(公告)号：US20180150360A1

公开(公告)日：2018-05-31

申请号：US15361946

申请日：2016-11-28

Applicant: SAP SE

Inventor： Yong Sik Kwon ,  Hyeong Seog Kim ,  Kyu Hwan Kim ,  Seyeong Bae ,  Joo Yeon Lee ,  Beomsoo Kim ,  Juchang Lee ,  Marcel Birn

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1451 ,  G06F17/30309 ,  G06F17/30371 ,  G06F2201/84

Abstract: 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.