Wayne State University

Warrior strong
Login
Search

School of Medicine

Clinical Research

Database Creation

PRICING

The platforms provide the framework to build and customize databases that can be used in research and other projects.

Request Database Support

  • Create study specific electronic data capture (EDC) databases
  • Create your own participant population specific registry
  • Access and training required - contact Brian Reed or Daniel Paduchowski for support (Note: this is for creation of NEW databases, not access to pre-existing datasets). 
 

Advarra EDC

21 CFR Part 11 Compliant

REDCap
General Description 
  • Manage Studies
  • Build Databases
  • Custom Forms
  • Exports Data 
  • Builds Surveys
  • Build Databases
  • Custom Forms
  • Exports Data
Web-based Yes Yes
Export Formats Excel, PDF or SAS  Excel, PDF, SAS, Stata, R, or SPSS
HIPAA Compliant  Yes No
Registries Yes Yes
Participant Survey Entry No Yes
Pros
  • Visit Data Forms
  • Standard and custom reports
  • 21 CFR Part 11 compliant
  • Validated
  • Manage participant data
  • Custom reports and graphs
  • Export and re-upload data
Cons
  • No data reload
  • Not validated 
  • Not 21 CFR Part 11 compliant

 

Google Cloud Platform (Computing/Visualizations)

GCP is a secure HIPAA compliant platform for data storage and computing, accessible via single-sign on with a WSU AccessID. GCP services offer a secure means of storing large databases in a cloud based web-accessible environment.

Services include:

  • Cloud Storage (GCS) : scalable data storage
    • Integratatable with BigQuery and other GCP tools via Cloud Run and other API tools
  • BIgQuery: scalable database platform
    • Offers features for data visualization
  • Cloud Run: schedule custom functions and processes
    • Schedule events and functions using Cloud Scheduler
    • Built in development support for GO, .NET, JAVA, NODE.js, Python and Ruby

Use cases include:

  • Cloud Storage as a data archive
  • Cloud Storage as bridge between external data sources and other platforms e.g. BigQuery, REDCap, etc.
  • Scheduling daily processes - data upload/download, database queries, etc.

 

GCP offers an extensive suite of web-based products, including data storage (Cloud Storage - GCS), a database platform (BigQuery), and platforms for writing and scheduling custom functions and processes (Cloud Run and Cloud Scheduler).  Cloud Storage and BigQuery are scalable and capable of supporting extremely large datasets (i.e. >terabyte).  Storage can function as a cloud based repository for data, but it can also be programmatically integrated with BigQuery and other GCP products via Cloud Run and various API tools.  BigQuery offers traditional database functionality, including storage and query capabilities, in addition to features for data visualization.  Cloud Run offers built-in development support for GO, .NET, JAVA, NODE.js, Python, and Ruby for application coding.  Functions developed in Cloud Run can be created with event based triggers, or scheduled using Cloud Scheduler.  Because all of the products are part of the same GCP platform, their operation can be integrated using native API methods and Cloud Run