Index

A B C D E F G H I J L M N O P Q R S T U V W X

A

access control entry (ACE)

definition, 27.1.3

access control list (ACL)

child

definition, 27.4.4

constraining inheritance

definition, 27.4.4

definition, 27.1.4

extending inheritance

definition, 27.4.4

overview, 1.2.3.1

parent

definition, 27.4.4

system, 27.4.1

account XDB, 2.1, 3.18.1, 3.18.7.1, 25.6, 26.2, 27.4, 36.6.1, 36.6.1

ACE

See access control entry

ACL

See access control list

ACLOID resource property

definition, 27.4

administering Oracle XML DB, 34

Advanced Queuing (AQ)

IDAP, 37.4

messaging scenarios, 37.1.1

point-to-point support, 37

publish/subscribe support, 37

XMLType queue payloads, 37.5.1

aggregate privilege

definition, 27.1.2

annotations

XML schema, 3.7.3, 7.9

querying to obtain, 7.10

anonymous user, access to repository, 28.2.1

appendChildXML SQL function, 4.2.11

atomic privilege

definition, 27.1.2

attribute XML Schema data types

mapping to SQL, 7.12.2

attributes

Container, 21.3.2

xdb:columnProps, 7.9.3

xdb:defaultSchema, 7.3.7

xdb:defaultTable, 7.9.1, 7.9.3

xdb:defaultTableSchema, 7.9.3

xdb:maintainDOM, 7.6.2, 7.9.1, 7.9.3, 7.9.3

xdb:maintainOrder, 7.9.3

xdb:mapUnboundedStringToLob, 7.9.3

xdb:maxOccurs, 7.9.3

xdb:SQLCollSchema, 7.9.3

xdb:SQLCollType, 7.9.1, 7.9.3

xdb:SQLInline, 7.9.3, 9.3, 9.3

xdb:SQLName, 7.9.1, 7.9.3

xdb:SQLSchema, 7.9.3, 7.9.3

xdb:SQLType, 7.9.1, 7.9.3, 7.9.3, 9.7

xdb:srclang, 7.9.3

xdb:storeVarrayAsTable, 7.9.1, 7.9.3

xdb:tableProps, 7.9.3

xdb:translate, 7.9.3

xsi:noNamespaceSchemaLocation, 7.1, 19.3.1.1

authenticatedUser role

DBuri servlet security, 20.9.3

B

backward-compatible XML schema evolution

definition, 10.3.1

binary XML

definition, 1.3.3

Schema data types

mapping to SQL, 7.12.4

bootstrap ACL

definition, 27.4.1

B-tree index, 1.3.3

C

C API for XML, 16

CharacterData interface, 13.2.10

CheckIn event, repository, 30.2

CheckOut event, repository, 30.2

child ACL

definition, 27.4.4

circular dependencies

XML schemas, 9.9

CLASSPATH Java variable

setting, 31.3.1

CLOB storage of XML data

definition, 1.3.3

closeContext PL/SQL procedure, 14.2

collection

in out-of-line tables, 9.4

loading and retrieving large documents, 9.11

XML

definition, 7.8.1.3

collection attribute (SQL), 7.12.5

columnProps attribute, 7.9.3

complex XLink link

definition, 23.2.2

D

database role

definition, 27.1.1, 27.1.1, 27.1.1

database user

definition, 27.1.1

data-centric use of XML data

definition, 1.3.3

date and time XML Schema data types

mapping to SQL, 7.12.4

DAV: WebDAV namespace, 27.3

DBMS_METADATA PL/SQL package, 20.3.1

reference documentation, 1.2.1, 1.2.1

DBMS_XDB PL/SQL package, 26.1

reference documentation, 1.2.1, 1.2.1

DBMS_XDB_ADMIN PL/SQL package

reference documentation, 1.2.1

DBMS_XDB_VERSION PL/SQL package, 24

reference documentation, 1.2.1

DBMS_XDBT PL/SQL package, 1.2.1

DBMS_XDBZ PL/SQL package, 29.7

disable_hierarchy procedure, 27.7.1

enable_hierarchy procedure, 27.7

is_hierarchy_enabled function, 29.7

purgeLDAPCache procedure, 27.6

reference documentation, 1.2.1

DBMS_XEVENT PL/SQL package

reference documentation, 1.2.1

DBMS_XMLDOM PL/SQL package, 13.2

examples, 13.2.12

reference documentation, 1.2.1

DBMS_XMLGEN PL/SQL package, 18.3

reference documentation, 1.2.1

DBMS_XMLINDEX PL/SQL package

modifyParameter procedure, 6.4.17.1

reference documentation, 1.2.1

registerParameter procedure, 6.4.17.1

DBMS_XMLPARSER PL/SQL package, 13.3

reference documentation, 1.2.1

DBMS_XMLQUERY PL/SQL package

Oracle Java Virtual Machine dependency, B

DBMS_XMLSAVE PL/SQL package, 14.1

Oracle Java Virtual Machine dependency, B

DBMS_XMLSCHEMA PL/SQL package, 7.3

copyEvolve procedure, 10

deleteSchema procedure, 7.3.12

generateSchema and generateSchemas functions, 9.1

inPlaceEvolve procedure, 10

mapping types, 7.12

purgeSchema procedure, 7.3.12.1

reference documentation, 1.2.1

registerSchema procedure, 7.3.1, 9.10.3

enableHierarchy parameter, 29.2

