《www.hygy1688.com衬塑复合管 涂塑复合管 钢塑复合管-An Overview》.ppt

XML and Oracle: An Overview Roger Schrag Database Specialists, Inc. XML and Oracle: An Overview XML Basics XML’s Potential Support for XML in Oracle Products What Is XML? A standard for representing structured data in human-readable text form Any type of data can be represented in XML Syntax uses open and close tags similar to HTML Use tags common in your industry or make up your own XML Basics XML Documents Document Type Definitions Document Object Model Simple API for XML Transformations XML Documents A Sample XML Document Document Type Definition (DTD) What tags are allowed What attributes are allowed within each tag Which elements are required and which are optional Which tags may be nested inside of other tags A Sample DTD What Can You Do With An XML Document? Anything you can do with a plain text file: Edit it with vi or Notepad Move it between servers with FTP or HTTP Store it in a VARCHAR2 or CLOB column in your Oracle database What Else Can You Do With An XML Document? Store it in a SYS.xmltype column in your Oracle 9i database View it with a web browser (IE 5 or Netscape 6) View and edit it with JDeveloper Validate it against a DTD Document Object Model (DOM) Uses a tree structure known as a document’s infoset Extract the infoset from an XML document Query the infoset using a search API called XPath Make changes to the infoset Write the infoset back to an XML document Simple API for XML (SAX) Documents are represented as a linear sequence of parse events Events occur at the start and end of elements and text Application provides custom event-handlers Application code gets executed at specified events in document XML Stylesheet Language for Transformation (XSLT) A process for transforming XML documents: From one DTD to another Between XML and other formats such as HTML or proprietary flat file formats XML’s Potential Why all the excitement over XML? Strict yet extensible standards XML + HTTP XML Standards XML 1.0 specification defines XML and DTD s