Oracle Database 10g Oracle XML DB 2005 3 14 1 Agenda Oracle XML DB XML SQL Oracle Database 10g Release 2 Copyright Oracle Corporation, 2005 All right reserved. 2
XML Oracle Database 10g Release 2 Oracle Database 10g Release 1 Oracle 8 Oracle9i Database Release 1 Oracle 8i Oracle9i Database Release 2 1997/9 1999/5 2001/10 2002/8 2004/4 Copyright Oracle Corporation, 2005 All right reserved. 3 Oracle XML DB Oracle Database XML XMLType XML XML XML XML API XML API Oracle XML DB Repository Copyright Oracle Corporation, 2005 All right reserved. 4
( ) XML 1.0 XML Namespaces (1.0) DOM 1.0/2.0 XPath 1.0 XML Schema 1.0 XSL 1.0 SQL/XML WD FTP RFC 959 HTTP RFC 2616/2718 WebDAV RFC 2518/2718 Java Servlet 2.2 Copyright Oracle Corporation, 2005 All right reserved. 5 ( ) W3C XML Core, XML Query Java Community Process JSR 225 : XQuery API for Java (XQJ) ebxml, XBRL Japan Copyright Oracle Corporation, 2005 All right reserved. 6
Agenda Oracle XML DB XMLType XML XML SQL Oracle Database 10g Release 2 Copyright Oracle Corporation, 2005 All right reserved. 7 XMLType XML SQL XMLType PL/SQL JDBC (XMLType ) XPath XML DOM Copyright Oracle Corporation, 2005 All right reserved. 8
3 DTD XML Schema 2 XML Schema DTD XML 2 Copyright Oracle Corporation, 2005 All right reserved. 9 XMLType CREATE TABLE XML XML Schema Copyright Oracle Corporation, 2005 All right reserved. 10
XMLType XMLType sys_nc_rowinfo$ XML Copyright Oracle Corporation, 2005 All right reserved. 11 XML - SQL, PL/SQL INSERT SQL PL/SQL XML Copyright Oracle Corporation, 2005 All right reserved. 12
XML - / SQL*Loader LOB XML Copyright Oracle Corporation, 2005 All right reserved. 13 - Oracle XML DB Repository XML SQL PL/SQL FTP, HTTP, WebDAV ACL SQL Copyright Oracle Corporation, 2005 All right reserved. 14
SQL XDBURIType DBMS_XDB SQL Copyright Oracle Corporation, 2005 All right reserved. 15 - DBUri SCOTT EMP http://<host>:<port>/oradb/scott/emp http://<host>:<port>/oradb/scott/emp?transform=/public/emp.xsl &contenttype=text/html Copyright Oracle Corporation, 2005 All right reserved. 16
Agenda Oracle XML DB XML XML XML XML SQL Oracle Database 10g Release 2 Copyright Oracle Corporation, 2005 All right reserved. 17 XML SQL ExistsNode XML Extract ExtractValue XMLType existsnode ExistsNode extract Extract get [Clob Blob String Number] Val Copyright Oracle Corporation, 2005 All right reserved. 18
Extract XML XPath XMLType XPath Copyright Oracle Corporation, 2005 All right reserved. 19 ExtractValue XML XPath Extract XML XML XML SQL SQL Copyright Oracle Corporation, 2005 All right reserved. 20
Oracle XML DB Oracle Database REGEXP_LIKE XPath Copyright Oracle Corporation, 2005 All right reserved. 21 XML UpdateXML XMLType UPDATE XMLType [ ] [XPath] [ ] FTP, WebDAV XML UPDATE Copyright Oracle Corporation, 2005 All right reserved. 22
XML DELETE XML UpdateXML UpdateXML NULL FTP, WebDAV XML UPDATE Copyright Oracle Corporation, 2005 All right reserved. 23 Agenda Oracle XML DB XML SQL Oracle Database 10g Release 2 Copyright Oracle Corporation, 2005 All right reserved. 24
, REF, VARRAY Oracle XML DB Copyright Oracle Corporation, 2005 All right reserved. 25 XML Oracle XML Schema SQL XML Schema VARRAY OCT (Ordered Collections in Tables) XPath B UpdateXML XML Copyright Oracle Corporation, 2005 All right reserved. 26
XMLType XPath SELECT Extract(job,'/emp/job/elem/text()') FROM emp; SQL SELECT e.job.xmldoc.xmldata.elem FROM emp e; Copyright Oracle Corporation, 2005 All right reserved. 27 Agenda Oracle XML DB XML SQL SQL/XML XML Oracle Database 10g Release 2 Copyright Oracle Corporation, 2005 All right reserved. 28
SQL/XML SQL XML XML XMLElement XML XMLAttributes XMLElement(, [XMLAttributes( [, as ])], [ ]...) Copyright Oracle Corporation, 2005 All right reserved. 29 XMLType XMLType XML SQL/XML XMLType DML XMLType DML XML Schema XML Copyright Oracle Corporation, 2005 All right reserved. 30
XMLType XMLType Copyright Oracle Corporation, 2005 All right reserved. 31 XMLType DML XMLType INSTEAD OF Copyright Oracle Corporation, 2005 All right reserved. 32
(VARCHAR2 NUMBER ) XMLType INSTEAD OF Copyright Oracle Corporation, 2005 All right reserved. 33 XML XML EMP User EMP ename) XML Copyright Oracle Corporation, 2005 All right reserved. 34
Agenda Oracle XML DB XML SQL Oracle Database 10g Release 2 Copyright Oracle Corporation, 2005 All right reserved. 35 Oracle Database 10g Release 2 XML Query (XQuery) SQL SQL/XML XML Query XML Query Oracle Enterprise Manager 10g XML XML DB SQL/XML SQL Copyright Oracle Corporation, 2005 All right reserved. 36
Agenda Oracle XML DB XML SQL Oracle Database 10g Release 2 Copyright Oracle Corporation, 2005 All right reserved. 37 Temenos TEMENOS T24 3 ING Credit Suisse Private Banking Merrill Lynch American Express Copyright Oracle Corporation, 2005 All right reserved. 38
Temenos HP 9000 Superdome 32 CPU 168G 796.67 / OTN-J http://otn.oracle.co.jp/tech/xml/xmldb/index.html XML 1 INSERT x 1 UPDATE x 2 Copyright Oracle Corporation, 2005 All right reserved. 39 Agenda Oracle XML DB XML SQL Oracle Database 10g Release 2 Oracle XML DB Copyright Oracle Corporation, 2005 All right reserved. 40
Oracle XML DB (1) SQL XML XML XML SQL XML XML B Copyright Oracle Corporation, 2005 All right reserved. 41 Oracle XML DB (2) ISO/IEC 15408 Common Criteria FIPS 140-1 17 Oracle Real Application Clusters Oracle Data Guard Recovery Manager RMAN Copyright Oracle Corporation, 2005 All right reserved. 42
Oracle Technology Network Japan (OTN-J) http://otn.oracle.co.jp/tech/xml/ http://otn.oracle.co.jp/tech/xml/xmldb/ Copyright Oracle Corporation, 2005 All right reserved. 43 Copyright Oracle Corporation, 2005 All right reserved. 44