XQueryってどんなもの？

Size: px

Start display at page:

Download "XQueryってどんなもの？"

ありかつふしはら
5 years ago
Views:

1 2 XML Week XML XML XML-DB WG NTT ( ) ymmt@po.ntts.co.jp chiba@isid.co.jp obamikio@jp.ibm.com

2 XQuery SQL SQL SQL

3 XQuery SQL XML

4 XQuery XML XML XPath XML XPath XML XPath XPath XML XML

5 XQuery XML XML XPath XPath <students> <student name=" "> <teacher> </teacher> </student> <student name=" "> <teacher> </teacher> </student> <students> "] <student name=" "> <teacher> </teacher> </student>

6 XQuery XML XML XPath <students> <teacher name=" "> <student name=" "> <student> </student> <teacher> </teacher> <student> </student> </student> </teacher> <student name=" "> <teacher> </teacher> </student> <students> XML

7 XQuery XML XML XPath XSLT XSLT XPath XML XSLT

8 XQuery XML XML XPath XSLT XPath XSLT XML!! XQuery XQuery!!

9 XML XML XML XML

10 XML XML XML XML SQL XML SQL

11 XML XML XML XML XML SQL XQuery

12 XML XML XML (Join)

13 XML XML XML XML XML

14 XML XML XQuery unordered ( ) unordered unordered( for $p in doc("parts.xml")//part[color = "Red"], $s in doc("suppliers.xml")//supplier where $p/suppno = $s/suppno return <ps> { $p/partno, $s/suppno } </ps> ) XQuery

15 XML Query XQL99 XQL98 XPath XSLT XUL excelon XML-QL XSQL Oracle XML XML OODBQuery OODBQuery XPointer RDBQuery RDBQuery SQL OQL QUILT XQuery XQL XSLT XPath XML XML-QL SQL XQL XML-QL QUILT XQuery QUILT W3C XML

16 XQuery W3C Working Draft ( XML Query Requirements (5/2/2003) XML Query Use Cases (5/2/2003) :11/15/ XQuery1.0 and XPath2.0 Data Model (LAST CALL) (5/2/2003) XSLT 2.0 and XQuery 1.0 Serialization (5/2/2003) XQuery1.0 and XPath2.0 Formal Semantics (5/2/2003) XQuery1.0: An XML Query Language (5/2/2003) XML Syntax for XQuery1.0 (XQueryX) (6/7/2001) XQuery1.0 and XPath2.0 Functions and Operators (LAST CALL)(5/2/2003) XPath Requirements Version2.0 (2/14/2001) XML Path Language (XPath)2.0 (5/2/2003) :8/16/2002 Document WG XML Query and XPath Full-Text Requirements (5/2/2003) XML Query and XPath Full-Text Use Cases (2/14/2003) Document WG

17 XQuery Expression XQuery 2003/05/03 Working Draft FLWOR Path

18 Path $ QName $b $val FLWOR typeswitch Path XML Path Language (XPath)2.0 /doc/chapter[title="introduction"]

19 XQuery XQuery1.0 and XPath2.0 Functions and Operators op:numeric-add fn:round fn:concat fn:contains fn:replace fn:local-name fn:deep-equal fn:empty fn:insert-before fn:sum fn:doc

20 XML Direct Element Constructor XML curly braces { } Computed Constructor element attribute document text <title isbn= isbn > { $b/title } </title> element title { "Harold and the Purple Crayon" } { attribute isbn { "isbn " } }

21 FLWOR 1 F L W O R FOR LET WHERE ORDER BY RETURN flower əʊə XML JOIN XML FLWOR FLWOR

22 FLWOR 2 FOR for in (, in )* Cartesian tuple stream iteration LET let := (, in )* tuple stream FOR FOR FOR

23 FLWOR 3 WHERE where FOR LET tuple stream true false ORDER BY order by tuple stream collation empty

24 FLWOR 4 RETURN return FLWOR tuple stream

25 XML Query Use Cases 9 ( XMP ) ( TREE ) ( SEQ ) ( R ) ("SGML") Standard Generalized Markup Language ( STRING ) ( NS ) ( PARTS ) ("STRONG")

26 XML Query Use Cases Use Case Addison-Wesley (Use Case XMP Q1) Use Case 2 Bicycle itemno description bid Use Cases R Q2

27 Use Case Addison-Wesley (Use Case XMP Q1)

28 XML bib.xml <bib> <book year="1994"> <title>tcp/ip Illustrated</title> <author> <>Stevens</> <>W.</> </author> <publisher>addison-wesley</publisher> <price> 65.95</price> </book> XML Query Use Cases <book year="2000"> <title>data on the Web</title> <author> <>Abiteboul</> <>Serge</> </author> <author> <>Buneman</> <>Peter</> </author> <author> <>Suciu</> <>Dan</> </author> <publisher>morgan Kaufmann Publishers</publisher> <price>39.95</price> </book> </bib>

29 bib.xml bib book book year title author publisher price year title author author author publisher price 1994 TCP/IP Illustrated Addison -Wesley Data on the Web Morgan Kaufmann Publishers Stevens W. Abiteboul Serge Buneman Peter Suciu Dan

30 XQuery Addison-Wesley (Use Case XMP Q1) XQuery

31 XQuery 1 1 bib book year 1994 title TCP/IP Illustrated author Stevens W. publisher price Addison -Wesley book year 2000 title Data on the Web author Abiteboul Peter publisher price Morgan Kaufmann Publishers author Suciu Serge author Buneman Dan

32 XQuery 1 2 bib $b = book book year title author publisher price year title author author author publisher price 1994 TCP/IP Illustrated Addison -Wesley Data on the Web Morgan Kaufmann Publishers Stevens W. Abiteboul Serge Buneman Peter Suciu Dan

33 XQuery 1 3 WHERE bib $b = book book year title author publisher price year title author author author publisher price 1994 TCP/IP Illustrated Addison -Wesley Data on the Web Morgan Kaufmann Publishers Stevens W. Abiteboul Serge Buneman Peter Suciu Dan

34 XQuery 1 4 return <book year= 1994 > <title>tcp/ip Illustrated</title> </book> bib $b = book book year title author publisher price year title author author author publisher price 1994 TCP/IP Illustrated Addison -Wesley Data on the Web Morgan Kaufmann Publishers Stevens W. Abiteboul Serge Buneman Peter Suciu Dan

35 XQuery 1 5 bib book $b = book year title author publisher price year title author author author publisher price 1994 TCP/IP Illustrated Addison -Wesley Data on the Web Morgan Kaufmann Publishers Stevens W. Abiteboul Serge Buneman Peter Suciu Dan

36 XQuery 1 6 bib WHERE book $b = book year title author publisher price year title author author author publisher price 1994 TCP/IP Illustrated Addison -Wesley Data on the Web Morgan Kaufmann Publishers Stevens W. Abiteboul Serge Buneman Peter Suciu Dan

37 XQuery 1 7 XQuery <bib> <book year= 1994 > <title>tcp/ip Illustrated</title> </book> </bib> bib book book year title author publisher price year title author author author publisher price 1994 TCP/IP Illustrated Addison -Wesley Data on the Web Morgan Kaufmann Publishers Stevens W. Abiteboul Serge Buneman Peter Suciu Dan

38 Use Case 2 Bicycle itemno description bid Use Cases R Q2

39 ITEMS BIDS U01 Broken Bicycle U04 Racing Bicycle U03 Helicopter U03 Tennis Racket U01 Tricycle U02 Old Bicycle U02 Motorcycle U01 Red Bicycle 1001 RESERVE _PRICE END_DATE START_DATE OFFERED _BY DESCRIPTION ITEMNO U U U U U U U U U U U U U U U U02 BID_DATE BID ITEMNO USERID

40 XML items.xml items.xml

41 XML bids.xml bids.xml

42 XQuery 2 Bicycle itemno description bid Use Cases R Q2 XQuery

43 XQuery 2 1 <result> { for $i in doc("items.xml")//item_tuple let $b := doc("bids.xml")//bid_tuple[itemno = $i/itemno] where contains($i/description, "Bicycle") order by $i/itemno return <item_tuple> { $i/itemno } { $i/description } <high_bid>{ max($b/bid) }</high_bid> </item_tuple> }</result> items bids $i = item_tuple bid_tuple $b = itemno description offered_by start_date end_date reserve_price userid itemno bid bid_date XML JOIN

44 XQuery 2 2 <result> { for $i in doc("items.xml")//item_tuple let $b := doc("bids.xml")//bid_tuple[itemno = $i/itemno] where contains($i/description, "Bicycle") order by $i/itemno return <item_tuple> { $i/itemno } { $i/description } <high_bid>{ max($b/bid) }</high_bid> </item_tuple> }</result> JOIN $i = $b = ITEMNO 1001 DESCRIPTION Red Bicycle OFFERED _BY U01 START_DATE END_DATE RESERVE _PRICE 40 USERID U02 U04 ITEMNO BID BID_DATE U U U

45 XQuery 2 3 <result> { for $i in doc("items.xml")//item_tuple let $b := doc("bids.xml")//bid_tuple[itemno = $i/itemno] where contains($i/description, "Bicycle") order by $i/itemno return <item_tuple> { $i/itemno } { $i/description } <high_bid>{ max($b/bid) }</high_bid> </item_tuple> }</result> $i = $b = ITEMNO 1001 DESCRIPTION Red Bicycle OFFERED _BY U01 START_DATE END_DATE RESERVE _PRICE 40 USERID U02 U04 ITEMNO BID BID_DATE U U U

46 XQuery 2 4 <result> { for $i in doc("items.xml")//item_tuple let $b := doc("bids.xml")//bid_tuple[itemno = $i/itemno] where contains($i/description, "Bicycle") order by $i/itemno return <item_tuple> { $i/itemno } { $i/description } <high_bid>{ max($b/bid) }</high_bid> </item_tuple> }</result> $i = $b = ITEMNO DESCRIPTION OFFERED _BY START_DATE END_DATE RESERVE _PRICE USERID U02 ITEMNO 1001 BID 35 BID_DATE Red Bicycle U U U item_tuple U04 U itemno description high_bid max( )

47 XQuery 2 5 <result> { for $i in doc("items.xml")//item_tuple let $b := doc("bids.xml")//bid_tuple[itemno = $i/itemno] where contains($i/description, "Bicycle") order by $i/itemno return <item_tuple> { $i/itemno } { $i/description } <high_bid>{ max($b/bid) }</high_bid> </item_tuple> }</result> result item_tuple item_tuple item_tuple item_tuple itemno description high_bid itemno description high_bid itemno description high_bid itemno description high_bid 1001 Red Bicycle Old Bicycle Racing Bicycle Broken Bicycle order by

48 XQuery 2 6 <result> <item_tuple> <itemno>1001</itemno> <description>red Bicycle</description> <high_bid>55.0</high_bid> </item_tuple> <item_tuple> <itemno>1003</itemno> <description>old Bicycle</description> <high_bid>20.0</high_bid> </item_tuple> <item_tuple> <itemno>1007</itemno> <description>racing Bicycle</description> <high_bid>225.0</high_bid> </item_tuple> <item_tuple> <itemno>1008</itemno> <description>broken Bicycle</description> <high_bid></high_bid> </item_tuple> </result>

49 SVG XQuery SVG Scalable Vector Graphics W3C XML rect circle text SVG XQuery

SVG SVG <?xml version= 1.0 encoding= UTF-8?> <svg xmlns:svg='http://www.w3.

50 SVG SVG <?xml version= 1.0 encoding= UTF-8?> <svg xmlns:svg=' width='100mm' height='100mm' viewbox=' '> <circle cx='20' cy='20' r='15' fill="#ff0000" stroke="#000000" stroke-width="0.3"/> </svg> SVG 20 x RGB #FF y

51 SVG XML-DB (NeoCore) XQueryViewer XML-DB (Xquery Apache XML Project Batik 1.5 (SVG Library) Java Foundation Class (Swing) Java SDK 1.4

52 SVG SVG Xquery

53 [ ] SVG 1 SVG circle1.svg

54 [ ] SVG 2 SVG circle1.svg <?xml version="1.0" encoding="utf-8" standalone="no"?> <svg xmlns=' width='100mm' height='100mm' viewbox=' '> <g> <circle cx='15' cy='15' r='5' fill="#ff0000" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='15' cy='65' r='5' fill="#ff0000" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='65' cy='65' r='5' fill="#ff0000" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='65' cy='15' r='5' fill="#ff0000" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='20' cy='20' r='10' fill="#ff0033" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='20' cy='60' r='10' fill="#ff0033" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='60' cy='60' r='10' fill="#ff0033" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='60' cy='20' r='10' fill="#ff0033" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='25' cy='25' r='15' fill="#ff0066" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='25' cy='55' r='15' fill="#ff0066" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='55' cy='55' r='15' fill="#ff0066" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='55' cy='25' r='15' fill="#ff0066" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='30' cy='30' r='20' fill="#ff0099" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='30' cy='50' r='20' fill="#ff0099" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='50' cy='50' r='20' fill="#ff0099" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='50' cy='30' r='20' fill="#ff0099" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='35' cy='35' r='25' fill="#ff00cc" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='35' cy='45' r='25' fill="#ff00cc" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='45' cy='45' r='25' fill="#ff00cc" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='45' cy='35' r='25' fill="#ff00cc" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> <circle cx='40' cy='40' r='30' fill="#ff00ff" fill-opacity="0.2" stroke="#000000" stroke-width="0.3"/> </g> </svg>

55 [ ] SVG 3 20 <svg xmlns=' width='100mm' height='100mm' viewbox=' '> { for $c in document("circle1.svg")/svg//circle where $c/@r < 20 return <g> { $c } </g> }</svg> 20 <svg xmlns=' width='100mm' height='100mm' viewbox=' '> { for $c in document("circle1.svg")/svg//circle where $c/@r > 20 return <g> { $c } </g> }</svg>

56 [ ] SVG

57 [ ] SVG 5 SVG rect1.svg

58 [ ] SVG 6 SVG circle1.svg <?xml version="1.0" encoding="utf-8" standalone="no"?> <svg xmlns=' width='40mm' height='40mm' viewbox=' '> <g> <rect x='0' y='0' width='10' height='10' fill="#66ccff" stroke="none"/> <rect x='10' y='0' width='10' height='10' fill="#ff9933" stroke="none"/> <rect x='20' y='0' width='10' height='10' fill="#66ccff" stroke="none"/> <rect x='30' y='0' width='10' height='10' fill="#ff9933" stroke="none"/> <rect x='0' y='10' width='10' height='10' fill="#ff9933" stroke="none"/> <rect x='10' y='10' width='10' height='10' fill="#66ccff" stroke="none"/> <rect x='20' y='10' width='10' height='10' fill="#ff9933" stroke="none"/> <rect x='30' y='10' width='10' height='10' fill="#66ccff" stroke="none"/> <rect x='0' y='20' width='10' height='10' fill="#66ccff" stroke="none"/> <rect x='10' y='20' width='10' height='10' fill="#ff9933" stroke="none"/> <rect x='20' y='20' width='10' height='10' fill="#66ccff" stroke="none"/> <rect x='30' y='20' width='10' height='10' fill="#ff9933" stroke="none"/> <rect x='0' y='30' width='10' height='10' fill="#ff9933" stroke="none"/> <rect x='10' y='30' width='10' height='10' fill="#66ccff" stroke="none"/> <rect x='20' y='30' width='10' height='10' fill="#ff9933" stroke="none"/> <rect x='30' y='30' width='10' height='10' fill="#66ccff" stroke="none"/> </g> </svg>

59 [ ] SVG 7 x 2 <svg xmlns=' width='80mm' height='40mm' viewbox=' '> { for $r in document("rect1.svg")/svg//rect return <g> <rect x={$r/@x*2} y={$r/@y} width={$r/@width*2} height={$r/@height} fill={$r/@fill} stroke="none"/> </g> }</svg>

60 [ ] SVG 8

61 Demonstration XML DB NeoCore SVG

UbiquitousMetadata活用-3

UbiquitousMetadata活用-3 XML XML XML-DB WG NTT () ymmt@po.ntts.co.jp chiba@isid.co.jp obamikio@jp.ibm.com 2XML Week 3/4 XQuery SQL SQL SQL XQuery SQL XML XQuery XML XML XPath XML XPath XML XPath XPath XML XML XQuery XML XML XPath