Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Introducing DLP: a tool to

...

help screen for and manage sensitive data 

As part of its role in managing HDX, the Centre is aware of various types of sensitive data collected and used by our partners to meet needs in humanitarian operations. While organisations are not allowed to share personally identifiable information (PII) on HDX, and the they can share survey or needs assessment data which may (or may not) be sensitive due to the risk of re-identifying people and their locations. The HDX team manually reviews every dataset uploaded resource to the platform as part of a standard quality assurance (QA) process that flags . As the platform has scaled and the range of data types shared by partners has expanded, screening for and identifying potentially sensitive, high-risk data to our contributors. This type of data typically emerges from survey or needs assessment data, otherwise known as ‘microdata’. Microdata is integral to crisis response, but may present a re-identification risk to certain individuals and groups depending on the key variables present in the data. For example, aggregate information about age, marital status, and location could allow the re-identification of a specific individual in a camp. Similarly, information about disabilities or child-headed households could be exposed in the free-text field of a needs assessment. Assessing the disclosure risk presented by microdata uploaded to the platform is a key component of how the Centre supports our partners in managing sensitive data more responsibly. With support from the Directorate-General for European Civil Protection and Humanitarian Aid Operations (ECHO) and the Foreign, Commonwealth and Development Office (FCDO) COVIDAction programme, the Centre has developed an improved technical infrastructure for the management of sensitive data on HDX. We now automatically screen all data for personal or sensitive information at the point of upload rather than after it is made publichas become more challenging. 

To improve this process, we have integrated a detection tool from Google called Cloud Data Loss Prevention (DLP) into our screening process. Our goal is to screen all data uploaded to HDX for PII and non-personal sensitive data. By using DLP, we are able to quickly scan the entire data file for different attributes (e.g. column headers that may indicate the presence of sensitive data) and identify potentially sensitive information. Datasets flagged as sensitive based on our criteria are marked ‘under review’ in the public interface of HDX and made inaccessible until the HDX team completes a manual review of the data. In order to automate this screening process for sensitive data, the Centre uses a detection tool from Google called Cloud Data Loss Prevention (DLP).

...

Over time, we will refine our use of DLP based on its performance, adding or removing key attributes to improve the detection of different forms of sensitive data. 

The goal of this document is to provide an overview of DLP based on our experience. We specifically focus on identifying a use case for DLP, customizing DLP scans, testing DLP, and interpreting the results of DLP scans. We will continue to update this document based on what we learn in order to help other organisations integrate DLP or similar tools for screening humanitarian data into their own workflow.  

NB: Google maintains extensive documentation of DLP that serves as a helpful technical resource when getting started. Our documentation supplements and contextualizes that resource by presenting a humanitarian use case of DLP. See “Annex: Navigating the official Google DLP documentation” at the end of this document for some tips on how to find what you’re looking for.

Preparing DLP: identify a use case and plan how to add DLP to your workflow

Google Cloud Data Loss Prevention (DLP) is a service designed to discover, classify, and protect sensitive information.  DLP providesIt provides the ability to

  • The ability to use over 120 built-in information type detectors , known as ‘infoTypes’, ‘infoTypes' – to identify sensitive data The ability data, and to define custom infoTypes using dictionaries, regular expressions, and contextual rules

  • The ability to detect sensitive data in streams of various formats: text, structured text (e.g. tables), storage repositories, and even images

  • The ability to apply de-identification techniques and re-identification risk analyses to the data 

Organisations should consider which of these capabilities is most relevant to their existing data

...

Given data input, DLP returns details about any infoTypes found in the text, the likelihood that the infoType was correctly identified, and the actual pieces of sensitive text from the dataset. 

Purpose of this document 

The goal of this document is to provide an overview of DLP as used by the Centre and model how it might be included in a responsible data management process. 

Google maintains extensive documentation of DLP that serves as a helpful technical resource when getting started. Our resource supplements and contextualizes that documentation by presenting a humanitarian use case of the tool. We hope that the Centre’s experience will help our partners decide whether to use DLP in their own management processes. management process before proceeding with DLP. While it may seem obvious, it is important to clearly describe the way(s) in which you expect DLP to improve your data management workflow before initiating the process to customize, deploy, and interpret the results of DLP.

Because the Centre already has a process and tool in place for assessing the risk of re-identification and applying disclosure control techniques to datasets (learn more on the SDC page), we chose to use DLP only for detection and classification of sensitive information. 

The diagram below shows how the Centre has integrated DLP into its standard QA process:

...

Customizing DLP: choose and create infoTypes for humanitarian contexts 

Standard infoTypes: built-in detection mechanisms

Cloud DLP provides a set of over 120 built-in information types – known as ‘infoTypes’ – to define the sensitive data it can detect in a resource. There are both global infoTypes and country-specific infoTypes. For example, Location and Gender are global infoTypes, and France_Passport is a France infoTypecountry-specific infoType that detects French passport numbers. Google maintains a list of all its built-in infoTypes here