DBMS_XMLSTORE PL/SQL package, 14

reference documentation, 1.2.1

DBMS_XSLPROCESSOR PL/SQL package, 13.4

reference documentation, 1.2.1

DBUri

definition, 20.3

generating using sys_DburiGen SQL function, 20.8

identifying a row, 20.6.4.2

identifying a target column, 20.6.4.3

retrieving column text value, 20.6.4.4

retrieving the whole table, 20.6.4

security, 20.9.3

servlet, installation, 20.9.2

DBUri-refs, 20.6

HTTP access, 20.9

DBUriServlet

definition, 20.9

DBURIType

definition, 20.3

debugging

XML schema registration, 7.3.6

default tables

creating during XML schema registration, 7.3.8

defaultSchema attribute, 7.3.7

defaultTable attribute, 7.9.1, 7.9.3

defaultTableSchema attribute, 7.9.3

definition, 10.3.1

Delete event, repository, 30.2

deleteSchema PL/SQL procedure, 7.3.12

deleteXML PL/SQL function, 14.1

deleteXML SQL function, 4.2.12

deleting

resource, 25.3.2

XML schema using DBMS_XMLSCHEMA, 7.3.12

depth SQL function, 25.2.4

derived XML Schema data types

mapping to SQL, 7.12.4

E

effective text value of a node

definition, 6.4.4.2

element XML Schema data types

mapping to SQL, 7.12.3

elements

Contents, Resource index, 21.3

XDBBinary, 21.4.1.3

enable_hierarchy PL/SQL procedure, 27.7, 27.7

enableHierarchy parameter, DBMS_XMLSCHEMA.registerSchema, 29.2

Enterprise Manager

administering Oracle XML DB, 34.3

entities, XML

using a DTD with binary XML storage, 7.2

equals_path SQL function, 5.10.5.1, 25.2.2

equipartitioning of XMLType tables

definition, 9.5

event

repository, 30

configuring, 30.5

predefined, 30.2

event handler, repository

definition, 30.1.3

event listener, repository

definition, 30.1.3

evolution, XML schema, 10

existsNode Oracle SQL function (deprecated), Preface

extended XLink link

definition, 23.2.2

extending inheritance, ACLs

definition, 27.4.4

extract Oracle SQL function (deprecated), Preface

extracting data from XML, 4.1.3

extractValue Oracle SQL function (deprecated), Preface

F

fidelity

DOM, 7.6

for XML schema mapping, 13.2.5.1

SYS_XDBPD$ object attribute, 7.6.2

using SQL function updateXML, 4.2.3.3

FLWOR XQuery expression, 5.2.3

fn:available

support, 5.14.2.1

fn:collection

avoiding to improve performance, 5.10.5

support, 5.14.2

fn:doc

avoiding to improve performance, 5.10.5

support, 5.14.2

fn:id

support, 5.14.2

fn:idref

support, 5.14.2

fn:matches

support, 5.14.2

fn:replace

support, 5.14.2

fn:tokenize

support, 5.14.2

folder

definition, 21.2.1, 21.2.1

folder link

definition, 21.3.3.1

folder sys, repository, 21.1

foldering, 21.1

folder-restricted query

definition, 3.18.13.2

fragment, XML

definition, 3.11.6

SQL operations on, 3.11.6

fragments, XML

mapping to LOBs, 9.7

freeDocument PL/SQL procedure, 13.2.12

freeing a DOMdocument instance, 13.2.12

FROM list order

XMLTable PASSING clause, 5.9.4

FTP

configuration parameters, 28.2.1

creating default tables, 7.3.8

protocol server, features, 28.3

fully qualified XML schema URLs, 9.6

functional evaluation

definition, 3.15

function-based index, 6.2.4.1

functions

PL/SQL

createResource, 3.4.6

deleteXML, 14.1

generateSchema and generateSchemas, 9.1

insertXML, 14.1

is_hierarchy_enabled, 29.7

updateXML, 14.1

SQL

appendChildXML, 4.2.11

contains, 6.2.2

deleteXML, 4.2.12

depth, 25.2.4

equals_path, 5.10.5.1, 25.2.2

existsNode (deprecated), Preface

extract (deprecated), Preface

extractValue (deprecated), Preface

insertChildXML, 4.2.6

insertChildXMLafter, 4.2.8

insertChildXMLbefore, 4.2.7

insertXMLafter, 4.2.10

insertXMLbefore, 4.2.9

path, 25.2.3

sys_DburiGen, 20.8

sys_XMLAgg, 18.5

sys_XMLGen, 18.4

under_path, 25.2.1

updateXML, 4.2.3

updating XML data, 4.2

XMLAgg, 18.2.4

XMLAttributes, 18.2.1

XMLCast, 4.1.2.2

XMLCDATA, 18.2.11

XMLColAttVal, 18.2.10

XMLComment, 18.2.6

XMLConcat, 18.2.3

XMLElement, 18.2.1

XMLExists, 4.1.2.1

XMLForest, 18.2.2

XMLIsValid, 3.9.1.2.1, 11.3

XMLParse, 18.2.8

XMLPI, 18.2.5

XMLQuery, 5.3, 5.3.1

XMLRoot, 18.2.9

XMLSequence (deprecated), Preface

XMLSerialize, 18.2.7

XMLTable, 5.3, 5.3.2

XMLtransform, 11.1.1

XPath

ora:instanceof (deprecated), Preface

