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

Scarlat MD, Alexander

ISBN 10: 1544093373 / ISBN 13: 9781544093376

Editore: CreateSpace Independent Publishing Platform, 2018

*VALUE PRICED USED BOOK* Book may contain markings, highlights, water damage, and minor cover damage. Used items may not contain supplemental items such as CD, DVD, or other previously included items that would come with a NEW book. Codice articolo BSNV8448269

Riassunto:

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

Dati bibliografici

Titolo: Medical Information Extraction & Analysis: ...
Casa editrice: CreateSpace Independent Publishing Platform
Data di pubblicazione: 2018
Legatura: paperback
Condizione: Good