The first step in preparing a DLP scan is to choose a relevant set of standard infoTypes for your use case. The Centre has used the following global infoTypes in its scans: AGE, CREDIT_CARD_NUMBER, DATE, DATE_OF_BIRTH, EMAIL_ADDRESS, ETHNIC_GROUP, GENDER, GENERIC_ID, ICD10_CODE, ICD9_CODE, IMEI_HARDWARE_ID, LOCATION, MEDICAL_TERM, ORGANIZATION_NAME, PERSON_NAME, PHONE_NUMBER, STREET_ADDRESS, and URL.

The Google DLP team updates controls the standard infoType detectors and releases , meaning they may update them or add new ones periodically. In order to monitor these externally unavailable changes, the Centre recommends creating that organisations create a benchmark file to test at regular intervals. 

Custom infoTypes: personalized detection mechanisms

While standard infoTypes are useful in certain contexts, custom infoTypes allow humanitarian organizations to specify and detect potentially sensitive keywords associated with affected people, humanitarian actors and/or a response. 

Typically, custom infoTypes are dictionaries (e.g. text files containing lists of words or phrases, with each new line treated as its own unit). DLP only matches alphanumeric characters, so all special characters are treated as whitespace. For example, “household size” will match “household size,” “household-size,” and “household_size.” Dictionary words are also case-insensitive. 

Custom infoTypes may also be regular expressions, enabling DLP to detect matches based on regular expression patterns.  

The Centre currently maintains has created a set of twelve custom infoTypes:

Custom infoType 

Format

Description

DISABILITY_GROUP

Dictionary

A list of disabilities / disabled 'groups' or groups with limited 'functioning' per standard classification

EDUCATION_LEVEL

Dictionary

Include A list of different indicators for level of education (e.g. ‘OSY’ for out of school youth)

GEO_COOR

Regular expression

Latitude and longitude coordinates

HDX_HEADERS

Dictionary

A set of commonly seen column names that may indicate presence of sensitive data , (e.g. Key Informant‘Key Informant’)

HH_ATTRIBUTES

Dictionary

Words A list of words indicating specific attributes of a household , (e.g. Child‘Child_Headed_HouseholdHousehold’)

HXL_TAGS

Regular expression

A sub-set subset of all existing HXL tags that have been associated with (potentially) sensitive data.

MARITAL_STATUS

Dictionary

A list of marital statuses

OCCUPATION

Dictionary

A list of employment statuses and common occupations

PROTECTION_GROUP

Dictionary

Include A list of different indicators for populations of concern (e.g. ‘pregnant’ or ‘unaccompanied child’)

RELIGIOUS_GROUP

Dictionary

A list of religions / religious groups in different languages

SEXUALITY

Dictionary

A list of sexual orientations

SPOKEN_LANGUAGE

Dictionary

A list of spoken languages

The dictionary infoTypes are currently set up to match two types of information: the column names of key variables and the values of each key variable. For example, SPOKEN_LANGUAGE matches “mother tongue” and “language” as well as specific language names. Similarly, MARITAL_STATUS matches the term “marital status” as well as “married” and “widowed.”

Updating custom infoTypes over time 

Cycle of updating the model until we have a really strong model 

Because custom infoTypes are inherently static, the Centre has developed a category-based system for monitoring and potentially updating the custom infoTypes over time. 

...

Category

...

Description

...

Action

(1) Comprehensive:

GEO_COOR (regex)

HXL_TAGS (regex)

PROTECTION_GROUP

RELIGIOUS_GROUP

SEXUALITY

SPOKEN_LANGUAGE

May have an occasional error or omission. 

Example: SPOKEN_LANGUAGE may be missing certain rare or dying languages. 

Make occasional edits or additions as needed. 

Check the list of key variables from the SDC process. If any key variables were missed in the results, update the specific dictionary accordingly. 

(2) Comprehensive in context:

DISABILITY_GROUP

EDUCATION_LEVEL

MARITAL_STATUS

Difficult to ensure the correct context of key terms. 

Example: “single” is not exclusively a marital status, just as “primary” is not always an education level.

Watch for low accuracy levels. 

If the majority of an infoType’s results are incorrect in the context of each dataset, then consider eliminating certain terms to narrow its scope. 

Example: Even if the words “single” and “separated” were deleted, MARITAL_STATUS could capture most marriage-specific terms. 

(3) Not comprehensive: 

OCCUPATION

HH_ATTRIBUTES

HDX_HEADERS

Difficult to capture all possibilities upfront. 

The dictionaries are highly dependent upon the test datasets seen thus far. 

Example: “child_headed”, “families headed by children”, and “hohh child” 

