[PDF] XPath Terminology

Grammaire - Attribut et apposition

L’apposition est un attribut sans verbe «attribut sans verbe «attribut sans verbe « êtreêêttrreeêtre »»»» ou autre verbe d’état Elle concerne des noms qui dépendent un autre nom ou des adjectifs qualificatifs séparés du nom par une virguleséparés du nom par une virguleséparés du nom par une virgule

Exercise modelbuilder for beginners - MIT Libraries

3 Attribute” Click on the tool and drag it into the model window Note that it automatically generates an output variable Note also that the model is just an outline at this point

Exercise 31 Join Attribute Data to a Shapefile

The data joining step is often a prerequisite for mapping and spatial analysis Creating a color-shaded map (also known as a choropleth map), is a good first step in geographic

Tutorial Exercises for the Weka Explorer 17

560 CHAPTER 17 Tutorial Exercises for the Weka Explorer Familiarize yourself with the Preprocess panel by doing the following exercises The solutions to these and other exercises in this section are given at the end of the

BS in Exercise Science

B S in Exercise Science Updated 05/07/2018 p 2 of 2 Major Requirements (62 sh) SUMMARY OF MAJOR REQUIREMENTS 12 sh of Foundational courses 46 sh of Upper Level courses

Tutorial –XPath, XQuery

Node selector : exercise sol Result Path Expression Selects theSelects the document rootdocument root node / Selects the bookstore element node /bookstore /bookstore Selects all book element nodes /bookstore/book

Exercise 4 Editing and Data Management

7 When the Copy finishes close the Geoprocessing Pane 8 Open the Project Pane Right click Folders, and then click Add Folder Connection 9 In the Add Folder Connection, browse to C:\Esri and select the ArcGIS Pro folder

DATABASE MANAGEMENT SYSTEMS SOLUTIONS MANUAL

The Entity-Relationship Model 13 Answer 2 7 1 The ER diagram is shown in Figure 2 3 2 If the drug is to be sold at a xed price we can add the price attribute to the Drug

Build your own symbols - Autodesk

1 Select the Convert Text to Attribute tool from the Symbol Builder toolbar to launch the dialog box 2 Select a text entry in the list and click the arrow pointing at the attribute name

XPath Terminology

1 CSC343: Intro to Databases 1 Tutorial 7 – XPath, XQuery CSC343 - Introduction to Databases Fall 2008 TA: Lei Jiang CSC343: Intro to Databases 2

[PDF] attribut du sujet cm1 pdf

[PDF] accord attribut du sujet exercices

[PDF] attribut du sujet cm1 leçon

[PDF] séquence attribut du sujet cm1

[PDF] attribut du sujet cm1 évaluation pdf

[PDF] leçon attribut du sujet cm2

[PDF] evaluation attribut du sujet cm1 avec correction

[PDF] texte avec adjectif épithète et attribut

[PDF] évaluation adjectif épithète attribut cm1

[PDF] fonction attribut du sujet

[PDF] attribut du sujet exercices pdf

[PDF] tableau fonctions syntaxiques

[PDF] fonction épithète

[PDF] analyse grammaticale arabe pdf

[PDF] mubtada khabar

1

CSC343: Intro. to Databases 1

Tutorial 7 - XPath, XQuery

CSC343 - Introduction to Databases

Fall 2008

TA: Lei Jiang

CSC343: Intro. to Databases 2

XPath Terminology

•Node - document root, element, attribute, text, comment, ... •Relationship - parent, child, sibling, ancestor, descendent, ... •Exercise: Identify nodes and relationships in following xml document 79.99 69.95 39.00 document root does not correspond to anything in the document 2

CSC343: Intro. to Databases 3

Node selector

Selects attribute nodes@Selects the document rootnode (absolute path)/

Selects the parent of the current node..Selects the current node.Selects all descendent nodes of the current node

that match the selection//Selects the node (relative path)nodeDescriptionExpression

CSC343: Intro. to Databases 4

Node selector: exercise

/bookstore//@lang/../..??Selects all lang attribute nodes ?Selects all price elementnodes? ?Selects the document rootnode Selects all book elementnodesSelects the bookstore elementnodeResult ./book/tilte/@lang ?Path Expression 3

CSC343: Intro. to Databases 5

Node selector : exercise sol

