Changes between Version 7 and Version 8 of i2b2 Database Structure

Timestamp:

02/21/11 08:16:21 (14 years ago)

Author:

jeff.lusted

Comment:

--

i2b2 Database Structure

@@ -1 +1 @@
 == i2b2 - DB Basics ==
 
-This is a very bare basics. At this stage we should be primarily interested in the observation_fact table and its relationship with the concept_dimension table within the CRC Cell. And then the correspondence with any ontology tables within the Ontology Cell. Interest in the patient_dimension, visit_dimension and other of the tables within the CRC are a little further down the line.
+This is a very bare basics. At this stage we should be primarily interested in the observation_fact table and its relationship with the concept_dimension table within the CRC Cell. And then the correspondence with any ontology tables within the Ontology Cell. Interest in the patient_dimension, visit_dimension and other of the tables within the CRC are a little further down the line.[[BR]]
 
+There can be a number of ontology tables within the Ontology Cell. We know which are ontology tables by an entry in the table_access table.[[BR]]
+
+The QueryTool uses the ontology tables within the Ontology Cell to format queries for submission against the tables within the CRC Cell.
 {{{
 +-------------CRC Cell-------------+   +-----------Ontology Cell---------+
@@ -26 +29 @@
 +----------------------------------+
 }}}
-There is much more to it than the above suggests. It needs a deal of studying.[[BR]]
-There can be a number of ontology tables within the Ontology Cell. We know which are ontology tables by an entry in the table_access table.