Search

Help

Page 1 of 72. Showing 714 results (0.024 seconds)

  1. Multi-fact Table Home

    a character sequence to support sorting documents. hide i2b2 Multiple Fact Tables Project Name: Multi-fact table Repository Location … it Download the i2b2 Software i2b2 Website http://www.i2b2.org/software Project Summary The multi-fact table project is a new feature
    Multi-fact Table • Mar 08, 2022

  2. Multi-fact Table

    The multi-fact table project is a new feature introduced in 1.7.09 that enables the i2b2 to query more than one fact table. This new feature empowers … in a single table.
    Multi-fact Table • Mar 05, 2018

  3. 3.11 Multiple Fact Tables

    Multi-fact Table Home
    Developers Getting Started With i2b2 • Mar 08, 2022

  4. Update Ontology Tables

    How classic i2b2 works The standard i2b2 star schema only allows for one fact table. In the i2b2 database this is the observation_fact table.  When running a query in the i2b2, the CRC queries against the observation_fact table by default.   Update Metadata The CRC needs to know the name of the fact table
    Multi-fact Table • Mar 01, 2018

  5. Setup Guide

    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. Requirements  The following items are required for multi-fact tables to work correctly.  You have a working version of i2b2 that is running release
    Multi-fact Table • Mar 08, 2022

  6. Patient Counting Scripts ("totalnum")

    Mappings files are not supported. i.e. the c_basecodes in your ontology tables must be the same codes used in your fact tables. image2023-12-5_15-55-30.png … . ACT_VISIT_DETAILS_V4 and ACT_DEM_V4 table names are presently hardcoded, so change if your table names are different. If you use more than one fact table
    Developers Getting Started With i2b2 • Dec 07, 2023

  7. i2b2 Data Mart & Ontology

        This page is a brief overview of the i2b2 Data Mart and Ontology in relation to the Multi-fact table project. It only touches the surfaces of the i2b2 … in a star schema format. A star schema contains one fact and many dimension tables. This statement although true is no longer completely accurate for the i2b2
    Multi-fact Table • Mar 01, 2018

  8. "Totalnum" Patient Counting Scripts

    , not (exclusively) the concept_dimension or Adapter Mappings files. Multiple fact tables cannot coexist in the same hierarchy. (i.e. any single ontology can reference a fact table other than observation_fact, but it cannot reference multiple fact tables) Running the scripts See database-specific instructions below. After
    Additional Tutorials and Documentation • Sep 21, 2021

  9. Update CRC Properties File

    CRC Properties Configuration In order for the CRC to know there are multiple fact tables the queryprocessor.multifacttable property in the crc.properties file … : queryprocessor.multifacttable Value Behavior false The CRC will continue to work as it does in the classic i2b2. Only one fact table (observation_fact) will be queried
    OMOP • Apr 04, 2017

  10. OBSERVATION_FACT Table

    The OBSERVATION_FACT table is the fact table of the i2b2 star schema and represents the intersection of the dimension tables. Each row describes one observation about a patient made during a visit. Most queries in the i2b2 database require joining together the OBSERVATION_FACT table with one or more dimension tables
    Server (Cells) Design • Jul 15, 2020