Oracle Database 10gによる高パフォーマンス・エンタープライズXMLアプリケーションの作成

Size: px

Start display at page:

Download "Oracle Database 10gによる高パフォーマンス・エンタープライズXMLアプリケーションの作成"

きみのしんきちや
4 years ago
Views:

1 Oracle Database 10g XML

2 Oracle Database 10g XML TU UT... 3 TU UT... 3 TUOracle XML Developer's Kit 10gUT... 4 TU UT... 5 TU UT... 5 TU UT... 5 TUXML /XSL UT... 5 TUXML UT... 6 TUXML Class GeneratorUT... 6 TUXML JavaBeansUT... 6 TUXML SQL UtilityUT... 7 TUXSQL Pages UT... 7 TUSOAP UT... 8 TUTransX UT... 8 TUXML UT... 9 TUXML SQL UT TUOCI XML DB UT TUOracle XDK 10g XSLTUT TUXSLT C/C++ VMUT TUJava XSLT 2.0 UT TU XML UT TU XML UT TU UT Oracle Database 10g XML 2

3 Oracle Database 10g XML XML 2001 XML XML XML XML XML XDK Oracle XML Developer's Kit Oracle Database 10g XML XML XDK XMLType XML 2001 XML XML XML XML XML Oracle Database 10g XML 3

4 XML XML SMP Windows XML Web XML XML XML XML PDA XML Oracle Database 10g XML XML XDK XML Oracle XML Developer's Kit 10g XML Oracle Database 10g XDK Oracle XML Developer's Kit XDK XML XML Oracle XDK Oracle Database 10g XML 4

5 Oracle XDK XDK Java Java Beans C/C++ XDK C/C++ Oracle XDK XDK Java Oracle Database 10g JDK 1.4 JVM Oracle Application Server XDK C C++ XML Oracle XDK Oracle Oracle XDK OTN Oracle Technology Network XML Forum Oracle XML XDK Oracle XDK Oracle XDK XDK XDK XML /XSL Oracle XDK Java C C++ XML XML SAX Simple API for XML DOM Document Object Model JAXP Java API for XML Processing XML Oracle Oracle Database 10g XML 5

6 XSL XML Stylesheet Language XML XSLT XSL Transformation XSLT XML XSL XML XML HTML Oracle XDK 10g C XSLT Java XSLT XPath 2.0 Oracle XDK 10g DOM 3.0 Load and Save DOM 3.0 Validation XML XML XML XML W3C XML Java C C++ XML C XMLType XML Oracle XDK 10g XML Class Generator XDK XML XML XML Class Generator Java C++ XML XSD Java C++ XSD XML Oracle XDK 10g JAXB Java Architecture for XML Binding 1.0 Oracle XML JavaBeans XML Oracle JDeveloper XDK Java Beans Beans XDK 1 Oracle Database 10g XML 6

7 1: Oracle XDK 10g Java Beans Oracle XDK 10g Java Beans DOMBuilder Bean XSLTransformer Bean DBAccess Bean XMLDBAccess Bean XMLCompress Bean XMLDiff Bean XSDValidator Bean DOM XML XML XML Oracle XML XML Oracle XMLType XML XMLType XML DOM SAX XML 2 XML XSLT XML XML XSD XML SQL Utility Java PL/SQL XSU XML SQL Utility XML XML XML DTD XSD XSU XMLType SAX Oracle XDK 10g SAX XML XSQL Pages Oracle XSQL Pages XSQL XML Web SQL XML XSLT Web Web 1 Oracle Database 10g XML 7

8 Oracle XDK 10g JSP XSQL XSQLErrorHandler JDBC SOAP Oracle XDK 10g SOAP Simple Object Access Protocol 1.0 Java ASF Apache Software Foundation SOAP XML SOAP Web SOAP Oracle Database 10g Oracle XDK 10g SOAP Oracle Application Server J2EE C C++ SOAP Oracle XDK 10g 2 SOAP W3C SOAP 1.2 W3C SOAP 1.1 SOAP HTTP 1.0 TransX Oracle TransX XML Java API SQL Oracle Database 10g XML 8