ora:instanceof-only (deprecated), Preface, Preface

G

gatherRepositoryStats PL/SQL procedure, 26.2

generateSchema and generateSchemas PL/SQL functions, 9.1

generating XML, 18

DBMS_XMLGEN PL/SQL package, 18.3

DBMS_XMLSCHEMA PL/SQL package, 9.1

generateSchema and generateSchemas PL/SQL functions, 9.1

SQL functions, 18.1

sys_XMLAgg SQL function, 18.5

sys_XMLGen SQL function, 18.4

XML schemas, 9.1

XMLAgg SQL function, 18.2.4

XMLAttributes SQL function, 18.2.1

XMLCDATA SQL function, 18.2.11

XMLColAttVal SQL function, 18.2.10

XMLComment SQL function, 18.2.6

XMLConcat SQL function, 18.2.3

XMLElement SQL function, 18.2.1

XMLForest SQL function, 18.2.2

XMLParse SQL function, 18.2.8

XMLPI SQL function, 18.2.5

XMLRoot SQL function, 18.2.9

XMLSerialize SQL function, 18.2.7

getBLOBVal() Oracle XMLType method (deprecated), Preface

getCLOB() XMLType method, 15.3

getCLOBVal() Oracle XMLType method (deprecated), Preface

getNamespace() Oracle XMLType method (deprecated), Preface

getNumberVal() XMLType method, 4.1.1

getObject() XMLType method, 15.2.1.2

getOPAQUE() XMLType method, 15.2.1.2

getRootElement() Oracle XMLType method (deprecated), Preface

getSchemaURL() XMLType method, 7.4

getStringVal() Oracle XMLType method (deprecated), Preface

getting JCR repository objects, 31.3.2

global XML schema

definition, 7.5.2

using fully qualified URL to override, 9.6

grants declared in an ACL

definition, 27.4.4

grants defined for an ACL

definition, 27.4.4

group in an XMLIndex structured component

definition, 6.4.7

H

hard link

definition, 21.3.3.2

JCR, 31.2.6

hierarchical repository index, 3.18.14

hierarchy-enabled table

definition, 27.7

HTTP

access for DBUri-refs, 20.9

accessing Java servlet or XMLType, 32.2.1

accessing repository resources, 21.4.1.2

configuration parameters, WebDAV, 28.2.1

creating default tables, 7.3.8

improved performance, 28.1.1

Oracle XML DB servlets, 32.5

protocol server, features, 28.4

requests, 32.5

servlets, 32.3

URIFACTORY, 20.9.4

using UriRefs to store pointers, 20.3

HTTPUri

definition, 20.3

HTTPURIType

definition, 20.3

hybrid columnar compression, B

hybrid storage

definition, 6.2.1

hybrid storage of XML data

definition, 1.3.3

I

IDAP

architecture, 37.5

transmitted over Internet, 37.4

IMPORT/EXPORT

in XML DB, 36.6

index

hierarchical repository, 3.18.14

indexing

CTXCAT, 12.4.5.1

CTXRULE, 12.4.5.1

function-based, 6.2.4.1

options for XMLType, 3.1.2

Oracle Text, 1.4.4, 6.5, 12

XMLType, 6.2

index-organized tables, 3.7.4

inheritance

XML schema, restrictions in complexTypes, 9.8.1

in-place XML schema evolution, 10.3

inPlaceEvolve PL/SQL procedure, 10

insertChildXML SQL function, 4.2.6

insertChildXMLafter SQL function, 4.2.8

insertChildXMLbefore SQL function, 4.2.7

insertXML PL/SQL function, 14.1

insertXML() XMLType method, 15.3

insertXMLafter SQL function, 4.2.10

insertXMLbefore SQL function, 4.2.9

installing Oracle XML DB, 34.1

instance document

definition, 1.3.2

specifying root element namespace, 7.1

Internet Data Access Presentation (IDAP)

SOAP specification for AQ, 37.4

Internet Protocol Version 6

FTP, 28.3.1.6

HTTP(S), 28.4.1.4

IPv6

FTP, 28.3.1.6

HTTP(S), 28.4.1.4

is_hierarchy_enabled PL/SQL function, 29.7

isSchemaBased() XMLType method, 7.4

IsSchemaValid() XMLType method, 11.3

isSchemaValid() XMLType method, 7.4

isSchemaValidated() XMLType method, 7.4, 11.3

J

Java

connections, thick and thin, 15.4

DOM API for XMLType, 15.1

Oracle XML DB applications, 32.1

oracle.xml.parser.v2, 15.1

Java Content Repository API

See JCR

JCR

compliance levels supported, 31.3.6

document view serialization

definition, 31.2.3

files and folders, exposure, 31.2.1

getPath() Java method, 31.2.6

hard link, 31.2.6

logging, 31.3.5

Oracle XML DB Repository access, 31.2

overview, 31.1.1

restrictions for Oracle XML DB Content Connector, 31.3.7

weak link, 31.2.6

XML schema, 31.4

JCR node types

mapping from XML Schema data types, 31.4.3

mapping from XML Schema global element declarations, 31.4.3.4

nt:file, 31.2

nt:folder, 31.2

Oracle extensions, 31.2.2

jcr:content, 31.2.5

jcr:data property, 31.2.3

JDBC

accessing XML documents, 15.2.1.2

drivers, OCI and thin, 15.2.2

loading large XML documents, 15.3

manipulating XML documents, 15.2.2

JSR-170

