Multi-fact Table
Space shortcuts
Space Tools

Versions Compared

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 
Anchor
multifact_install_assumptions
multifact_install_assumptions

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 fact tables have been setup and reside in the same database. 
  • The assumption is that the 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 up the CRC to use multiple fact tables is fairly easy. If 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 the terms in your metadata tables so the 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 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.