9 XML Oracle XDK 10g W3C XML Pipeline Definition Language Version 1.0 Oracle XML XML XML XML XDK Oracle XML Java API book.xml book.xsl Web myresult.html <pipeline xmlns=" xml:base=" <param name="target" select="myresult.html"/> <processdef name="domparser.p" definition="oracle.xml.pipeline.processes.domparserprocess"/ > <processdef name="xslstylesheet.p" definition="oracle.xml.pipeline.processes.xslstylesheetproce ss"/> <processdef name="xslprocess.p" definition="oracle.xml.pipeline.processes.xslprocess"/> =" false"> false"> <process id="p2" type="xslstylesheet.p" ignoreerrors <input name="xsl" label="book.xsl"/> <outparam name="stylesheet" label="xslstyle"/> </process> <process id="p3" type="xslprocess.p" ignoreerrors=" <param name="stylesheet" label="xslstyle"/> <input name="document" label="xmldoc"/> <output name="result" label="myresult.html"/> </process> <process id="p1" type="domparser.p" ignoreerrors="tr ue"> <input name="xmlsource" label="book.xml "/> <output name="dom" label="xmldoc"/> <param name="preservewhitespace" select="true"></param> <error name="dom"> <html xmlns=" <head> <title>domparser Failure!</title> </head> <body> <h1>error parsing document</h1> </body> </html> </error> </process> </pipeline> Oracle Database 10g XML 9

10 XML Java XML 1 XML 1: Oracle XML XML SQL XML XML XML XML XML XML Oracle9i XMLType XML XML XML Oracle Database 10g Oracle XDK 10g SQL XML Oracle Database XML 2 Oracle Database 10g XML 10

11 2: Oracle XDK 10g XML XML Version XML 1.0 Java C C++ XML 1.0 Java C C++ DOM 1.0/2.0 Java C C++ DOM / 3.0 Java SAX + 1.0/2.0 Java C C++ XSLT + XPath 1.0/2.0 Java Java C C++ XML 1.0 Java C C++ SOAP /1.2 C/C++ Java C C++ JAXP 1.2 Java JAXB 1.0 Java OCI XML DB XML Java Oracle XML XML OCI Oracle Database 10g XDK XMLType XOB XMLType DOM XML XML XDK C API DOM DOM API API OCI XDK API 1 /* XML */ params[0].name_ocixmldbparam = XCTXINIT_OCIDUR; params[0].value_ocixmldbparam = &dur; xctx = OCIXmlDbInitXmlCtx(envhp, svchp, errhp, params, 1); /* */ if (!(doc = XmlLoadDom(xctx, &err, "buffer", lpxml_test_sch, "buffer_length", sizeof(tlpxml_test_sch)-1, "validate", TRUE, NULL))) /* */ top = XmlDomGetDocElem(xctx, doc); quux = (xmlnode *) XmlDomCreateElem(xctx,doc, (oratext *) "QUUX"); foo = (xmlnode *) XmlDomCreateElem(xctx, doc, (oratext *) "FOO"); Oracle Database 10g XML 11

12 foo_data = (xmlnode *) XmlDomCreateText(xctx, doc, (oratext *) "foo's data"); foo_data = XmlDomAppendChild(xctx, (xmlnode *) foo, (xmlnode *) foo_data); foo = XmlDomAppendChild(xctx, quux, foo); quux = XmlDomAppendChild(xctx, top, quux); XmlSaveDom(xctx, &err, top, "stdio", stdout, NULL); XmlSaveDom(xctx, &err, doc, "stdio", stdout, NULL); /* my_table */ ins_stmt = "insert into my_table values (:1)"; status = OCITypeByName(envhp, errhp, svchp, (const text *) "SYS", (ub4) strlen((char *)"SYS"), (const text *) "XMLTYPE", (ub4) strlen((char *)"XMLTYPE"), (CONST text *) 0, (ub4) 0, dur, OCI_TYPEGET_HEADER, (OCIType **) &xmltdo)) ; if (status == OCI_SUCCESS) { exec_bind_xml(svchp, errhp, stmthp, (void *)doc, xmltdo, ins_stmt)); } /* xml ctx */ OCIXmlDbFreeXmlCtx(xctx); URL XML XMLType XML Oracle XDK 10g XSLT XML XML XML XSL HTML SVG WML XSLT XSL Transformation Oracle XDK 10g XSLT Oracle Database 10g XML 12

