| xml
enhancements |
| XML
DB: |
|
|
|
|
A
key part of
this new release is XML DB,
Oracle's solution for storing XML data within the relational
database. Traditional relational database structures do not
lend themselves
well
to efficient storage and retrieval of XML data
and with the emergence of new database vendors hawking databases
designed exclusively for the storage of XML data, a solution
was urgently needed from the traditional RDBMS
camp. |
| Oracle's
solution has been the incorporation of the XML Type datatype and the XML repository,
which together mean that XML data can be stored in and efficiently retrieved from the
database. |
|
| XML
type: |
|
|
|
| (introduced
in 9i Release 1 and now significantly enhanced) can be used
like any other column datatype,
comes with a number of associated methods for data manipulation.
It can be stored "as
is" in BLOB format or alternatively in object-relational format for maintaining
Document Object Model (DOM) fidelity. The latter format contains
hidden columns for some of the
data, which can be accessed through APIs. The two storage
models are interchangeable. In addition to the XML Type datatype,
Release 9.2 also includes a number of PL/SQL packages
for manipulation of XML documents and conversion into
relational data. |
|
| XML
Repository: |
|
|
|
| Provides
functionality for managing XML data and documents. The available
features provide two key functions: |
|
 Foldering, which
enables the mapping of XML files into database structures
(and vice versa) which can be hierarchically traversed and
accessed via SQL, FTP, WebDAV and Servlets.
Access Control which enables you to define your own
security and privileges on any XML Type object. |
|
| Although
Oracle's XML features have been hailed as the best solution
so far from the
traditional RDBMS vendors, the inherent incompatibility between
XML data storage and relational data storage remains and
we can expect to see this functionality
continually revamped over the coming months and years. |
|
| |
<<
previous page |
|
next
page >> |
|
020 8465 9100 
Sales
Enquiries
Other Enquiries
