CIDER

1. CIDER Clinical Investigation Data Exploration Repository

2. CIDER Clinical Investigation Data Exploration Repository • Joint venture of BJC & WUSM • Data repository to contain routine patient care (inpatient and outpatient) data • Advanced Query functionality through web interface • Restricted data access / Role Management • Data Interface to external systems like CSMS • Controlled Vocabulary support

3. Need for CIDER • Clinical & Translational research goals • Rapidly convert novel advances in basic science to Patient care • Get quick feedback on customized diagnostics and therapeutics for further refinements back to the bench • Need to analyze complex biomedical data • Clinical Information • Routine laboratory tests, imaging, biospecimens • Molecular profiling and genome annotation

4. Need for CIDER – cont’d • Data sets must be co-analyzed & visualized to gain a comprehensive understanding of underlying processes occurring in multi-factorial diseases • Easy access to this data for physicians, clinician-scientists, and bench scientists • Reduce barrier between basic science and clinical research

5. Current challenges • No easy way to access consolidated patient data • Privacy and confidentiality risks • No seamless and regulated data access • HIPAA regulations

6. How CIDER addresses the challenges • No easy way to access consolidated patient data - Consolidated repository • Privacy and confidentiality risks - Secured data access based on user role and project privileges • No seamless and regulated data access - Seamless & regulated data access • HIPAA regulations - HIPAA training a must for all CIDER users

7. Solution CIDER

8. CIDER Data Repository • Discrete Data from ClinDesk (IP Data) • Demographics • Encounters • Labs • Medications • Vitals • Allergies • Microbiology • Documents from ClinDesk, including Scanned Documents • (Hospital-based IP & OP Data) • NLP (Natural Language Processing) • AllScripts Data (WU Physician Offices OP Data) • NextGen Data (BJC Medical Group Physician Offices OP Data) • Diagnostic Images • Other Sources (e.g.. MDL Discrete data)

9. CIDER Overall Timeline

10. Release-1 Modules • Manage Users / Manage Projects • Query Module • Vocabulary Interface • Audit System • Data Delivery (conversion and interface) • Dashboard • APIs to external systems like CSMS

11. references

12. CIDERData flow CDR Data Repository AllScripts IRB NextGen CIDER Imaging Health Care World Research World

13. CIDER-DATA TO CIDER-DOMAIN-MODEL Via ETL Process CIDER Database (DB2) Data Source DB2 – XML Database XSD - XML Schema Definition XSDs Object Model – Graphical Representation of Data Elements and their Relationships OBJECT MODEL

14. Via ETL Process CIDER Database (DB2) Data Source DB2 – XML Database XSD - XML Schema Definition XSDs i-Query Object Model – Graphical Representation of Data Elements and their Relationships Generate Metadata X-Query OBJECT MODEL What data to query? Categories

15. CIDER Query Module

16. CIDER Workflow

17. CIDER Technology • Web based GUI (Graphical User Interface) which uses Java, Ajax, Flex and Web services technologies • Hierarchical and real-time data in XML • Federated DB2 Databases on Linux • Advanced Query capabilities (Graphical) using XQuery / SQL-XML • Multiple vocabulary support (SNOMED CT, LOINC etc)

18. CIDER Architecture – cont’d