Multi-fact Table
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

i2b2 Multiple Fact Tables

Project Name:Multi-fact tableRepository Location:
Developer/s:Lori Phillips, MS

Institution/s:Partners HealthCarei2b2 Components:i2b2 Server
Email:lcphillips@partners.orgKeywords:i2b2, multifact
I want to...Where to find it
View the setup documentationSoftware Configuration
Download the i2b2 Softwarei2b2 Website

Project Summary

The multi-fact table project is a new feature that has been added to version 1.7.09 of the i2b2. Prior to this release, the i2b2 star schema could only support one fact table (observation_fact). We have noticed an increasing need for the i2b2 to be able to search multiple fact tables with a single query. The i2b2 server has been updated to allow those sites that want to use multiple fact tables will have the option to do so. A new parameter called “queryprocessor.multifacttable” has been added to the file.  

 "true"  value will turn on the multi-fact table feature. The CRC will query all the fact tables you have setup in your environment.

"false" value will disable the multi-fact table feature and only search the single observation_fact table.

This new feature enables the i2b2 to adapt to the needs of such projects as the Patient Centered Outcome Research Institute (PCORI) network and the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM). It can also be used for sites that want to be able to query both genomic and phenotype data but don't want the data to reside in a single table.

Beginning in 1.7.12, the CRC properties are in the database! See this link.

  • No labels