公开(公告)号：US20180246928A1

公开(公告)日：2018-08-30

申请号：US15442906

申请日：2017-02-27

Applicant: SAP SE

Inventor： Kyu Hwan Kim ,  Deok Hoe Kim ,  Beomsoo Kim ,  Juchang Lee ,  Werner Thesing ,  Christoph Roterring

IPC: G06F17/30 ,  G06F11/14

Abstract: A computer implemented method is provided for determining a delay between a first database and an associated replicated database by replicating transactions of the first database in the replicated database, determining a delay between the two databases based on a commit timestamp from the first database and a timestamp associated with the commit transaction becoming visible in the replicated database. Then, after a predefined period of time has elapsed since replicating the commit transaction, determining a second delay based on a timestamp associated with a heartbeat log and a replicated database system time. And, selectively determining to execute or deny a statement received by the replicated database based on the second delay. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20180150496A1

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

申请号：US15361760

申请日：2016-11-28

Applicant: SAP SE

Inventor： Kyu Hwan Kim ,  Juchang Lee ,  Beomsoo Kim ,  Chang Gyoo Park ,  Reiner Singer ,  Christoph Rottering ,  Werner Thesing ,  Michael Muehle

IPC: G06F17/30

CPC classification number: G06F16/2322 ,  G06F16/2365 ,  G06F16/2379 ,  G06F16/2386 ,  G06F16/245 ,  G06F16/27 ,  G06F16/273

Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US09959178B2

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

申请号：US14657948

申请日：2015-03-13

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang-Gyoo Park ,  Hyoung-Jun Na ,  Kyu-Hwan Kim

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F11/1469 ,  G06F11/1464 ,  G06F17/30368 ,  G06F17/30371 ,  G06F17/30377 ,  G06F17/30575 ,  G06F17/30578 ,  G06F17/30876 ,  G06F2201/80

Abstract: Disclosed herein are system, method, and computer program product embodiments for replicating a database transaction to a replica table. An embodiment operates by receiving a replication log entry and an associated transaction commit log entry for a database transaction to be replayed to a row at a replica table. A row-ID value of the replication log entry is compared to a row-ID column value of the row at the replica table. The replication log entry is then replayed at a parallel log replayer based on the comparison. The database transaction is then committed to the replica table by replaying the associated transaction commit log entry at a transaction log replayer.

公开(公告)号：US20170351718A1

公开(公告)日：2017-12-07

申请号：US15682358

申请日：2017-08-21

Applicant: SAP SE

Inventor： Franz Faerber ,  Juchang Lee ,  Ivan Schreter

IPC: G06F17/30

CPC classification number: G06F16/215 ,  G06F16/21 ,  G06F16/217 ,  G06F16/221 ,  G06F16/23 ,  G06F16/2365

Abstract: Deleting a data record from the second level storage or main store is disclosed. A look-up is performed for the data record in the first level storage, where the data record is defined by a row identifier. If the row identifier is found in the first level storage, a look-up is performed for an updated row identifier representing an update of the data record in the second level storage and the main store, the update of the data record being defined by an updated row identifier. If the updated row identifier is found in the second level storage, an undo log is generated from the first level storage to invalidate a row identifier of the row identifier. A flag is generated representing an invalid updated row identifier, and a redo log is generated to restore the data record in the first level storage.

公开(公告)号：US20170177698A1

公开(公告)日：2017-06-22

申请号：US14977427

申请日：2015-12-21

Applicant: SAP SE

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

IPC: G06F17/30

CPC classification number: G06F17/30581 ,  G06F17/30351 ,  G06F17/30477

Abstract: Technologies are described for facilitating transaction processing within a database environment having first, second, and third database system nodes. In the database system, the first database system node receives from the second database system node a request to precommit a first database transaction. The first database system node stores information for the first database transaction that includes an indication that the second database system node coordinates the committing of the first database transaction. The first database system node receives from the third database system node a request to precommit a second database transaction. The first database system node stores information for the second database transaction that includes an indication that the third database system node coordinates the committing of the second database transaction.

