公开(公告)号：US11645411B2

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

申请号：US17405524

申请日：2021-08-18

Applicant: SAP SE

Inventor： Maike Jansen ,  Raik Kulinna ,  Stephan Kessler

IPC: G06F21/00 ,  G06F21/62

CPC classification number: G06F21/6227

Abstract: In an example embodiment, using several computerized innovative data anonymization techniques, sensitive and personal data can be anonymized so that it can be used in further analysis without revealing the individuals to which the data applies. More particularly, a privacy view is created for a microdata table by generating one or more transformations, based on an anonymization method. Only once a request for data in the microdata table is received from a data consumer is the privacy view populated or repopulated with the most recent data from the microdata table by transforming it using the one or more transformations.

公开(公告)号：US11360972B2

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

申请号：US16365903

申请日：2019-03-27

Applicant: SAP SE

Inventor： Taehun Kim ,  Taehyung Lee ,  Stephan Kessler ,  Kaweh Amoi-Taleghani ,  Thomas Seufert ,  Jens Hoff ,  Kai Morich ,  Jin Uk Bae ,  Chuho Chang

IPC: G06F16/00 ,  G06F16/242 ,  G06F21/62 ,  G06F16/248 ,  G06F16/2453

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.

公开(公告)号：US10657127B2

公开(公告)日：2020-05-19

申请号：US15362586

申请日：2016-11-28

Applicant: SAP SE

Inventor： Kornel Skalkowski ,  Youssef Hatem ,  Stephan Kessler ,  Christian Mathis

IPC: G06F16/2453 ,  G06F16/22 ,  G06F16/2455

Abstract: In one respect, there is provided a distributed database system that includes hosts configured to store and/or manage data, a first query processing engine comprising a master node and an executor node, and a second query processing engine. The master node can be implemented on programmable processors and configured to perform operations. The operations can include: offloading, to the second query processing engine, a creation of a first and a second table such that the first and the second table are partitioned by the second query processing engine; generating an execution plan for a query on data in the distributed database system, the execution plan including a distributed join operation that combines data from the first and second table; determining to push down, to the second query processing engine, the distributed join operation; and dispatching, to the executor node, a portion of the execution plan including the distributed join operation.

公开(公告)号：US20230058906A1

公开(公告)日：2023-02-23

申请号：US17405524

申请日：2021-08-18

Applicant: SAP SE

Inventor： Maike Jansen ,  Raik Kulinna ,  Stephan Kessler

IPC: G06F21/62

Abstract: In an example embodiment, using several computerized innovative data anonymization techniques, sensitive and personal data can be anonymized so that it can be used in further analysis without revealing the individuals to which the data applies. More particularly, a privacy view is created for a microdata table by generating one or more transformations, based on an anonymization method. Only once a request for data in the microdata table is received from a data consumer is the privacy view populated or repopulated with the most recent data from the microdata table by transforming it using the one or more transformations.

公开(公告)号：US20200311296A1

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

申请号：US16365903

申请日：2019-03-27

Applicant: SAP SE

Inventor： Taehun Kim ,  Taehyung Lee ,  Stephan Kessler ,  Kaweh Amoi-Taleghani ,  Thomas Seufert ,  Jens Hoff ,  Kai Morich ,  Jin Uk Bae ,  Chuho Chang

IPC: G06F21/62 ,  G06F16/2453 ,  G06F16/248 ,  G06F16/242

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.

公开(公告)号：US20180150521A1

公开(公告)日：2018-05-31

申请号：US15362586

申请日：2016-11-28

Applicant: SAP SE

Inventor： Kornel Skalkowski ,  Youssef Hatem ,  Stephan Kessler ,  Christian Mathis

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/2282 ,  G06F16/2455

Abstract: In one respect, there is provided a distributed database system that includes hosts configured to store and/or manage data, a first query processing engine comprising a master node and an executor node, and a second query processing engine. The master node can be implemented on programmable processors and configured to perform operations. The operations can include: offloading, to the second query processing engine, a creation of a first and a second table such that the first and the second table are partitioned by the second query processing engine; generating an execution plan for a query on data in the distributed database system, the execution plan including a distributed join operation that combines data from the first and second table; determining to push down, to the second query processing engine, the distributed join operation; and dispatching, to the executor node, a portion of the execution plan including the distributed join operation.

公开(公告)号：US11074238B2

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

申请号：US15979067

申请日：2018-05-14

Applicant: SAP SE

Inventor： Stephan Kessler ,  Thomas Seufert ,  Kai Morich

IPC: G06F16/22 ,  G06F11/34 ,  G06F21/62 ,  G06F16/23 ,  G06F16/24

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.

公开(公告)号：US10901977B2

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

申请号：US15979032

申请日：2018-05-14

Applicant: SAP SE

Inventor： Stephan Kessler ,  Thomas Seufert ,  Kai Morich

IPC: G06F16/23 ,  G06F16/22 ,  G06F16/2455

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.

公开(公告)号：US20180089267A1

公开(公告)日：2018-03-29

申请号：US15275040

申请日：2016-09-23

Applicant: SAP SE

Inventor： Youssef Hatem ,  Stephan Kessler ,  Axel Christ ,  Christian Mathis

IPC: G06F17/30

CPC classification number: G06F16/24542 ,  G06F16/2455 ,  G06F16/2471 ,  G06F16/9535

Abstract: In one respect, there is provided a distributed database system. The distributed database system can include a plurality of hosts configured to store and/or manage data, a first query processing engine comprising a master node and an executor node, and a second query processing engine. The master node can be implemented on one or more programmable processors and configured to perform operations. The operations can include: generating an execution plan for a query on data that is stored at and/or managed by one or more of the plurality of hosts; determining to push down, to the second query processing engine, at least one data processing operations in the execution plan; and dispatching, to the executor node, at least a portion of the execution plan, the portion of the execution plan including the at least one data processing operation that is pushed down to the second query processing engine.