Alexander Scarlat MD

Medical Information Extraction & Analysis Alexander Scarlat MD

Book introduces clinicians to SQL and using hands on examples on MIMIC2 - a publicly available, de-identified ICU database from Beth Israel Deaconess Medical Center and MIT Physionet - it enables care providers to query any database of an Electronic Health Record (EHR) and create meaningful reports to support their quality initiatives. IT professionals will benefit from a structured analysis of the main parameters that interest clinicians: diagnosis, procedure, lab, meds, imaging reports, nursing assessments and interventions, scoring systems, mortality, length of stay, readmissions' rate, costs, etc. Using this book, both clinicians and IT professionals can easily retrieve any information from the data in their EHR and discover new clinical insights hidden in their database.1. A Brief Database Primer12. MIMIC2 Clinical Database93. MySQL Workbench124. Introduction to the Mighty SELECT215. Aggregate / Summary Functions486. Querying Multiple Tables637. Entity Relationship Diagram - ERD768. Systematic information extraction919. Patient10210. Mortality12511. Length of stay (LOS)13912. Readmissions14513. Diagnosis15314. Sepsis profile17415. Lab20016. Drug21717. Procedure23018. Chart, note and much more23919. Provider and care unit24820. Nursing25921. Fluid26722. Score and scale274Appendix Answers to Questions