all express the same household attribute; different orgs may have their own versions. 

Continually update as new values and/or permutations of headers are found.

Check each dictionary against the list of key variables from the SDC process. Make sure all variations of variable names and values are represented. 

Example: If a dataset has an “occupation” column, ensure that all its values are included in the OCCUPATION dictionary. 

Unlike the standard infoTypes, the custom infoTypes must be maintained by your organisation. Some custom infoTypes are essentially complete from the outset; others may require updates over time as your organisation learns and adapts. Over time, the Centre will refine its use of DLP by adding, updating, or removing custom infoTypes to improve the detection of different forms of sensitive data. 

Testing and Refining DLP: assess the suitability of the results for your use case

Once an organisation has selected standard infoTypes and created custom infoTypes to use in their scans, it is time to test and refine DLP to make sure the output meets their requirements.

Given data input, DLP returns details about 1) the infoTypes detected in the text; 2) a likelihood, ranging from VERY_UNLIKELY to VERY_LIKELY with default POSSIBLE, that indicates how likely it is that the data matches the given infoType; and 3) a quote, which is the actual string of data identified as the infoType.

Over the course of 4 months, the Centre conducted 6 rounds of testing on a set of 70 sensitive datasets and 70 placebo datasets. This testing strategy is not necessarily universal; organisations should focus on the DLP capabilities most relevant to their existing data management process. However, we recommend answering two key questions before deploying DLP:

  • Can DLP detect all or most types of sensitive data that we encounter in our existing data management process?

  • How accurately do the detected infoTypes from a scan match the PII and key variables we are trying to catch? 

While the answers may seem obvious from an initial glance at the infoType descriptions, we found it crucial to observe DLP’s detection mechanisms in detail. For example, when using the LAST_NAME infoType in early stages of testing, we looked at the quotes and discovered it was flagging refugee camp names along with actual surnames. The infoType was not accurately matching the variable we intended to catch. Because microdata uploaded to HDX frequently contains camp names, we decided that the LAST_NAME infoType was not particularly helpful to include in the Centre’s scans. Additionally, we expected the LOCATION infoType to detect GPS coordinates, but found that it did not. In other words, DLP did not initially detect a type of sensitive data we were looking for. In response, we adjusted our initial assumptions and created a custom infoType to detect longitude and latitude coordinates.

Organisations may ultimately differ from the Centre in their findings, but these types of contextual observations and decisions in light of the two key questions are what define a robust testing process for DLP. Accordingly, the process should draw upon cross-functional expertise from teams across your organisation, not just the data scientists. At the Centre, the Development team managed the technical details of DLP while both the Data Partnerships and the Data Responsibility teams analyzed the outputs of the scans.

Interpreting and Using the Output of DLP: develop actionable criteria for classifying data as sensitive

Even once an organisation is confident that DLP accurately detects the types of sensitive data present in their context, the output of a DLP scan alone does not determine whether a given dataset is sensitive. Ultimately, each organisation needs to define their own criteria for interpreting the DLP output (e.g. does the presence of a single instance of an infoType mean a dataset is sensitive?)

Depending on the number of standard and custom infoTypes included in the inspection, the raw output of a DLP scan may comprise anywhere from zero to millions of detected matches. On average, it took our team 48 hours to review the full results of our test scans, which included 70 sensitive datasets and 70 placebo datasets. While reviewing the results for the scan of a single dataset would take much less time, this process still proved onerous and was non-conducive to our use case of reaching a binary decision about a dataset’s sensitivity. Based on this difficulty, we proceeded to explore whether we could create a complementary tool or algorithm to classify a dataset as sensitive using the training data generated through DLP testing.

A machine learning approach

To interpret the output of a DLP inspection scan, the Centre has developed a robust model that averages the results of a random forest model, a generalized linear model, and a gradient boosting model to predict the possibility that a dataset is sensitive or non-sensitive. We generated the training data for this model from our most recent round of testing on 70 sensitive datasets and 70 placebo datasets. The model uses detected infoTypes, likelihoods, and quotes as the main elements in its analysis. 

When a new resource is uploaded to HDX, the output of the DLP scan is used by the model to predict the probability that the dataset is sensitive. The HDX team then manually reviews the new datasets for sensitivity and accordingly accepts or rejects the model’s classification. 

As the model is used to classify more and more datasets, its prediction values should become more and more accurate. If we start to see higher levels of error – e.g. if the QA officer often disagrees with the model’s classification of sensitivity – we will revisit our DLP testing process, may reevaluate our use of certain standard and custom infoTypes, and will retrain the model accordingly. 

In this way, we will refine our use of DLP over time based on its performance. We will continue to update this document based on what we learn.

Annex: Navigating the official Google DLP documentation 

