Oracle XML DB 2005 8
Oracle XML DB... 3 XML... 4 XCM... 5 XML... 6... 6... 7... 7... 7... 8... 8... 8... 8... 8 Oracle XML DB... 9... 9... 12... 12... 13... 14 XML... 14... 15... 15 Oracle XML DB... 16 XDB... 16... 17... 18 Oracle XML DB XCM... 19... 19... 23... 27... 28... 30 XML... 31... 31... 31 TV Web... 31... 32... 34 Oracle XML DB 2
Oracle XML DB IT CM 1980 1980 1990 PC PC MS-Word Word-Perfect 1990 WWW World Wide Web Web Web Web Web HTML 2000 Oracle XML DB 3
XML XML XML XCM CM XCM CM XML 10 CD HTML PDF Flash XCM XML XML SQL XML XCM Microsoft Office 2 003 Altova Authentic Web XML Blast Radius X-Metal XML Abortext EPIC Adobe Frame W3C XML XML XML XCM XML W3C: World Wide Web Consortium XPath XQuery ANSI/ISO SQL:2003 XCM XCM XML Schema Oracle XML DB 4
XML XML XML HTML PDF WAP XCM XML XML XML XML XCM XCM OASIS OGM XML XML XCM RSS NewsML XML XML PDF XCM Securities & Exchanges Commission Financial Services Authority XML Business Reporting Language XBRL XBRL XCM XBRL XCM XML Oracle XML DB 5
XML XML XCM XML XCM Web Web RSS XML XCM XCM XML XML XCM XCM XCM Microsoft Office Altova Macromedia Adobe XCM Oracle XML DB 6
XML XML XML Schema XCM XML Schema W3C XML Schema XML http://www.w3.org/tr/xmlschema-0/ W3C XML Schema XML XML Schema XML XML Schema XML Document Type Definition DTD XML Schema XML XML Schema XML Schema XML Schema XCM XCM XCM Oracle XML DB 7
XCM XML Schema 1 XCM XCM XCM API XCM API XCM XML XCM XCM Oracle Database 10g Release 2 XML DB Repository XML DB WebDAV XML Oracle XML DB Oracle XML DB Oracle XML DB 8
Oracle XML DB Oracle XML DB Oracle XML DB Oracle Database 10g Release 2 XCM Oracle XML DB HTTP WebDAV FTP Microsoft Windows WebDAV Oracle XML DB XCM Oracle XML DB Microsoft Office Oracle XML DB WebDAV IETF WebDAV HTTP HTTP WebDAV DAV HTTP WebDAV WebDAV URL Oracle XML DB Oracle XML DB XML WebDAV Microsoft Windows Explorer Oracle XML DB Microsoft Oracle XML DB Microsoft Explorer Microsoft Windows My Network Places Oracle XML DB Oracle XML DB 9
URL Network Place Microsoft Windows Explorer Windows Microsoft Word 2003 Oracle Database10g Release 2 Oracle XML DB 10
Web HTTP WebDAV FTP Oracle XML DB Web Oracle XML DB Altova StyleVision Microsoft Office 2003 Web Oracle XML DB 1 WebDAV http://xmlns.oracle.com/xdb/xdbresource.xsd XML Schema Oracle XML DB 11
XML Oracle XML DB XML Schema 1 XML Schema Oracle XML DB XML XML Oracle XML DB XML Schema XML XML Schema Oracle XML DB WebDAV ACL 1 ACE ACE 1 ACL ACE 1 ACL 1 1 Oracle XML DB Oracle XML DB ACL ACL XML Schema ACL Oracle 10g XML DB SQL ACL Oracle XML DB 12
Oracle XML DB ACL XML Oracle XML DB ACL XML Schema XML ACE Oracle Internet Directory OID Oracle XML DB 4 ACL /sys/acls ACL Oracle XML DB ACL Oracle XML DB ACL Oracle XML DB WebDAV PL/SQL Oracle XML DB 13
Web Oracle Database 10g Release 2 Oracle XML DB 1 XML XML DB XML Oracle XML DB XML XML Oracle Database 10g Release 2 Oracle XML DB Oracle XML DB 14
XML Oracle XML DB Oracle Text XML XML Oracle XML DB Oracle XML DB SQL PL/SQL Oracle XML DB SQL Java C C++ C# Visual Basic J# Oracle XML DB SQL Oracle XML DB Oracle XML DB RESOURCE_VIEW PATH_VIEW 2 SQL SQL 1 Web Oracle XML DB Web Web Oracle XML DB JSR 170 Java Content Management API Oracle XML DB XCM XML Oracle XML DB Oracle XML DB XSLT XSLT Virtual Oracle XML DB XML XHTML PDF XML DB PDF Oracle XML DB 15
Oracle XML DB XML Views XML View XML Repository XML XML Views SQL:2003 SQL/XML XML Oracle XML DB Oracle XML DB Oracle Database 10g Release 2 3 XDB XDB XDB XDB XDB$RESOURCE XDB$RESOURCE XMLType 1 XML http://xmlns.oracle.com/xdb/xdbresource.xsd XML Schema RESOURCE_VIEW PATH_VIEW RES XDB ACL XML Oracle XML DB 16
XDB XDB$RESOURCE LOB XML Schema XML XDB$RESOURCE XMLType Oracle XML DB XML Schema XMLType 1 XML DB PL/SQL DBMS_XDB DBMS_XDB_VERSION DBMS_XDBZ DBMS_XDBT ACL Oracle XML DB Oracle Text Oracle XML DB Oracle Database 10g Release 2 HTTP FTP SQL*NET HTTP FTP Oracle XML DB 17
HTTP FTP XDB HTTP FTP WebDAV Oracle NET Oracle XML DB HTTP WebDAV HTTP FTP quot Oracle XML DB Oracle XML DB XCM XDB$HI_TABLE Oracle XML DB Oracle XML DB 18
Oracle XML DB XCM Oracle XML DB XML Oracle XML DB HTML Oracle Database 10g Release 2 Oracle XML DB Java XML DB HTTP Oracle XML Java JNDI JDBC PL/SQL XML DB JNDI JNDI JDBC RESOURCE_VIEW PATH_VIEW DBMS_XDB JNDI API JDBC PL/SQL Oracle XML DB 19
FolderProcessor : UploadFiles : Multipart Mime HTML NewFolder : SelectionProcessor : VersionHistory : Java Source XSL XML DB WebDAV Oracle JVM Oracle XML DB HTTP PL/SQL Java Oracle OC4J Oracle Internet Application Server Java Oracle XML DB XSLT XSLT XML HTML View XML View XSL XML XSL Oracle XML DB 20
XCM Oracle XML DB 21
FolderProcessor XML XML XSLT XML XSL Oracle XML DB 22
Oracle XML DB 1 XML Schema XMLType XML XMLType XMLType XML XML Oracle XML DB Exchangeable Image File Format EXIF EXIF JPEG Oracle Database 10g Release 2 Intermedia EXIF JEPG EXIF Intermedia XML JPEG Oracle XML DB Intermedia Image Image EXIF Intermedia XML Oracle Database 10g Release 2 EXIF EXIF Oracle XML DB XML Schema EXIF Oracle Database 10g Release 2 EXIF XML XML Schema imagemetadata RESID imageurl Title Description exifmetadata XML Schema exifmetadata Intermedia EXIF XML Schema Oracle XML DB 23
<xs:schema targetnamespace="http://xmlns.oracle.com/demo/imagemetad ata" elementformdefault="qualified" attributeformdefault="unqualified" xmlns:xdb="http://xmlns.oracle.com/xdb" xmlns:xs="http://www.w3.org/2001/xmlschema" xmlns:exif="http://xmlns.oracle.com/ord/meta/exif" xmlns="http://xmlns.oracle.com/demo/imagemetadata"> <xs:import namespace="http://xmlns.oracle.com/ord/meta/exif" schemalocation="http://xmlns.oracle.com/ord/meta/exif"/> <xs:element name="imagemetadata" type="imagemetadatatype" <xs:complextype name="imagemetadatatype" <xs:sequence> <xs:element name="resid" type="xs:string"/> <xs:element name="imageurl" type="xs:anyuri"/> <xs:element name="title" minoccurs="0"> <xs:simpletype> <xs:restriction base="xs:string"> <xs:maxlength value="80"/> </xs:restriction> </xs:simpletype> </xs:element> <xs:element name="description" type="xs:string" minoccurs="0"/> <xs:element ref="exif:exifmetadata"/> XML Schema XML Schema XML DB EXIF Oracle XML DB JPEG Oracle 10g R2 Advanced Queuing AQ PL/SQL Resource ID EXIF 1. Resource ID 2. Intermedia EXIF exifmetadata 3. exifmetadata imagemetadata 4. DBMS_XDB imagemetadata Oracle XML DB 24
PL/SQL create procedure addimagemetadata(resource_id RAW) as EXIF_METADATA xmltype; IMAGE_METADATA xmltype; IMAGE_METADATA_NAMESPACE VARCHAR2(128) := 'http://xmlns.oracle.com/demo/imagemetadata'; VIRTUAL_PATH varchar2(256); TARGET_PATH varchar2(256); XMLREF ref xmltype; begin select ANY_PATH into TARGET_PATH from RESOURCE_VIEW where RESID = RESOURCE_ID; VIRTUAL_PATH := dbms_xdb.createoidpath(resource_id); begin select value(metadata) into EXIF_METADATA from table ( ordsys.ordimage.getmetadata ( xdburitype(virtual_path).getblob(), 'EXIF' ) ) METADATA; Exception -- JPEG Image did not contain EXIF meta-data. when no_data_found then null; end; select xmlelement ( "img:imagemetadata", xmlattributes ( IMAGE_METADATA_NAMESPACE as "xmlns:img", XDB_NAMESPACES.EXIF_NAMESPACE as "xmlns", 'http://www.w3.org/2001/xmlschema-instance' as "xmlns:xsi", IMAGE_METADATA_NAMESPACE ' &4' as "xsi:schemalocation" ), XmlElement("img:RESID",null), xmlelement("img:imageurl",virtual_path), EXIF_METADATA ) into IMAGE_METADATA from dual; dbms_xdb.appendresourcemetadata(target_path,image_metadata); Oracle XML DB 25
XML Oracle XML DB 26
XCM XML DB SelectionProcessor 1 UploadFiles Oracle XML DB UploadFiles VersionHistory VersionHistory Oracle XML DB 27
XCM XSLT XCM mime XML XML Schema XSLT PurchaseOrder PurchaseOrder HTML Oracle XML Publisher PurchaseOrder XSLT HTML HTML RTF PDF Oracle XSQL Oracle XML DB 28
PDF RTF PurchaseOrder Oracle XML DB 29
XCM UploadFiles FTP WebDAV Access Control List Access Control List SelectionProcessor Oracle XML DB Bootstrap ACL ALL_ALL_ACL.xml ALL_OWNER_ACL.xml BOOTSTRAP_ACL.xml XDBADMIN RO_ALL_ACL.xml Oracle XML DB 30
XML 1 E-Government XML XML Schema DTI DTI XML Schema 2 Web XML Editor XML Altova Style-vision Excel Web Oracle Database 10g Release 1 Oracle XML DB XML Web API DTI Oracle Discover XML Oracle Application Server 10g Oracle XML DB XML Altova Stylevision XML Editor XSL XML XML SQLX Web HTML self-referential SQLX XML XSL Web Oracle Portal TV Web TV Web XUL XML Web Web Web 1 http://www.govtalk.gov.uk/schemasstandards/schemasstandards.asp Oracle XML DB 31
Oracle XML DB Apache Cocoon Web Oracle XML DB Web 1 XML 2 Oracle XML DB XML X-Metal X-Metal Blast Radius XML Schema XML X-Metal X-Metal XML XML Schema X-Metal Red-lining WebDAV X-Metal Oracle Database 10g Release 1 Oracle XML DB XML Schema Oracle XML DB Web X-Metal 203,000 XML Oracle XML DB 1 1,000 Oracle XML DB 32
XSL/FO PDF Render/X XSL FO Oracle XML DB 33
XCM XML XCM Oracle XML DB 34
Oracle XML DB 2005 8 : Mark D Drake Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. : : +1.650.506.7000 : +1.650.506.7200 www.oracle.com Copyright 2005, Oracle. Oracle Oracle Corporation