Order-independent multi-record hash generation and data filtering

    公开(公告)号:US11468062B2

    公开(公告)日:2022-10-11

    申请号:US16801039

    申请日:2020-02-25

    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.

    Selective dispatching of OLAP requests using execution statistics

    公开(公告)号:US11068506B2

    公开(公告)日:2021-07-20

    申请号:US15150815

    申请日:2016-05-10

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing within a database environment that includes one or more processing units and a memory. A request for a database operation, such as a query, is received from a client. Execution statistics associated with the request are retrieved. At least some of the execution statistics are compared with one or more threshold values. Based on results of the comparing, the request is carried out with a first execution component or delegated to a second execution component. The request is executed and execution results are sent to the client.

    Client-driven commit of distributed write transactions in a database environment

    公开(公告)号:US10936578B2

    公开(公告)日:2021-03-02

    申请号:US15611156

    申请日:2017-06-01

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing in a distributed database environment. A database client sends database operations to a slave node, which mediates execution of the transaction. A connection between the database client and the slave node is associated with an identifier, and the transaction has an identifier. The database client sends a commit request to a master node over a network connection between the master node and the database client. The commit request includes the transaction identifier. The commit request can also include an indication of database nodes executing operations in the transaction.

    AUTOMATIC DETERMINATION OF TABLE DISTRIBUTION FOR MULTINODE, DISTRIBUTED DATABASE SYSTEMS

    公开(公告)号:US20210011898A1

    公开(公告)日:2021-01-14

    申请号:US17037484

    申请日:2020-09-29

    Applicant: SAP SE

    Abstract: Technologies are described for improving the performance of distributed database systems. The technologies provide suggested table distributions that can reduce the performance overhead associated with database operations that involve multiple nodes, and can provide more even distribution of computing resource use. In a particular example, a method includes minimizing a scoring function that includes a plurality of performance metrics, at least a portion of the metrics being associated with a weight. Candidate table distributions can be analyzed in an iterative manner to determine a lowest-score distribution. A final table distribution can be output, such as to a user.

    CLIENT-DRIVEN COMMIT OF DISTRIBUTED WRITE TRANSACTIONS IN A DATABASE ENVIRONMENT

    公开(公告)号:US20180349430A1

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

    申请号:US15611156

    申请日:2017-06-01

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating transaction processing in a distributed database environment. A database client sends database operations to a slave node, which mediates execution of the transaction. A connection between the database client and the slave node is associated with an identifier, and the transaction has an identifier. The database client sends a commit request to a master node over a network connection between the master node and the database client. The commit request includes the transaction identifier. The commit request can also include an indication of database nodes executing operations in the transaction.

Patent Agency Ranking