_02_3.ppt

Transcription

1 XML DB Oracle Corporation Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 2

2 Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 3 RDB-XML RDB XML Oracle Corporation 4

3 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

4 SQL SQL92 RDB SQL99 SQL2003 Java/OLAP/XML ANSI American National Standard Institute ISO International Organization for Standardization Oracle Corporation 7 SQL/XML XML RDB XML SQL/XML XML XML SQL XML SQL XML Oracle Corporation 8

5 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

6 XML DB XML XML Enabled XML XML:DB Initiative Oracle Corporation 11 XML XML 2 XML XML XML PCDATA Oracle Corporation 12

7 XML Enabled XML Enabled XML XML XPath SQL Oracle Corporation 13 XML XML XML Enabled Oracle Corporation 14

8 Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 15 vs. XML LOB XML Oracle Corporation 16

9 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 SMITH Oracle Corporation 17 vs. Oracle Corporation 18

10 Agenda RDB XML SQL/XML XML DB XML XML XML Oracle Corporation 19 XML (1) / DayEntry Entries Date Oracle Corporation 20

11 XML (2) / DayEntry Entries Date Entry EntryId Created Modified Title Content Categories abc T01:02: T04:05:06 Oracle;Tokyo Oracle Corporation 21 Oracle XML DB XML XML XML XML URL XML Oracle Corporation 22

12 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

13 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

14 Extract XML XPath XMLType XPath XMLType XML targetnamespace XML Oracle Corporation 27 ExtractValue XML XPath Extract ORDER BY Oracle Corporation 28

15 XSLT PL/SQL XSLT Processor API for XMLType DBMS_XSLPROCESSOR Oracle Corporation 29 XQuery Oracle Database Oracle Corporation 30

16 Agenda RDB XML SQL/XML XML DB XML XML XML Oracle Corporation 31 XML XML SQL PL/SQL SQLX Oracle Corporation 32

17 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

18 XMLForest XML Oracle Corporation 35 XMLForest XMLForestXMLForest Oracle Corporation 36

19 XMLType XMLType XML XMLType DML XMLType DML XML XML Oracle Corporation 37 XMLType XMLType Oracle Corporation 38

20 XMLType (XML ) XML XML XML XMLType Oracle Corporation 39 XMLType (XML ) XML XML XML XML Oracle Corporation 40

21 XMLType XPath Oracle Corporation 41 XMLType DML Insert dept_xml DEPTNO DNAME LOC 90 TEST TOKYO Oracle Corporation 42

22 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

23 XML DB 2 XML XML XML Schema Oracle Corporation 45 XML DB [ ] XML RDB Oracle Corporation 46

24 1 XML 2001 SQL DB XML RDB-XML 2004 Oracle Corporation 47 2 OTN Oracle Technology Network OTN-J Oracle Technology Network Japan Oracle Corporation 48

25 Oracle Oracle Corporation Oracle Corporation Oracle Corporation 49