Title: Medical Information Extraction & Analysis: From Zero to Hero with a Bit of SQL and a Real-life Database
Publisher: Createspace Independent Publishing Platform
Publication Date: 2018
Language: English
ISBN 10: 1544093373
ISBN 13: 9781544093376
Binding: Paperback
Condition: Good
Dust Jacket Condition: No Jacket
Weight: 2.33 pounds

About this title

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 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.

"About this title" may belong to another edition of this title.

Store Description

ThriftBooks is a fully independent seller of used books, having sold more than 160 million used and new books since we started in 2003. Each quality used book is sorted, graded, shelved and shipped by hand by our team of dedicated employees in our seven warehouses across the US. We have the best selection of books, in the right condition and format, at everyday low prices. We also have a dedicated, US-based Customer Service team, ranked in the top three by Newsweek for Best Customer Service in 2018 and 2019, so you can shop with confidence. We support and invest in our employees, appreciate and value our customers, and truly believe in the power of the written word to educate, energize, and engage readers of all ages and interests.

Visit Seller's Storefront

Seller's business information

Thrift Books Global, LLC
18300 Cascade Ave S, Ste 150, Seattle, WA, 98188, U.S.A.

Sale & Shipping Terms

Terms of Sale

We guarantee the condition of every book as it's described
on the Abebooks website. If you're dissatisfied with your
purchase (Incorrect Book/Not as Described/Damaged) or if the
order hasn't arrived, you're eligible for a refund within 30
days of the estimated delivery date. If you've changed your
mind about a book that you've ordered, please use the "Ask
bookseller a question link to contact us" and we'll respond
as soon as possible.

Shipping Terms

All domestic Standard shipments are distributed from our warehouses by OSM, then handed off to the USPS for final delivery.

2-Day Shipping is delivered by FedEx, which does not deliver to PO boxes.

International shipments are tendered to the local postal service in the destination country for final delivery – We do not use courier services for international deliveries.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	4 to 8 business days	4 to 8 business days
First item	US$ 0.00	US$ 0.00

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.