See JCR 1.0

L

large node handling, 13.2.13

lazy XML loading (lazy manifestation), 13.1.1.1

link

document

definition, 21.3.3.1

folder

definition, 21.3.3.1

hard

definition, 21.3.3.2

repository

definition, 21.3.3.1

weak

definition, 21.3.3.2

link name

definition, 21.2.1

LinkIn event, repository, 30.2

linking, repository

definition, 3.18.13.1

link-properties document

definition, 3.18.13.1

LinkTo event, repository, 30.2

large documents with collections, 9.11

loading large XML documents using JDBC, 15.3

loading of XML data, lazy, 13.1.1.1

LOB locator, 24.4

LOBs

mapping XML fragments to, 9.7

local XML schema

definition, 7.5.1

using fully qualified URL to specify, 9.6

Lock event, repository, 30.2

M

maintainDOM attribute, 7.6.2, 7.9.1, 7.9.3, 7.9.3

maintainOrder attribute, 7.9.3

manifestation, lazy, 13.1.1.1

mapping

complexType any and anyAttributes declarations, 9.8.3

complexType to SQL

out-of-line storage, 9.3

overriding using SQLType attribute, 7.12.3.1

simpleContent to object types, 9.8.2

mapping XML Schema complexType data types to SQL, 7.12.5

mapping XML Schema data types to SQL data types, 7.12

mapping XML Schema to SQL

simpleType, 7.12.4

mapUnboundedStringToLob attribute, 7.9.3

matches XQuery function (Oracle), 5.7.2

maxOccurs attribute, 7.9.3

metadata

definition, 29.1

system-defined

definition, 1.2.3

user-defined

definition, 1.2.3

methods

XMLType

createXML(), 13.1.1.3, 15.2.1

getBLOBVal() (deprecated), Preface

getCLOB(), 15.3

getCLOBVal() (deprecated), Preface

getNamespace() (deprecated), Preface

getNumberVal(), 4.1.1

getObject(), 15.2.1.2

getOPAQUE(), 15.2.1.2

getRootElement() (deprecated), Preface

getSchemaURL(), 7.4

getStringVal() (deprecated), Preface

insertXML(), 15.3

isSchemaBased(), 7.4

IsSchemaValid(), 11.3

isSchemaValid(), 7.4

isSchemaValidated(), 7.4, 11.3

schemaValidate(), 7.4

setObject(), 15.2.2

setSchemaValidated(), 7.4, 11.3

writeToStream(), 21.4.1.5

XML schema, 7.4

MIME

overriding with DBUri servlet, 20.9.1

mix:referenceable, 31.2.3

mixed XML content

definition, 1.3.3

model, XML Schema

definition, 10.3.1.1.4

modifyParameter PL/SQL procedure, 6.4.17.1

N

NamedNodeMap object (DOM), 13.2.10

namespace

prefixes

ocjr, 31.2.2

URL for XML schema, 7.1

XQuery, 5.5, 5.9.5

naming SQL objects, 7.9

navigational access to repository resources, 21.4

nested XML

generating using DBMS_XMLGEN, 18.3.3

generating with XMLElement, 18.2.1.3

NESTED_TABLE_ID pseudocolumn, 3.7.7

newDOMDocument() function, 13.2.9

NodeList object (DOM), 13.2.10

nodes, large (DBMS_XMLDOM), 13.2.13

nodes, large (Java), 15.6

noNamespaceSchemaLocation attribute, 7.1, 19.3.1.1

non-schema-based view

definition, 19.1

nt:file JCR node type, 31.2

nt:folder, 31.2

nt:folder JCR node type, 31.2

numeric XML Schema data types

mapping to SQL, 7.12.4

O

object attributes

for collection (SQL), 7.12.5

of XMLFormat, 18.4.2

REF, 9.3, 9.9.2

sys_DburiGen SQL function

passing to, 20.8.1

SYS_XDBPD$, 7.6.2

XMLType, in AQ, 37.5.1

object identifier

definition, 27.4

OBJECT_ID column of XDB$ACL table, 27.4

object-based persistence of XML data

definition, 1.3.3

object-relational storage of XML data

definition, 1.3.3

occurrence indicator

definition, 5.2.2

OCI API for XML, 16

ocjr namespace prefix, 31.2.2

OCT

definition, 3.7.4

ODP.NET, 17

OID

See object identifier

ojcr:folder, 31.2.3

operator

See functions, SQL

optimizer hints

COST_XML_QUERY_REWRITE, 5.10.1

optimizing repository queries, 26.2

ora:contains XPath function (Oracle), 12.5

policy

definition, 12.5.4

ora:defaultTable XQuery pragma, 5.8, 5.10.5.2

ora:instanceof Oracle XPath function (deprecated), Preface

ora:instanceof-only Oracle XPath function (deprecated), Preface, Preface

ora:invalid_path XQuery pragma, 5.8

ora:matches XQuery function (Oracle), 5.7.2

ora:replace XQuery function (Oracle), 5.7.3

ora:sqrt XQuery function (Oracle), 5.7.4

ora:tokenize XQuery function (Oracle), 5.7.5

ora:view_on_null XQuery pragma, 5.8

ora:xq_proc XQuery pragma, 5.8, 6.4.9

ora:xq_qry XQuery pragma, 5.8

Oracle ASM files

accessing, 21.4.2

using FTP, 28.3.1.4

Oracle ASM virtual folder, 21.3.1.3

