User Tools

Site Tools


documentation:next_cdm:schema_revisions

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
documentation:next_cdm:schema_revisions [2016/11/01 17:28]
cgreich
documentation:next_cdm:schema_revisions [2017/12/18 00:20]
chrisknoll
Line 17: Line 17:
 In April 2012 the [[http://​75.101.131.161/​download/​loadfile.php?​docname=CDM%20Specification%20V4.0|CDM V4 specification]] introduced the cohort table as a location to store records that share a particular feature during a particular time span and defined cohorts as a group of entities exposed to a common circumstance. ​ This table has since been included as part of the DDL statements to create a CDM database.  ​ In April 2012 the [[http://​75.101.131.161/​download/​loadfile.php?​docname=CDM%20Specification%20V4.0|CDM V4 specification]] introduced the cohort table as a location to store records that share a particular feature during a particular time span and defined cohorts as a group of entities exposed to a common circumstance. ​ This table has since been included as part of the DDL statements to create a CDM database.  ​
  
-When the initial tool to create cohort definitions ([[documentation:​software:​circe|CIRCE]]) was introduced it leveraged the existing ​cohort table that was found in the CDM schema ​as the location ​where it would store people identified when a cohort definition is executed against a CDM database ​resulting in a cohort of people.  ​+When the initial tool to create cohort definitions ([[documentation:​software:​circe|CIRCE]]) was introduced it introduced a new 'cohort' ​table that was found in the results ​schema where it would store people identified when a cohort definition is executed against a CDM database.  ​
  
 Since that time many other tools have been created and new tables have appropriately been deployed in the separate results schema to store the data that they derive from the CDM schema. ​ This represents the fundamental issue we are seeking to resolve whereby some derived results are being stored in the CDM schema specified table and others are defined and maintained in the results schema. Since that time many other tools have been created and new tables have appropriately been deployed in the separate results schema to store the data that they derive from the CDM schema. ​ This represents the fundamental issue we are seeking to resolve whereby some derived results are being stored in the CDM schema specified table and others are defined and maintained in the results schema.
documentation/next_cdm/schema_revisions.txt ยท Last modified: 2018/02/12 20:23 by patrick_ryan