Release Management
Space shortcuts
Space Tools
Release Management RM

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info Box
titleImportant links

Downloads:

Relevant Documentation:


1.8.2

...

Release Notes

i2b2 1.8.2 -beta Release introduces functionality of user-created data table definition and data download of limited data sets (LDS). The Data Request Management tool enables project managers to manage the data file exports. In addition, there are minor improvements in the Query tool, improvements to the fast "totalnum" patient counting scripts,  and some bug fixes.

...

Top New Features

Description

Export Extension: Create data table for Export Extension for i2b2

The Create Data Table tool allows the i2b2 user to create their own data table definitions with ontology variables and then request data exports in the Run Query dialog.

Export Extension: Data Request Manager Extension for i2b2

The Data Request Manager tool allows an i2b2 manager to manage and process the user data requests.  

NOTE: In this beta release, clicking Create File on a custom-table data request in a Postgres database does not actually generate the file.

Enhanced Data Exporter (v1.8.1)

Image Removed

v1.8.1-style data exports (

Both custom table exports and exports of pre-defined tables defined by domain

)

can

now

be run and managed using the new tools.

Manager users can manage and generate these data file exports using the Data Request Manager Console

 



ENACT Ontology v4.2

Upgraded to UMLS 2025AA:

  • Lab (Provisional)
  • Medications grouped alphabetically
  • Medications grouped by VA Classification
  • Diagnosis ICD10CM
  • Procedures CPT4
  • Procedures HCPCS
  • Procedures ICD10PCS

Other updates:

  • Lab (Common)
  • Demographics
  • Social Determinants of Health
  • Research Ontology
  • Vaccines

 Update to new secure versions of software

 Image Added

The new server uses Java 17, Wildfly 37.01, and Axis2 v2

Digital Twin Bundle (distributed separately) 

Tools for computing loyalty cohorts and computational phenotypes in i2b2. 

Bug fixes and minor feature updates

Image AddedImage ModifiedImage Added

Totalnum (patient counting) scripts have been updated, and the PM cell has performance enhancements (a database trigger to rotate the pm_user_session table)

Detailed Documentation on New Features

...

  • User logs into i2b2 webclient and creates Data table definition using the Create Data Table tool, using desired Ontology elements
  • User runs a regular i2b2 query, checking the User-created Data request option(s) when running the query.
  • The manager logs in and views the data requests using the Data Request Manager Console.
  • Manager user generates the data export files using the Data Request Manager Console.
  • The generated data file is stored in a configurable location on the i2b2 server.

...

ENACT - V4.

...

2 Ontology

The V4.

...

2 Ontology

...

includes 19 ontologies-

...

12 updated and

...

7 unchanged

Image Added


Metadata and CRC zip files

...

provided

...

in the NewInstall  load the latest ENACT Version-4.

...

2 ontology into your db schema using ANT scripts.

The CPT4 ontology table is not included with i2b2 due to AMA restrictions on redistribution of CPT code information. Contact the ENACT team to get a copy if your institution is an AMA member.

...

ENACT V4.

...

2 data load process

  1. Download and extract the newinstall zip package from "Download Binary Distribution" in the top section of https://www.i2b2.org/software
  2. Edit the  edu.harvard.i2b2.data\Release_1-8\NewInstall\Metadata\db.properties file to update the project properties to 'ACT' ; db.project=ACT
  3. From the edu.harvard.i2b2.data\Release_1-8\NewInstall\Metadata folder, run the ant command: ant -f data_build.xml db_metadata_load_data. This will execute the SQL scripts from the edu.harvard.i2b2.data\Release_1-8NewInstall\Metadata\act\scripts\<db type> folder to create and load the metadata tables 
  4. From the edu.harvard.i2b2.data\Release_1-8\NewInstall\crcdata folder, run the ant command: ant -f data_build.xml db_demodata_load_data. This will execute the SQL scripts from the edu.harvard.i2b2.data\Release_1-8NewInstall\crcdata\act\scripts\<db type> folder to create and load the concept_dimension 
  5.  Run the scripts from the edu.harvard.i2b2.data\Release_1-8\NewInstall\Metadata \<dbtype>\scripts folder to load the Schemes, Table_access tables
  6. You can now verify the new Ontology by logging into the webclient

...

Info

Note: the ENACT v4.2 ontology is distributed as a New Install only. If you are upgrading, install the v4.2 tables in a different schema from v4.1. Installing in the same schema will insert duplicate rows into the Ontology, Concept_dimension and Table_access tables


ACT Fast Totalnum Scripts

The 5x faster totalnum scripts (patient counting scripts) are now available for all three database platforms!

Patient Counting Scripts ("totalnum")

PM_USER_SESSION table rotation trigger

When a user logs in, the PM_USER_SESSION table size is now checked. If it has over 1000, all of the expired sessions after the first 100 are moved to a new PM_USER_SESSION_ARC table. A large PM_USER_SESSION table causes performance problems, and this is especially problematic when using SHRINE, which frequently starts new sessions.

Changelog

Database Drivers

...

Server Type

oracle

Postgresql

mssql

Driver Version

ojdbc8.jarojdbc11jar

postgresql-42.7.18.jar

mssql-jdbc-12.48.21.jre8.jar

Supported Db Server versions

...

Web client

WEBCLIENT-368   1.8.2 Webclient update     

CORE-370 VERACODE Scan - 1.8.2 Webclient                                                                                                                                                                                                                   

Core-server

CORE-456 Data Export: agg table

CORE-455  455 Data Export: Request Management admin tool

CORE-451 Enhanced Data Export - download file generation

CORE-459 updrade upgrade to wildfly 34 with axis2 version2

CORE-460 Upgrade to JAVA 17

CORE-454 Upgrade Spring jar to version 6

CORE-447  Update JDBC Update JDBC drivers

CORE-458 Software maintainence maintenance - drivers, libraries

CORE-445   java code java code folder structure for 1.7 should be changed to refer to 1.8.2       

CORE-473  VERACODE Scan - 1.8.2 Server code                                                                                                                                                                                                                                             

...

Release Management RM