Contribution | Contributor | |
Totalnum Scripts for Postgres and MSSQL have been updated to improve the Totalnum counter performance on very large(>1.5 million) ontology elements such as ACT medications, Debug messages have also been added for troubleshoot purposes
Totalnum Scripts Setup
Oracle:
begin
RUNTOTALNUM('observation_fact','i2b2demodata');
end;
Note: If you get the error as: ERROR at line 1: ORA-01031: insufficient privilege, then run the command:
grant create table to (DB USER)
SQL server:
exec RUNTOTALNUM
PostgreSQL:
select RUNTOTALNUM('observation_fact','public')
– (replace 'public' by the schema name for the fact table)
– If using a schema other than public for metadata, you might need to run "set search_path to 'i2b2metadata','public' " first as well
These total counts will be visible in the ontology browser in the web client.
A new option is now available for loading Synthea data files into i2b2. Synthetic patient data generated by Synthea is hosted on SyntheticMass..The Synthea sample files have been converted to i2b2-ACT format. The zipped data files can be downloaded from https://github.com/i2b2/i2b2-synthea
Synthea Load Process:
Currently i2b2 db upgrade process is tedious involving multiple manual steps of running upgrade scripts and stored procedures. This release provides a single upgrade script which will perform the complete db upgrade.
The JDBC drivers were updated to the following versions.
Driver | New Version |
ojdbc8.jar | Oracle 12.2.0.1 |
postgresql-42.2.5.jar | PostgreSQL 42.2.5 |
mssql-jdbc-7.0.0.jre8.jar | MS Sql Server 7.0.0 |
Type | Version |
SQL Server | 2012+ |
Oracle | 12g+ |
Postgres | 9 |
Application | Version |
Java | 8 |
java | 11 |
Wildfly | 17.0.0 |
Apache HTD | 2.4.17 or higher |
Apache Ant | 1.9.6 |
Apache Axis2 | 1.7.1 |
PHP | 7.2.27 or higher |
New db updates include
For Java 11 install, if you change xsd, then modify the gensource.