公开(公告)号：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.

公开(公告)号：US10353895B2

公开(公告)日：2019-07-16

申请号：US14961309

申请日：2015-12-07

Applicant: SAP SE

Inventor： Changgyoo Park ,  Yongjae Chuh ,  Juchang Lee ,  Norman May ,  Thomas Seufert ,  Hannes Jakschitsch

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

Abstract: Disclosed herein are systems, methods, and computer program products for providing transaction-consistent snapshots of data stored in or associated with a database. An embodiment operates by receiving, at a source database, an update request to update data associated with a table stored at the source database, and modifying a value of a modification-in-progress data structure corresponding to the table to indicate that a modification is in progress for the table. The embodiment includes updating a value of a commit identification counter and a table time stamp associated with the table to indicate that cached data having a time stamp older than the updated time stamp are invalid. The embodiment further includes modifying the value of the modification-in-progress counter to indicate completion of table modification.

公开(公告)号：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.

公开(公告)号：US20170147638A1

公开(公告)日：2017-05-25

申请号：US14961309

申请日：2015-12-07

Applicant: SAP SE

Inventor： Changgyoo Park ,  Yongjae Chuh ,  Juchang Lee ,  Norman May ,  Thomas Seufert ,  Hannes Jakschitsch

IPC: G06F17/30

CPC classification number: G06F16/24539 ,  G06F16/2282 ,  G06F16/2308 ,  G06F16/2379 ,  G06F16/24552

Abstract: Disclosed herein are system, method, and computer program product embodiments for efficiently providing transaction-consistent snapshots of data stored in or associated with a database stored within a database management system. An embodiment operates by receiving, at a source database, an update request to update data associated with a table stored at the source database. The embodiment continues by modifying a value of a modification-in-progress data structure corresponding to the table to indicate that a modification is in progress for the table, and that cached data associated with the table is invalid while the modification is in progress for the table and performing the table update based, at least, on information received in the update request. The embodiment further continues by updating a value of a commit identification counter, and subsequently a table time stamp associated with the table, to indicate that all cached data associated with the table having a time stamp older than the updated time stamp are invalid. The embodiment further continues by modifying the value of the modification-in-progress counter to indicate the completion of table modification.

公开(公告)号：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.

公开(公告)号：US20170147628A1

公开(公告)日：2017-05-25

申请号：US14985766

申请日：2015-12-31

Applicant: SAP SE

Inventor： Changgyoo Park ,  Yongjae Chuh ,  Juchang Lee ,  Norman May ,  Thomas Seufert ,  Hannes Jakschitsch

IPC: G06F17/30

Abstract: Disclosed herein are system, method, and computer program product embodiments for efficiently providing transaction-consistent snapshots of data stored in or associated with a database stored within a database management system. An embodiment operates by receiving, at a source database, an update request to update a table at the source database and transmitting a message to a cache node to invalidate a copy of a table time stamp associated with the table, where the copy of the table time stamp is stored at the cache node. The embodiment continues by updating the table at the source database based on the update request.