Integrating row level security in i2b2: segregation of medical records into data marts without data replication and synchronization.

ABSTRACT:

Objective

i2b2 offers the possibility to store biomedical data of different projects in subject oriented data marts of the data warehouse, which potentially requires data replication between different projects and also data synchronization in case of data changes. We present an approach that can save this effort and assess its query performance in a case study that reflects real-world scenarios.

Material and methods

For data segregation, we used PostgreSQL's row level security (RLS) feature, the unit test framework pgTAP for validation and testing as well as the i2b2 application. No change of the i2b2 code was required. Instead, to leverage orchestration and deployment, we additionally implemented a command line interface (CLI). We evaluated performance using 3 different que

SUBMITTER: Scheible R 

PROVIDER: S-EPMC10425194 | biostudies-literature | 2023 Oct

REPOSITORIES: biostudies-literature