Two Types of XML Applications

1
Two Types of XML Applications

• Authored XML Documents full XML documents stored
  as BLOBs or CLOBs. Good for static content that
  will only be updated by replacing the entire
  document.
• Generated XML Documents These are XML documents
  that are stored as relational data in tables or
  views the database. This data can then be
  generated back into XML format, dynamically, when
  necessary.

2
(No Transcript)
3
Oracle XML Components
4
Content and Document Management
5
Oracle XML Components

• XDK (XML Developers Kit) for Java XML Parser
  for Java and XSL-T Processor, XML Java Class
  Generator, XSQL Servlet, XML Transviewer Beans,
  XML Schema Processor
• XDK for C XML Parser for C
• XDK for C XML Parser for C
• XML C Class Generator
• XDK for PL/SQL XML Parser for PL/SQL
• XML-SQL Utility (XSU) for Java and PL/SQL

6
The Oracle XML Parser
7
The Oracle XML Parser for Java
8
XML-SQL Utility (XSU)

• Supports queries over richly-structured
  user-defined object types and object views.
• Supports automatic "XML Insert" of
  canonically-structured XML into any existing
  table, view, object table or object view.
• Generate from an SQL query or Result set object a
  text or XML document, a Document Object Model
  (DOM), or a Document Type Definition (DTD).

9
(No Transcript)
10
Running XML-SQL Utility in the Database
11
DB Schema to XML

• Columns are mapped to top level elements
• Scalar values are mapped to elements with
  text-only content
• Object types are mapped to elements with
  attributes appearing as sub-elements.
• Collections are mapped to lists of elements.

12
Loading XML into Database

• Use PL/SQL stored procedures for LOB, such as
  dbms_lob
• Write Java (ProC, C) custom code
• Use sqlloader
• Use Oracle interMedia
• XML-SQL Utility

13
(No Transcript)
14
Document Object Model (DOM)

• Describes a set of language-neutral interfaces
  capable of representing any well-formed XML or
  HTML document.
• From the DOM point of view, the document is the
  object tree, and the XML, HTML,
• The DOM is completely described in IDL, the
  Interface Definition Language used in CORBA.

15
Using Oracle XML Components to Generate an XML
Document - Java Options
16
Using Oracle XML Components to Generate an XML
Document PL/SQL Options