Upgrade to Pro — share decks privately, control downloads, hide ads and more …

20090530 オープンセミナー@岡山

20090530 オープンセミナー@岡山

2009-05-30, オープンセミナー@岡山
タイトル:「XMLデータベースひとめぐり」

Avatar for Takeo Kunishima

Takeo Kunishima PRO

November 15, 2023

More Decks by Takeo Kunishima

Other Decks in Technology

Transcript

  1. Φʔϓϯηϛφʔ!Ԭࢁ ࣗݾ঺հ  4*(8*ݚڀձ 9.-ʢ࠶ʣೖ໳ ࠃౡৎੜ LVOJTIJ!BDNPSH ... the correct

    full name of XML, is "Extensible Markup Language". "eXtensible Markup Language" is just a spelling error. -- Tim Bray ࿈ࡌʮ೔༵େ޻తXMLೖ໳ʯ (2002-2003)
  2. Φʔϓϯηϛφʔ!Ԭࢁ 9.-%#ͷྫ 59 ඇఆܕσʔλ ਺஋จࣈྻ σʔλத৺ ςΩε τ σʔλத৺ ඇఆܕσʔλ΍ςΩε

    τ σʔλ͸ɺ 59޲͖ શจݕࡧ Τϯδϯ TJCMF.BSLVQ-BOHVBHF ͸ɺ Πϯλʔωοτ্Ͱަ׵ɾ஝ੵ͞ΕΔ ࣜͱͯ͠ɺ ͞·͟·ͳྖҬͰ׆༻͕ਐΜͰ͍·͢ɻ .-σʔλͷߏ଄Λͦͷ··֨ೲ͠ͳ͕Βɺ  ࣮ݱͨ͠9.-σʔλϕʔεͰ͢ɻ ͕ɺ 9.-σʔλͷ׆༻ͷՄೳੑΛ޿͛·͢ɻ ɾ ಠࣗʹ։ൃٕͨ͠ज़Ͱɺ  ɹߴ଎ݕࡧΛ࣮ݱ ͱ͖ʹσʔλϕʔε ͕ٛෆཁ εςϜʹࣅͨ ϧ ɾ σʔλϕʔεʹٻΊΒΕΔ ৴པੑΛ֬อ ɾ 92VFSZͱಠࣗ"1*Ͱ%#Λࣗࡏʹૢ࡞ ɾ 8FCΞϓϦέʔγϣϯ։ൃΛࢧԉ͢Δ98FC ɾ ͞·͟·ͳܗࣜͷσʔλΛ9.-ʹม׵ͯ͠ ɹొ࿥͢Δσʔλ࿈ܞػೳ ɾ ߴ౓ͳ೔ຊޠॲཧٕज़Ͱɺ   ଟ࠼ͳݕࡧखஈΛఏڙ ಛ௕ ςϥόΠ τڃͷ େ༰ྔσʔλͰ΋ ߴ଎ݕࡧ ௕ ೈͳσʔλߏ଄ ಛ௕ ৴པੑͷ֬อ ಛ௕ ޮ཰తͳΞϓϦ έʔγϣϯ։ൃ ಛ௕ ଟ࠼ͳݕࡧखஈ ˙؅ཧ͞Εͳ͍··૿͑ଓ͚Δඇఆܕσʔλ اۀ಺ʹ͸ɺ ച্͛΍ࡏݿͳͲͷجװܥ৘ใɺ ϝʔϧ΍ܝࣔ൘ͳͲͷίϛϡχέʔγϣϯ ৘ใɺ ઃܭॻ΍ٞࣄ࿥ɺ ঎඼৘ใɺ ඼࣭৘ใͳͲͷυΩϡϝϯτ৘ใͱ͍͏Α͏ʹɺ ࣮ʹ͞· ͟·ͳ৘ใ͕͋Γ·͢ɻ  ͦͯ͠ɺ ͜ΕΒاۀ಺৘ใͷ໿ׂ͕ɺ ίϛϡχέʔγϣϯ৘ใ΍υΩϡϝϯτ৘ใʹ୅ද ͞ΕΔɺ ߲໨ͷ௕͞΍਺͕֬ఆͰ͖ͳ͍ඇఆܕσʔλͩͱݴΘΕ͍ͯ·͢ɻ   ͜Ε·Ͱɺ ച্͛ͳͲͷجװܥ৘ใͷத৺Λ઎ΊΔఆܕσʔλ͸ɺ 3%#ͳͲΛ༻͍ͯ؅ཧ ͞Ε͖ͯ·͕ͨ͠ɺ ඇఆܕσʔλ͸ɺ ΄ͱΜͲ؅ཧ͞Ε͖ͯ·ͤΜͰͨ͠ɻ  ͔͠͠ɺ اۀՁ஋޲্ͷͨΊͷ৘ใ׆༻ɺ ͦͯ͠ɺ ίϯϓϥΠΞϯεରԠͷͨΊʹ͸ɺ ఆܕ σʔλ͚ͩͰͳ͘ɺ ඇఆܕσʔλ΋త֬ʹ؅ཧ͍ͯ͘͠ඞཁ͕͋Γ·͢ɻ ͭ·Γɺ ඇఆܕ σʔλΛత֬ʹ؅ཧ͍͔ͯ͠ͳ͚Ε͹ɺ اۀ׆ಈ͕੒Γཱͨͳ͘ͳ͖͍ͬͯͯΔͷͰ͢ɻ   ˙ඇఆܕσʔλͷ؅ཧʹ༗ޮͳ9.- ͜ͷඇఆܕσʔλͷ؅ཧʹޮՌΛൃش͢Δͷ͕9.-Ͱ͢ɻ 9.-͸ॊೈͳσʔλߏ଄͕ ࠾ΕΔͨΊɺ ߲໨ͷ௕͞΍਺͕֬ఆͰ͖ͳ͍ඇఆܕσʔλΛ༰қʹදݱͰ͖·͢ɻ ͔͠ ΋σʔλදݱܗࣜͷࠃࡍඪ४ن֨Ͱ͋Γɺ ͢Ͱʹσʔλަ׵΍஝ੵͷͨΊͷج൫ٕज़ͱ ͯ͠ఆண͖͍ͯͯ͠·͢ɻ ·ͨɺ 9.-Ͱ͋Ε͹ɺ ߲໨ͷมߋ΍γεςϜͷ֦ு͕͋ͬͯ ΋ॊೈʹରԠͰ͖Δɺ ৘ใ؅ཧ͠΍͍͢γεςϜΛͭ͘Δ͜ͱ͕Ͱ͖·͢ɻ   ˙ςϥόΠ τڃͷ9.-σʔλͰ΋؅ཧͰ͖Δ9.-σʔλϕʔεɻ ͦΕ͕ ʮ59ʯ  اۀ಺ʹଘࡏ͢Δଟछଟ༷ͳඇఆܕσʔλΛ؅ཧ͢Δʹ͸ɺ େྔͷ9.-σʔλΛ؅ཧ Ͱ͖Δσʔλϕʔε͕ඞཁͰ͢ɻ  9.-σʔλϕʔε59͸ɺ ౦ࣳιϦϡʔγϣϯ͕։ൃͨ͠ ʮςϥόΠ τڃͷ9.-σʔλ Ͱ΋ߴ଎ʹݕࡧͰ͖Δ9.-σʔλϕʔεʯ Ͱ͢ɻ ΤϯλʔϓϥΠζΫϥεͷγεςϜʹ ద͢Δಛ௕Λ࣋ͭ59Λར༻͢Ε͹ɺ େྔͷඇఆܕσʔλͰ΋త֬ʹ؅ཧ͢Δ͜ͱ͕Ͱ͖·͢ɻ   ˙ඇఆܕσʔλ΍ςΩετσʔλͷ؅ཧʹదͨ͠59 59͸ɺ ඇఆܕσʔλ͚ͩͰͳ͘ɺ ςΩετσʔλͷ؅ཧʹ΋దͨ͠σʔλϕʔεͰ͢ɻ 3%#Ͱ͸֨ೲͮ͠Β͍σʔλ΋త֬ʹ؅ཧͰ͖·͢ɻ  ʔλ༰ྔͰ΋ߴ଎ ɾ ߴਫ਼౓ݕࡧ ༻χʔζʹ͔֬ͳٕज़ͰԠ͑·͢ɻ  ϨΫλαʔόಈ࡞04 αʔναʔόಈ࡞04 EPXT4FSWFS 4UBOEBSEY&EJUJPOˎ EPXT4FSWFS &OUFSQSJTFY&EJUJPOˎ EPXT4FSWFS 4UBOEBSE&EJUJPO EPXT4FSWFS &OUFSQSJTF&EJUJPO EPXT4FSWFS EPXT"EWBODFE4FSWFS BSJT 4PMBSJT )BU&OUFSQSJTF-JOVY ʢGPSYʣ  )BU&OUFSQSJTF-JOVY"4 ʢWGPSYʣ  )BU&OUFSQSJTF-JOVY&4 ʢWGPSYʣ  ʦσΟ ϨΫ λαʔό͕4PMBSJT04-JOVYͷ৔߹ʧ  3FE)BU&OUFSQSJTF-JOVY ʢGPSYʣ  3FE)BU&OUFSQSJTF-JOVY"4 ʢWGPSYʣ  3FE)BU&OUFSQSJTF-JOVY&4 ʢWGPSYʣ  ʦσΟ ϨΫ λαʔό͕8JOEPXTͷ৔߹ʧ  8JOEPXT4FSWFS 4UBOEBSEY&EJUJPO 8JOEPXT4FSWFS &OUFSQSJTFY&EJUJPO 8JOEPXT4FSWFS 4UBOEBSE&EJUJPO 8JOEPXT4FSWFS &OUFSQSJTF&EJUJPO 8JOEPXT4FSWFS 8JOEPXT"EWBODFE4FSWFS  ඼໊ STUBHF"QQMJDBUJPO4FSWFS STUBHF4UVEJP STUBHF$PMMBCPSBUJPO3JOH%BUB$PMMFDUJPO4FSWFS STUBHF$PMMBCPSBUJPO3JOH'JMF5SBOTGFS*OUFHSBUPS STUBHF/BWJHBUPS4FSWFS NGPXBSF4FSWFS ΞϓϦ έʔγ ϣ ϯαʔό ΞϓϦ έʔγ ϣ ϯ։ൃ؀ڥ ϑΝ ΠϧసૹΛ τ Ϧ Ψʔʹ ͨ͠σʔλ࿈ܞ ෳࡶԽ͢Δαʔόؒͷ࿈ܞ ෦໳͔ Βશࣾن໛· Ͱαϙʔ τ͢Δ0-"1 σʔλϕʔε ػೳ֓ཁ ঎ඪ·ͨ͸ొ࿥঎ඪͰ͢ɻ  ࠃʹ͓͚Δొ࿥঎ඪͰ͢ɻ  ঎ඪͰ͋Γɺ  ϥΠ ηϯεڙ༩͞Ε͍ͯΔ ΋ͷͰ͢ɻ  Ε֤ࣾͷ঎ඪ·ͨ͸ొ࿥঎ඪͰ͢ɻ  ΋঎ඪදࣔ ʢ5.ɺ ʣ Λ෇ه͓ͯ͠Γ ·ͤΜɻ  ·͢ ɻ  http://interstage.fujitsu.com/jp/ 3 ඼໊ STUBHF4IVOTBLV%BUB.BOBHFS&OUFSQSJTF&EJUJPO ػೳ֓ཁ 9.-ܕσʔλϕʔεΤϯδϯ ζΛૉૣ͘ ͱ Β͑ɺ εϐʔσΟ ʔʹϏδωεΛల։͍ͯ͘͠ ʮػහੑʯ ɺ গͳ͍౤ࢿͰ࠷େݶͷޮՌΛੜΉϏδωεͷ ʮޮ཰ੑʯ ɺ ࣌ؒ೔ͷ҆ఆ ͢ɻ  ʹԠ͑Δ෋࢜௨ͷ*5ج൫Ͱ͢ɻ ΦʔϓϯԽʹΑ ΓෳࡶʹͳͬͨγεςϜͷ՝୊Λղܾ͠ɺ ࠷ળͷ౴͑ ͱ͔֬ͳޮՌΛ ΋ͨ Β ͠·͢ɻ  ೳͱ ͠ · ͢ɻ ௕ɺ ֦େΛ *5Ϧ ιʔεͷΑ Γ༗ޮͳ׆༻Λ࣮ݱ͢Δ ͱ ͱ ΋ʹɺ γϯϓϧͳࣗ཯ӡ ༻ͱ༰қͳγεςϜอकͰӡ༻ίε τͷ࡟ݮ͕ՄೳͱͳΓ ·͢ɻ  ͓٬༷ͷ*5౤ࢿʹରͯ͠࠷େݶͷޮՌΛൃش͠ ·͢ɻ  Ϗδωεͷޮ཰ੑ ɿ *5Ϧ ιʔεΛ࠷େݶʹ༗ޮར༻͠ɺ   Ϗδωεͷޮ཰ੑΛ௥ٻɻ  ࣌ؒ೔҆ఆՔಇɻ ϝ Π ϯϑ ϨʔϜͰഓٕͬͨज़ͱ ϊ ΢ϋ΢ʹ Α Γɺ Φʔϓϯ؀ڥʹ͓͍ͯϛ ο γ ϣ ϯΫ ϦςΟ ΧϧͳγεςϜͰϏδ ωεʹܧଓੑΛ ΋ͨ Β ͠ ·͢ɻ  Ϗδωεͷܧଓੑ ɿ ߴ৴པ ɾ ߴՄ༻ੑͷٕज़ͱϊ΢ϋ΢Ͱɺ   ϏδωεͷܧଓੑΛՄೳʹɻ  Ͱ͢ɻ  ˎ ɿ 808 ʢ8JOEPXTCJU0O8JOEPXTCJUʣ αϒγεςϜ্Ͱɺ Ϗ ο τΞϓϦέʔγ ϣ ϯͱ ͯ͠ಈ࡞͠·͢ ૯߹Χλϩά 4UVEJP O4FSWFS جװΦϯϥΠϯ ɾ όονγεςϜج൫ 4*1OFU Ϧϙδ τϦ #1. ΠϯλϥΫγϣϯ ɾ Ϛωδϝϯ τ $PMMBCPSBUJPO3JOH ாථιϦϡʔγϣϯ 4IVOTBLV%BUB.BOBHFS Interstage Shunsaku Data Manager ͋Δ͕··ʹ֨ೲ͠ɺ ࢥ͏͕··ʹݕࡧ͢Δɺ 9.-ܕσʔλϕʔεΤϯδϯ  Integration nternal high-performance XML parser ata map (schema container) Stores/indexes XML objects Maps data to RDBMSs, Adabas, etc. erver extensions/triggers arious index types for simple/complex lements and attributes ack up, restore disaster recovery, etc. igh availability ocal and distributed transactions ino‘s core enables you to build server ensions and connect external databases. core is augmented by core services and bling services. Core Services The core services are basic functional compo- nents immediately available after product installation. Native XML Data Store Accessible via HTTP-based DOM, JDOM, ˜ SAX APIs and SOAP services Storage capacity for the following docu- ˜ ments, messages and meta data: - Well-formed-, Valid-, Non-XML Auto-versioning supported via WebDAV ˜ and Subversion Query/Text Retrieval Services Tamino XML Server‘s built-in query interpreter provides: Extensive W3C XQuery support including ˜ updates, cross-collection joins, user-defined functions, modules, external variables, etc. Unique, collective searches on data, ˜ meta-data and non-XML data (e.g. full text) with-in XQuery-embedded functions Infrastructure for Thesaurus, word stemming, ˜ phonetic searches and highlighting webMethods Tamino XML Server ANGE XML DOCUMENTS ON THE FLY r erprise n Services External DB Services (opt.) Web Services SOAP) Data/Metadata/non-XML + Customer Solutions ore ... X-Tension Service Processor & Obj. mposer Databases incl. Adabas Applications Data Map chema vice Native XML Data Store Business Reporting Customer Solutions Back Office/ Back End
  3. Φʔϓϯηϛφʔ!Ԭࢁ 9.-%#ͷ෼ྨ 59 ඇఆܕσʔλ ਺஋จࣈྻ σʔλத৺ ςΩε τ σʔλத৺ ඇఆܕσʔλ΍ςΩε

    τ σʔλ͸ɺ 59޲͖ શจݕࡧ Τϯδϯ TJCMF.BSLVQ-BOHVBHF ͸ɺ Πϯλʔωοτ্Ͱަ׵ɾ஝ੵ͞ΕΔ ࣜͱͯ͠ɺ ͞·͟·ͳྖҬͰ׆༻͕ਐΜͰ͍·͢ɻ .-σʔλͷߏ଄Λͦͷ··֨ೲ͠ͳ͕Βɺ  ࣮ݱͨ͠9.-σʔλϕʔεͰ͢ɻ ͕ɺ 9.-σʔλͷ׆༻ͷՄೳੑΛ޿͛·͢ɻ ɾ ಠࣗʹ։ൃٕͨ͠ज़Ͱɺ  ɹߴ଎ݕࡧΛ࣮ݱ ͱ͖ʹσʔλϕʔε ͕ٛෆཁ εςϜʹࣅͨ ϧ ɾ σʔλϕʔεʹٻΊΒΕΔ ৴པੑΛ֬อ ɾ 92VFSZͱಠࣗ"1*Ͱ%#Λࣗࡏʹૢ࡞ ɾ 8FCΞϓϦέʔγϣϯ։ൃΛࢧԉ͢Δ98FC ɾ ͞·͟·ͳܗࣜͷσʔλΛ9.-ʹม׵ͯ͠ ɹొ࿥͢Δσʔλ࿈ܞػೳ ɾ ߴ౓ͳ೔ຊޠॲཧٕज़Ͱɺ   ଟ࠼ͳݕࡧखஈΛఏڙ ಛ௕ ςϥόΠ τڃͷ େ༰ྔσʔλͰ΋ ߴ଎ݕࡧ ௕ ೈͳσʔλߏ଄ ಛ௕ ৴པੑͷ֬อ ಛ௕ ޮ཰తͳΞϓϦ έʔγϣϯ։ൃ ಛ௕ ଟ࠼ͳݕࡧखஈ ˙؅ཧ͞Εͳ͍··૿͑ଓ͚Δඇఆܕσʔλ اۀ಺ʹ͸ɺ ച্͛΍ࡏݿͳͲͷجװܥ৘ใɺ ϝʔϧ΍ܝࣔ൘ͳͲͷίϛϡχέʔγϣϯ ৘ใɺ ઃܭॻ΍ٞࣄ࿥ɺ ঎඼৘ใɺ ඼࣭৘ใͳͲͷυΩϡϝϯτ৘ใͱ͍͏Α͏ʹɺ ࣮ʹ͞· ͟·ͳ৘ใ͕͋Γ·͢ɻ  ͦͯ͠ɺ ͜ΕΒاۀ಺৘ใͷ໿ׂ͕ɺ ίϛϡχέʔγϣϯ৘ใ΍υΩϡϝϯτ৘ใʹ୅ද ͞ΕΔɺ ߲໨ͷ௕͞΍਺͕֬ఆͰ͖ͳ͍ඇఆܕσʔλͩͱݴΘΕ͍ͯ·͢ɻ   ͜Ε·Ͱɺ ച্͛ͳͲͷجװܥ৘ใͷத৺Λ઎ΊΔఆܕσʔλ͸ɺ 3%#ͳͲΛ༻͍ͯ؅ཧ ͞Ε͖ͯ·͕ͨ͠ɺ ඇఆܕσʔλ͸ɺ ΄ͱΜͲ؅ཧ͞Ε͖ͯ·ͤΜͰͨ͠ɻ  ͔͠͠ɺ اۀՁ஋޲্ͷͨΊͷ৘ใ׆༻ɺ ͦͯ͠ɺ ίϯϓϥΠΞϯεରԠͷͨΊʹ͸ɺ ఆܕ σʔλ͚ͩͰͳ͘ɺ ඇఆܕσʔλ΋త֬ʹ؅ཧ͍ͯ͘͠ඞཁ͕͋Γ·͢ɻ ͭ·Γɺ ඇఆܕ σʔλΛత֬ʹ؅ཧ͍͔ͯ͠ͳ͚Ε͹ɺ اۀ׆ಈ͕੒Γཱͨͳ͘ͳ͖͍ͬͯͯΔͷͰ͢ɻ   ˙ඇఆܕσʔλͷ؅ཧʹ༗ޮͳ9.- ͜ͷඇఆܕσʔλͷ؅ཧʹޮՌΛൃش͢Δͷ͕9.-Ͱ͢ɻ 9.-͸ॊೈͳσʔλߏ଄͕ ࠾ΕΔͨΊɺ ߲໨ͷ௕͞΍਺͕֬ఆͰ͖ͳ͍ඇఆܕσʔλΛ༰қʹදݱͰ͖·͢ɻ ͔͠ ΋σʔλදݱܗࣜͷࠃࡍඪ४ن֨Ͱ͋Γɺ ͢Ͱʹσʔλަ׵΍஝ੵͷͨΊͷج൫ٕज़ͱ ͯ͠ఆண͖͍ͯͯ͠·͢ɻ ·ͨɺ 9.-Ͱ͋Ε͹ɺ ߲໨ͷมߋ΍γεςϜͷ֦ு͕͋ͬͯ ΋ॊೈʹରԠͰ͖Δɺ ৘ใ؅ཧ͠΍͍͢γεςϜΛͭ͘Δ͜ͱ͕Ͱ͖·͢ɻ   ˙ςϥόΠ τڃͷ9.-σʔλͰ΋؅ཧͰ͖Δ9.-σʔλϕʔεɻ ͦΕ͕ ʮ59ʯ  اۀ಺ʹଘࡏ͢Δଟछଟ༷ͳඇఆܕσʔλΛ؅ཧ͢Δʹ͸ɺ େྔͷ9.-σʔλΛ؅ཧ Ͱ͖Δσʔλϕʔε͕ඞཁͰ͢ɻ  9.-σʔλϕʔε59͸ɺ ౦ࣳιϦϡʔγϣϯ͕։ൃͨ͠ ʮςϥόΠ τڃͷ9.-σʔλ Ͱ΋ߴ଎ʹݕࡧͰ͖Δ9.-σʔλϕʔεʯ Ͱ͢ɻ ΤϯλʔϓϥΠζΫϥεͷγεςϜʹ ద͢Δಛ௕Λ࣋ͭ59Λར༻͢Ε͹ɺ େྔͷඇఆܕσʔλͰ΋త֬ʹ؅ཧ͢Δ͜ͱ͕Ͱ͖·͢ɻ   ˙ඇఆܕσʔλ΍ςΩετσʔλͷ؅ཧʹదͨ͠59 59͸ɺ ඇఆܕσʔλ͚ͩͰͳ͘ɺ ςΩετσʔλͷ؅ཧʹ΋దͨ͠σʔλϕʔεͰ͢ɻ 3%#Ͱ͸֨ೲͮ͠Β͍σʔλ΋త֬ʹ؅ཧͰ͖·͢ɻ  ʔλ༰ྔͰ΋ߴ଎ ɾ ߴਫ਼౓ݕࡧ ༻χʔζʹ͔֬ͳٕज़ͰԠ͑·͢ɻ  ϨΫλαʔόಈ࡞04 αʔναʔόಈ࡞04 EPXT4FSWFS 4UBOEBSEY&EJUJPOˎ EPXT4FSWFS &OUFSQSJTFY&EJUJPOˎ EPXT4FSWFS 4UBOEBSE&EJUJPO EPXT4FSWFS &OUFSQSJTF&EJUJPO EPXT4FSWFS EPXT"EWBODFE4FSWFS BSJT 4PMBSJT )BU&OUFSQSJTF-JOVY ʢGPSYʣ  )BU&OUFSQSJTF-JOVY"4 ʢWGPSYʣ  )BU&OUFSQSJTF-JOVY&4 ʢWGPSYʣ  ʦσΟ ϨΫ λαʔό͕4PMBSJT04-JOVYͷ৔߹ʧ  3FE)BU&OUFSQSJTF-JOVY ʢGPSYʣ  3FE)BU&OUFSQSJTF-JOVY"4 ʢWGPSYʣ  3FE)BU&OUFSQSJTF-JOVY&4 ʢWGPSYʣ  ʦσΟ ϨΫ λαʔό͕8JOEPXTͷ৔߹ʧ  8JOEPXT4FSWFS 4UBOEBSEY&EJUJPO 8JOEPXT4FSWFS &OUFSQSJTFY&EJUJPO 8JOEPXT4FSWFS 4UBOEBSE&EJUJPO 8JOEPXT4FSWFS &OUFSQSJTF&EJUJPO 8JOEPXT4FSWFS 8JOEPXT"EWBODFE4FSWFS  ඼໊ STUBHF"QQMJDBUJPO4FSWFS STUBHF4UVEJP STUBHF$PMMBCPSBUJPO3JOH%BUB$PMMFDUJPO4FSWFS STUBHF$PMMBCPSBUJPO3JOH'JMF5SBOTGFS*OUFHSBUPS STUBHF/BWJHBUPS4FSWFS NGPXBSF4FSWFS ΞϓϦ έʔγ ϣ ϯαʔό ΞϓϦ έʔγ ϣ ϯ։ൃ؀ڥ ϑΝ ΠϧసૹΛ τ Ϧ Ψʔʹ ͨ͠σʔλ࿈ܞ ෳࡶԽ͢Δαʔόؒͷ࿈ܞ ෦໳͔ Βશࣾن໛· Ͱαϙʔ τ͢Δ0-"1 σʔλϕʔε ػೳ֓ཁ ঎ඪ·ͨ͸ొ࿥঎ඪͰ͢ɻ  ࠃʹ͓͚Δొ࿥঎ඪͰ͢ɻ  ঎ඪͰ͋Γɺ  ϥΠ ηϯεڙ༩͞Ε͍ͯΔ ΋ͷͰ͢ɻ  Ε֤ࣾͷ঎ඪ·ͨ͸ొ࿥঎ඪͰ͢ɻ  ΋঎ඪදࣔ ʢ5.ɺ ʣ Λ෇ه͓ͯ͠Γ ·ͤΜɻ  ·͢ ɻ  http://interstage.fujitsu.com/jp/ 3 ඼໊ STUBHF4IVOTBLV%BUB.BOBHFS&OUFSQSJTF&EJUJPO ػೳ֓ཁ 9.-ܕσʔλϕʔεΤϯδϯ ζΛૉૣ͘ ͱ Β͑ɺ εϐʔσΟ ʔʹϏδωεΛల։͍ͯ͘͠ ʮػහੑʯ ɺ গͳ͍౤ࢿͰ࠷େݶͷޮՌΛੜΉϏδωεͷ ʮޮ཰ੑʯ ɺ ࣌ؒ೔ͷ҆ఆ ͢ɻ  ʹԠ͑Δ෋࢜௨ͷ*5ج൫Ͱ͢ɻ ΦʔϓϯԽʹΑ ΓෳࡶʹͳͬͨγεςϜͷ՝୊Λղܾ͠ɺ ࠷ળͷ౴͑ ͱ͔֬ͳޮՌΛ ΋ͨ Β ͠·͢ɻ  ೳͱ ͠ · ͢ɻ ௕ɺ ֦େΛ *5Ϧ ιʔεͷΑ Γ༗ޮͳ׆༻Λ࣮ݱ͢Δ ͱ ͱ ΋ʹɺ γϯϓϧͳࣗ཯ӡ ༻ͱ༰қͳγεςϜอकͰӡ༻ίε τͷ࡟ݮ͕ՄೳͱͳΓ ·͢ɻ  ͓٬༷ͷ*5౤ࢿʹରͯ͠࠷େݶͷޮՌΛൃش͠ ·͢ɻ  Ϗδωεͷޮ཰ੑ ɿ *5Ϧ ιʔεΛ࠷େݶʹ༗ޮར༻͠ɺ   Ϗδωεͷޮ཰ੑΛ௥ٻɻ  ࣌ؒ೔҆ఆՔಇɻ ϝ Π ϯϑ ϨʔϜͰഓٕͬͨज़ͱ ϊ ΢ϋ΢ʹ Α Γɺ Φʔϓϯ؀ڥʹ͓͍ͯϛ ο γ ϣ ϯΫ ϦςΟ ΧϧͳγεςϜͰϏδ ωεʹܧଓੑΛ ΋ͨ Β ͠ ·͢ɻ  Ϗδωεͷܧଓੑ ɿ ߴ৴པ ɾ ߴՄ༻ੑͷٕज़ͱϊ΢ϋ΢Ͱɺ   ϏδωεͷܧଓੑΛՄೳʹɻ  Ͱ͢ɻ  ˎ ɿ 808 ʢ8JOEPXTCJU0O8JOEPXTCJUʣ αϒγεςϜ্Ͱɺ Ϗ ο τΞϓϦέʔγ ϣ ϯͱ ͯ͠ಈ࡞͠·͢ ૯߹Χλϩά 4UVEJP O4FSWFS جװΦϯϥΠϯ ɾ όονγεςϜج൫ 4*1OFU Ϧϙδ τϦ #1. ΠϯλϥΫγϣϯ ɾ Ϛωδϝϯ τ $PMMBCPSBUJPO3JOH ாථιϦϡʔγϣϯ 4IVOTBLV%BUB.BOBHFS Interstage Shunsaku Data Manager ͋Δ͕··ʹ֨ೲ͠ɺ ࢥ͏͕··ʹݕࡧ͢Δɺ 9.-ܕσʔλϕʔεΤϯδϯ  Integration nternal high-performance XML parser ata map (schema container) Stores/indexes XML objects Maps data to RDBMSs, Adabas, etc. erver extensions/triggers arious index types for simple/complex lements and attributes ack up, restore disaster recovery, etc. igh availability ocal and distributed transactions ino‘s core enables you to build server ensions and connect external databases. core is augmented by core services and bling services. Core Services The core services are basic functional compo- nents immediately available after product installation. Native XML Data Store Accessible via HTTP-based DOM, JDOM, ˜ SAX APIs and SOAP services Storage capacity for the following docu- ˜ ments, messages and meta data: - Well-formed-, Valid-, Non-XML Auto-versioning supported via WebDAV ˜ and Subversion Query/Text Retrieval Services Tamino XML Server‘s built-in query interpreter provides: Extensive W3C XQuery support including ˜ updates, cross-collection joins, user-defined functions, modules, external variables, etc. Unique, collective searches on data, ˜ meta-data and non-XML data (e.g. full text) with-in XQuery-embedded functions Infrastructure for Thesaurus, word stemming, ˜ phonetic searches and highlighting webMethods Tamino XML Server ANGE XML DOCUMENTS ON THE FLY r erprise n Services External DB Services (opt.) Web Services SOAP) Data/Metadata/non-XML + Customer Solutions ore ... X-Tension Service Processor & Obj. mposer Databases incl. Adabas Applications Data Map chema vice Native XML Data Store Business Reporting Customer Solutions Back Office/ Back End ωΠςΟϒXML DB ͦͷଞ XMLରԠRDB
  4. Φʔϓϯηϛφʔ!Ԭࢁ ͜ΕΛ9.-Ͱॻ͘ͱ  YNMWFSTJPOzzFODPEJOHzVUGz  NBJM IFBE GSPNBEESFTTLVOJTIJ!FYBNQMFDPNBEESFTTGSPN UPBEESFTTIBUBOP!FYBNQMFDPNBEESFTT BEESFTTIJKJLBUB!FYBNQMFDPNBEESFTTUP

    TVCKFDUߨԋͷ͓༠͍TVCKFDU EBUFEBUF IFBE CPEZ QͷBISFGzIUUQXXXJFJDFPSHdXJz4*(8*ݚڀձB Ͱߨԋ͠·͢ɻCͥͻݟʹདྷ͍ͯͩ͘͞CQ BEESFTTࠃౡৎੜ LVOJTIJ!FYBNQMFDPN BEESFTT CPEZ NBJM
  5. Φʔϓϯηϛφʔ!Ԭࢁ 9.-ͷද͢ߏ଄ʹ໦ mail head from body to subject date address

    address address p address a b kunishi@ex ample.com hatano@ex ample.com hijikata@ex ample.com ߨԋͷ ͓༠͍ 2008-11-01 17:01:30 12/11ʹ Ͱߨԋ͠ ·͢ɻ SIG WI2 ݚڀձ ͥͻݟʹདྷͯ ͍ͩ͘͞! ࠃౡৎੜ ([email protected]) href http://www.ieice.org/~wi2/
  6. Φʔϓϯηϛφʔ!Ԭࢁ ςΩετจॻͷهड़  YNMWFSTJPOzzFODPEJOHzVUGz  NBJM IFBE GSPNBEESFTTLVOJTIJ!FYBNQMFDPNBEESFTTGSPN UPBEESFTTIBUBOP!FYBNQMFDPNBEESFTT BEESFTTIJKJLBUB!FYBNQMFDPNBEESFTTUP

    TVCKFDUߨԋͷ͓༠͍TVCKFDU EBUFEBUF IFBE CPEZ QͷBISFGzIUUQXXXJFJDFPSHdXJz4*(8*ݚڀձB Ͱߨԋ͠·͢ɻCͥͻݟʹདྷ͍ͯͩ͘͞CQ BEESFTTࠃౡৎੜ LVOJTIJ!FYBNQMFDPN BEESFTT CPEZ NBJM
  7. Φʔϓϯηϛφʔ!Ԭࢁ σʔλߏ଄ͷهड़  YNMWFSTJPOzzFODPEJOHzVUGz  NBJM IFBE GSPNBEESFTTLVOJTIJ!FYBNQMFDPNBEESFTTGSPN UPBEESFTTIBUBOP!FYBNQMFDPNBEESFTT BEESFTTIJKJLBUB!FYBNQMFDPNBEESFTTUP

    TVCKFDUߨԋͷ͓༠͍TVCKFDU EBUFEBUF IFBE CPEZ QͷBISFGzIUUQXXXJFJDFPSHdXJz4*(8*ݚڀձB Ͱߨԋ͠·͢ɻCͥͻݟʹདྷ͍ͯͩ͘͞CQ BEESFTTࠃౡৎੜ LVOJTIJ!FYBNQMFDPN BEESFTT CPEZ NBJM
  8. Φʔϓϯηϛφʔ!Ԭࢁ 9.-ରԠ3%# ໰߹ͤ XPath XQuery XML:DB API etc. 9.- 42-໰߹ͤ

    9.-Λؔ܎ʹ෼ղͯ֨͠ೲ ࡧҾFUD͸3%#ͷํࣜ 9.-ઐ༻໰߹ͤݴޠ 42-9.- ௨ৗͷ42-Ͱ΋໰߹ͤՄೳ
  9. Φʔϓϯηϛφʔ!Ԭࢁ %5%ʢจॻܕఆٛʣ &-&.&/5NBJM IFBE CPEZ  NBJMཁૉͷ಺༰͸IFBE͕ݸɺଓ͍ͯCPEZ͕ݸҎ্ &-&.&/5IFBE GSPN UP

    DD TVCKFDU EBUF  &-&.&/5GSPN BEESFTT  &-&.&/5UP BEESFTT  &-&.&/5EBUF 1$%"5"c ZFBS NPOUI EBZ  &-&.&/5CPEZ 1$%"5"cQcBEESFTT  &-&.&/5Q 1$%"5"cBcC  Qཁૉͷ಺༰͸จࣈྻɺBཁૉɺCཁૉͷݸҎ্ͷฒͼ &-&.&/5B 1$%"5"  "55-*45BISFG$%"5"3&26*3&%
  10. Φʔϓϯηϛφʔ!Ԭࢁ Ϟσϧࣸ૾ a b c d d (1, 5, 1)

    (2, 1, 2) (3, 4, 2) (4, 2, 3) (5, 3, 3) ϥϕϧͷ෇͚ํ ɾൣғϥϕϧʜ ߦ͖͕͚ॱ ؼΓ͕͚ॱ ਂ͞ ɾ%FXFZॱংʜB C D E  ID Name Label Path 1 a (1,5,1) /a 2 b (2,1,2) /a/b 3 c (3,4,2) /a/c 4 d (4,2,3) /a/c/d 5 d (5,3,3) /a/c/d
  11. Φʔϓϯηϛφʔ!Ԭࢁ IFBEBEESFTTUFYU <`LVOJTIJ!FYBNQMFDPN`> mail head from body to subject date

    address address address p address a b kunishi@ex ample.com hatano@ex ample.com hijikata@ex ample.com ߨԋͷ ͓༠͍ 2008-11-01 17:01:30 12/11ʹ Ͱߨԋ͠ ·͢ɻ SIG WI2 ݚڀձ ͥͻݟʹདྷͯ ͍ͩ͘͞! ࠃౡৎੜ ([email protected]) href http://www.ieice.org/~wi2/ 91BUI
  12. Φʔϓϯηϛφʔ!Ԭࢁ 9.-ͷྫ TCP/IP Stevens Data on the Web Abiteboul Buneman

    bib book book year year title author title author author 1994 2000
  13. Φʔϓϯηϛφʔ!Ԭࢁ '-803ࣜ for $b in doc(“books.xml”)//book let $y := $b/@year

    where $y > “1999” order by $b/author return $b/author TCP/IP Stevens Data on the Web Abiteboul Buneman bib book book year year title author title author author 1994 2000 <author>Abiteboul</author> <author>Buneman</author>
  14. Φʔϓϯηϛφʔ!Ԭࢁ ཁૉߏ੒ࢠ <bib>{ for $b in doc(“book.xml”)//book where $b/@year <

    2000 return <ttl>{$b/title/text()}</ttl> }</bib> TCP/IP Stevens Data on the Web Abiteboul Buneman bib book book year year title author title author author 1994 2000 <bib> <ttl>TCP/IP</ttl> </bib>
  15. Φʔϓϯηϛφʔ!Ԭࢁ λϓϧετϦʔϜ for $i in (1, 2), $j in (3,

    4) ($i = 1, $j = 3), ($i = 1, $j = 4), ($i = 2, $j = 3), ($i = 2, $j = 4)
  16. Φʔϓϯηϛφʔ!Ԭࢁ 9.-ͷ݁߹ for $b1 in doc(“book1.xml”)//book, $b2 in doc(“book2.xml”)//book where

    $b1/author = $b2/author and $b1/title != $b2/title return <pair>{$b1/title, $b2/title}</pair> <pair> <title>The Art of Comp. Prog.</title> <title>TeX Book</title> </pair>
  17. Φʔϓϯηϛφʔ!Ԭࢁ 92VFSZ ςΩετݕࡧ for $b in /books/book where $b/title ftcontains

    (“program” with stemming) ftand “Ruby” return $b/author lQSPHSBNzXJUITUFNNJOH ˠlQSPHSBNzΛޠװͱ͢Δ୯ޠ lQSPHBNNJOHzFUD
  18. Φʔϓϯηϛφʔ!Ԭࢁ 92VFSZ6QEBUF 'BDJMJUZ insert node <year>2005</year> after fn:doc(“bib.xml”)/books/book[1]/title delete node

    fn:doc(“bib.xml”)/books/book[1]/author[last()] rename node fn:doc("bib.xml")/books/book[1]/author[1] as "principal-author"
  19. Φʔϓϯηϛφʔ!Ԭࢁ 9.-ੜ੒ select xmlelement(name “bib”, xmlattributes(year as “year”), xmlforest(title as

    “title”)) as “books” from books title year TCP/IP 1990 Database 2000 books books <bib year=”1990”><title>TCP/IP</title></bib> <bib year =”2000”><title>Database</title></bib>
  20. Φʔϓϯηϛφʔ!Ԭࢁ 92VFSZͷຒΊࠐΈ books <bib year=”1990”><title>TCP/IP</title></bib> <bib year =”2000”><title>Database</title></bib> books_xml select

    xmlquery( ‘for $b in $col return $b/title’ passing books as “col” returning content null on empty) as result from books_xml result <title>TCP/IP</title> <title>Database</title>
  21. Φʔϓϯηϛφʔ!Ԭࢁ 9.-ˠؔ܎ select result.* from books_xml, xmltable( ‘for $b in

    $col/bib return $b’ passing books_xml.books as “col” columns “title” varchar(80) path ‘title’, “year” integer path “@year” ) as result books <bib year=”1990”><title>TCP/IP</title></bib> <bib year =”2000”><title>Database</title></bib> books_xml title year TCP/IP 1990 Database 2000