Understanding the OCHIN Data

The OCHIN data is organized into different Views per Project. Within these views are Tables in i2b2 format.

You have access to two databases.

The first is the Raw database, which contains the patient data. You have read-only access to this database.

• For AIM AHEAD Year 1 programs, the Raw database is named FellowsSample.

• For AIM AHEAD Year 2 programs, the Raw database is named AAOCHIN2023.

Within the Raw database, you must open the View specific to your project. Your OCHIN Project ID will be provided to you when you receive confirmation of your OCHIN DB Login Activation.

Once you have opened your View, you will see the Tables which contain the subset of data specific to your project.

• Tables containing patient-level data specific to your project will be prefixed with your OCHIN Project ID.

• Tables that contain metadata shared amongst all projects are prefixed with "common".

The second database is your Project database, which is unique to your project. The project database is named after your OCHIN Project ID. You have read-write access to this database.

Your project database is initially empty. All temporary tables or aggregate results for your project should be saved here. You can store up to 50GB in your project database. This is not a lot! The full Raw database has over 1TB of data. If you copy data directly from the Raw database to your project database, you will quickly run out of space.

Note that you can use SQL Server temp tables (with a “#” prefix on the table name) in your queries, and that will not use space in your project database. However, temp tables are automatically dropped when your database connection ends.