/bookstore//@lang/../..Selects all the book elementnodes././.Selects the document root node//@langSelects all lang attribute nodesbookstore/book/priceSelects all price elementnodes

//price./bookstore /Selects the document rootnode

Selects the empty set

Selects all book elementnodesSelects the bookstore elementnodeResult ./book/tilte/@lang //book /bookstore/book/bookstorePath Expression

CSC343: Intro. to Databases 6

Node selector: more exercise

/bookstore/book/text()? /bookstore/book/title/..//@*??Select all nodes except attribute nodes ?Select all attribute nodes?Select all commentnodes?Selects textnodes of all price element nodes

Select all child nodes of book element

nodesResult ?Path Expression 4

CSC343: Intro. to Databases 7

Node selector: more exercise sol

/bookstore/book/text()Selects empty set /bookstore/book/title/..//@*Select all attribute nodes which are descendant of book elementnodes //node()Select all nodes except attribute nodes

//@*Select all attribute nodes//comment()Select all commentnodes//price/text()Selects textnodes of all price element

nodes

Select all child nodes of book element

nodesResult /bookstore/book/*Path Expression

CSC343: Intro. to Databases 8

XPath Syntax and Semantics

••SyntaxSyntax - locationStep1/locationStep2/... • locationStep = axis::nodeSelector[predicate] •Semantics - Find all nodes specified by locationStep1locationStep1 • Find all nodes specified by axis::nodeSelectoraxis::nodeSelector • Select only those that satisfy predicatepredicate - For each such node N: • Find all nodes specified by locationStep2locationStep2 using N as the current node • Take union

- For each node returned by locationStep2locationStep2 do the same using locationStep3, locationStep3, ......

5

CSC343: Intro. to Databases 9

Complete set of Axes

•self-- the context node itself•child-- the children of the context node•descendant-- all descendants (children+)•parent-- the parent (empty if at the root)•ancestor-- all ancestors from the parent to the root•descendant-or-self -- the union of descendant and self•ancestor-or-self -- the union of ancestor and self

•following-sibling-- siblings to the right•preceding-sibling-- siblings to the left•following-- all following nodes in the document, excluding descendants

•preceding-- all preceding nodes in the document, excluding ancestors•attribute-- the attributes of the context node

CSC343: Intro. to Databases 10

Axes: exercise

/bookstore/node()/descendant-or- self::node()?/bookstore/book/following- sibling::book?/child::book? /descendant::title/@*/parent::title/f ollowing::node()??Select titleandprice elementnodes?Selects book element nodes

Select all isbn attributenodes Result

?Path Expression 6

CSC343: Intro. to Databases 11

Axes: exercise (sol)

/bookstore/node()/descendant-or- self::node()Select all nodes (except attributes) that are descendants of the bookstore elementnode/bookstore/book/following- sibling::bookSelects the second book elementnode/child::bookSelects empty set /descendant::title/@*/parent::title/f ollowing::node()Select all nodes (except attributes)

after the first title node//book/title | //book/priceSelect titleand price elementnodes/descendant::bookSelects book element nodes

Select all isbn attributenodes Result

//book/attribute::isbnPath Expression

CSC343: Intro. to Databases 12

Predicate: summary

