![](3D"master04_image004.gif")
![](3D"master04_image005.gif")
![](3D"master04_image006.gif")
![](3D"slide0038_image008.jpg")
“This presentation is for informational purposes only and may n=
ot
be incorporated into a contract or agreement.”
The following is intended to outli=
ne our
general product direction. I=
t is intended for information purposes only,
and may not be incorporated into any contract. It is not a commitment to d=
eliver
any material, code=
, or
functionality, and should not be relied upon in making purchasing decision. The development, release, and tim=
ing of any features or functionality described
for Oracle’s products remains at the sole discretion of Oracle.
------=_NextPart_01C642BD.26625AF0
Content-Location: file:///C:/0ED24C8E/OOWJapan_files/slide0039.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Oracle XML
DB
And XQuer=
y
![](3D"slide0039_image010.gif")
![](3D"slide0039_image011.gif")
Mark D Drake
Product Manager
XML Technology
![](3D"slide0040_image012.gif")
![](3D"slide0040_image013.gif")
XML Use cases
&#=
376;Data Interchange &=
#13;
–Moving data between
systems
–Majority of our cu=
rrent
customers
–Generation of XML =
from
relational data
–Ingestion of XML d=
ata
via staging tables
&#=
376;Persisted XML
=
–Archive Records=
3;
–Semi Structured
data
&#=
376;Content Management=
–Document Authoring,
Technical Pubs
2 Development Para=
digms
=
ŸXML Centric
–Data is represente=
d as a
collection of XML documents
–=
Support for Iterat=
ive
and path based operations
–XQuery, XPath and =
XSLT
are the language of choice
=
ŸSQL Centric
–=
Allows Set-based
operations on XML content
–Data is represented
using Table / Column Metapho=
r
–=
SQL is the languag=
e of
choice
–Text and Attribute=
nodes
represented as column Values
–Parent / Child
relationship represented as ‘master / ‘detail’ tables
=
–
Data / Content Life
Cycle
&#=
376;Data centric
requirements
–Replication
–High Availability&=
#13;
–Security
&#=
376;Content Centric
requirements
–Access Control
=
;
–Versioning
–Digital Signature&=
#13;
![](3D"slide0005_image014.gif")
Data Management Gr=
id
![](3D"slide0005_image015.gif")
Content
Managem= ent
Managem= ent
Life Cycle
Data
Centric
Life Cy= cle
Life Cy= cle
SQL
Centric=
Centric=
XML
Centric=
Centric=
DB3
DB2
SQL
Server
Documentum
GRID<=
/div>
![](3D"slide0005_image017.gif")
XML Algebra
XQuery / Iterative Logic
Relational Algebra
SQL / Set Based Logic
Native XML Databases
Compliance
Veritas
![](3D"slide0006_image018.gif")
8i
9i
10g
<=
/b>
9iR2
<=
/b>
10gR2
<=
/b>
XDK
XSU
XMLType
=
XSQL<=
/div>
XDB
XQuery
<=
/span>
Oracle XML Milesto=
nes
Performance&=
#13;
Robustness&#=
13;
![](3D"slide0036_image019.gif")
Oracle XML DB Overview
Persistence
Publishing
DML
Repository
![](3D"slide0036_image020.gif")
What is Oracle XML=
DB
&#=
376;Native support for=
XML in the Oracle database
&#=
376;Implementations of=
key
XML standards
–First RDBMS Vendor with support for XML and XQuery
&#=
376;Flexible persisten=
ce
models for XML Content
&#=
376;URL-centric access=
to
XML content
&#=
376;Standards complian=
t XML
Publishing
&#=
376;SQL/XML and XML/SQL
Duality
Ÿ<=
span
style=3D'font-family:"Times New Roman";mso-ascii-font-family:Arial;mso-bid=
i-font-family:
"Times New Roman";font-size:140%;display:none'>
–
Ÿ<=
span
style=3D'font-family:"Times New Roman";mso-ascii-font-family:Arial;mso-bid=
i-font-family:
"Times New Roman";font-size:140%;display:none'>
–DAV, HTTP, FTP
XML Standards supp=
orted
–XML, Namespaces
–XQuery, XPath
–XML Schema
–XSL and XSLT
=
–DOM
![](3D"slide0012_image022.gif")
![](3D"slide0012_image025.gif")
Ÿ=
–SQL/XML
![](3D"slide0013_image026.gif")
Oracle XML DB Overview
Publishing
DML
Repository
![](3D"slide0013_image027.gif")
Oracle XML DB
Native XML data ty=
pe
&#=
376;Abstraction for St=
oring
XML in the database
–Use as Table, Column, Variable, Argument or Return Value
&#=
376;Supports both
Schema-based and Schema-less XML
=
76;Multiple native
persistence models for storing XML in the database
<=
/span>
&#=
376;Guarantees XML
Fidelity
–XML Content model =
is
maintained
–XML Schema
Validation
–SQL Style Referent=
ial
Integrity
Versatile Persiste=
nce
Models
&#=
376;Applications requi=
re
flexible persistence models
–Different models to meet different application requirements
–Model can be tuned to deliver application performance
=
76;Persistence model =
is
transparent to application
–Developer should code independent of the persistence =
model
<=
/span>
–Changes to the
persistence model must not require changes to application code
XML Schema based
persistence
&#=
376;WC3 Standard
<=
/span>
–Defines the struct=
ure of
XML documents
–Authored by Tools =
like
Oracle’s JDeveloper, Altova’s =
XMLSpy
=
–XML Editors, Tools and Database can validate XML content against XML
Schema
&#=
376;XML DB provides XML
Schema based optimizations
–Automatic mapping between XML and SQL object models
–XQuery operations over XML automatically re-written into SQL query over SQL
objects
Versatile XML Inde=
xing
&#=
376;B-TREE Indexing=
3;
–Allows indexing of
specific scalar values
–Requires Schema ba=
sed
XML persistence
&#=
376;Functional Indexin=
g
–Allows index of specific element or attribute values
–Path Expression mu=
st be
unique within document
&#=
376;Full text indexing=
–Document and node =
level
text indexing
XML Path Index
&#=
376;XML Path Index
=
;
–Path : Value model=
–Namespace aware=
3;
–Data-type aware=
3;
&=
#376;support for numeri=
c and
date range searches
![](3D"slide0035_image028.gif")
Oracle XML DB Overview
Persistence
Publishing
Repository
![](3D"slide0035_image029.gif")
Oracle XML DB
XML Operations
&#=
376;Document Level
operations
=
–Create, Read, Upda=
te and
Delete
–Schema Validation&=
#13;
–XSL Based
Transformation
&#=
376; Full support for W3C XQuery
Specification
–Enable XQuery over
persisted XML content and XML Views of relational data
XML Operations
&#=
376;Node Level
operations
–Selection based on
document content
–Extraction of scal=
ar
values and Fragments
–Update of scalar v=
alues
or fragments
–Deletion of nodes =
or
Fragments
–Insertion of nodes=
or
Fragments
&#=
376;DOM API
–PL/SQL, Java and C=
![](3D"slide0051_image030.gif")
Oracle XML DB Overview
Persistence
Publishing
DML
Repository
![](3D"slide0051_image031.gif")
What is XQuery?
&#=
376;W3C language for
querying and generating XML
–Natural query lang=
uage
for XML content
&#=
376;Evolved from XPath=
and
XSLT
&#=
376;Analogous to SQL i=
n the
relational world
&#=
376;Adopted by ANSI / =
ISO
SQL Standard in SQL:2005
XQuery Usages
&#=
376;Transformation
=
;
–XML to XML
Transformation
&#=
376;Templating
–XML Construction&#=
13;
&#=
376;Querying XML
documents
–Selection, Iterati=
on
XQuery Expressions=
&#=
376;Everything in XQue=
ry is
an “expression<=
span
style=3D'mso-ascii-font-family:Arial'>”
&#=
376;Every expression r=
eturns
a new value
&#=
376;Major Expressions&=
#13;
–FLWOR expressions =
–
&=
#376;For, Let, Where ,
Order-by Return
–Path Expressions -
/a/b/c
&#=
376;Powerful, extensib=
le
Functions and Operators Library
–Shared with XSLT 2=
.0
XQuery Status
&#=
376;XQuery 1.0 now in =
final
call.
&#=
376;Proposed XQuery
extensions
–Grouping, Exception
handling
&#=
376;XQuery Full-Text F=
ull
Text extensions
&#=
376;XQuery update DML
extensions
–Insert, Update, De=
lete
XQuery and SQL:200=
5
&#=
376;XMLQuery() Functio=
n
–XML-centric
–Applies an XQuery to one or more XML documents
–Returns the result of evaluating the XQuery expression as an XML document=
3;
&#=
376;XMLTable() Functio=
n
–SQL-centric
–Maps the result of an XQuery evaluation into relational rows and columns&#=
13;
–Enables SQL based
operations on XML content