Search

Help

Page 2 of 72. Showing 711 results (0.025 seconds)

  1. 5. Advanced Topics

    : https://www.i2b2.org/software/files/PDF/current/IM_Design.pdf https://www.i2b2.org/software/files/PDF/current/IM_Design.pdf 5.2 Multiple Fact Tables Starting with release 1.7.09, the i2b2 software supports multiple fact tables. This enables, for example, diagnoses to be stored in one fact table, laboratory tests in a second fact table
    BundlesFeb 03, 2021
  2. I2b2 grid integration.ppt

    Fact Table. The Ontology Mapper adds 2 additional fact tables, the Mapped Data and Mapped Aggregate fact tables. Therefore to fully integrate Workbench to Ontology Mapper we have created a simple database View which is a UNION the 3 fact tables and which presents a table definition that is identical to the Obs Fact Table
    Health Ontology Mapper / … / HOM HomeDec 20, 2010
  3. I2B2 DATA MART

    central fact table surrounded by one or more dimension tables. The most important concept regarding the construction of a star schema is identifying what … at that time (there may be many diagnoses of diabetes for this patient over time). The fact table contains the basic attributes about the observation, such as the patient
    Server (Cells) DesignSep 04, 2018
  4. 2. Quick Start Guide

    warehouse modeled on the star schema structure first proposed by Ralph Kimball. The database schema looks like a star, with one central fact table surrounded by one or more dimension tables. The most important concept regarding the construction of a star schema is identifying what constitutes a fact. In healthcare, a logical
    BundlesFeb 03, 2021
  5. OMOP

    The legacy i2b2 data model is comprised of a central fact table (observation_fact) surrounded by multiple dimension tables (star schema). In the Observation Medical Outcomes Partnership (OMOP) Clinical Data Model (CDM) rather than a central fact table, we have a collection of them distinguished by domain: procedures
    OMOPMar 16, 2017
  6. Mapper_Schema_Design.doc

    the transformed data from the source data and also to keep the i2b2 fact table (OBSERVATION_FACT) design intact. Mapper functionality required several design changes … a similar structure as the i2b2 fact table with the flexibility of effecting new design changes required for the Mapper functionality. In accordance
    Health Ontology Mapper / … / HOM HomeDec 20, 2010
  7. 3. Table and Field Definitions and Descriptions

    https://community.i2b2.org/wiki/display/ServerSideDesign/MODIFIER_DIMENSION+Table The relationships between these dimension tables and the fact table are described … This chapter contains a complete reference list of tables and fields in the i2b2 CDM, followed by a detailed description of each of the tables. 3.1 Schema
    BundlesFeb 03, 2021
  8. Translational Bioinformatics Warehouse Database Design v2.pdf

    processing. The dimensional model is composed of a fact table joined to several dimensions. A fact table is the primary table of the dimensional model. Each fact table contains measurable facts. “A row in a fact table corresponds to a measurement. A measurement is a row in a fact table. All the measurements in a fact
    Health Ontology Mapper / … / HOM HomeDec 20, 2010
  9. OntoMapper Minutes 6 17 08.doc

    of i2b2 to make integration easier. We are layered between the fact table (built during ETL) and the CRC (Clinical Research Chart) data mart which i2b2 uses … grant is approved. 2) Our system reads data from the Observable Fact Table and writes data to a new fact table called the Map Data Fact Table. So we
    Health Ontology Mapper / … / HOM HomeDec 20, 2010
  10. i2b2 Usage Community FAQ

    clustered columnstore indexes for the fact table. All platforms If your fact table is extremely large, consider splitting it into multiple fact tables. ... more … table. To allow a user to repeat the same query after the lockout number of attempts, you must delete the previous queries from the qt_query_master table