Data
generating 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 schemas
creating, 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
Databases
connecting FAQ web sites to XML, 274–277
connecting to, 440–441
consuming web services within Oracle, 492–497
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
Datatypes
simple and complex, 68–73
XML schema built-in, 69–70
DB components, installed Oracle XML, 242–244
DB, configuring Oracle XML, 244–248
DB Repository
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
Debugging
Java stored procedures, 516–517
web services, 491–492
Decisions
C, 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
Designing
element and attribute names, 80
schemas, 79
XML databases, 149–156
XML databases for messaging applications, 155–156
XML databases for Web applications,155
Development environment
C XML, 367–374
C++ XML, 423–430
Displaying
FAQ 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
Documents
cutting and pasting across, 48
database schema and XML, 11–14
dividing XML, 180–182
inserting XML, 122
parsing and binding XML, 16–17
processing invalid XML, 361
processing that are valid against remote schema, 361
valid XML, 8–9
well-formed XML, 7–8
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