Medical Information Extraction & Analysis: From Zero to Hero with a Bit of SQL and a Real-life Database - Softcover

Scarlat MD, Alexander

Softcover

ISBN 10: 1544093373 ISBN 13: 9781544093376

Publisher: CreateSpace Independent Publishing Platform, 2018

Synopsis

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

About this title

About the Author

I am a physician board certified in Anesthesiology with a Bachelor's degree in computer sciences passionate about clinical informatics.
 
For more than two decades, I've worked with both vendors developing electronic health records and healthcare organizations implementing this technology, as a liaison between two highly educated groups of professionals-- clinicians and information technologists -- that unfortunately, rarely speak the same language.
 
This is my second book, trying to bridge this gap between medicine and informatics.
My first book being on the subject of Structured Systems Analysis of the EHR Medications Domain.
 
You can contact me by sending a letter, preferably in Structured Query Language and with a well-behaved homing dolphin, to the address mentioned in the book.

From the Back Cover

There are no prerequisites for reading this book, except being just a bit curious about clinical databases and the information accumulated in your Electronic Health Record (EHR) during the last years.

After a gentle introduction to the Structured Query Language (SQL), you will connect to a real-life database, stored in the proverbial cloud: MIMIC - the de-identified, publicly available ICU database from Beth Israel Deaconess Medical Center developed in cooperation with Physionet - MIT Lab for Computational Physiology, MA, USA.

Using MIMIC and hundreds of hands-on examples and exercises, you will learn how to slice and dice any clinical database of an EHR:

• Extract all the clinical information on one patient: diagnosis, procedure, lab results, medications, imaging reports, nursing notes, discharge summaries, fluid drips and balances, scoring systems, etc.
• Create a profile on any condition or procedure, such as Sepsis - contrasting populations with/without the disease: number of patients, admissions, mortality, length of stay (LOS), readmissions rate, age and gender distribution
• Identify patients at risk due to under or over-dosing of a medication (e.g. Heparin, Nitroprusside)
• Retrieve and display clinical time series such as vital signs
• Find the percentage of patients receiving blood products according to best practice
• Calculate average reaction time to hypoglycemic events in diabetics
• Use the Braden score to identify patients at risk of developing pressure ulcers
• Create any clinical report you may wish: from the conceptual phase, using the Entity Relationship Diagram and the Information Schema, thru the query design and debugging to the final embedding into documents to support your Quality Improvement initiatives.

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2018
• Language: English
• ISBN 10: 1544093373
• ISBN 13: 9781544093376
• Binding: Paperback
• Number of pages: 400