1 / 28

Health Data Integration

Health Data Integration. Farrokh Alemi, Ph.D. Francisco Loaiza Ph.D. Vikas Arya. Essential XML Concepts. XML Syntax XML - instance document. Essential XML Concepts. XML Syntax XML - instance document. Structure of XML Tag. Sample XML Document. Sample XML Document. XML Declaration.

fhamilton
Download Presentation

Health Data Integration

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. Health Data Integration Farrokh Alemi, Ph.D.Francisco Loaiza Ph.D.Vikas Arya

  2. Essential XML Concepts • XML Syntax XML - instance document

  3. Essential XML Concepts • XML Syntax • XML - instance document

  4. Structure of XML Tag

  5. Sample XML Document

  6. Sample XML Document XML Declaration

  7. XML Declaration XML Declaration Processing instruction end Processing instruction start

  8. Comment Tags XML Comment Comment end Comment start

  9. Comment Tags XML Comment Comment end Comment start

  10. Opening & Closing Tags for Person Opening tag XML commands Closing tag

  11. Opening & Closing Tags for PersonName Opening tag XML commands Closing tag

  12. Opening & Closing Tags for BloodPressure Opening tag XML commands Closing tag

  13. Root Tag Root Tag

  14. Root Tag Tag for Table name

  15. Root Tag Attributes/Fieldsin Table

  16. Another Example

  17. Declaration Statement <?xml version="1.0" encoding="ASCII" ?>

  18. Comment Statement <?xml version="1.0" encoding="ASCII" ?><!-- data from public health agencies on influenza outbreak in 2002 -->

  19. Root Tag <?xml version="1.0" encoding="ASCII" ?><!-- data from public health agencies on influenza outbreak in 2002 --> <Influenza_2002></Influenza_2002>

  20. Record Tags <?xml version="1.0" encoding="ASCII" ?><!-- data from public health agencies on influenza outbreak in 2002 --><Influenza_2002>   <Report>      <cityName>Atlanta</cityName>      <patientQuantity>2,138</patientQuantity>      <hospitalStay unit="days">8</hospitalStay>      <casualtyQuantity>14</casualtyQuantity>   </Report>   <Report>      <cityName>Los Angeles</cityName>      <patientQuantity>15,764</patientQuantity>      <hospitalStay unit="days">5</hospitalStay>      <casualtyQuantity>77</casualtyQuantity>   </Report>   <Report>   <cityName>New York</cityName>       <patientQuantity>22,349</patientQuantity>      <hospitalStay unit="days">7</hospitalStay>      <casualtyQuantity>146</casualtyQuantity>   </Report>   </Influenza_2002>

  21. Using Excel to Write XML

  22. Spreadsheet with Tags Inserted

  23. Inserting Record Delimiter Tag

  24. Correcting Syntax in Notepad <PatRec> <Name> JohnRobertson </Name> <MedTest> Blood Test </MedTest> <Date> 02-Jan-03 </Date> </PatRec> <PatRec> <Name> MariaEstrada </Name> <MedTest> Cholesterol Test </MedTest> <Date> 27-Jul-02 </Date> </PatRec> <PatRec> <Name> Sandy Hellerman </Name> <MedTest> X-Ray </MedTest> <Date> 13-Mar-02 </Date> </PatRec> <PatRec> <Name> Julia Moriarty </Name> <MedTest> Chest MRI </MedTest> <Date> 23-Dec-01 </Date> </PatRec> <PatRec> <Name> Pedro Martinez </Name> <MedTest> EKG </MedTest> <Date> 11-Feb-03 </Date> </PatRec> <PatRec> <Name> Sayeed Rashidi </Name> <MedTest> Cholesterol Test </MedTest> <Date> 11-Nov-02 </Date> </PatRec>

  25. Final Result PatRec> <Name>John Robertson</Name> <MedTest>Blood Test</MedTest> <Date>2002-01-03</Date> </PatRec> <PatRec> <Name>Maria Estrada</Name> <MedTest>Cholesterol Test</MedTest> <Date>2002-07-27</Date> </PatRec> <PatRec> <Name>Sandy Hellerman</Name> <MedTest>X-Ray</MedTest> <Date>2002-04-13</Date> </PatRec> <PatRec> <Name>Julia Moriarty</Name> <MedTest>Chest MRI</MedTest> <Date>2002-12-23</Date> </PatRec> <PatRec> <Name>Pedro Martinez</Name> <MedTest>EKG</MedTest> <Date>2003-02-11</Date> </PatRec> <PatRec> <Name>Sayeed Rashidi</Name> <MedTest>Cholesterol Test</MedTest> <Date>2002-11-11</Date> </PatRec>

  26. Insert Declaration <?xml version="1.0" encoding="ASCII" ?><MedRecords><PatRec><Name>John Robertson</Name><MedTest>Blood Test</MedTest><Date>2002-01-03</Date></PatRec><PatRec><Name>Maria Estrada</Name><MedTest>Cholesterol Test</MedTest><Date>2002-07-27</Date></PatRec><PatRec><Name>Sandy Hellerman</Name><MedTest>X-Ray</MedTest><Date>2002-04-13</Date></PatRec><PatRec><Name>Julia Moriarty</Name><MedTest>Chest MRI</MedTest><Date>2002-12-23</Date></PatRec><PatRec><Name>Pedro Martinez</Name><MedTest>EKG</MedTest><Date>2003-02-11</Date></PatRec><PatRec><Name>Sayeed Rashidi</Name><MedTest>Cholesterol Test</MedTest><Date>2002-11-11</Date></PatRec></MedRecords>

  27. Saving Document as XML

  28. Take Home Lesson XML syntax and structure

More Related