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.

    Data anonymization in database management systems

    公开(公告)号:US11360972B2

    公开(公告)日:2022-06-14

    申请号:US16365903

    申请日:2019-03-27

    Applicant: SAP SE

    Abstract: Implementations of the present disclosure include receiving a view command for creating a view to display anonymized data in response to one or more queries, the view command including a view name, a table, a set of columns of the table, an anonymization type, a set of static parameters, and, for a sub-set of columns of the table, one or more sets of column-specific parameters, each set of column-specific parameters being specific to anonymization of data of a respective column of the table included in the sub-set of columns, storing the view command within the database system, and receiving a query referencing the view, and in response, providing a data set including data from each column in the sub-set of columns, receiving an anonymized data set including anonymized data that is generated from the data set using the anonymization type, the static parameters, and the sets of column-specific parameters.

    DATA ANONYMIZATION IN DATABASE MANAGEMENT SYSTEMS

    公开(公告)号:US20200311296A1

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

    申请号:US16365903

    申请日:2019-03-27

    Applicant: SAP SE

    Abstract: Implementations of the present disclosure include receiving a view command for creating a view to display anonymized data in response to one or more queries, the view command including a view name, a table, a set of columns of the table, an anonymization type, a set of static parameters, and, for a sub-set of columns of the table, one or more sets of column-specific parameters, each set of column-specific parameters being specific to anonymization of data of a respective column of the table included in the sub-set of columns, storing the view command within the database system, and receiving a query referencing the view, and in response, providing a data set including data from each column in the sub-set of columns, receiving an anonymized data set including anonymized data that is generated from the data set using the anonymization type, the static parameters, and the sets of column-specific parameters.

Patent Agency Ranking