•[position() op #],[last()] - op: =, !=, <, >, <=, >= - test position among siblings •[attribute::name op "value"] - op: =, !=, <, >, <=, >= - test equality of an attribute •[axis:nodeSelector] - test pattern 7

CSC343: Intro. to Databases 13

Predicate: exercise

?Selects all nodes which have an attr /bookstore/book[price>35.00]/titleSelects all the title elementof all book elementswith a price greater than 35.00?Selects nodes with an attribute named langor has a child element named price. /bookstore/book/title[last()]??Selects the second to last book element /bookstore/book[position()>1 and attribute::isbn="111111"]??Select book elementnodes which has a child title elementwith langattribute value no equal to "eng".?Selects the first book elementthat is the child of the bookstore element.Result ?Path Expression

CSC343: Intro. to Databases 14

Predicate: exercise sol

//node()[@*]Selects all nodes which have an attr /bookstore/book[price>35.00]/titleSelects all the title elementof all book

elementswith a price greater than 35.00//node()[@lang or child::price]Selects nodes with an attribute named

langor has a child element named price. /bookstore/book/title[last()]Select the last title elementnode of all book elementnodes/bookstore/book[last()-1]Selects the second to last book element /bookstore/book[position()>1 and attribute::isbn="111111"]Select the empty set/bookstore/book[child::title/attri bute::lang!="eng"]Select book elementnodes which has a child title elementwith langattribute value no equal to "eng"./bookstore/book[1]Selects the first book elementthat is the child of the bookstore element.Result /bookstore/book[position()=1]Path Expression 8

CSC343: Intro. to Databases 15

XPath: exercise

•Question: find the title and price of non fiction books with a price more than 50 USD. 79.99 69.95 39.00 •Answer:

-/bookstore/book[attribute::cat!="fiction" and price>50.00]/title | /bookstore/book[attribute::cat!="fiction" and price>50.00]/@isbn

CSC343: Intro. to Databases 16

XPath: exercise

•Question: find average price of textbooks. 79.99 69.95 39.00 •Answer:

-sum(/bookstore/book[attribute::cat="textbook"]/price/number(text())) div count(/bookstore/book[attribute::cat="textbook"]/price)

9

CSC343: Intro. to Databases 17

XPath: exercise

•Question: find the titles of textbooks on XML. 79.99 69.95 39.00 •Answer: -/bookstore/book[attribute::cat="textbook" and contains(title, "XML")]/title/text()

CSC343: Intro. to Databases 18

XQuery Example

Q1: Create a new document which contain only the isbn and title of textbooks. { for$bookin doc("bookstore.xml")//book where$book/@cat="textbook" return{$book/title}

Result:

10

CSC343: Intro. to Databases 19

XQuery Syntax and Semantics

•Syntax (FLWR) forvariable bindings (like fromin SQL) letvariable bindings(like fromin SQL) wherecondition (likewherein SQL) returndocument(likeselectin SQL) • Semantics - The for andletclause binds variables to elements specified by an XQuery expression. •for:bind a variable to each element in the returned set •let:bind a variable to the whole set of elements - Filter out nodes that do not satisfy the condition of the where clause . - For each retained tuple of bindings, instantiate the returnclause.

CSC343: Intro. to Databases 20

XQuery Example Again

{ for$bookin doc("bookstore.xml")//book where$book/@cat="textbook" return{$book/title} 79.99 69.95 39.00 11

CSC343: Intro. to Databases 21

XQuery Example Modified

Q2: { let$book:= doc("bookstore.xml")//book where$book/@cat="textbook" return{$book/title} 79.99 69.95 39.00

CSC343: Intro. to Databases 22

XQuery Exercise - Basic

Q3: Find the title and price of the book with isbn "222222" for $book in doc("bookstore.xml")//book where $book[@isbn="222222"] return { $book/title, $book/price}

Result:

69.95 12

CSC343: Intro. to Databases 23

XQuery Exercise - Ordering

Q4: Produce a list of non-fictions with their title and price, sorted by price. { for $book in doc("bookstore.xml")//book, $title in $book/title, $price in $book/price where $book/@cat!="fiction" order by $price/text() return { $title, $price}

Result:

39.00 69.95

CSC343: Intro. to Databases 24

XQuery Exercise - Aggregation

Q5: Find title of the the textbook with highest price. { let $prices := doc("bookstore.xml")//book[@cat="textbook"]/price let $max := max($prices) return {for $book in doc("bookstore.xml")//book where $book/price = $max return $book/title

Result:

13

CSC343: Intro. to Databases 25

XQuery Exercise - Restructuring

Q6: Restructure the document to organize books by categories. { let $categories := for $category in doc("bookstore.xml")//book/@cat return $category for $cat in distinct-values($categories) return { for $book in doc("bookstore.xml")//book where $book[@cat = $cat] return $book }

Result:

79.99 69.95 39.00 79.99 69.95

CSC343: Intro. to Databases 26

XQuery Exercise - Restructuring

Q7: Restructure the document to produce the total price and count of books in each category. { let $categories := for $category in doc("bookstore.xml")//book/@cat return $category for $cat in distinct-values($categories) return { let $prices-in-cat := doc("bookstore.xml")//book[@cat=$cat]/price return

Result:

79.99 69.95 quotesdbs_dbs12.pdfusesText_18