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

Versions Compared

Old Version 22

changes.mady.by.user Reeta Metta

Saved on

compared with

New Version 23

changes.mady.by.user Reeta Metta

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%







Section


Column

Requirements 
Anchor
multifact_install_requirements
multifact_install_requirements

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

  • You have a working version of i2b2 that is running release 1.7.12 or higher.
  • 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 database using SQL editor
  • 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. 
  • Your fact tables are organized by concept: e.g. all diagnoses facts are in one table; all medication facts in another




Setup Process 
Anchor
multifact_install_process
multifact_install_process

The process of setting up the i2b2 to use multiple fact tables is straight forward. Once you have updated your software to at least version 1.7.12 or higher, create 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 hive_cell_params table. Refer to Multi-fact table home


Multi-fact Table MFT