Changes between Version 2 and Version 3 of LEGACY - i2b2OntologyCRC-1


Ignore:
Timestamp:
02/21/11 11:53:10 (13 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • LEGACY - i2b2OntologyCRC-1

    v2 v3  
    33
    44=== Ontology Cell tables compared to CRC concept_dimension table ===
    5 There are thress ontology tables within the demo Ontology cell: birn, i2b2 and custom_meta.[[br]]
    6 When I do a select count(*) where c_visualattribute like '%LA%' I get:
     5There are three ontology tables within the demo Ontology cell: birn, i2b2 and custom_meta.[[br]]
     6
     7When I do a select count(*) from <table_name> where c_visualattributes like '%LA%' I get the following figures:
    78   * birn: 37
    89   * custom_meta: 0
    910   * i2b2: 93807
     11
     12When I do a "select count(*) from concept_dimension" within the CRC cell I get a count of 73590.[[br]]
     13
     14The totals are 93844 as opposed to 73590. Why is there a difference and what does it mean?