Oracle Data Provider for .NET, 17

Oracle Enterprise Manager

administering Oracle XML DB, 34.3

Oracle extensions to JCR node types, 31.2.2

Oracle Internet Directory, 27.8

Oracle Net Services, 1.2

Oracle Text

contains SQL function and XMLType, 6.2.2

index, 1.4.4, 6.5, 12

searching for resources, 25.6

searching XML in CLOB instances, 1.4.4

Oracle XML DB

access models, 2.3.2

advanced queuing, 1.4.4

architecture, 1.2

features, 1.3

installation, 34.1

Java applications, 32.1

overview, 1.1

Repository

See repository

upgrading, 34.2

versioning, 24

when to use, 2.2

Oracle XML DB Content Connector, 31

how to use, 31.3

logging API, 31.3.5

overview, 31.1.2

restrictions, 31.3.7

sample code to upload file, 31.3.3

P

parent ACL

definition, 27.4.4

partial update of XML data

definition, 4.2.2

partial validation of XML data

definition, 3.9.1.1

partitioning XMLType tables, 9.5

binary XML, 3.3

PASSING clause of XMLTable

FROM list order, 5.9.4

path component of a resource path name

definition, 21.2.1

path index of XMLIndex

definition, 6.4.4

path name

definition, 21.2.1

resolution, 21.3.2

path SQL function, 25.2.3

path table of XMLIndex, 6.4.4

PATH_VIEW, 25

path-based access to repository resources, 21.4

path-index trigger

definition, 27.7

PD (positional descriptor), 7.6.2

persistence models for XML data, 1.3.3

PL/SQL functions

See functions, PL/SQL

PL/SQL packages

DBMS_METADATA, 20.3.1

reference documentation, 1.2.1, 1.2.1

DBMS_XDB, 26.1

reference documentation, 1.2.1, 1.2.1

DBMS_XDB_ADMIN

reference documentation, 1.2.1

DBMS_XDB_VERSION, 24

reference documentation, 1.2.1

DBMS_XDBT, 1.2.1

DBMS_XDBZ, 27.7, 29.7

reference documentation, 1.2.1

DBMS_XEVENT

reference documentation, 1.2.1

DBMS_XMLDOM, 13.2

reference documentation, 1.2.1

DBMS_XMLGEN, 18.3

reference documentation, 1.2.1

DBMS_XMLINDEX

reference documentation, 1.2.1

DBMS_XMLPARSER, 13.3

reference documentation, 1.2.1

DBMS_XMLQUERY

Oracle Java Virtual Machine dependency, B

DBMS_XMLSAVE, 14.1

Oracle Java Virtual Machine dependency, B

DBMS_XMLSCHEMA

reference documentation, 1.2.1

See DBMS_XMLSCHEMA PL/SQL package

DBMS_XMLSTORE, 14

reference documentation, 1.2.1

DBMS_XSLPROCESSOR, 13.4

reference documentation, 1.2.1

for XMLType, 13.1

PL/SQL procedures

See procedures, PL/SQL

point-to-point

support in AQ, 37

policy for ora:contains XPath function (Oracle)

definition, 12.5.4

ports

configuring

FTP, 28.2.1

HTTP, 28.2.1

HTTPS, 28.2.2

positional descriptor (PD), 7.6.2

post-parse persistence of XML data

definition, 1.3.3

pragmas

XQuery

Oracle, 5.8

predefined ACLs, 27.4.1

preference

Oracle Text indexing

definition, 12.4.5.1

pretty-printing, 18.2.7

in book examples, Preface

not done by SQL/XML functions, 3.16.1

Web service output, 33.3

primitive XML Schema data types

mapping to SQL, 7.12.4

principal

definition, 27.1.1, 27.1.1

private (local) XML schema, definition, 7.5

privilege

definition, 27.1.2

procedures

PL/SQL

closeContext, 14.2

copyEvolve, 10

disable_hierarchy, 27.7.1

enable_hierarchy, 27.7, 27.7

freeDocument, 13.2.12

gatherRepositoryStats, 26.2

inPlaceEvolve, 10

modifyParameter, 6.4.17.1

processXSL, 13.4.3

purgeLDAPCache, 27.6

registerParameter, 6.4.17.1

registerSchema, 7.3.1

setKeyColumn, 14.2

setUpdateColumn, 14.2

processXSL PL/SQL procedure, 13.4.3

protocol server, 28.1

architecture, 28.1.1

configuration parameters, 28.2.1

event-based logging, 28.2.5

FTP, 28.3

configuration parameters, 28.2.1

HTTP, 28.4

configuration parameters, 28.2.1

WebDAV, 28.5

configuration parameters, 28.2.1

protocols, access to repository resources, 21.4.1

public (global) XML schema, definition, 7.5

publish/subscribe

support in AQ, 37

purchase-order XML document

used in full-text examples, 12.7.1

purchase-order XML schema, 3.6.4.1

annotated, 3.7.5, A.6

graphical representation, 3.6.4.2

revised, 10.2.1, A.6

purgeLDAPCache PL/SQL procedure, 27.6

purgeSchema PL/SQL procedure, 7.3.12.1

Q

qualified XML schema URLs, 9.6

query-based access to resources

using RESOURCE_VIEW and PATH_VIEW, 25.1

using SQL, 21.5

querying XMLType data

choices, 4.1

transient data, 4.1.3

R

recursive schema support, 9.10

REF object attribute, 9.3, 9.9.2

