Transcript Why XML in the Database

Oracle9i XML Database
Albert Godfrind
GeoSpatial and Multimedia
Technologies
Oracle Corporation
Sophia Antipolis, France
The Oracle Platform
Oracle9i
Database
Oracle9i
Application
Server
Enterprise Manager
Development Tools
Applications
Managing all the information …
Spatial Data
Object Relational Data
Field
Documents
XML
Prospects
Multimedia
Messages
Infrastructure
Customers
Our Mission ...
 To supply a foundation for the distribution
and integration of spatial data such that any
application can use it
 To make Spatial Data An Integral
Component of the Overall Information
Technology Strategy of an Organization
Our Strategy ...
 Products

Oracle Spatial, Oracle Locator
 Partnerships With Leading Spatial Vendors




Software vendors
Integrators,
Data suppliers
Service providers
 Commitment To Standards



Open GIS Consortium, OpenLS, ...
SQL, LIF,
ISO TC-211, TC-204
 Integration with Oracle applications



E-Business Suite
CRM
Location Based Services
SQL3/MM Spatial
Oracle Spatial Database Services
P
7
P
8
P
1
H
1
H
4
P
6
P
5
H
3
H
2
P
2
Element 0
P
4
P
3
Abstract Data Type
ROADS
Element 1 (Hole)
Geometry
Data Type
RNAME
ID
TYPE
M40
140
HWY
6
M25
141
HWY
4
Indexing
Quadtree, Rtree
Query/Analysis
Select, join, buffer, within distance,
nearest neighbor, intersection, union,
convex hull, centroid, ...
X
LANES
Y
x1
x1
x2
x2
x3
x3
x4
x4
x5
x5
GEOMETRY
Why XML in the Database
 Enforce and leverage the XML data model
–
–
Loosely coupled, flexible applications
XML Schema, DOM
 Enable richer semantics and better management for
content-oriented applications
–
–
Store as XML vs. Files or LOBs
Queryability, Integrity, RAS etc.
 Process XML close to data for high scalability and
performance
–
–
Generation, Transformation
Superior memory management for large XML
Why XML in the Database
 Reduce maintenance costs of extra moving parts
–
Eliminate separate ‘XML-processing’ layers
 Keep applications standards-based
–
–
W3C, IETF, ANSI/ISO, J2EE
Eliminate proprietary file formats, message formats,
delimited columns
Oracle9iR2: XML DB
 Enhanced XMLType
 XML Repository
Enhanced XMLType
 XMLSchema Support
 Object-Relational Storage Maintaining DOM fidelity
 XML-specific memory mgmt for better scalability and
performance
 Built-in XML operators for SQL/XML interchangability
 XPath Search in the server, and piecewise update of XML
via XPath
 XSL Transforms in the server
 Enhanced XML Views for creating your own efficient
representations of XML
XML Repository
 FTP, WebDAV, HTTP protocol servers to move
XML content in and out
 ‘Foldering’ and Repository view over XML Content
including access control
–
Hierarchical Index, SQL Versioning
 SQL Repository Search
XML DB Architecture
Data-oriented Access
Application Clients
OCI Client
JAVA Client
XQuery
XML Schema Cache
XML/DOM Parser
JDBC/OCI
Oracle Net
SQL
XMLType
Views/Tables
Repository
Text Index
Path Index
9i XML
DB
Text Index
B-Tree
Bitmap Index
XML DB Architecture
Content-oriented Access
HTTP Client
HTTP
FTP Client
WebDAV Client
WebDAV
FTP
Protocol Handlers
XMLType
Views/Tables
Repository
Text Index
Path Index
XML DB
Text Index
B-Tree
Bitmap Index