Search

Help

Page 5 of 76. Showing 757 results (0.008 seconds)

  1. AMIA_Spring_IDR_v1.2.doc

    . Aggregation requirements posed a unique challenge related to the partial existence of facts. A separate fact table was designed to accommodate aggregate facts. The development of aggregate fact tables is a common practice in data warehousing, typically accomplished through a materialized view against the detailed fact
    Health Ontology Mapper / … / HOM HomeDec 20, 2010
  2. OMOP Home

    -on-FHIR tool that relies on the i2b2 API, over OHDSI ontologies, can run with an OMOP data source. The standard i2b2 data model is comprised of a central fact table … CDM), rather than a central fact table, we have a collection of them distinguished by domain:  procedures, condition, drug, measurement, observation, etc
    OMOPJun 23, 2017
  3. Data Storage

    The i2b2 data is stored in a relational database, usually either Oracle or SQL Server and always in a star schema format. A star schema contains one fact and many dimension tables. The fact table contains the quantitative or factual data, while the dimension tables contain descriptors that further characterize
    Server (Cells) DesignSep 04, 2018
  4. Use Case 2_ Add new facts

    In this case new facts are added to the OBSERVATION_FACT table regardless of whether or not the fact's encounter exists. This involves overwriting any matching fields. i.e. if the incoming fact matches a particular stored fact and its update date is greater than the update of the matching fact, then the new fact
    Server (Cells) DesignSep 04, 2018
  5. 1.7.13 Release Notes

    and profiling purposes. Support for multiple fact tables has been added and bugfixes have been made. Totalnum Scripts Setup If upgrading, create the totalnum … multiple fact tables, the recommended approach is to create a fact table view as the union of all your fact tables. (This is essentially going back to a single fact
    Release ManagementJan 31, 2023
  6. Query Building from Ontology

    ] [c_operator] [c_dimcode] The intent of this query is to associate a link between the dimension tables and the fact table for a given term. As a result every metadata SELECT SQL statement should return a fact table key. A sample concept_dimension-based term is shown: select concept_cd from
    i2b2 Developer's ForumOct 12, 2010
  7. Modifiers in i2b2 Data Model

    in the observation_fact table. The use of this column allows a single fact to be modified with an unlimited number of codes, for example: A drug can be modified … table, the modifier is represented by the modifier_cd column, which is now part of the primary key on the fact table. This column is a varchar(50) and its codes
    i2b2 Developer's ForumSep 14, 2011
  8. Ontologies 101 – Introduction – Your First i2b2 Ontology

    , at sites using OMOP CDM multi-fact-table-enhanced i2b2 Common Data Model (star-schema) To view and compare details of the domains and coding schemes included … (CONCEPT_DIMENSION table in CRC database) Concept Path, a unique identifier Concept Code, used in facts table other fields \i2b2\Diagnoses\Respiratory system (460
    Mark AbajianJun 05, 2025
  9. Ontologies 101 – Introduction – Your First i2b2 Ontology

    , at sites using OMOP CDM multi-fact-table-enhanced i2b2 Common Data Model (star-schema) To view and compare details of the domains and coding schemes included … (CONCEPT_DIMENSION table in CRC database) Concept Path, a unique identifier Concept Code, used in facts table other fields \i2b2\Diagnoses\Respiratory system (460
    Ontology Working GroupMay 29, 2025
  10. i2b2 Usage Community FAQ

    observation_fact tables, consider splitting into multiple fact tables. i2b2 running with SHRINE: Some sites have found that truncating pm_user_login … Timeout" to 180 or more. Tips for Optimizing i2b2 Query Speed PostgreSQL: Avoid using % in concept codes (it prevents index usage). Consider table