REGISTER_NT_AS_IOT option for XML schema registration, 3.7.4, 3.7.4, 7.3.1

registered XML schemas, list of, 7.3.11

registering an XML schema, 7.3.1

debugging, 7.3.6

default tables, creating, 7.3.8

SQL object types, creating, 7.3.7

registering an XML schema for JCR, 31.4.1

registerParameter PL/SQL procedure, 6.4.17.1

registerSchema PL/SQL procedure, 7.3.1

renaming an XMLIndex index, 6.4.5

Render event, repository, 30.2

replace XQuery function (Oracle), 5.7.3

repository, 21.2

access by anonymous user, 28.2.1

access using JCR, 31.2

data storage, 21.3.1

event, 30

configuring, 30.5

predefined, 30.2

event handler

definition, 30.1.3

event listener

definition, 30.1.3

hierarchical index, 3.18.14

resource

See resource

use with XQuery, 5.9.2

repository link

definition, 21.3.3.1

repository objects, 31.3.2

RESID

definition, 24.2

resource

access, 21.1.1

using protocols, 28.2.3

definition, 1.2.3, 29.1

deleting, 21.3.3.2

nonempty container, 25.3.2.1

using DELETE, 25.3.2

managing with DBMS_XDB, 26.2, 34.5

required privileges for operations, 27.2

searching for, using Oracle Text, 25.6

setting property in ACLs, 27.5

simultaneous operations, 25.4

updating, 25.3.3

resource configuration file

definition, 22.1

resource configuration list

definition, 22.1

resource content

definition, 21.2.1

resource document

definition, 3.18.7.1

resource ID

definition, 24.2

resource name

definition, 21.2.1

resource version

definition, 24.1

RESOURCE_VIEW

explained, 25

resource-view-cache-size configuration parameter, 25.5

retrieving large documents with collections, 9.11

rewrite

XPath (XPath), 8

XQuery, 5.10

role

authenticatedUser, DBuri servlet, 20.9.3

database

definition, 27.1.1

XDB_SET_INVOKER, 30.5.1

XDBADMIN, 7.5.2, 22.1, 27.4.1, 30.5

root folder, repository, 21.1

root XML Schema

definition, 7.3.5

rule-based XML query rewrite

definition, 5.10.1

S

scalar value

converting to XML document using sys_XMLGen, 18.4.2

schema evolution

See XML schema evolution

schema for schemas (XML Schema)

definition, 1.3.2

schema location hint

definition, 3.7.6

schemaValidate() XMLType method, 7.4

searching CLOB instances, 1.4.4

security

DBUri, 20.9.3

semi-structured XML data

definition, 1.3.3

servlets

accessing repository data, 21.6

APIs, 32.8

configuring, 32.4

session pooling, 32.6, 32.6

writing, 32.9

in Java, 32.3

XML manipulation, 32.2.3

session pooling, 32.6

protocol server, 28.1.1

setKeyColumn PL/SQL procedure, 14.2

setObject() XMLType method, 15.2.2

setSchemaValidated() XMLType method, 7.4, 11.3

setUpdateColumn PL/SQL procedure, 14.2

simple XLink link

definition, 23.2.2

simpleContent

mapping to object types, 9.8.2

simpleType XML Schema data types

mapping to SQL, 7.12.4

SOAP, 33.1

access through Advanced Queuing, 1.2

IDAP, 37.4

SQL function

See functions, SQL

SQL functions

See functions, SQL

SQL object types

creating during XML schema registration, 7.3.7

SQL operator

See functions, SQL

SQL*Loader, 35.2

SQL*Plus

XQUERY command, 5.12

SQLCollSchema attribute, 7.9.3

SQLCollType attribute, 7.9.1, 7.9.3

SQLInline attribute, 7.9.3, 9.3, 9.3

SQLJ, 15.4.1.1

SQLName attribute, 7.9.1, 7.9.3

SQLSchema attribute, 7.9.3, 7.9.3

SQLType attribute, 7.9.1, 7.9.3, 7.9.3, 9.7

SQL/XML generation functions

definition, 1.3.5

SQL/XML publishing functions

definition, 1.3.5, 18.2

SQL/XML query and access functions

definition, 1.3.5

SQL/XML standard

generating XML data, 18.2

querying XML data

XMLExists and XMLCast, 4.1.2

XMLQuery and XMLTable, 5.3

sqrt XQuery function (Oracle), 5.7.4

srclang attribute, 7.9.3

standard metadata, 31.2.4

static type-checking

XQuery language, 5.11

storage

out of line, 9.3

collections, 9.4

XMLType, CREATE TABLE, 7.8.1.2

storage models for XMLType, 1.3.3

storeVarrayAsTable attribute, 7.9.1, 7.9.3

string XML Schema data types

mapping to SQL, 7.12.4

mapping to VARCHAR2 vs CLOB, 7.12.4.2

structured storage of XML data

definition, 1.3.3

structured XMLIndex component

definition, 6.4.2

style sheet for updating XML instance documents, 10.2.5

sys folder, repository, 21.1

sys_DburiGen SQL function, 20.8

inserting database references, 20.8.2

retrieving object URLs, 20.8.2.2, 20.8.2.2

use with text node test, 20.8.1

SYS_NC_ARRAY_INDEX$ column, 3.7.7

SYS_XDBPD$ object attribute, 7.6.2

sys_XMLAgg SQL function, 18.5

