Observational Health Data Sciences and Informatics

A given institution implementing a CDM may have more than one datasets in CDM. A research may want to execute an OHDSI study on multiple CDM datasets and data and result schema should not refer to conflicting table names.

This wiki page documents a configuration that is most common at many implementing institution.

For example, a read-only schema with CDM data (e.g., person table, measurement table) may be in schema `dataA`. To allow (for example for Achilles) to write to result tables (e.g., achilles_results table), a corresponding schema (with write privileges) would be `dataA_results`.

The convention is that OHDSI software tools or studies do not try to manage various datasets (e.g., by columns in result tables (column for dataset in achilles_results table (for exmaple)). Instead, they rely on separation of results by simply separate database result schemas for each dataset.

ADDITION: So, if you have a CDM in schema 'dataA' and it is read-only, you can create a new schema 'dataA_results' that is writable, and when you execute Achilles, specify dataA as the cdm_database_schema and dataA_results as the results_database_schema.

Example setup for multiple datasets:

  data schema,results schema
  ---------------------------
  dataA,dataA_results
  dataB,dataB_results