Developers Getting Started With i2b2
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata


The i2b2 data is stored in a relational database in a star schema format. Currently, the i2b2 supports three different database management systems (DBMS); Only one of them is required to store your i2b2 data.

1. Oracle
2. PostgreSQL
3. SQL Server


The DBMS you choose to use is dependent on what works best for your institution. At this point in the installation all that we require is that you have a DBMS setup in your environment.


If you do not have a DBMS currently setup then you will need to do so at this point in the installation. The setup of the DBMS is specific to the version you are installing, therefore we recommend you follow the installation procedures documented by the vendor providing the software. The following table provides the links to the websites for each DBMS.


DBMS

Version

Website

Oracle

12 and 18

http://www.oracle.com/us/downloads/index.html

PostgreSQL

9.x (and 10.x unofficially)

http://www.postgresql.org/download/

SQL Server

2012+ (through 2019)

https://www.microsoft.com/en-us/sql-server/sql-server-downloads