sys_XMLGen SQL function, 18.4

converting XMLType instances, 18.4.2

object views, 18.4.2

XMLFormat object attributes, 18.4.2

XMLGenFormatType object, 18.4.2

SYSAUX tablespace, 34.1.1

system ACL

definition, 27.4.1

system ACLs, 27.4.1

system-defined metadata

definition, 1.2.3

T

tableProps attribute, 7.9.3

tables

index-organized, 3.7.4

tablespace

SYSAUX, 34.1.1

text value of a node, effective

definition, 6.4.4.2

text-based persistence of XML data

definition, 1.3.3

third-party XLink link

definition, 23.2.2

tokenize XQuery function (Oracle), 5.7.5

translate attribute, 7.9.3

trigger, path-index

definition, 27.7

type-checking, static and dynamic

XQuery language, 5.11

U

UDT

generating an element from, 18.2.1.3

UncheckOut event, repository, 30.2

under_path SQL function, 25.2.1

uniform access control mechanism

definition, 27.7

unique constraint on parent element of an attribute, 9.2

UnLinkIn event, repository, 30.2

Unlock event, repository, 30.2

unresolved XLink and XInclude links, 23.7.1

unstructured storage of XML data

definition, 1.3.3

unstructured XMLIndex component

definition, 6.4.2

Update event, repository, 30.2

updateXML PL/SQL function, 14.1

updateXML SQL function, 4.2.3

mapping NULL values, 4.2.3.1

updating repository resource, 25.3.3

updating XML data

partial update

definition, 4.2.2

updating same node more than once, 4.2.3.2

using SQL functions, 4.2

optimization, 4.2.4

upgrading Oracle XML DB, 34.2

URIFACTORY PL/SQL package

configuring to handle DBURI-ref, 20.9.4

creating subtypes of URIType, 20.7

Uri-reference

database and session, 20.6.3

DBUri-ref, 20.6

HTTP access for DBUri-ref, 20.9

URIFACTORY PL/SQL package, 20.7

URIType examples, 20.4

URIType

examples, 20.4

user

definition, 27.1.1

user XDB, 2.1, 3.18.1, 3.18.7.1, 25.6, 26.2, 27.4, 36.6.1, 36.6.1

user-defined metadata, 31.2.5

definition, 1.2.3

V

validating

examples, 11.4

IsSchemaValid() XMLType method, 11.3

isSchemaValidated() XMLType method, 11.3

setSchemaValidated() XMLType method, 11.3

XMLIsValid SQL function, 11.3

use as CHECK constraint, 3.9.1.2.1

validation of XML data, partial

definition, 3.9.1.1

value index of XMLIndex

definition, 6.4.4

varray in a LOB

definition, 3.7.4

varray in a table

definition, 3.7.4

VCR

See version-controlled resource

version resource

definition, 24.1

version series of a resource

definition, 24.2

versionable resource

definition, 24.1

VersionControl event, repository, 30.2

version-controlled resource

definition, 24.1

versioning, 1.2.3.1, 24

views

RESOURCE and PATH, 25

W

weak link

definition, 21.3.3.2

deletion, 23.7.1

JCR, 31.2.6

Web service, 33.1

pretty-printing output, 33.3

WebDAV protocol server, 28.5

WebFolder

creating in Windows 2000, 28.5.3

well-formed XML document

definition, 3.9

writeToStream() XMLType method, 21.4.1.5

WSDL

Web service for accessing stored PL/SQL, 33.4

Web service for database queries, 33.3

X

XDB database schema (user account), 2.1, 3.18.1, 3.18.7.1, 25.6, 26.2, 27.4, 36.6.1, 36.6.1

xdb namespace, 27.3

XDB$ACL table, 27.4

xdb:columnProps attribute, 7.9.3

xdb:defaultSchema attribute, 7.3.7

xdb:defaultTable attribute, 7.9.1, 7.9.3

xdb:defaultTableSchema attribute, 7.9.3

xdb:maintainDOM attribute, 7.6.2, 7.9.1, 7.9.3, 7.9.3

xdb:maintainOrder attribute, 7.9.3

xdb:mapUnboundedStringToLob attribute, 7.9.3

xdb:maxOccurs attribute, 7.9.3

xdb:SQLCollSchema attribute, 7.9.3

xdb:SQLCollType attribute, 7.9.1, 7.9.3

xdb:SQLInline attribute, 7.9.3, 9.3, 9.3

xdb:SQLName attribute, 7.9.1, 7.9.3

xdb:SQLSchema attribute, 7.9.3, 7.9.3

xdb:SQLType attribute, 7.9.1, 7.9.3, 7.9.3, 9.7

xdb:srclang attribute, 7.9.3

xdb:storeVarrayAsTable attribute, 7.9.1, 7.9.3

xdb:tableProps attribute, 7.9.3

xdb:translate attribute, 7.9.3

XDB_SET_INVOKER role, 30.5.1

XDBADMIN role, 7.5.2, 22.1, 27.4.1, 27.4.1, 30.5

XDBBinary element, 21.4.1.3

definition, 21.2.1

xdbconfig.xml configuration file, 34.4

xdbcore parameters, 9.11.1

xdbcore-loadableunit-size configuration parameter, 9.11, 25.5

xdbcore-xobmem-bound configuration parameter, 9.11, 25.5

XDBUri, 20.3.1

definition, 20.3, 20.5

XDBURIType

definition, 20.3

