wiki:LEGACY - i2b2OntologyCRC-1

Version 3 (modified by jeff.lusted, 13 years ago) ( diff )

--

i2b2 Ontology and CRC Discussion: 1

Questions asked and points to ponder. Access to the demo database is useful here...

Ontology Cell tables compared to CRC concept_dimension table

There are three ontology tables within the demo Ontology cell: birn, i2b2 and custom_meta.

When I do a select count(*) from <table_name> where c_visualattributes like '%LA%' I get the following figures:

  • birn: 37
  • custom_meta: 0
  • i2b2: 93807

When I do a "select count(*) from concept_dimension" within the CRC cell I get a count of 73590.

The totals are 93844 as opposed to 73590. Why is there a difference and what does it mean?

Note: See TracWiki for help on using the wiki.