公开(公告)号：US20170177697A1

公开(公告)日：2017-06-22

申请号：US14977372

申请日：2015-12-21

Applicant: SAP SE

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

IPC: G06F17/30 ,  H04L29/08

CPC classification number: G06F16/275 ,  G06F1/14 ,  G06F16/2322 ,  G06F16/2365 ,  G06F16/951 ,  H04L67/10

Abstract: Technologies are described for facilitating transaction processing within a database environment having a coordinator node, a first worker node, and at least a second worker node. The coordinator node receives local transaction tokens from the first and the at least a second worker nodes. The coordinator nodes determines a synchronized transaction token using at least the local transaction tokens from the first and the at least a second worker nodes. The coordinator node sends the synchronized transaction token to the first and the at least a second worker nodes.

公开(公告)号：US20170177658A1

公开(公告)日：2017-06-22

申请号：US14975365

申请日：2015-12-18

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Kyu Hwan Kim ,  Hyoung Jun Na ,  Deok Koo Kim ,  Joo Yeon Lee

IPC: G06F17/30 ,  G06F11/14

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

公开(公告)号：US20170147638A1

公开(公告)日：2017-05-25

申请号：US14961309

申请日：2015-12-07

Applicant: SAP SE

Inventor： Changgyoo Park ,  Yongjae Chuh ,  Juchang Lee ,  Norman May ,  Thomas Seufert ,  Hannes Jakschitsch

IPC: G06F17/30

CPC classification number: G06F16/24539 ,  G06F16/2282 ,  G06F16/2308 ,  G06F16/2379 ,  G06F16/24552

Abstract: Disclosed herein are system, method, and computer program product embodiments for efficiently providing transaction-consistent snapshots of data stored in or associated with a database stored within a database management system. An embodiment operates by receiving, at a source database, an update request to update data associated with a table stored at the source database. The embodiment continues by modifying a value of a modification-in-progress data structure corresponding to the table to indicate that a modification is in progress for the table, and that cached data associated with the table is invalid while the modification is in progress for the table and performing the table update based, at least, on information received in the update request. The embodiment further continues by updating a value of a commit identification counter, and subsequently a table time stamp associated with the table, to indicate that all cached data associated with the table having a time stamp older than the updated time stamp are invalid. The embodiment further continues by modifying the value of the modification-in-progress counter to indicate the completion of table modification.

公开(公告)号：US20170097977A1

公开(公告)日：2017-04-06

申请号：US15380720

申请日：2016-12-15

Applicant: SAP SE

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

IPC: G06F17/30

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.

公开(公告)号：US20170004177A1

公开(公告)日：2017-01-05

申请号：US15260175

申请日：2016-09-08

Applicant: SAP SE

Inventor： FRANZ FAERBER ,  Juchang Lee ,  Ivan Schreter

IPC: G06F17/30

CPC classification number: G06F16/24561 ,  G06F16/213 ,  G06F16/221 ,  G06F16/24 ,  G06F16/2455 ,  G06F16/2456

Abstract: A system and method of query processing in a multi-level storage system having a unified table architecture. A query is received by a common query execution engine connected with the unified table architecture, the query specifying a data record. The common query execution engine performs a look-up for the data record based on the query at the first level storage structure. If the data record is not present at the first level storage structure, the common query execution engine performs separate look-ups in each of the second level storage structure and the main store.

Abstract translation: 具有统一表架构的多级存储系统中的查询处理系统和方法。 与统一表架构相连的通用查询执行引擎接收到查询，查询指定数据记录。 普通查询执行引擎根据第一级存储结构的查询执行数据记录的查找。 如果第一级存储结构中不存在数据记录，则公共查询执行引擎在第二级存储结构和主存储中的每一个中执行单独的查找。