1.8 Release Notes

i2b2 1.8 Release includes the newly redesigned i2b2 Web interface, ACT i2b2 on OMOP functionality, few improvements and bug fixes.

Highlight of Features

Top New Features

Community-Contributed Features

Detailed Documentation on New Features

New Web client User Interface

ACT i2b2 on OMOP (for MSSQL and Oracle databases)

ACT i2b2 on OMOP functionality uses ACT Ontology in the front-end and enables the i2b2 Software to run against a database that uses the OMOP CDM architecture.  For historical reference on old 2018 OMOP  installation , refer to OMOP Home - OMOP - i2b2 Community Wiki

The following steps will load the OMOP metadata and CRC tables and the OMOP Views required to query the OMOP tables.

Step 1: Load Ontology tables

1. Download and extract the new install zip package from "Download Binary Distribution" section of https://www.i2b2.org/software
2. Edit the  edu.harvard.i2b2.data\Release_1-7\NewInstall\Metadata\db.properties file to update the project properties to 'ACT-OMOP'; example: db.project=ACT-OMOP
3. From the edu.harvard.i2b2.data\Release_1-7\NewInstall\Metadata folder, run the ant command: ant -f data_build.xml db_metadata_load_data
1. This will execute the SQL scripts from the edu.harvard.i2b2.data\Release_1-7\NewInstall\Metadata\act\scripts\<db type> folder and will create and load ACT-OMOP Ontology metadata tables. 
4. You can now verify the new Ontology by logging into the web client.

Step 2: Load OMOP views and Concept dimension

1. From the edu.harvard.i2b2.data\Release_1-7\NewInstall\Crcdata folder, run the ant command: ant -f data_build.xml db_demodata_load_data
1. This will execute the  BUILD_ACT_OMOP_Views _<dbtpye> script from the edu.harvard.i2b2.data\Release_1-7\NewInstall\crcdata\act-omop\scripts\<db type> folder and will create the OMOP views under the Views section in the database.
2. In addition, the corresponding ACT-OMOP concept_dimension data is populated by executing the scripts form the crcdata.zip folders.

              2.  You can now run queries against the OMOP tables from the web client interface

Step 3: Execute Totalnum counts

Load and execute file totalnum_usp/sqlserver/totalnum_fast_prep_OMOP.sql and run the following command:

exec totalnum_fast_prep_OMOP 'observation_fact','dbo','@

When finished, verify by checking that c_totalnum columns in your ontology tables contain numbers. These total counts will be visible in the ontology browser in the web client for 2b2 users with DATA_AGG user permission.

ACT OMOP Totalnum Scripts

Totalnum Scripts (patient counting scripts) have been updated to improve the counter's performance on both multiple ontology tables and very large(>1.5 million) ontologies  such as ACT medications. Debug messages have also been added for troubleshooting and profiling purposes. Support for multiple fact tables has been added and bugfixes have been made.

Patient Counting Scripts ("totalnum")

Improved CRC scripts execution Process

Prior to 1.8 release, CRC scripts via ANT execution command supported single CRC zip folder structure. 1.8 release will support multiple CRV zip folder execution. The databuild.xml has been modified for this process.

Changelog

Database Drivers

The JDBC drivers were updated to the following versions.

Supported Db Server versions

Supported software versions

Supported Operating Systems

 Rocky linux 8 and 9, CentOS versions  7

Windows 2016 -2019

Unofficially, MacOS and other flavors of Linux are likely to work.

i2b2 Server and Client Changes

New Features and Improvements

i2b2 Database Changes

New Features and Improvements

Bug Fixes

Notes for Developers

For Java 11 install, if you change the xsd (REST API message definitions), then you will need to regenerate gensrc via JAXB in Java 8. In the i2b2-core cell directory for which you're regenerating the XSD-Java, run the ant target "jaxb_gen" on Java 8 and then build as usual using Java 11.