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.

    Real-time anonymization
    2.
    发明授权

    公开(公告)号:US11074238B2

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

    申请号:US15979067

    申请日:2018-05-14

    Applicant: SAP SE

    Abstract: Techniques are described for real time anonymization. In one example, a first a first query associated with a table is received, the table associated with a first anonymization operation satisfying satisfies a privacy requirement. The first anonymization operation is applied at runtime to generate a first anonymized data set against which the first query is executed. At T2 after T1, a subsequent query is received. A determination is made as to whether a change to the table has occurred since T1. If so, a determination is made as to whether the first anonymization operation satisfies the privacy requirement as applied to the current table. If the operation does not satisfy the privacy requirement when applied to the current table, a second anonymization operation satisfying the defined privacy requirement is determined and applied at runtime to generate a second anonymized data set against which the subsequent query can be executed.

    Database independent detection of data changes

    公开(公告)号:US10901977B2

    公开(公告)日:2021-01-26

    申请号:US15979032

    申请日:2018-05-14

    Applicant: SAP SE

    Abstract: Techniques are described for identifying changes to databases. In one example, a table associated with a data set is identified containing at least one entry, each entry associated with a sequence column value. The sequence column value for new entries is automatically incremented by one from a last max value. At time T1, a total entry count and a maximum sequence column value of the entries is calculated and stored in metadata. At time T2 later than T1, a total entry count and a maximum sequence column value in the table is calculated and compared to the previously stored values. If the values are the same, the table has not changed; if the values are different, then a change has been made. In response to a determined change, the calculated total entry count and the maximum sequence column value at T2 is stored in the metadata.

    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.

    Documenting modifications to configuration file

    公开(公告)号:US11200212B2

    公开(公告)日:2021-12-14

    申请号:US16222226

    申请日:2018-12-17

    Applicant: SAP SE

    Abstract: This disclosure describes documenting modifications to configuration file that can affect (e.g., change) behavior of a component of a service provided by a database management system. The service can collect metadata associated with a request to modify a configuration file affecting the behavior of the component of the service. The service can modify the configuration file in response to the request. The modification can change the behavior of the component of the service. The service can generate data representing documentation of the modification to the configuration file and the metadata. The data can represent the documentation being configured for storage by the database management system. Related apparatuses, systems, methods, techniques and articles are also described.

Patent Agency Ranking