createDiffSummary: Generate a (numeric) summary of differences between two...
In OHDSI/Tantalus: A Tool For Comparing Different Versions of the Vocabulary

This function finds high level differences between two specified vocabularies (essentially sql COUNT comparison queries). The results of the queries are written to a JSON file and converted to html via inst/reports/GenerateDiffReport.Rmd. The summary report, diffSummary.html will be created in JSONFileLoc unless otherwise specified.

1
2
3

createDiffSummary(connectionDetails, oldVocabularyDatabaseSchema,
  newVocabularyDatabaseSchema, JSONFileLoc, reportFileLoc = JSONFileLoc,
  oracleTempSchema = NULL)

`connectionDetails`	An R object of type `connectionDetails` created using the function `createConnectionDetails` in the `DatabaseConnector` package.
`oldVocabularyDatabaseSchema`	The name of the database schema that contains the old vocabulary instance. Requires read permissions to this database. On SQL Server, this should specify both the database and the schema, so for example 'cdm_vocab.dbo'.
`newVocabularyDatabaseSchema`	The name of the database schema that contains the new vocabulary instance. Requires read permissions to this database. On SQL Server, this should specify both the database and the schema, so for example 'cdm_vocab.dbo'.
`JSONFileLoc`	Location of the JSON file created by the function.
`reportFileLoc`	Location of the html report, defaults to JSONFileLoc.
`oracleTempSchema`	For Oracle only: the name of the database schema where you want all temporary tables to be managed. Requires create/insert permissions to this database.

In an effort to assess the vocabulary proper (rather than the entire CDM), only the following tables are considered: 1. CONCEPT 2. CONCEPT_SYNONYM 3. CONCEPT_ANCESTOR 4. CONCEPT_RELATIONSHIP 5. CONCEPT_CLASS 6. DOMAIN 7. RELATIONSHIP

OHDSI/Tantalus documentation built on May 3, 2019, 3:39 p.m.