ATOMIC PROCESSING OF COMPOUND DATABASE TRANSACTIONS THAT MODIFY A METADATA ENTITY

    公开(公告)号:US20200257672A1

    公开(公告)日:2020-08-13

    申请号:US16730528

    申请日:2019-12-30

    Applicant: SAP SE

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

    Order-independent multi-record hash generation and data filtering

    公开(公告)号:US10698892B2

    公开(公告)日:2020-06-30

    申请号:US15950013

    申请日:2018-04-10

    Applicant: SAP SE

    Abstract: A process is provided for independently hashing and filtering a data set, such as during preprocessing. For the data set, one or more records, separately having one or more fields, may be identified. A record hash value set, containing one or more record hash values for the respective one or more records, may be generated. Generating a given record hash value may be accomplished as follows. For a given record, a hash value set may be generated, having one or more field hash values for the respective one or more fields of the given record. The record hash value for the given record may be generated based on the hash value set. A total hash value for the data set may be generated based on the record hash value set. The records of the data set may be filtered based on classification of the query that generated the records.

    Atomic processing of compound database transactions that modify a metadata entity

    公开(公告)号:US10585873B2

    公开(公告)日:2020-03-10

    申请号:US15589740

    申请日:2017-05-08

    Applicant: SAP SE

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

    Write access control in a database
    147.
    发明授权

    公开(公告)号:US10275401B2

    公开(公告)日:2019-04-30

    申请号:US15364649

    申请日:2016-11-30

    Applicant: SAP SE

    Abstract: A computer implemented method for initializing a first image of a first database from a recovery image; modifying the first image of the first database by replaying transaction logs of a second database; establishing a connection with a client; receiving a query via the connection, the query including a transaction to be executed on the first database; and rejecting the query when the transaction would cause any one of: updating of the first image of the first database; generating a new transaction log; and modifying the recovery image. Related apparatus, systems, techniques and articles are also described.

    Distributed Transaction Management With Tokens
    148.
    发明申请

    公开(公告)号:US20190108182A1

    公开(公告)日:2019-04-11

    申请号:US16212915

    申请日:2018-12-07

    Applicant: SAP SE

    Abstract: A system, method and computer product for managing distributed transactions of a database. A transaction manager is provided for each of a plurality of transactions of the database. Each transaction manager is configured to perform functions that include generating a transaction token that specifies data to be visible for a transaction on the database. The database contains both row and column storage engines, and the transaction token includes a transaction identifier (TID) for identifying committed transactions and uncommitted transactions. A last computed transaction is designated with a computed identifier (CID), record-level locking of records of the database is performed using the TID and CID to execute the transaction, and the plurality of transactions of the database are executed with each transaction manager.

    MULTI-REPLICA ASYNCHRONOUS TABLE REPLICATION
    149.
    发明申请

    公开(公告)号:US20190005105A1

    公开(公告)日:2019-01-03

    申请号:US16122617

    申请日:2018-09-05

    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.

    Multi-source asynchronous table replication

    公开(公告)号:US10169439B2

    公开(公告)日:2019-01-01

    申请号:US14871717

    申请日:2015-09-30

    Applicant: SAP SE

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

Patent Agency Ranking