280 likes | 354 Views
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.
E N D
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
Sample XML Document XML Declaration
XML Declaration XML Declaration Processing instruction end Processing instruction start
Comment Tags XML Comment Comment end Comment start
Comment Tags XML Comment Comment end Comment start
Opening & Closing Tags for Person Opening tag XML commands Closing tag
Opening & Closing Tags for PersonName Opening tag XML commands Closing tag
Opening & Closing Tags for BloodPressure Opening tag XML commands Closing tag
Root Tag Root Tag
Root Tag Tag for Table name
Root Tag Attributes/Fieldsin Table
Declaration Statement <?xml version="1.0" encoding="ASCII" ?>
Comment Statement <?xml version="1.0" encoding="ASCII" ?><!-- data from public health agencies on influenza outbreak in 2002 -->
Root Tag <?xml version="1.0" encoding="ASCII" ?><!-- data from public health agencies on influenza outbreak in 2002 --> <Influenza_2002></Influenza_2002>
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>
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>
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>
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>
Take Home Lesson XML syntax and structure