Database diagnostics

The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

Introduction

In this example we’re going to be using the Eunomia synthetic data.

library(CDMConnector)
library(OmopSketch)
library(PhenotypeR)
library(dplyr)
library(CohortConstructor)

con <- DBI::dbConnect(duckdb::duckdb(), 
                      CDMConnector::eunomiaDir("synpuf-1k", "5.3"))
cdm <- CDMConnector::cdmFromCon(con = con, 
                                cdmName = "Eunomia Synpuf",
                                cdmSchema   = "main",
                                writeSchema = "main", 
                                achillesSchema = "main")

cdm$injuries <- conceptCohort(cdm = cdm,
  conceptSet = list(
    "ankle_sprain" = 81151L,
    "ankle_fracture" = 4059173L,
    "forearm_fracture" = 4278672L,
    "hip_fracture" = 4230399L
  ),
  name = "injuries")

Database diagnostics

Although we may have created our study cohort, to inform analytic decisions and interpretation of results requires an understanding of the dataset from which it has been derived. The databaseDiagnostics() function will help us better understand a data source.

To run database diagnostics we just need to provide our cdm reference to the function.

db_diagnostics <- databaseDiagnostics(cdm$injuries)

Database diagnostics builds on OmopSketch package to perform the following analyses:

Snapshot: Summarises the meta data of a CDM object by using summariseOmopSnapshot()
Observation periods: Summarises the observation period table by using summariseObservationPeriod(). This will allow us to see if there are individuals with multiple, non-overlapping, observation periods and how long each observation period lasts on average.
Person table: Summarises the person table by using summarisePerson(). This provides demographic information including sex, race, ethnicity, year/month/day of birth distributions, and location/provider/care site information.
Clinical Records: The diagnostics will detect which domains appears to the codelist associated to your cohort (i.e., Drug), and use summariseClinicalRecords() to summarise the clinical table associated (i.e., “drug_exposure”).

The output is a summarised result object.

Visualise the results

We can use OmopSketch package functions to visualise the results obtained.

Snapshot

tableOmopSnapshot(db_diagnostics)

Observation Periods

tableObservationPeriod(db_diagnostics)

Person Table

tablePerson(db_diagnostics)

Clinical Records

tableClinicalRecords(db_diagnostics)

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.