Measuring Snapshot Delay Between Source Database System and Its Asynchronous Replica

    公开(公告)号:US20180246928A1

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

    申请号:US15442906

    申请日:2017-02-27

    Applicant: SAP SE

    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.

    Multi-Level Storage Architecture
    154.
    发明申请

    公开(公告)号:US20170351718A1

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

    申请号:US15682358

    申请日:2017-08-21

    Applicant: SAP SE

    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.

    DECENTRALIZED TRANSACTION COMMIT PROTOCOL
    155.
    发明申请

    公开(公告)号:US20170177698A1

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

    申请号:US14977427

    申请日:2015-12-21

    Applicant: SAP SE

    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.

    DISTRIBUTED DATABASE TRANSACTION PROTOCOL
    156.
    发明申请

    公开(公告)号:US20170177697A1

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

    申请号:US14977372

    申请日:2015-12-21

    Applicant: SAP SE

    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.

    TABLE REPLICATION IN A DATABASE ENVIRONMENT
    157.
    发明申请

    公开(公告)号:US20170177658A1

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

    申请号:US14975365

    申请日:2015-12-18

    Applicant: SAP SE

    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.

    ATOMIC VISIBILITY SWITCH FOR TRANSACTIONAL CACHE INVALIDATION

    公开(公告)号:US20170147638A1

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

    申请号:US14961309

    申请日:2015-12-07

    Applicant: SAP SE

    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.

    Hybrid Database Table Stored as Both Row and Column Store

    公开(公告)号:US20170097977A1

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

    申请号:US15380720

    申请日:2016-12-15

    Applicant: SAP SE

    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.

    UNIFIED TABLE QUERY PROCESSING
    160.
    发明申请
    UNIFIED TABLE QUERY PROCESSING 审中-公开
    统一表查询处理

    公开(公告)号:US20170004177A1

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

    申请号:US15260175

    申请日:2016-09-08

    Applicant: SAP SE

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

Patent Agency Ranking