Pseudonymisation/de-pseudonymisation of data

摘要

In a computer-implemented system, a database comprises a plurality of entries/values and a metadata file describes attributes of those entries. A user interface is configured to display the metadata and to enable user selection of one or more attributes. A first set of selected attributes corresponds to entries/values for which repeated occurrences of an entry/value are to be given different, preferably unrelated, pseudonyms. A second set of selected attributes corresponds to entries/values for which repeated occurrences of an entry/value are to be given the same pseudonym or traceably-related pseudonyms. A code generator generates respective first and second sets of code which, when executed and applied to the database entries, achieves the corresponding pseudonymisation. The code may comprise SQL (Structured Query Language). In an embodiment, the pseudonymised data may be de-pseudonymised to an appropriately authenticated and authorised user.