1 / 16

Introduction to Information and Computer Science

Introduction to Information and Computer Science. Databases and SQL. Lecture d.

gavan
Download Presentation

Introduction to Information and Computer Science

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to Information and Computer Science Databases and SQL Lecture d This material (Comp4_Unit6d) was developed by Oregon Health & Science University, funded by the Department of Health and Human Services, Office of the National Coordinator for Health Information Technology under Award Number IU24OC000015.

  2. Databases and SQLLearning Objectives • Define and describe the purpose of databases (Lecture a) • Define a relational database (Lecture a) • Describe data modeling and normalization (Lecture b) • Describe the structured query language (SQL) (Lecture c) • Define the basic data operations for relational databases and how to implement them in SQL (Lecture c) • Design a simple relational database and create corresponding SQL commands (Lecture c) • Examine the structure of a healthcare database component (Lecture d) Introduction to Information and Computer Science Databases and SQL Lecture d

  3. Sample Database Use in VistA • VistA: Veterans Health Information Systems and Technology Architecture • Used at Department of Veterans Affairs (VA) health care facilities • (US Dept. of Veterans Affairs, 2007, PD-US) Introduction to Information and Computer Science Databases and SQL Lecture d

  4. NUMI • National Utilization Management Integration (NUMI) supports reviews of clinical care activities • NUMI documents patient movements • NUMI is separate from VistA • (NUMI, 2011, PD-US) Introduction to Information and Computer Science Databases and SQL Lecture d

  5. Workflow (NUMI, 2011, PD-US) Introduction to Information and Computer Science Databases and SQL Lecture d

  6. NUMI Tables AdmissionReviewType CareLevel CermeReviewXML DismissStayReason FacilityTreatingSpecialty MASMovementTransactionType MASMovementType NumiUser NumiUserSiteActivityBitmask Patient PatientAudit PatientReview PatientReviewAudit PatientReviewReason PatientStay PatientStayAudit Physician PhysicianAdvisorPatientReason PhysicianAdvisorPatientReview PhysicianAdvisorPatientReviewAudit Reason Region Reports ReviewType ServiceSection Site Status VISN WardLocation WebLog Introduction to Information and Computer Science Databases and SQL Lecture d

  7. Patient Table (Select Elements) 6.24 Table: Patient table (Select elements) (PD-US). Introduction to Information and Computer Science Databases and SQL Lecture d

  8. Site Table (Select Elements) 6.25 Table: Site table (Select elements) (PD-US). Introduction to Information and Computer Science Databases and SQL Lecture d

  9. ER Diagram 6.26 Diagram: Entity-relationship (ER) Diagram. (PD-US, 2011) Introduction to Information and Computer Science Databases and SQL Lecture d

  10. Patient Review Table (Select Elements) 6.27 Table: Patient review table (Select elements) (PD-US, 2011). Introduction to Information and Computer Science Databases and SQL Lecture d

  11. ER Diagram 6.28 Diagram: Entity-relationship diagram (PD-US, 2011). Introduction to Information and Computer Science Databases and SQL Lecture d

  12. Patient Review in NUMI (NUMI, 2011, PD-US) Introduction to Information and Computer Science Databases and SQL Lecture d

  13. Databases and SQLSummary – Lecture d • Viewed an example application: NUMI • Examined the NUMI database structure • Tables • Relationships Introduction to Information and Computer Science Databases and SQL Lecture d

  14. Databases and SQLSummary • Data and type are independent • Speed and efficiency are critical for data access • Four basic data operations: retrieval, addition, modification and deletion • Information relationships and types are maintained in a relational database • Designed a simple database • Improved the database design using normalization to remove duplicate data • Introduced to SQL statements and data types • Created a database and database tables • Learned basic select, insert, delete and update SQL statements • Examined design of a production healthcare database Introduction to Information and Computer Science Databases and SQL Lecture d

  15. Databases and SQLReferences – Lecture d References U.S. Department of Veterans Affairs. (2011, September 21, 2011). Veterans Health Information Systems and Technology Architecture. Retrieved December 19, 2011, from http://www.va.gov/VISTA_MONOGRAPH/index.asp U.S. Department of Veterans Affairs. (2011). User Guide for National Utilization Management Integration (NUMI),. Retrieved Jan 2012 from http://www.va.gov/vdl/documents/HealtheVet/National_Utilization_Management_Integration/numi_user_guide-v1_1_13.doc U.S. Department of Veterans Affairs. (2011). Systems Management Guide for National Utilization Management Integration (NUMI). Retrieved Jan 2012 from http://www.index.va.gov/search/va/va_search.jsp?QP=on&QT=Systems+Management+Guide+for+National+Utilization+Management&SQ=http%3A%2F%2Fwww.va.gov%2Fvdl%2Fdocuments%2FHealtheVet%2FNational_Utilization_Management_Integration%2Fnumi_system_management_guide-1_1_13.doc. Charts, Tables, Figures 6.24 Table: Patient table (Select elements) (PD-US). 6.25 Table: Site table (Select elements) (PD-US). 6.26 Diagram: Entity-relationship (ER) Diagram. (PD-US, 2011) 6.27 Table: Patient review table (Select elements) (PD-US, 2011). 6.28 Diagram: Entity-relationship diagram (PD-US, 2011). Introduction to Information and Computer Science Databases and SQL Lecture d

  16. Databases and SQLReferences – Lecture d IMAGES Slide 3: VistA Image [image on the Internet]. US Dept. of Veterans Affairs (2007). [Updated 10/29/2007; cited 11/8/2011]. Retrieved Jan 2012 from: http://en.wikipedia.org/wiki/File:VistA_Img.png. (PD-US). • Slides 4,12 : NUMI Screenshot . NUMI (2011). U.S. Department of Veterans Affairs. User Guide for National Utilization Management Integration (NUMI). Retrieved Jan 2012 from http://www.va.gov/vdl/documents/HealtheVet/National_Utilization_Management_Integration/numi_user_guide-v1_1_13.doc. (PD-US). • Slide 5: NUMI Workflow. NUMI(2011). U.S. Department of Veterans Affairs. User Guide for National Utilization Management Integration (NUMI). Retrieved Jan 2012 from http://www.va.gov/vdl/documents/HealtheVet/National_Utilization_Management_Integration/numi_user_guide-v1_1_13.doc. (PD-US). Introduction to Information and Computer Science Databases and SQL Lecture d

More Related