Chapter 3. Data Installation
The data installation chapter outlines the process of installing the i2b2 data. This process involves creating tables, procedures and triggers as well as loading data into the tables.
Chapter 3. Table of Contents
3.0 Prerequisites
3.2 Data Installation Overview
3.3 Create Database User Accounts
- 3.3.3 Create User Accounts in SQL Server
- 3.3.1 Create User Accounts in Oracle
- 3.3.2 Create User Accounts in PostgreSQL
3.4 Crcdata Tables
- 3.4.4 Create Crcdata Stored Procedures
- 3.4.2 Set Database Properties
- 3.4.5 Load Crcdata Tables
- 3.4.3 Create Crcdata Tables
- 3.4.1 Working Directory
3.5 Hivedata Tables
3.6 IM Tables
3.7 Metadata Tables
- 3.7.4 Load Metadata Tables
- 3.7.1 Working Directory
- 3.7.2 Set Database Properties
- 3.7.3 Create Metadata Tables
3.8 PM Tables
- 3.8.1 Working Directory
- 3.8.4 Create PM Triggers
- 3.8.3 Create PM Tables
- 3.10.5 Load PM Tables
- 3.8.2 Set Database Properties
3.9 Workdata Tables
- 3.9.4 Load Workdata Tables
- 3.9.2 Set Database Properties
- 3.9.3 Create Workdata Tables
- 3.9.1 Working Directory
3.10 Next Steps
3.11 Multiple Fact Tables
Patient Counting Scripts ("totalnum")
i2b2-on-OMOP With ENACT-OMOP Ontology v4.1