Page History
Overview of CRC Data Installation
The crcdata tables are part of the Data Repository (CRC) Cell. The following outlines the steps that will be taken during the crcdata installation.
Step 1: Change your working directory
Step 2: Configure the database properties for the crcdata
Step 3: Create the crcdata tables, indexes and sequences
Step 4: Create the stored procedures
Step 5: Load sample data into the tables
Step 6: Create the OMOP views
Step 1: Change Working Directory
Anchor | ||||
---|---|---|---|---|
|
During the CRC Data Installation we will be working with the crcdata directory. Within this directory are the files we will be editing to define the database properties, create the crcdata tables and load the sample data provided with the i2b2 on OMOP data package.
To change your working directory to the crcdata directory enter the following command:
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Excerpt | ||
---|---|---|
|
EXAMPLES:
indent | ||
---|---|---|
| ||
Windows Command: CD C:\opt\data\i2b2_omop_data\oracle\CRCdata |
indent | ||
---|---|---|
| ||
Linux Command: CD /opt/data/i2b2_omop_data/oracle/CRCdata |
Step 2: Configure the database properties for the crcdata
Anchor | ||||
---|---|---|---|---|
|
Step 3: Create the crcdata tables, indexes and sequences
Anchor | ||||
---|---|---|---|---|
|
Step 4: Create the stored procedures
Anchor | ||||
---|---|---|---|---|
|
Step 5: Load sample data into the tables
Anchor | ||||
---|---|---|---|---|
|
Step 6: Create the OMOP views
Anchor | ||||
---|---|---|---|---|
|