Server (Cells) Design
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A hive can have multiple projects setup. More technical detail can be found in 6.6 Managing i2b2 Projects

Anchor
_Toc340148029
_Toc340148029
Project Data

...

  • Parameters entered here are specific to the project.
  • The project parameters can be added from the project parameters page.
  • The information will be stored in the PM_PROJECT_PARAMS table.





Project Database Lookup

  • Each i2b2 cell has a DB_LOOKUP table that defines the Wildfly XML datasource name for each project.
  • Expand Manage Cells in the Navigation Tree on the left of the page. Then select the cell to expand further, once this is done you will see DB-Lookup as an option. Clicking on DB-Lookup will display the DBLookup List page. This page will display all the values in a table format.
  • To add a new entry into the DB_LOOKUP table simply click on the Add New DBLookup button that appears above the table of existing values. The page will be updated to a form with fields to capture the information to be stored in the DB_LOOKUP table.
  • To edit an existing entry, click on its Name located in the Navigation Tree on the left. The page will be updated to show the values currently filed in the DB_LOOKUP table. Make any changes and click on Save to save your edits.


dbLookup.pngImage Added

Anchor
_Toc340148031
_Toc340148031
Project Users

...

Each user will have at least two roles per user_id and product_id combination. These two roles can be further defined as a Data Protection role and a Hive Management role.
The data protection role establishes the detail of data the user can see while the hive management role defines the level of functionality the user has in a project. The following tables summarize the roles in a hierarchical order of least to most access.

Data Protection Track

 


Role

Access Description

DATA_OBFSC

OBFSC = Obfuscated

  • The user can see aggregated results that are obfuscated (example: patient count).
  • The user is limited on the number of times they can run the same query within a specified time period. If the user exceeds the maximum number of times then their account will be locked and only the Admin user can unlock it.

DATA_AGG

AGG = Aggregated

  • The user can see aggregated results like the patient count.
  • The results are not obfuscated and the user is not limited to the number of times they can run the same query.

DATA_LDS

LDS = Limited Data Set

  • The user can see all fields except for those that are encrypted.
  • An example of an encrypted field is the blob fields in the fact and dimension tables.

DATA_DEID

DEID = De-identified Data

  • The user can see all fields including those that are encrypted.
  • An example of an encrypted field is the blob fields in the fact and dimension tables.

DATA_PROT

PROT = Protected

  • The user can see all data, including the identified data that resides in the Identity Management Cell.



Hive Management Track

 


Role

Access Description

USER

Can create queries and access them if he / she is the owner of the query.

MANAGER

Can create queries as well as access queries created by different users within the project

...