Customizable filtering for query plan stability in database systems using abstract query plans

    公开(公告)号:US11748349B2

    公开(公告)日:2023-09-05

    申请号:US16835566

    申请日:2020-03-31

    Applicant: SAP SE

    CPC classification number: G06F16/24542

    Abstract: Methods, systems, and computer-readable storage media for receiving a query plan and a set of query parameters of the query plan, the query plan corresponding to a query submitted to a database system, and determining that the set of query parameters matches a filter in a set of filters, each parameter in a set of parameters of the filter matching a query parameter in the set of query parameters, and in response: providing the query plan to an abstract query plan generator that generates an abstract query plan based on the query plan, and storing the abstract query plan in an abstract query plan store.

    Query plan migration in database systems

    公开(公告)号:US11556538B2

    公开(公告)日:2023-01-17

    申请号:US16874822

    申请日:2020-05-15

    Applicant: SAP SE

    Abstract: Methods, systems, and computer-readable storage media for receiving, by a current database system, a query plan file representative of a captured query plan from a source database system, receiving, by the current database system, a set of definitions including one or more definitions, each definition in the set of definitions corresponding to an object that is implicated by the query plan, the object being included in a set of objects, and determining, by the current database system, that each definition in the set of definitions is identical to a respective definition of a corresponding object within the current database system, and in response: executing the captured query plan in the current database system to provide a query result.

    QUERY PLAN MIGRATION IN DATABASE SYSTEMS

    公开(公告)号:US20210357407A1

    公开(公告)日:2021-11-18

    申请号:US16874822

    申请日:2020-05-15

    Applicant: SAP SE

    Abstract: Methods, systems, and computer-readable storage media for receiving, by a current database system, a query plan file representative of a captured query plan from a source database system, receiving, by the current database system, a set of definitions including one or more definitions, each definition in the set of definitions corresponding to an object that is implicated by the query plan, the object being included in a set of objects, and determining, by the current database system, that each definition in the set of definitions is identical to a respective definition of a corresponding object within the current database system, and in response: executing the captured query plan in the current database system to provide a query result.

Patent Agency Ranking