"Modern" XML applications XML in electronic data - PowerPoint PPT Presentation

"Modern" XML applications XML in electronic data interchange, application integration and databases Patryk Czarnik Institute of Informatics University of Warsaw XML and Modern Techniques of Content Management – 2010/11 Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 1 / 50

Electronic data interchange 1 Introduction Pre-XML solutions XML for EDI Application integration 2 Idea Web Services XML in security 3 XML Signature XML Encryption XML and databases 4 XML support in relational databases XML databases

Electronic data interchange 1 Introduction Pre-XML solutions XML for EDI Application integration 2 Idea Web Services XML in security 3 XML Signature XML Encryption XML and databases 4 XML support in relational databases XML databases

Electronic data interchange Introduction Electronic data interchange (EDI) — motivation How to interchange data between How to establish EDI companies/institutions (B2B)? protocol? paper customer receives (or buys) a tool from electronic data interchange provider smaller partner Standard deployment levels complies to bigger software developed according to parter standard from beginning ad-hoc created interface added to legacy conversion tools system standard Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 4 / 50

Electronic data interchange Introduction Electronic data interchange (EDI) — motivation How to interchange data between How to establish EDI companies/institutions (B2B)? protocol? paper customer receives (or buys) a tool from electronic data interchange provider smaller partner Standard deployment levels complies to bigger software developed according to parter standard from beginning ad-hoc created interface added to legacy conversion tools system standard Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 4 / 50

Electronic data interchange Introduction Electronic data interchange (EDI) — motivation How to interchange data between How to establish EDI companies/institutions (B2B)? protocol? paper customer receives (or buys) a tool from electronic data interchange provider smaller partner Standard deployment levels complies to bigger software developed according to parter standard from beginning ad-hoc created interface added to legacy conversion tools system standard Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 4 / 50

Electronic data interchange Pre-XML solutions EDI standardisation prior to XML introduction ANSI Accredited Standards Committee X12 sub-group USA national standard used mainly in America EDIFACT international standard (UN/CEFACT and ISO) used mainly in Europe and Asia Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 5 / 50

Electronic data interchange Pre-XML solutions EDI standardisation prior to XML introduction ANSI Accredited Standards Committee X12 sub-group USA national standard used mainly in America EDIFACT international standard (UN/CEFACT and ISO) used mainly in Europe and Asia Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 5 / 50

Electronic data interchange Pre-XML solutions EDIFACT characteristic Format text hardly readable tree structure Predefined dictionaries 193 message types 279 segments 186 elements (version 08a, 2008) Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 6 / 50

Electronic data interchange Pre-XML solutions EDIFACT characteristic Format text hardly readable tree structure Predefined dictionaries 193 message types 279 segments 186 elements (version 08a, 2008) Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 6 / 50

Electronic data interchange Pre-XML solutions EDIFACT EDIFACT message example UNB+IATB:1+6XPPC+LHPPC+940101:0950+1’ UNH+1+PAORES:93:1:IA’ MSG+1:45’ IFT+3+XYZCOMPANY AVAILABILITY’ ERC+A7V:1:AMD’ IFT+3+NO MORE FLIGHTS’ ODI’ TVL+240493:1000::1220+FRA+JFK+DL+400+C’ PDI++C:3+Y::3+F::1’ APD+74C:0:::6++++++6X’ TVL+240493:1740::2030+JFK+MIA+DL+081+C’ PDI++C:4’ APD+EM2:0:1630::6+++++++DA’ UNT+13+1’ UNZ+1+1’ cite: Wikipedia Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 7 / 50

Electronic data interchange Pre-XML solutions EDIFACT structure Wymiana ( interchange ) Wiadomość ( message ) Grupa ( segment group ) Segment MEA+WT+AAD+KGM:690+X5 ' Złożenie ( composite ) + KGM:690 + Element ( data element ) : 690 Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 8 / 50

Electronic data interchange XML for EDI XML EDI Idea: use XML as data format for EDI Traditional EDI XML EDI Documents unreadable „Self-descriptioning” documents without specification format Compact messages Verbose messages Centralised standard “Pluggable”, flexible standards maintenance Well written software ready to Changes in format requires format extensions software change XML-format layer handled by Specialised tools needed general XML libraries Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 9 / 50

Electronic data interchange XML for EDI XML EDI Idea: use XML as data format for EDI Traditional EDI XML EDI Documents unreadable „Self-descriptioning” documents without specification format Compact messages Verbose messages Centralised standard “Pluggable”, flexible standards maintenance Well written software ready to Changes in format requires format extensions software change XML-format layer handled by Specialised tools needed general XML libraries Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 9 / 50

Electronic data interchange XML for EDI XML EDI flexibility Format flexibility Structures: choosing, repeating, nesting, optionality Format extensions and mixing via namespaces Applications Data interchange between partners’ systems Web interface (easy transformation via XSLT) Web Services integration Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 10 / 50

Electronic data interchange XML for EDI XML EDI flexibility Format flexibility Structures: choosing, repeating, nesting, optionality Format extensions and mixing via namespaces Applications Data interchange between partners’ systems Web interface (easy transformation via XSLT) Web Services integration Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 10 / 50

Electronic data interchange XML for EDI XML EDI standardisation Framework level general rules for all kinds of data data of the same kind should be represented in the same way (not to define the same twice) example: Electronic Business XML ( ebXML ). Industry standards SWIFT — banking RosettaNet — trade and logistic Automotive Industry Action Group — motor industry (mainly American) Health Level Seven — health care Open Travel Alliance — (people) transport and tourist services . . . Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 11 / 50

Electronic data interchange XML for EDI XML EDI standardisation Framework level general rules for all kinds of data data of the same kind should be represented in the same way (not to define the same twice) example: Electronic Business XML ( ebXML ). Industry standards SWIFT — banking RosettaNet — trade and logistic Automotive Industry Action Group — motor industry (mainly American) Health Level Seven — health care Open Travel Alliance — (people) transport and tourist services . . . Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 11 / 50

Electronic data interchange XML for EDI ebXML ebXML set of specifications defining concepts and methodologies for conducting electronic business via Internet (2001) XML used as data format Electronic Business XML Working Group founded in 1999 more than hundred specialists OASIS and UN/CEFACT patronage Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 12 / 50

Electronic data interchange XML for EDI ebXML ebXML set of specifications defining concepts and methodologies for conducting electronic business via Internet (2001) XML used as data format Electronic Business XML Working Group founded in 1999 more than hundred specialists OASIS and UN/CEFACT patronage Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 12 / 50

Electronic data interchange XML for EDI ebXML standardisation Meta-model: zbiór podstawowych schematów, elementów XML oraz procesów biznesowych, sposób definiowania słowników danych, nie definiuje konkretnych, docelowych komunikatów – mog ˛ a one zale˙ ze´ c od konkretnego zastosowania. Metainformacje: informacje o wersjach, metadane odpowiadaj ˛ ace nagłówkom z istniej ˛ acych systemów EDI. Ramy architektury technicznej: sposoby implementacji repozytoriów, serwisów, itp., integracja z istniej ˛ acymi technologiami EDI. Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 13 / 50

Electronic data interchange 1 Introduction Pre-XML solutions XML for EDI Application integration 2 Idea Web Services XML in security 3 XML Signature XML Encryption XML and databases 4 XML support in relational databases XML databases

Application integration Idea XML for application integration Goal — data interchange between applications applications/modules/components with different internal formats XML as interface Usage: client/server communication distributed system nodes components integration configuration of application or components . . . Patryk Czarnik 11 — EDI, WS, databases XML 2010/11 15 / 50