INTELLIGENT OPTIMIZATION OF PARAMETERIZED QUERIES

    公开(公告)号:US20240086404A1

    公开(公告)日:2024-03-14

    申请号:US18075781

    申请日:2022-12-06

    Applicant: SAP SE

    CPC classification number: G06F16/2454 G06F16/24542

    Abstract: A computer implemented method can receive a parameterized query written in a declarative language. The parameterized query comprises a parameter which can be assigned different values. The method can perform a first compilation session of the parameterized query in which the parameter has no assigned value. Performing the first compilation session can generate an intermediate representation of the parameterized query. The intermediate representation describes a relational algebra expression to implement the parameterized query. The method can perform a second compilation session of the parameterized query in which parameter has an assigned value. Performing the second compilation session reuses the intermediate representation of the parameterized query.

    HYBRID COMPILATION FRAMEWORK FOR ARBITRARY AD-HOC IMPERATIVE FUNCTIONS IN DATABASE QUERIES

    公开(公告)号:US20200320069A1

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

    申请号:US16372652

    申请日:2019-04-02

    Applicant: SAP SE

    Abstract: Implementations of the present disclosure include providing a parse tree including a declarative portion and an imperative portion, dividing the parse tree to provide a first parse sub-tree and a second parse sub-tree, compiling the first parse sub-tree using a declarative compiler to provide a query execution plan (QEP) including an imperative script operator to prompt execution of the imperative portion, compiling the second parse sub-tree using an imperative compiler to provide one or more script execution plans, executing, by an execution engine, the QEP until encountering an imperative script operator, and, in response to encountering the imperative script operator, initiating execution of the one or more script execution plans to provide an imperative result, and providing a query result at least partially including the imperative result.

    AUTHORIZATION CHECKS AND AUDITING FOR QUERIES IN DATABASE SYSTEMS

    公开(公告)号:US20240303364A1

    公开(公告)日:2024-09-12

    申请号:US18180221

    申请日:2023-03-08

    Applicant: SAP SE

    CPC classification number: G06F21/6227 G06F2221/2141

    Abstract: 1. Implementations of the present disclosure include receiving, by a database system, a query from an entity, providing a parse tree based on the query, the parse tree including nodes representative of operations to be executed and data objects stored within the database system, generating a module tree based on the parse tree, the module tree including a set of modules provided in sequential order from a root module to a leaf module, and executing an authorization check using the module tree by, for each module, determining a set of data objects and, for each data object in the set of data objects, determining whether the entity is one or more of authorized access the data object and perform an operation on the data object.

    OPERATOR MOVEMENT OPTIMIZATION TECHNIQUE FOR PROCEDURES

    公开(公告)号:US20230048391A1

    公开(公告)日:2023-02-16

    申请号:US17561104

    申请日:2021-12-23

    Applicant: SAP SE

    Abstract: In some embodiments, a method receives a statement graph for a procedure that is used to access data and determines a set of producer statements and a set of consumer statements in the statement graph. A producer statement produces a variable for a consumer statement, and the consumer statement consumes the variable from the producer statement. The method optimizes the statement graph to generate an optimized procedure by moving an operator from a consumer statement to a producer statement or by moving an operator from a producer statement to a consumer statement. The optimized procedure is output based on the optimized statement graph.

Patent Agency Ranking