Index
D
Datagenerating XML from SQL, 190–199, 199–206
protecting in Oracle XML DB Repository, 248–250
Data fetching, 202–203
Data loading, XML, 168–171
Data-retrieval application, building XML, 451–462
building cppextract application, 452–459
designing framework, 452
extending framework, 460–462
running cppextract application, 459–460
Data, retrieving XML, 476–478
Data, searching XML, 155, 219–240
best practices, 239–240
full text searching, 230–238
XPath-based searches, 220–229
Data, storing XML, 150–154, 157–188
best practices, 185–187
external tables, 184–185
schema evolution, 185
storing XML documents in CLOB XMLTypes, 158–159
storing XML documents in relational tables, 176–184
storing XML documents in XML schema-based XMLTypes, 159–176
Data, updating with XSQL Servlet, 122–125
Data, XML documents as object-relational, 77,78
Database and standards, XML, 148–149
Database connection, setting up, 261–264
Database design decisions for XML, 522–526
Database mappings, supported, 76–78
Database OCI applications, building XML, 393–408
designing framework, 394–395
initializing OCI application, 398–401
performing unified DOM operations, 406–407
retrieving DOM of record list via OCI, 401–405
running xmlupdate application, 407–408
setting up OCI application environment, 395–397
update application, 397–398
Database OCI C++ application, building XML, 433–450
Database schemascreating, 317–321
installing sample, 137–138
mapping DTDs to, 75–76
mapping XML documents to, 12–14,76
setting up, 482–485
and XML documents, 11–14
Database servers, building web services in, 497–498
Database user, creating, 272
Database web service, publishing first, 482–492
calling web service from clients, 489–491
debugging web service, 491–492
Oracle JDeveloper 10g, 485–489
publishing PL/SQL web service, 485–489
setting up database schemas, 482–485
Database XML application, initializing C++, 438–439
Databasesconnecting FAQ web sites to XML, 274–277
connecting to, 440–441
consuming web services within Oracle, 492–497
designing XML, 149, 155–156
disconnecting from, 441–442
installing Oracle XML, 133–137
Oracle XML, 140–148
querying XML in, 92–93
using SOAP and Oracle, 100–103
XML and, 11
XML support in Oracle, 130–132
XQuery and Oracle, 92–93
XSLT and, 61
Databases, creating FAQ, 269–274
creating database user, 272
designing FAQ schema, 269–271
loading FAQs, 273–274
registering FAQ schema, 272–273
Databases, Oracle XML, 129–156, 241–251
designing XML databases, 149–156
installed Oracle XML DB components, 242–244
Oracle XML database, 140–148
security management, 248–251
setting up Oracle XML databases, 132–140
XML database and standards, 148–149
XML support in Oracle databases, 130–132
Databases, setting up Oracle XML, 132–140
creating users to run XMLType samples, 138
installing Oracle XML databases, 133–137
installing sample database schemas, 137–138
setting up WebDAV folders, 138–140
Databases, XML document models and, 75–78
mapping DTDs to database schemas, 75–76
mapping XML documents to database schemas, 76
supported database mappings, 76–78
Datatypessimple and complex, 68–73
XML schema built-in, 69–70
DB components, installed Oracle XML, 242–244
DB, configuring Oracle XML, 244–248
DB RepositoryOracle XML, 147, 154, 173–176
protecting data in Oracle XML, 248–250
DB Repository interfaces, Oracle XML, 170
DBAccess bean, 111–113
DBMS_XMLSTORE, 182–184
DBM_XMLGEN, 199–206
DBUri operations, securing, 250–251
DebuggingJava stored procedures, 516–517
web services, 491–492
DecisionsC, 524–526
C++, 524–526
database design, 522–526
Java, 524–526
PL/SQL, 524–526
XML processing tier, 521–522
Definitions, displaying glossary, 286–287
Design decisions, database, 522–526
Designingelement and attribute names, 80
schemas, 79
XML databases, 149–156
XML databases for messaging applications, 155–156
XML databases for Web applications,155
Development environmentC XML, 367–374
C++ XML, 423–430
DisplayingFAQ and answers, 280–283
glossary definitions, 286–287
Document fragments, appending XML, 215–216
Document() function in XSLT, 62
Document models and databases, XML, 75–78
Document Object Model (DOM), 16
Document pruning, XML, 460–461
Document, searching XML, 221–224
Documentscutting and pasting across, 48
database schema and XML, 11–14
dividing XML, 180–182
inserting XML, 122
mapping XML, 12–14, 76
parsing and binding XML, 16–17
processing invalid, 360, 362
processing invalid XML, 361
processing that are valid against remote schema, 361
storing XML, 159–176, 176–184
valid XML, 8–9
well-formed XML, 7–8
XML, 4–7, 78
XML documents as fragment, 78
Documents, querying XML, 91
querying XML from command line,91
querying XML with XQueryX, 91
running in interactive mode, 91
DOM (Document Object Model), 16
accessing XML using, 17–27
accessing XML with, 15
retrieving of record list via OCI, 401–405
SAX vs., 108
DOM APIs, 19–22
DOM APIs in C, Oracle, 27
DOM editing, 213–216
appending XML document fragments, 215–216
operating on XMLType DOM, 213–215
DOM Level 2, 22–25
DOM Level 3, 25–27
DOM, operating on XMLType, 213–215
DOM operations, performing unified, 406–407
DOM, processing XML using, 474–478
dealing with namespaces, 475–476
retrieving XML data using XPath, 476–478
DOM specifications, W3C, 531
DOMBuilder bean, 109–111
DTD caching, 47
DTDs (Document Type Definitions), 5, 64,186
introducing, 64–66
loading external, 80–81
mapping to database schemas, 75–76
parsing with, 474
DTDs, validating XML against, 66–68
DTDs, validating XML with, 63–81
best practices, 79–81
introducing DTDs, 64–66
simple and complex data types, 68–73
validating XML against DTDs, 66–68
XML document models and databases, 75–78
Dvdcatalog.dtd, 378
Dynamic areas, creating, 293–300