Sap Se

Sap Ag

Kai Morich

Thomas Seufert

Stephan Kessler

Vladislav Leonkev

Oliver Rebholz

Taehun Kim

Juchang Lee

Christian Bensberg

Norman May

Kyu Hwan Kim

Andreas Kemmler

Ki Hong Kim

Alexander Boehm

Sung Heun Wi

Chul Won Lee

Taehyung Lee

Michael Rudolf

Jeong Ae Han

Jin Uk Bae

Chuho Chang

Kaweh Amoi-Taleghani

Christoph Glania

Armin Risch

Jens Hoff

Michael R Schmalzl

Sebastian Kook

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

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.

Documenting modifications to configuration file

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

A method may include receiving a query for data to be provided by a database server, wherein the query includes an indication of a maximum lag. The method may further include determining whether a hint is available to apply to the query, wherein the hint affects an execution of the query. When no hint is available, a baseline database server may be selected to be the database server. When the hint is available, a replication server or a cache server may be selected to be the database server based on the hint and the maximum lag. The query may be processed at the selected database server.

Query hints for caching and replication

A computing system method for high-availability operation is disclosed. Implementations of the system include a plurality of host computers connected together in a network, each host computer running an HA process to monitor activity on the host computer. The system further includes a master HA process, designated from all other HA processes running on the plurality of host computers. The master HA process includes a heartbeat monitor to monitor activity of the network to detect a failed host computer, and a failover handler to transfer at least one of the one or more tasks from the failed host computer to an active host computer. All other HA processes other than the master HA process are used as cache for read requests to topology data.

Integrated heartbeat monitoring and failover handling for high availability

A method and system for reorganizing a distributed computing landscape for dynamic load balancing is presented. A method includes the steps of collecting information about resource usage by a plurality of hosts in a distributed computing system, and generating a target distribution of the resource usage for the distributed computing system. The method further includes the step of generating an estimate of an improvement of the resource usage according to a reorganization plan.

Landscape reorganization algorithm for dynamic load balancing

Growing community of inventors

Hockenheim, Germany

Kai Morich