Migration scripts for an I2B2 database.
The goal of this project is to provide a Docker container including Alembic and a Python model of the I2B2 schema.
We use an I2B2 database twice in the Data Factory:
- I2B2 capture database: this database is used to capture as much as possible information from hospitals or research datasets, even if we do not understand it or know yet how to use it in MIP. Information in this database will be transformed and normalised into the I2B2 CDE database each time the MIP CDE (Common Data Elements) evolve or the mapping for the source data to the normalised CDE data needs adjustment.
- I2B2 CDE database: this database contains the variables selected by the Data Governance and Data Selection committee, in a normalised form in order to ensure a consistent representation of data across sites. Data in this database is then exported into the LDSM database, using a structure facilitating its use by Queries and the Algorithms.
Example:
docker run --rm -e "DB_URL=postgresql://postgres:postgres@localhost:5432/postgres" hbpmip/i2b2-setup:1.5.2 upgrade head
Run: ./build.sh
Run: cd tests && ./test.sh
Run: ./publish.sh
Copyright (C) 2017 LREN CHUV
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
This work has been funded by the European Union Seventh Framework Program (FP7/20072013) under grant agreement no. 604102 (HBP)
This work is part of SP8 of the Human Brain Project (SGA1).