PAUSE AND RESUME IN DATABASE SYSTEM WORKLOAD CAPTURE AND REPLAY

    公开(公告)号:US20210311850A1

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

    申请号:US16838113

    申请日:2020-04-02

    Applicant: SAP SE

    Abstract: Methods, systems, and computer-readable storage media for receiving a capture file, the capture file holding data representative of a workload executed in a source database system, processing the capture file to provide a replay file, the replay file being in a format that is executable by a replayer to replay the workload in a target database system, the workload including a set of requests represented within the replay file, providing a set of tags associated with the replay file, the set of tags including one or more tags, each tag associated with a request in the set of requests, and during replay of the workload in the target database system: pausing replay of the workload in response to a tag, executing a request associated with the tag, providing replay results specific to the request, and selectively resuming replay of the workload in the target database system.

    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.

    Database workload capture and replay

    公开(公告)号:US11294897B2

    公开(公告)日:2022-04-05

    申请号:US16715882

    申请日:2019-12-16

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.

    Database workload capture and replay

    公开(公告)号:US10552413B2

    公开(公告)日:2020-02-04

    申请号:US15150075

    申请日:2016-05-09

    Applicant: SAP SE

    Abstract: Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.

    ORDER-INDEPENDENT MULTI-RECORD HASH GENERATION AND DATA FILTERING

    公开(公告)号:US20190311057A1

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

    申请号: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.

Patent Agency Ranking