In this chapter we will be using the scripts provided in the data package to create tables and load them with sample data.

Assumptions

The data in this package provides data for a domain of i2b2demo and a project of Demo. The assumption is that the PM Service will be configured as such when installing the PM Cell.

Order of Installation

The basic steps that will be taken during this installation are as follows:


Step 1:   Extract the i2b2 data package

Step 2:   Create database user accounts

Step 3:   Install the Crcdata Tables and Stored Procedures

Step 4:   Install the Hivedata Tables

Step 5:   Install the Imdata Tables (only if installing the IM Cell which is optional)

Step 6:   Install the Metadata Tables

Step 7:   Install the PM Tables and Triggers

Step 8:   Install the Workdata Tables



The details of what is to be done for each step are defined in the different sections within this chapter. It is important to follow steps in the order they are defined and not to skip any of them unless otherwise noted.