OHDSI/CDMTableBrowser

Name: CDMTableBrowser

Owner: Observational Health Data Sciences and Informatics

Description: [under development] A GUI to explore the structure (tables, fields and other meta-data) associated with the OMOP Common Data Model v5

Created: 2015-11-13 17:05:51.0

Updated: 2017-10-20 15:53:18.0

Pushed: 2015-11-20 17:49:39.0

Homepage: null

Size: 510

Language: Java

GitHub Committers

User	Most Recent Commit	# Commits
Patrick Ryan	2015-11-13 17:05:52.0	1

Other Committers

User	Email	Most Recent Commit	# Commits
Joseph Finkelstein	jf193@cumc.columbia.edu	2015-11-20 17:49:37.0	2

README

CHAOS

Introduction

CHAOS is Common_data_model Hierarchy and Attributes Overview System. CHAOS provides interactive overview of CDM tables, fields and relationships between fields. Definitions of each table and field can be reviewed by hovering over corresponding item in the graphical representation of CDM. For fields, two types of mouseover information can be chosen depending radio button setting: definitions or data types.

Features

1. Hovering over a table name results in presentation of the table?s definition
2. Hovering over a field name results in presentation of the field?s definition or data type
3. Type of information presented by hovering over a field name is indicated by radio button at the bottom of the CDM graph
4. Clicking a table name results in presentation of the all fields of this table
5. Clicking a field name results in presentation of relationship with other fields. Primary key has green background and foreign key has a yellow background.

Screenshots

Technology

CHAOS is built using Java and JavaScript technologies. The overall technical design of CHAOS is presented in the figure below. Information on CDM tables and fields is stored in two tables: Metadata_tables and Metadata_fields. These tables contain complete metadata information on CDN based on Version 5 Specifications. These two tables have to be added to the database containing CDM tables.

Web services is written in Java and can be maintained by any servlet container. OMOPtables returns a collection in XML or JSON format representing information about CDM tables. OMOPtables?id=n returns information about table n. OMOP_fields returns a collection in XML or JSON format representing information about CDM fields. OMOPfields?id=n returns information about field n. Interactive graph is based on D3.js interactive visualization library.

System requirements

CHAOS requires Java 1.8 or higher.

Dependencies

The CDM metadata tables are provided in Excel and should be imported into CDM database. They reflect CDM v5 specifications.

Getting Started

1. Import the two metadata tables into CDM database.
2. Compile java code.
3. Install web services in a servlet container.

Comments/Questions

Github or jf193@columbia.edu (Joseph Finkelstein)