XML DB Oracle Corporation Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 2
Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 3 RDB-XML RDB XML Oracle Corporation 4
XML RDB [Oracle] Extract ExtractValue RDB XML XMLElement XMLForest XMLAgg SQLX Oracle Corporation 5 Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 6
SQL SQL92 RDB SQL99 SQL2003 Java/OLAP/XML ANSI American National Standard Institute ISO International Organization for Standardization Oracle Corporation 7 SQL/XML 9075-14 XML RDB XML SQL/XML XML XML SQL XML SQL XML Oracle Corporation 8
SQL/XML XML XML CAST XML XML XML XMLElement XMLForest XMLAgg Oracle Corporation 9 Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 10
XML DB XML XML Enabled XML XML:DB Initiative http://www.xmldb.org/ Oracle Corporation 11 XML XML 2 XML XML XML PCDATA Oracle Corporation 12
XML Enabled XML Enabled XML XML XPath SQL Oracle Corporation 13 XML XML XML Enabled Oracle Corporation 14
Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 15 vs. XML LOB XML Oracle Corporation 16
vs. XMLType CLOB <emp> <empno>1100</empno> <ename>scott</ename> <sal>300000</sal> </emp> <emp> <empno>1200</empno> <ename>smith</ename> <sal>350000</sal> </emp> XMLType( ) empno (NUMBER) ename (VARCHAR2) (NUMBER) sal 1100 SCOTT 300000 1200 SMITH 350000 Oracle Corporation 17 vs. Oracle Corporation 18
Agenda RDB XML SQL/XML XML DB XML XML XML Oracle Corporation 19 XML (1) / DayEntry Entries Date Oracle Corporation 20
XML (2) / DayEntry Entries Date 2005- Entry 12-17 EntryId Created Modified Title Content Categories abc123 2005-01-04T01:02:03 2005-02-24T04:05:06 Oracle;Tokyo Oracle Corporation 21 Oracle XML DB XML XML XML XML URL XML Oracle Corporation 22
XML Oracle XML DB XML Schema Oracle Oracle Corporation 23 XML Schema integer float, double datetime, time boolean ID, IDREF, anyuri, anytype, anysimpletype NUMBER Oracle NUMBER TIMESTAMP RAW(1) FLOAT DOUBLE BINARY FLOAT DATE TIMESTAMP WITH TIMEZONE VARCHAR2 VARCHAR2(4000) CHAR CLOB Oracle Corporation 24
XMLType CREATE TABLE XML XML Oracle Corporation 25 XML SQL ExistsNode XML Extract ExtractValue XMLType existsnodeexistsnode extract Extract get [Clob Blob String Number] Val Oracle Corporation 26
Extract XML XPath XMLType XPath XMLType XML targetnamespace XML Oracle Corporation 27 ExtractValue XML XPath Extract ORDER BY Oracle Corporation 28
XSLT PL/SQL XSLT Processor API for XMLType DBMS_XSLPROCESSOR Oracle Corporation 29 XQuery Oracle Database Oracle Corporation 30
Agenda RDB XML SQL/XML XML DB XML XML XML Oracle Corporation 31 XML XML SQL PL/SQL SQLX Oracle Corporation 32
SQLX SQLX XML SQL SQLX XMLElement XML XMLForest XML XMLConcat XML XMLAgg SQLX XMLColAttVal XML XMLSequence REF XMLType VARRAY Oracle Corporation 33 XMLElement XML XML XMLAttributes XMLElement(, [XMLAttributes( [, as ])], [ ]...) EmpNo="7369" Oracle Corporation 34
XMLForest XML Oracle Corporation 35 XMLForest XMLForestXMLForest Oracle Corporation 36
XMLType XMLType XML XMLType DML XMLType DML XML XML Oracle Corporation 37 XMLType XMLType Oracle Corporation 38
XMLType (XML ) XML XML XML XMLType Oracle Corporation 39 XMLType (XML ) XML XML XML XML Oracle Corporation 40
XMLType XPath Oracle Corporation 41 XMLType DML Insert dept_xml DEPTNO DNAME LOC 90 TEST TOKYO Oracle Corporation 42
Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 43 XML DB 1 XML DB XML XML XML XML Schema XPath XSLT XQuery Oracle Corporation 44
XML DB 2 XML XML XML Schema Oracle Corporation 45 XML DB [ ] XML RDB Oracle Corporation 46
1 XML 2001 SQL2003 2004 DB 20049 3 XML RDB-XML 2004 Oracle Corporation 47 2 OTN Oracle Technology Network http://otn.oracle.com/tech/xml/xmldb OTN-J Oracle Technology Network Japan http://otn.oracle.co.jp/tech/xml/xmldb Oracle Corporation 48
Oracle Oracle Corporation Oracle Corporation Oracle Corporation 49