Message-ID: <1466847272.7454.1711622034288.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7453_409428964.1711622034284" ------=_Part_7453_409428964.1711622034284 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Stored Workplace data is distributed to projects through the exi=
stence of independent databases (in SQL Server) or schemas (in Oracle). The=
se will be referred to in the rest of the document as the "persiste=
nt storage location" or PSL. These PSL's are orga=
nized so that the data from two metadata representations can be merged to a=
"Super" data set. While a person is working on a specific project, they wi=
ll be directed to data in a PSL associated with that project.
In order to support the i2b2 project distribution stra=
tegy, the user is enrolled in numerous projects recorded within the i2b2 pr=
oject management cell. The projects available to the user are returned in t=
he web service call to the Project Management cell. The logic of selecting =
the correct PSL for the project is embodied in the following table.
DB_LOOKUP |
|
|
---|---|---|
PK |
C_DOMAIN_ID |
VARCHAR(255) |
PK |
C_PROJECT_PATH |
VARCHAR(255) |
PK |
C_OWNER_ID |
VARCHAR(255) |
|
C_DB_FULLSCHEMA |
VARCHAR(255) |
|
C_DB_DATASOURCE |
VARCHAR(255) |
|
C_DB_SERVERTYPE |
VARCHAR(255) |
|
C_DB_NICENAME |
VARCHAR(255) |
|
C_DB_TOOLTIP |
VARCHAR(255) |
|
C_COMMENT |
CLOB |
|
C_ENTRY_DATE |
DATE |
|
C_CHANGE_DATE |
DATE |
|
C_STATUS_CD |
CHAR(1) |
The =
logic for selecting the PSL is as follows:
"DOMAIN" |
"PROJECT" |
"USER_ID" |
For example, only if the domain \ =
project \ user_id is an EXACT match to the entries in the database wil=
l that PSL be used.
Othe=
r columns are specified as follows:
To r=
estate, many cells need to access some kind of persistent storage, and thes=
e cells will organize their persistent storage so that it is self-contained=
and can be apportioned in a way consistent with the project-based requirem=
ents of i2b2 that are described above. To that end, a table exists in many =
cells to make the decision of what persistent storage location to which a s=
pecific user will be directed, depending on the project and domain to which=
they are associated.