i2b2 Release 1.7.09 Release Notes 

 

Release Date: June 16, 2017

1.7.09 Release Highlights

Querying multiple observation fact tables

Support for the OMOP Common Data Model (CDM)

Minor bug fixes – see release notes for details

1.7.09 Release Summary

The standard i2b2 star schema only allows for one fact table, the observation_fact table. We have heard from the community there is a need to be able to search multiple fact tables with a single query. In release 1.7.09, the i2b2 has been updated to accommodate this growing need.

This new feature enables the i2b2 to adapt to the needs of the Patient Centered Outcome Research Institute (PCORI) network. It also supports the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM).

The i2b2 Community Wiki has additional information about multi-fact tables and i2b2 on OMOP. The following links will take you to their respective space on the wiki.

 Multi-fact table documentation i2b2 on OMOP project

A complete list of all the bug fixes and new features can be found in the Change Summary sections.

 Change Summary - i2b2 Core Software

Change Summary - i2b2 Web Client Software

Installation Notes

This release note applies to you if you are upgrading to 1.7.09 from an earlier version of i2b2.

If you are installing 1.7.09 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.

If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.

Upgrade Notes

i2b2 Release 1.7.09 contains changes to the following software components:

i2b2 Data i2b2 Server (core software) i2b2 Web Client

Change Summary - i2b2 Core Software - Release 1.7.09

New Features

 [CORE-240] - Run queries using derived fact tables (Multi-fact table & OMOP)

Improvements

 [CORE-262] - Clean up connection handling

Bug Fixes

[CORE-228] - Exception when running parallel queries using Postgres

[CORE-237] - Cant build timeline when db is postgres

[CORE-246] - Entries being written to the PM user session log at the same time will cause a query to error

[CORE-247] - PDO requests with empty filter list not working

[CORE-252] - Remove hard-coded timeout setting for medium and large queues

[CORE-253] - Multiple queues are created on startup

[CORE-254] - Queue startup needs to flush any previously running queues

[CORE-256] - OMOP Temporal queries with Excluded concepts dont work

[CORE-257] - Remove "dbo" from the ICD9-ICD10 install scripts (SQL Server)

[CORE-258] - OMOP: Error returned when trying to view details of an item on the timeline

[CORE-263] - PostgreSQL Error: Too many parameters specified for RAISE

[CORE-264] - OMOP Data Scripts - valueflag_cd is misspelled in the create_omop_views.sql

[CORE-265] - OMOP Data Views: Need to add a view for the Provider table

[CORE-266] - When multi-fact property not found, an ERROR is logged; should be INFO

Change Summary - i2b2 Web Client Software - Release 1.7.09

New Feature

 [WEBCLIENT-206] - Custom Value Chooser Handling

Bug Fixes

[WEBCLIENT-154] - upon temporal query event selection, not able to drag and drop concept into anchoring observation if there are more than 3 grouppanels

[WEBCLIENT-207] - Max queries allows values <=0

[WEBCLIENT-210] - Cancelling the first query of a session causes error

[WEBCLIENT-211] - Query cancel causes prior query to be deleted

[WEBCLIENT-212] - PHP proxy does not support ports in automatic detection

Improvement / New Feature Details

Multi-fact tables

As stated earlier the standard i2b2 star schema only allows for one fact table, however [CORE-240] enables the crc to query multiple fact tables.

The setup is fairly simple; In the crc.properties file you will find a new parameter called queryprocessor.multifacttable, and when this parameter is set to true the crc will query all the fact tables you have setup.

The parameter is delivered with the value set to false, which means the multi-fact table feature is turned off and the CRC will behave as it has always done (prior to this release).

Important This same parameter is used by the i2b2 on OMOP project. For more information on this project please see the i2b2 on OMOP project space on the i2b2 Community Wiki.

Custom Value Choosing Handling

We are working on re-developing the way the lab value chooser works in the web client. The new implementation will allow for custom lab value handling in a modularized way. WEBCLIENT-206 is laying the ground work for this re-design. Users will not notice a difference on how they select lab values.

Note We are working on re-developing the way the lab value chooser works in the web client. The new implementation will allow for custom lab value handling in a modularized way. WEBCLIENT-206 is laying the ground work for this re-design. Users will not notice a difference on how they select lab values.

 

Licensing

The i2b2 source code is licensed under the i2b2 Software License 2.1. This includes but is not limited to all code in the edu.harvard.i2b2.* package namespace.

Trademarks

Microsoft, Windows, Windows 7, Windows Server 2003 and 2008 are either registered trademarks or trademarks of Microsoft Corporation in the United States and / or other countries.

Mac OS is a registered trademark of Apple Inc.

Eclipse Galileo is a registered trademark of the Eclipse Foundation, Inc.

All other trademarks are the property of their respective owners.

References

1. Original document (for all releases)  https://www.i2b2.org/software/releaseNotes_current.pdf