Version Compatibility

Overview



OpenI has been tested to work with i2b2 versions 1.3 and above. Since OpenI integrates with i2b2 at database schema level, the version compatibility essentially depends on how i2b2 database schema differs from one version to another. 

To test this, we loaded i2b2 demo database schema from version 1.3, 1.5, and 1.6.03 into a SQL Server Express database and compared the tables using Red Gate's SQL Compare tool. Not surprisingly, the base database schema does not change at all except for a few minor fields, which are not used by OpenI at all.

So, the same ETL script that works for version 1.3 WILL work for version 1.6.03 in terms of pulling data out of i2b2. What changes from one OpenI installation to another is the number of concepts that needs to be brought in as dimensions and their corresponding hierarchies (or "ontologies").

Here are our detailed findings:

Schema Differences


Between i2b2 1.3 and 1.5


No differences except Observation_Fact in 1.5 has instance_num


Between 1.3 and 1.6.03


observation_fact in 1.6.03 has 2 additional fields:



patient_dimension in 1.6.03 has 1 new field: income_cd



visit_dimension in 1.6.03 has length_of_stay


Between 1.5 and 1.6.03


observation_fact in 1.6.03 has instance_num as not null and adds text_search_index:


patient_dimension in 1.6.03 has income_cd



visit_dimension in 1.6.03 has length_of_stay

Comments