About the FAIR DB Administrator's Toolset

Image Modified

Introduction

Part of the FAIR Initiative is to make it as easy as possible for a DB administrator (DBA) to insert or
update the FAIR data for each patient into the i2b2 DB, after all the tedious upfront works has been done
in compiling them.
The FAIR DBA Toolset consists of the following utilities:
Page 5 of 20
UMASS Medical School | The FAIR DBA Toolset 5
SWC
• PL/SQL scripts containing useful procedures to be stored and used in the i2b2 DB
o FAIRupdate.sql – contains the FAIRupdate( ) procedure.
o FAIRshow.sql – contains the FAIRshow( ) procedure.
• VBS scripts for generating PL/SQL scripts to call the aforementioned stored procedures to update
and show the FAIR XML for specified patients in the i2b2 DB
o FAIRxls2sqls.vbs – takes an XLS input file that contains the patient FAIR data.
o FAIRcsv2sqls.vbs - takes a CSV input file that contains the patient FAIR data.
Part of the FAIR Initiative is to make it as easy as possible for a DB administrator (DBA) to insert or update the FAIR data for each patient into the i2b2 DB, after all the tedious upfront works has been done in compiling them.

...