Sap Se

Thomas Seufert

Norman May

Kai Morich

Stephan Kessler

Juchang Lee

Hannes Jakschitsch

Yongjae Chuh

Changgyoo Park

Taehun Kim

Christof Bornhoevd

Daniel Buchmann

Steffen Geissinger

Taehyung Lee

Marcus Paradies

Thomas Mueller

Karl Fuerst

Michael Rudolf

Jin Uk Bae

Chuho Chang

Kaweh Amoi-Taleghani

Jens Hoff

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

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 Tafter T, a subsequent query is received. A determination is made as to whether a change to the table has occurred since T. 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.

Real-time anonymization

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 T, a total entry count and a maximum sequence column value of the entries is calculated and stored in metadata. At time Tlater than T, 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 Tis stored in the metadata.

Database independent detection of data changes

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.

Transactional cache invalidation for inter-node caching

The present disclosure describes methods, systems, and computer program products for optimizing single-value database read operations. One computer-implemented method includes initializing, by a computer, a single value cache associated with a created database table where a column of the database table contains a single or unique data value, verifying that the created database table is in a useable state, performing an operation on the database table, and retrieving the data value from the single value cache without locking the column containing the single or unique data value.

Optimizing single-value database read operations using a single value cache

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.

Atomic visibility switch for transactional cache invalidation

A system and method for providing a transactional-consistent cache for database objects is disclosed. New data is received by a cache manager. The cache manager updates an entry of a cache with the new data received by the cache manager, by registering the updating of the entry with the new data with an invalidator. The registering includes a timestamp. An invalidation event is then generated by the invalidator. The invalidation event includes a notification about the updating of the entry of the cache with the new data received by the cache manager according to the timestamp.

Transactional-consistent cache for database objects

A system includes reception of an instruction to access a column of a database table, determination that the column is not associated with the schema of the database table, determination of whether the schema of the database table is flexible or static, returning, if it is determined that the schema of the database table is static, of an error in response to the instruction, and, if it is determined that the schema of the database table is flexible, not returning an error in response to the instruction.

Growing community of inventors

Oftersheim, Germany

Thomas Seufert