ࡱ > l n k U@ G bjbj ( ? x x x x x x x Z \ \ \ \ \ \ $ R # Z x x x x x Z Z x x $ z N 0 } ^ } x x x x } x @
Appendix C
XML Files
Nutrition.xml
65
20
300
2400
300
25
50
Avocado Dip
Sunnydale
29
11
3
5
210
2
0
1
0
0
0
0
Bagels, New York Style
Thompson
104
4
1
0
510
54
3
11
0
0
8
20
Beef Frankfurter, Quarter Pound
Armitage
115
32
15
65
1100
8
0
13
0
2
1
6
Chicken Pot Pie
Lakeson
198
22
9
25
810
42
2
10
20
2
2
10
Cole Slaw
Fresh Quick
1.5
0
0
0
15
5
2
1
30
45
4
2
Eggs
Goodpath
50
4.5
1.5
215
65
1
0
6
6
0
2
4
Hazelnut Spread
Ferreira
2
10
2
0
20
23
2
3
0
0
6
4
Potato Chips
Lees
28
10
3
0
180
15
1
2
0
10
0
0
Soy Patties, Grilled
Gardenproducts
96
5
0
0
420
10
4
9
0
0
0
0
Truffles, Dark Chocolate
Lyndon's
39
19
14
25
10
16
1
1
0
0
0
0
Parts.xml
The Adventures of Huckleberry Finn
Mark Twain
mass market paperback
298
$5.49
Leaves of Grass
Walt Whitman
hardcover
462
$7.75
The Legend of Sleepy Hollow
Washington Irving
mass market paperback
98
$2.95
The Marble Faun
Nathaniel Hawthorne
trade paperback
473
$10.95
Moby-Dick
Herman Melville
hardcover
724
$9.95
The Portrait of a Lady
Henry James
mass market paperback
256
$4.95
The Scarlet Letter
Nathaniel Hawthorne
trade paperback
253
$4.25
The Turn of the Screw
Henry James
trade paperback
384
$3.35
Query 0:
FOR $p IN document("./xml_files/nutrition.xml")//food
WHERE $p/sodium = "210"
RETURN $p
Result 0:
Avocado Dip
Sunnydale
29
11
3
5
210
2
0
1
0
0
0
0
Query 1:
FOR $p IN document("./xml_files/nutrition.xml")//food
WHERE $p/sodium = "210"
RETURN $p
Result 1:
Avocado Dip
Sunnydale
29
11
3
5
210
2
0
1
0
0
0
0
Query 2:
FOR $p IN document("./xml_files/nutrition.xml")//food
WHERE $p/sodium < "210"
RETURN $p
Result 2:
Cole Slaw
Fresh Quick
1.5
0
0
0
15
5
2
1
30
45
4
2
Eggs
Goodpath
50
4.5
1.5
215
65
1
0
6
6
0
2
4
Hazelnut Spread
Ferreira
2
10
2
0
20
23
2
3
0
0
6
4
Potato Chips
Lees
28
10
3
0
180
15
1
2
0
10
0
0
Truffles, Dark Chocolate
Lyndon's
39
19
14
25
10
16
1
1
0
0
0
0
Query 3:
FOR $p IN document("./xml_files/nutrition.xml")//food
WHERE $p/name = "Bagels, New York Style "
RETURN $p
Result 3:
Bagels, New York Style
Thompson
104
4
1
0
510
54
3
11
0
0
8
20
Query 4:
FOR $p IN document("./xml_files/nutrition.xml")//food
WHERE $p/sodium = "210"
RETURN
$p/name/text(),
$p/fiber/text(),
$p/protein/text()
Result 4:
Avocado Dip01
Query 5:
FOR $p IN document("./xml_files/nutrition.xml")//food
WHERE $p/sodium = "210"
RETURN
$p
Result 5:
Avocado Dip
Sunnydale
29
11
3
5
210
2
0
1
0
0
0
0
Query 6:
FOR $p IN document("./xml_files/nutrition.xml")//food
WHERE $p/sodium = "210"
RETURN
$p
Result 6:
Avocado Dip
Sunnydale
29
11
3
5
210
2
0
1
0
0
0
0
Query 7:
FOR $p IN document("./xml_files/nutrition.xml")//food
WHERE $p/sodium = "210"
RETURN
$p
Result 7:
Avocado Dip
Sunnydale
29
11
3
5
210
2
0
1
0
0
0
0
Query 8:
FOR $p IN document("./xml_files/nutrition.xml")//foods
WHERE $p/sodium = "210"
RETURN
$p
Result 8:
Query 9:
FOR $p in doc("./xml_files/parts.xml")/book
where $p/PAGES > "297"
return $p
Result 9:
The Adventures of Huckleberry Finn
Mark Twain
mass market paperback
298
$5.49
Leaves of Grass
Walt Whitman
hardcover
462
$7.75
The Marble Faun
Nathaniel Hawthorne
trade paperback
473
$10.95
Moby-Dick
Herman Melville
hardcover
724
$9.95
The Turn of the Screw
Henry James
trade paperback
384
$3.35
Query 10:
FOR $p IN document("./xml_files/nutrition.xml")//food
WHERE $p/sodium <= "210"
RETURN
$p/name,
$p/fiber,
$p/protein
$p/sodium
Result 10:
Avocado Dip
0
1
210
Cole Slaw
2
1
15
Eggs
0
6
65
Hazelnut Spread
2
3
20
Potato Chips
1
2
180
Truffles, Dark Chocolate
1
1
10
" # ` a c l # # # # u# v# # % % % % &