using constructor to expand compound documents (XInclude), 23.5.1, 23.5.1

XInclude, 23, 23

definition, 23.1

unresolved link, 23.7.1

XLink, 23, 23

complex link

definition, 23.2.2

definition, 23.1

extended link

definition, 23.2.2

link types, 23.2.2

simple link

definition, 23.2.2

third-party link

definition, 23.2.2

unresolved link, 23.7.1

XML attributes

See attributes

XML diagnosability mode, 5.10.4

XML entities

using a DTD with binary XML storage, 7.2

XML fragment

definition, 3.11.6

mapping to LOBs, 9.7

SQL operations on, 3.11.6

XML instance document

definition, 1.3.2

XML Object (XOB), 2.4.2

XML query rewrite

definition, 5.10

cost-based, 5.10.1

rule-based, 5.10.1

XML Schema

definition, Preface

XML schema

annotations, 3.7.3, 7.9

querying to obtain, 7.10

circular dependencies, 9.9

complexType declarations, 9.8.1, 9.9.2

cyclical dependencies, 9.9

definition, 1.3.2, 7.1

deletion, 7.3.12

evolution, 10

backward-compatible, 10.3.1

for XML schemas that can be registered, 7.3.5

generating from object-relational type, 9.1

inheritance in, complexType restrictions, 9.8.1

local and global, 7.5

managing and storing, 7.3.5

mapping to SQL object types, 13.2.5

registration with Oracle XML DB, 7.3.1

for use with JCR, 31.4.1

updating after registering, 10

URLs, 9.6

use with JCR, 31.4

use with Oracle XML DB, 7.2

W3C Recommendation, 3.6, 7

XMLType methods, 7.4

XML Schema data types

mapping to JCR node types, 31.4.3

mapping to SQL data types, 7.12

XML schema definition

definition, 1.3.2

XML schema evolution

copy-based, 10.2

in-place, 10.3

XML schema-based tables and columns, creating, 7.8

XML schema-based view

definition, 19.1

XML_DB_EVENTS parameter, 30.5

XMLAgg SQL function, 18.2.4

XMLAttributes SQL function, 18.2.1

XMLCast SQL function, 4.1.2.2

XMLCDATA SQL function, 18.2.11

XMLColAttVal SQL function, 18.2.10

XMLComment SQL function, 18.2.6

XMLConcat SQL function, 18.2.3

XMLElement SQL function, 18.2.1

XMLExists SQL function, 4.1.2.1

XMLEXTRA object column, 9.9.2.1

XMLForest SQL function, 18.2.2

XMLFormat

XMLAgg, 18.2.4, 18.5

XMLFormat object type

sys_XMLGen

XMLFormatType object, 18.4.2

XMLGenFormatType object, 18.4.2

XMLIndex

creating index, 6.4.5

dropping index, 6.4.5

order index

definition, 6.4.4

path index

definition, 6.4.4

path table, 6.4.4

renaming index, 6.4.5

structured component

definition, 6.4.2

unstructured component

definition, 6.4.2

value index

definition, 6.4.4

XMLIsValid SQL function, 3.9.1.2.1, 11.3

XMLOptimizationCheck SQL*Plus setting, 5.10.4

XMLOptimizationCheck SQL*Plus system variable, Preface, 5.10.4

XMLParse SQL function, 18.2.8

XMLPI SQL function, 18.2.5

XMLQuery SQL function, 5.3, 5.3.1

XMLRoot SQL function, 18.2.9

XMLSequence Oracle SQL function (deprecated), Preface

XMLSerialize SQL function, 18.2.7

XMLTable SQL function, 5.3, 5.3.2

breaking up an XML fragment, 3.11.6

breaking up multiple levels of XML data, 3.12.2

PASSING clause and FROM list order, 5.9.4

XMLtransform SQL function, 11.1.1

XMLType

as abstract data type, 1.3.3

benefits, 3.1.2

constructors, 3.4.1

contains SQL function, 6.2.2

CREATE TABLE statement, 7.8.1.2

DBMS_XMLDOM PL/SQL API, 13.2

DBMS_XMLPARSER PL/SQL API, 13.3

DBMS_XSLPROCESSOR PL/SQL API, 13.4

definition, 1.3.1

extracting data, 4.1.3

indexing columns, 6.2

instances, PL/SQL APIs, 13.1

loading data, 35.1

loading with SQL*Loader, 35.2

methods

createXML(), 13.1.1.3, 15.2.1

getCLOB(), 15.3

getNumberVal(), 4.1.1

getObject(), 15.2.1.2

getOPAQUE(), 15.2.1.2

getSchemaURL(), 7.4

insertXML(), 15.3

isSchemaBased(), 7.4

IsSchemaValid(), 11.3

isSchemaValid(), 7.4

isSchemaValidated(), 7.4, 11.3

schemaValidate(), 7.4

setObject(), 15.2.2

setSchemaValidated(), 7.4, 11.3

writeToStream(), 21.4.1.5

XML schema, 7.4

PL/SQL packages, 13.1

querying, 4.1

querying transient data, 4.1.3

querying XMLType columns, 4.1.3

queue payloads, 37.5.1

storage models, 1.3.3

table, querying with JDBC, 15.2.1.2

tables, views, columns, 7.8

views, access with PL/SQL DOM APIs, 13.2.6

XOB, 2.4.2

XPath language

functions

ora:contains (Oracle), 5.7.1, 12.5

syntax, 4.1.1