S

sample database
discussed, 427
logical relationship, 428
object model, 430
physical relationship, 429
Saxon program , 297299
scalability, XML advantages , 3
scalar expression , 146
schema, XSD
annotations, 193195
cardinality, 373374
complex data types, 378379
custom data types, 375
date data types, 372373
defined, 434
discussed, 167, 351
end of chapter exercise, 223, 380
global type, 370
hierarchical relational database table structure example, 191192
list elements, 377378
local type, 370
mapping to tables, 192193
miscellaneous data types, 373
numeric data types, 372
restriction data types, 376377
sequencing, 374375
simple data types, 376
simple type facets, 376
storing as schema collection, 195199
string data types, 371372
structures, 371
substitution, 379380
time data types, 372373
union list declarations, 378
scripts, end of chapter exercise , 28 , 55
secondary XML indexes , 200201
select attribute
xsl:apply--template element, 64
xsl:for--each element, 71
SELECT statement
alias in, 92
defined, 88
EXTRACT method, 140
FOR XML clause, 169170
FROM clause, 89
GROUP BY clause, 102104
ORDER BY clause
AS clause in, 101102
functionality, 100
WHERE clause and, 102
Try It Out exercise, 116118
UNION clause, 115
WHERE clause, 9295
self joins , 108
self--describing data , 246
semantic conflict, namespaces , 25
sequencing
functions, XPath scripting language, 288289
XSD, 374375
shared components , XQuery language , 296
short data type, 372
sibling node, XQuery language , 303
side tables, index values , 259
simple attribute, XLink, 321
simple data types, XSD , 376
Simple Object Access Protocol . See SOAP
simple type facets , 376
single quote (˜) , 93
single root node, syntax rules , 13
size , index , 200
SOAP (Simple Object Access Protocol)
body section, 211
defined, 433
discussed, 209
document transfers, 210214
end of chapter exercise, 222223
envelope section, 211
function interpretation, 214
header section, 211
message creation, 215218
namespaces, 211213
uses for, 210, 219
sorting order
index, 200, 258
subqueries, 114
table records, 100
XMLAGG method example, 139
xsl: sort element, 74
space characters
element naming rules, 17
removal, 138
specializations, object model , 232
SQL Server database
data type storage limitation, 186
documents, adding, 185186
downloading, 165
end of chapter exercise, 202203
OPENXML function, 183184
XML data types
documents, adding to server, 185186
exist() method, 169, 189
indexes, creating, 199201
modify() method, 169, 190
modifying, 186190
nodes() method, 169
pattern matching expressions, 187
query() method, 168, 186
retrieving, 186190
string patterns, searching, 186
table containing, 168
typed, 166167
untyped, 166167
uses for, 167
value() method, 169, 189
SQL (Structured Query Language)
defined, 87
end of chapter exercise, 129130
functionality, 88
precedence in, 9598
SELECT statement
alias in, 92
defined, 88
EXTRACT method, 140
FOR XML clause, 169170
FROM clause, 89
GROUP BY clause, 102104
ORDER BY clause, 100102
Try It Out exercise, 116118
UNION clause, 115
WHERE clause, 9295
SQL/XML standard
duplicated records, 142
file size considerations, 143
GROUP BY clause, 144
highlighted name example, 137
methods , list of, 135
multiple fields, 141
nested tables, 145
relational structure form, 140
root tag, 145
sorting order example, 139
tag creation, 136
white space removal, 138
XML document creation
discussed, 122
multiple--layer document, 125126
program control, 127
pseudocode, 127128
root tag, 123
two--dimensional structure, 123124
sql2000server web server , 82
src attribute
<IMG> tag, 8
<XML> tag, 7
static data , 13
storage
document creation, 153154
in NXD, 261
performance issues, 382383
string data types, XSD , 371372
strings
functions, XPath scripting language, 285
patterns, searching, 186
verification, EXISTSNODE method, 156
structural indexes , 259
structural validation, DTD , 1213
Structured Query Language . See SQL ; SQL Server database
structures, XSD , 371
style sheets
CSS (cascading style sheets), 4
references, syntax rules, 13
XSL (Extensible Style Sheets)
B2B (Business--2--Business) transfers, 220
control structure elements, 7074
data retrieval elements, 6970
defined, 3, 58, 434
DOM combined with, 8284
element functionality, 59
end of chapter exercise, 8587
function syntax, 77
functions versus method, 7677
method syntax, 81
node creation elements, 6669
pattern matching syntax, 81
processing instruction elements, 6061
transformation elements, 6165
Try It Out exercise, 7880
XSLT (Extensible Style Sheet Language Transformations), 58, 265, 434
subprograms, XMLType data type , 132
subqueries
AS clause in, 114115
correlated, 112
defined, 88, 110
embedding multiple layers , 111113
INSERT command, 120
nested, 110
record changes, 114115
sorting order, 114
UPDATE command, 120
uses for, 111
values returned by, 112
substitution , 379380
subtraction XPath numeric operator , 284
summarized records, table queries , 102104
syntax
Backus--Naur Form notation, 431432
case sensitivity rules, 14
comment rules, 17
element attributes, 1415
ending root tag rules, 13
opening and closing tag rules, 14
pattern matching, 81
root node rules, 13
rules, 1317
style sheet rules, 13
Try It Out exercise, 2223
XQuery language, 303
XSL method, 81
system--property function, 77
SYS_XMLGEN function, 146


Beginning XML Databases
Beginning XML Databases (Wrox Beginning Guides)
ISBN: 0471791202
EAN: 2147483647
Year: 2006
Pages: 183
Authors: Gavin Powell

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net