Author : Alexander Scarlat
Publisher : Createspace Independent Publishing Platform
Page : 400 pages
File Size : 47,9 Mb
Release : 2018-03-19
Category : Electronic
ISBN : 1544093373
Medical Information Extraction and Analysis by Alexander Scarlat Pdf
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 Primer 1 2. MIMIC2 Clinical Database 9 3. MySQL Workbench 12 4. Introduction to the Mighty SELECT 21 5. Aggregate / Summary Functions 48 6. Querying Multiple Tables 63 7. Entity Relationship Diagram - ERD 76 8. Systematic information extraction 91 9. Patient 102 10. Mortality 125 11. Length of stay (LOS) 139 12. Readmissions 145 13. Diagnosis 153 14. Sepsis profile 174 15. Lab 200 16. Drug 217 17. Procedure 230 18. Chart, note and much more 239 19. Provider and care unit 248 20. Nursing 259 21. Fluid 267 22. Score and scale 274 Appendix Answers to Questions