Multi-fact Table
Space shortcuts
Space Tools
Multi-fact Table MFT

Versions Compared

Old Version 11

changes.mady.by.user Janice Donahoe

Saved on

compared with

New Version 12

changes.mady.by.user Janice Donahoe

Saved on

Key

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

Multi-fact Table Setup Guide

This Setup Guide is designed to assist users with updating an existing i2b2 environment to be able to query multiple fact tables.

Column
width10%

html-text
<div style="margin-left: 60px;">
    <p>
        <span class="image-wrap" style="">
            <a class="confluence-thumbnail-link 625x390" href="https://community.i2b2.org/wiki/download/attachments/14092911/multifact-setup-guide.pdf">
                <img src="https://community.i2b2.org/wiki/download/attachments/14091764/Adobe_PDF_file_icon_32x32.png" alt="pdf icon" width="42" height="42" style="float:right" vertical-align="middle">
            </a>
        </span>
    </p>
</div>

Column
width12%

 

 

Assumptions 
Section
Column

Requirements 

Anchor
multifact_install_

assumptions

requirements
multifact_install_

assumptions

requirements

The following items are required in order for multi-fact tables to work correctly.

This setup guide assumes the following:

 

  • You have a working version of i2b2 that is running release 1.7.09 or higher.
  • The i2b2 Admin module has been installed.
    • All of your
    • All your fact tables reside in the same database.
    • All fact tables have the same data structure including primary keys & indexes.
    • observation_fact remains as one of the fact tables
    Column
    width5%

     

    Column

    Assumptions 
    Anchor
    multifact_install_assumptions
    multifact_install_assumptions

    This setup guide assumes the following: 

    • You know how to access and update your CRC properties file.
    • You are familiar with i2b2 data; metadata & data mart tables. (See i2b2 Data Mart & Ontology page for a quick overview)
    • Your fact tables have been setup
    and reside in the same database
    • . 
    The assumption is that the
    • Your fact tables are organized by concept: e.g. all diagnoses facts are in one table; all medication facts in another

    html-text<div class="i2b2-panel"> <table class="i2b2-important"> <colgroup> <col width="24"> <col> </colgroup> <tbody> <tr> <td> <img src="https://community.i2b2.org/wiki/download/attachments/14091764/icon_important.png" width="16" height="16" align="absmiddle" alt="important" border="0"> </td> <td> <b>Important</b> <br>If you are new to i2b2 or not familiar with how to install and setup the i2b2, we highly recommend you look at the <a href="https://community.i2b2.org/wiki/display/getstarted/i2b2+Installation+Guide">i2b2 Installation Guide</a> and go through the steps to setup the i2b2 demo environment. </td> </tr> </tbody> </table> </div> 

    Setup Process 
    Anchor
    multifact_install_process
    multifact_install_process

    Setting The process of setting up the CRC i2b2 to use multiple fact tables is fairly easystraight forward. If Once you are using your existing data sources and projects all you need to do is turn on the new parameter in the crc.properties file and update have updated your software to at least version 1.7.09, created your new fact tables and loaded the data into them there are only two remaining steps.

    1. Update the terms in your metadata tables so the i2b2 server knows what fact table to query
    2. Turn the Multi-fact table feature on in the crc.properties file

      crc knows where to find the fact table. Steps on how to do this are located in the Update CRC Properties File section of this guide.However, if you are setting up a new data source and / or project there are additional steps you need to take that are outside the scope of this project. Additional information on how to do this has been provided on the Additional Resources page of this space.

    Multi-fact Table MFT