122.pdf

Size: px

Start display at page:

Download "122.pdf"

いつやたけはな
4 years ago
Views:

1 HironobuUtsugi RDB exa review

2 XML HTML W3C(World Wide Web Consortium) XML(Extensible Markup Language) HTML RDB(Relational Database) XML XML DB RDB XML DB XML DB XML * 1 RDB DB RDB XML XML * 1 DB ER 1 RDB RDB XML SQLXML RDBXML NeoCore Cyber Luxeon IBM DB Oracle Database Microsoft SQL Server XML XML XQuery XML exa review

3 XQuery X1.FNAME, X1.LNAME EMP_X, XMLTABLE('$i/ ' PASSING EMP_X.XMLDOC as "i" COLUMNS "FNAME" char(30) PATH '', XQuery XML "LNAME" char(30) PATH '' )AS X1 XML EMP_X W3C XQuery XMLDOC XML < > FNAME LNAME <> </> <> </> </ > XQuery XML XML XMLForest RDB SQL XML SQL XMLTable RDB XMLTable SQL XML SQL SQL 4 RDB IBM DB 9 for LUW DB 9 XQuery XMLELEMENT (" ", XMLFOREST(FNAME as "", LAME as "") ) EMPLOYEE EMPLOYEE FNAME LNAME XML < > <> </> <> </> </ > < >... RDB ANSI/ISO SQLXML RDB RDB XML RDB XML SQL XML RDB XMLElementXMLForest XMLElement XML RDB RDB RDB exa review

4 SQL WITH SQL ITEM ITEM_TREE WHERE ITEM_TREE RESULT_R JOIN ITEM_TREE ITEM PARRENT_IDPARRENT_ID PARENT_ID -1 -GROUP BY ORDER BY RESULT_R ID ID ITEM NAME PARENT_ID 1 RESULT_R YEAR ID VALUE * XML XML XML RESULT_XXMLDOC* < RESULT_X ="007"> <><> SQL XMLDOC < >1.</ > < ></ > </ ></> </ > WITH ITEM_TREE (LEVEL, PARRENT_ID, PARRENT_ID, ID, NAME) AS ( 1, PARENT_ID, PARENT_ID, ID, NAME ITEM WHERE ITEM PARENT_ID IS NULL UNION ALL LEVEL+1, CRNT.PARRENT_ID, CHLD.PARENT_ID, CHLD.ID, CHLD.NAME ITEM_TREE CRNT, ITEM CHLD WHERE CHLD.PARENT_ID = CRNT.ID AND CRNT.LEVEL < 3 ) PARRENT.NAME, PARRENT.NAME, ITEM_TREE.NAME, MAX(CASE R_R.YEAR WHEN 007 THEN R_R.VALUE END) AS VALUE1, MAX(CASE R_R.YEAR WHEN 006 THEN R_R.VALUE END) AS VALUE, MAX(CASE R_R.YEAR WHEN 005 THEN R_R.VALUE END) AS VALUE3 ITEM_TREE I_T, RESULT_R R_R, ITEM PARRENT, ITEM PARRENT WHERE I_T.ID = R_R.ID and I_T.PARRENT_ID = PARRENT.ID and I_T.PARRENT_ID = PARRENT.ID GROUP BY PARRENT.NAME, PARRENT.NAME, ITEM_TREE.NAME ORDER BY PARRENT.NAME, PARRENT.NAME, ITEM_TREE.NAME SQL < ="006"> <><> < ></ > </ > RDB SQL X1.PARRENT_NAME, X1.PARRENT_NAME, X1.NAME, MAX(CASE X1.YEAR WHEN 007 THEN X1.VALUE END) AS VAL007, MAX(CASE X1.YEAR WHEN 006 THEN X1.VALUE END) AS VAL006, MAX(CASE X1.YEAR WHEN 005 THEN X1.VALUE END) AS VAL005 RESULT_X, XMLTABLE('$i/ /*/*/*' PASSING RESULT_X.XMLDOC AS "i" COLUMNS "PARRENT_NAME" CHAR(30) PATH 'fn:name(../..)', "PARRENT_NAME" CHAR(30) PATH 'fn:name(..)', "NAME" CHAR(30) PATH 'fn:name(.)', "VALUE" DECIMAL(10,) PATH '.', "YEAR" SMALLINT PATH '../../../@ ' )AS X1 GROUP BY X1.PARRENT_NAME, X1.PARRENT_NAME, X1.NAME ORDER BY X1.PARRENT_NAME, X1.PARRENT_NAME, X1.NAME -1 XML - XMLTable exa review

5 SQL XML HW IBM System p5 CPU Power5 OS AIX5.3 DB DB V9.1 4GB XML RDB ID ID RDB SQL RDB RDB SQL 70 Power5 IBM System p5 OSAIX5.3 DB DB 9 4GB DB DB CLP SQL RDB XML RDB RDB SQL RDB SQL SQL SQL XML SQL SQL SQL XMLTable XML SQL CRT.LEVEL XMLTable exa review * DB

6 9,600, ,000 1.GB.9GB XML DB RDB RDB SQL ID SQL ID Extensible Markup Language (XML), SQL ID XML XML DB 0074 p SQL SQL SQL 0.63 (004) Paul Zikopoulos et al., IBM DB 9 NEW FEATURES, RDB XML (006) W3C XQuery : An XML Query Language, Mcgraw-Hill Osborne Media(007) DB 9 XML, ftp://ftp.software.ibm.com/ps/products/db/info/vr9 /pdf/letter/nlv/ja_jp/dbxgj90.pdf SQL IBM DBAIXPower5System p5ibm Corporation SQL Microsoft Windows SQL Server Microsoft XML SQL * 3 Corporation RDB Oracle Database Oracle Corporation * 3 NeoCore NeoCore Inc. XML the World Wide Web Consortium exa review

山梨県ホームページ作成ガイドライン

山梨県ホームページ作成ガイドライン 17 7 ...1...4...4...4...4...5...5 W3C...5...6...6...6...7...8...8...10...10...10... 11...12...12...13...13...13...14...14...14...15...15...16...16...16...16...16...17...18 15 (2003 ) 69.7 81.1 43.6 19.6