13 XSLT C/C++ VM Oracle XDK 10g C C++ XSLT XSLTVM XSLTVM XSLT CPU XSLT XSL XSLTVM Oracle XDK 10g XSLT 1.0 XSL XML 2 2: XSLT XSLT VM API /* XML */ xctx = XmlCreate(&err,...); /* XML */ comp = XmlXvmCreateComp(xctx); /* XSLT */ code = XmlXvmCompileFile(comp, xslfile, baseuri, flags, &err); /* XSLTVM XSLTVM "...Stack Overflow" (XmlXvmCreate ) */ vm = XmlXvmCreate(xctx, "StringStack", 32, "NodeStack", 24); /* XSLTVM */ len = XmlXvmGetBytecodeLength(code, &err); err = XmlXvmSetBytecodeBuffer(vm, code, len); Oracle Database 10g XML 13

14 /* XML */ err = XmlXvmTransformFile(vm, xmlfile, baseuri); /* */ XmlXvmDestroy(vm); XmlXvmDestroyComp(comp); XmlDestroy(xctx); XML 200% Java XSLT 2.0 Oracle XDK 10g Java XSLT Java XSLT XSLT 2.0 XPath 2.0 XSLT 2.0 XPath 2.0 W3C Last Call Oracle Java XSLT : <xsl:for-each-group> <xsl:sort> : <xsl:variable> <xsl:param> <xsl:with-param> XPath : <xsl:result-document> HTML CSS SVG : <xsl:character-map> <xsl:output-character> JSP Unicode XSL : XSL XPath XPath DOM DOM XML Oracle Database 10g XML 14

15 XML XDK XML SQL DOM Oracle XDK 10g Java SAX SAX XSU SAX XML //Open a File and Initialize connection and SAX print OutputStream out = new FileOutputStream("out.xml"); DriverManager.registerDriver(new oracle.jdbc.driver.oracledriver()); conn = DriverManager.getConnection(thinConn, sh, sh ); XMLSAXSerializer sample = new XMLSAXSerializer (out); //init the OracleXMLQuery OracleXMLQuery qry = new OracleXMLQuery(conn,"select * from sales"); //Print the results qry.getxmlsax(sample); sample.flush(); XML XML XML XML XML SAX Simple API for XML XSLT XSLT DOM Document Object Model Oracle Database 10g XML 15

16 Oracle XDK 10g XML API XML 3 3: XML XML SAX XML XML XML XML SAX XSDValidator.getCurrentMode() LAX STRICT XSDValidator.getElementDeclaration() XSDValidator.getAttributeDeclarations() XML XSDValidator.getAnnotation() XML AQ SOAP Oracle Database 10g Oracle Database 10g XML 16

17 XML xhtml FinML WML MathML OAGIS XML XML 5 Architecture Review Board XML XML Database Application Server XDK XML Developer's Kit Oracle 10g XML XML SQL Oracle Database 10g XML 17

18 Oracle Database 10g XML : Jinyu Wang Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA U.S.A. : : : Copyright 2005, Oracle. All rights reserved. Oracle JD Edwards PeopleSoft Oracle Corporation

Oracle XDK（10.1.2）の技術概要

Oracle XDK（10.1.2）の技術概要 Oracle XDK 10.1.2 2005 1 Oracle XDK 10.1.2... 3... 3 Oracle XML Developer's Kit 10g... 4... 4... 5... 5 XML /XSL... 5 XML... 6 XML Class Generator... 6 XML JavaBeans... 6 XML SQL Utility... 7 XSQL Pages...