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.

Patent Agency Ranking