BACKGROUND

Static data masking is a privacy feature that enables users to anonymize their database. The anonymization happens at the column level. Data is erased and replaced with fake data. Static data masking is a one-way operation. Once a database has been masked, it is no longer possible to restore the database to its state before masking. Users are responsible for choosing which columns they wish to anonymize as well as the configurations for these columns.

SUMMARY

Implementations described herein disclose a system for static data masking. The static data masking system may perform one or more operations including unbinding tables in a database, evaluating masking operations on the tables to determine that at least one masking operation on a particular column of a candidate table is a complex masking operation that cannot be completed using a query, adding a temporary key column with unique values to the candidate table, generating a temporary table including the temporary key column and an empty masked column, generating masked values for the particular column at a client, and populating the masked values for the particular column in the empty masked column of the temporary table.

This Summary is provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This Summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used to limit the scope of the claimed subject matter.

Other implementations are also described and recited herein.

