Abstract

ABSTRACT
 Introduction/BackgroundThe ability to link datasets within the Secure Anonymised Information Linkage (SAIL) databank provides researchers with a powerful tool to analyse multiple datasets. The ability to combine several datasets also has the adverse effect of potential identification of an individual. Further encrypting linkage fields at a project level limits the links to datasets specific to the project only. This presentation discusses the opensource web based administration tool that programmatically applies project encryption in a consistent and timely manner, logging administrator actions.
 Objectives1). Identify encryption methodology2). Programme encryption steps and log steps 3). Design and implement web based user administration tool
 ApproachUtilising existing Secure Anonymised Information Linkage (SAIL) databank security, providing researchers with a view of their data, separating data linkage fields into a separate secure lookup table. Using Python programming language to automate the Structured Query Language (SQL) scripts required to accomplish this, as well as Python packages to interact with the databank and web based administration tool.
 ResultsProject encrypted views created for several projects and scores of datasets. Encrypted linkage fields unique to each project ensuring views across projects can not be linked either to each other or the original datasets.
 ConclusionEncryption process is programmable and administered through web tool.

Highlights

  • Further encrypting linkage fields at a project level limits the links to datasets specific to the project only

  • Using Python programming language to automate the Structured Query Language (SQL) scripts required to accomplish this, as well as Python packages to interact with the databank and web based administration tool

  • Open Access under CC BY-NC-ND 4.0 (https://creativecommons.org/licenses/by-nc-nd/4.0/deed.en)

Read more

Summary

Introduction

Encrypting data linkage fields at a project level within the Secure Anonymised Information Linkage (SAIL) databank The ability to link datasets within the Secure Anonymised Information Linkage (SAIL) databank provides researchers with a powerful tool to analyse multiple datasets. The ability to combine several datasets has the adverse effect of potential identification of an individual.

Objectives
Results
Conclusion
Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call