TRANSACTION COMMIT PROTOCOL WITH RECOVERABLE COMMIT IDENTIFIER

    公开(公告)号:US20180232412A1

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

    申请号:US15430091

    申请日:2017-02-10

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating database system recovery in a distributed database environment having a master node and at least one slave node. The master node maintains an in-memory reference that includes transaction identifiers and their corresponding commit identifiers. When a slave node requests that a commit identifier be assigned to a transaction, the transaction and commit identifiers for the transaction are added to the in-memory reference. The commit identifier is sent by the master node to the slave node. The slave node writes a log entry to a commit log that includes the transaction identifier and the assigned commit identifier. If the database system is interrupted before the slave node writes the commit log entry, the slave node can request the commit identifier for the transaction from the master node, which retrieves the identifier from the in-memory reference.

    Global Database Transaction Management Service

    公开(公告)号:US20180075083A1

    公开(公告)日:2018-03-15

    申请号:US15261582

    申请日:2016-09-09

    Applicant: SAP SE

    CPC classification number: G06F16/2379 G06F9/466 G06F16/2343 G06F16/2365

    Abstract: A transaction management service layer monitors a plurality of read and write transactions being executed by the data engines by way of client libraries at each of a plurality of data engines. In addition, the transaction management server layer maintains and coordinates transaction timestamp and sequence numbers that are shared by the plurality of data engines. The transaction management service layer identifies and resolves conflicts among the plurality of transactions. The transaction management service layer is a separate and independent service that is isolated from other components of the plurality of data engines. Related apparatus, systems, techniques and articles are also described.

    Hybrid Database Concurrent Transaction Control

    公开(公告)号:US20180074919A1

    公开(公告)日:2018-03-15

    申请号:US15260943

    申请日:2016-09-09

    Applicant: SAP SE

    Abstract: A plurality of database modification statements are received as part of a database transaction that implicates data stored within a database. Thereafter, lock requests are initiated that requesting the database to lock the implicated data. At least one database operation by at least one of the database modification statements is then executed prior to receiving responses from at least a portion of the lock requests. After confirming that prior lock requests made by the transaction are successfully processed, a commit to make changes to the corresponding implicated data permanent is initiated. The implicated data can then be caused to be unlocked after the commit completes. Related apparatus, systems, techniques and articles are also described.

    MULTI-REPLICA ASYNCHRONOUS TABLE REPLICATION
    68.
    发明申请
    MULTI-REPLICA ASYNCHRONOUS TABLE REPLICATION 审中-公开
    多拷贝异常表复制

    公开(公告)号:US20160371357A1

    公开(公告)日:2016-12-22

    申请号:US14871675

    申请日:2015-09-30

    Applicant: SAP SE

    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.

    Abstract translation: 描述了在数据库环境中执行复制的技术。 在数据库事务在多个副本节点上进行复制的情况下,选择副本节点作为事务的协调器副本节点。 其他副本节点或节点被指定为事务的跟随复制节点。 当跟随者复制节点预先提交事务时,跟随者副本节点发送协调器副本节点预先通知。 协调器副本节点发送跟随者副本节点的后期通知,以便在交易已被事务被复制到的所有副本节点事先预先提交时提交事务。

Patent Agency Ranking