Google maintains extensive documentation of Cloud DLP, including quickstart guides, references, and code samples. The links below provide a condensed simple way to navigate that documentation and assess which capabilities are relevant in your organization’s context. 

Cloud DLP is capable of: 

Inspection

...

  • k-anonymity: A property of a dataset that indicates the re-identifiability of its records. A dataset is k-anonymous if quasi-identifiers for each person in the dataset are identical to at least k – 1 other people also in the dataset. 

  • l-diversity: An extension of k-anonymity that additionally measures the diversity of sensitive values for each column in which they occur. A dataset has l-diversity if, for every set of rows with identical quasi-identifiers, there are at least l distinct values for each sensitive attribute. 

  • k-map: Computes re-identifiability risk by comparing a given de-identified dataset of subjects with a larger re-identification—or "attack"—dataset. Cloud DLP doesn't know the attack dataset, but it statistically models it by using publicly available data like the US Census, by using a custom statistical model (indicated as one or more BigQuery tables), or by extrapolating from the distribution of values in the input dataset. Each dataset—the sample dataset and the re-identification dataset—shares one or more quasi-identifier columns. 

  • Delta-presence (δ-presence): Estimates the probability that a given user in a larger population is present in the dataset. This is used when membership in the dataset is itself sensitive information. Similarly to k-map, Cloud DLP doesn't know the attack dataset, but statistically models it using publicly available data, user-specified distributions, or extrapolation from the input dataset.

Testing DLP: assess the accuracy of the scan in context

Testing detection mechanisms

In testing DLP, we set out to answer several key questions: 

  • Can DLP detect all or most types of sensitive data that we have encountered thus far? 

  • How well does DLP work on our microdata set compared to the placebo set? 

  • How accurately do DLP infoTypes match the PII and key variables we are trying to catch? 

  • Combining the different infoTypes based on their level of accuracy, can we establish a set of criteria to classify any given dataset as sensitive or non-sensitive? 

To explore these questions, the Centre conducted six rounds of testing on a microdata set – in other words, a ‘sensitive’ set – and a placebo set. Each set contained ~70 datasets to be scanned. We found that... [*include test 6 results analysis, which don’t currently exist but are technically most accurate? Include our test 4 results analysis?*] 

Flag time investment

Give strategic level recommendation

Is it able to meaningfully scan your data?

Who should be involved? Include technical specialists, contextual experts, cross-functional

The results of our testing produced two new questions: 

  • Can we introduce a complementary tool to process the DLP outputs/results and indicate whether or not a dataset is sensitive? 

  • Can we train or create another alternative tool to scan and classify new data as sensitive using the training data generated so far?

Interpreting DLP: develop actionable criteria for classifying data as sensitive

Limitations of the raw output of DLP 

Depending on the number of infoTypes scanned for and the amount of sensitive data present in the resource, the raw output of a DLP scan may comprise anywhere from thousands to millions of rows of matches. We found that the sheer number of results for microdata files was prohibitive to close analysis. 

A prediction-based approach

  • The output from the DLP scan needs further processing to get to the answer whether or not a given dataset is sensitive(i.e a binary yes/no)

  • We developed a robust model that is averaged over random forest, generalized linear and gradient boosting models to predict the sensitivity of datasets

  • This model is built based on the output from a DLP scan of datasets specifically prepared for training. InfoTypes, quotes and likelihoods are the main elements used in the analysis.

  • On DLP scan output of new datasets, the model is tested and its accuracy of predicting their sensitivity is recorded

  • The QA officer manually reviews the new datasets for sensitivity and accepts or refuses the model’s prediction

***

Main.json file

  • contains the name of the resource, file size, when it was scanned, a link to the other two files, and some info about the scan (how many infotypes were detected, what was used during detection)

  • Written over with the probability prediction from the algorithm 

  • Written over again when the QA officer reviews the prediction and makes a decision

Output from DLP

  • .dlp.json - contains all terms and infoTypes detected 

Debug file

  • we keep as a log to see how the scan went, look into it if questions arise

All 3 files are stored in a separate amazon bucket, separate from resources

Prefix these files with the time - the date (hour, minute) when it was scanned

Using DLP: model the Centre’s workflow

Current process diagrams: 

...

  •  

Acknowledgement: The Centre’s work to develop an improved technical infrastructure for the management of sensitive data on HDX was made possible with support from the Directorate-General for European Civil Protection and Humanitarian Aid Operations (DG ECHO). Development of this technical documentation was supported through the United Kingdom Foreign, Commonwealth and Development Office (FCDO)’s COVIDAction programme. 

Info

Filter by label (Content by label)
showSpacekb-how-to-article
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@416d933
falsesortmodified
typeshowSpacepagefalse
reversetruelabels
typepage
cqllabel = "kb-how-to-article" and type = "page" and space = "HDXKB"
labelskb-how-to-article
Page Properties
hiddentrue

Related issues