1 / 14

Oracle and XML

Oracle and XML. Nhu Nguyen Thanh-Phu Vu Bob Zhang. Presented by:. Agenda. A. Overview 1. How to apply XML in Oracle Database 2. Advantages and disadvantages B. Oracle Tools for XML-Enabling Database Applications 1. The XML Developer Kit 2. Oracle Text

bly
Download Presentation

Oracle and XML

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle and XML Nhu Nguyen Thanh-Phu Vu Bob Zhang Presented by:

  2. Agenda A. Overview 1. How to apply XML in Oracle Database 2. Advantages and disadvantages B. Oracle Tools for XML-Enabling Database Applications 1. The XML Developer Kit 2. Oracle Text 3. JDeveloper 4. The PLSXML Utility C. FAQ & References Oracle and XML

  3. OverviewHow to apply XML in Oracle Database • Publish/Store XML datagrams from/to Oracle DB • Mapping XML to Database • Table-based Mapping • Only work with limited subset of XML documents • Object-relational (Object-based) Mapping • Mapping DTDs to Object Schemas • Mapping the Object Schemas to Database Schemas Oracle and XML

  4. OverviewHow to apply XML in Oracle Database • Oracle XML SQL Utility -- XSU • Generate an XML document (string or DOM) given a SQL query or a JDBC ResultSet object. • Extract the data from an XML document, then insert the data into a DB table, update a DB table, or delete corresponding data from a DB table. Oracle and XML

  5. OverviewAdvantages • Provide vendor-neutral, platform-agnostic, human readable data exchange format • Ease of use and timesaving centralization of information • Greatly facilitate content maintenance • Easily include only the relevant subset of data to control access Oracle and XML

  6. OverviewDisadvantages • Lack integrated Security • Difficult to maintain large dataset • Inefficient query on XML data (expensive cost of CPU cycles and RAM) • Inefficient locking and concurrent access Oracle and XML

  7. ToolsThe XML Developer Kit (XDK) • Provides XML functionalities for the Oracle database (in Oracle 8i and Oracle 9i.) • Accessible from PL/SQL, Java, C, and C++ applications. • The XDK contains: • XML parser • XSLT processor • XPath engine • XSQL page processor and servlet (only accessible from Java applications) • XML SQL utility Oracle and XML

  8. ToolsOracle Text • Formerly interMedia Text • Uses standard SQL to index, search, and analyze text and documents stored in the Oracle database, files and on the Web. • Searchable documents include the popular formats such as HTML, Microsoft Word, and XML. • For XML documents, can search by tags or attribute values in Oracle 8i release 2 (8.1.6). • Oracle 9i database provides the new xmltype type. Oracle and XML

  9. ToolsJDeveloper • What is it? • Oracle9i JDeveloper is a J2EE™ and XML development environment that is provided by Oracle corporation. • Capabilities for XML • Creates XML documents and checks for syntax. • Works with XSLT stylesheets. • Creates and runs and XSQL pages. Oracle and XML

  10. ToolsThe PLSXML Utility • Is found as the one that adds XML capabilities to Oracle 8.0 or earlier databases. • Is extremely limited in its capabilities. • The PLSXML consists of • DBXML - Format SQL query results as XML document • DBDOM - The most common and useful parts of the DOM API in PL/SQL • DBXSL - XSL transformations in PLSQL Oracle and XML

  11. FAQ • Installing Oracle XML DB • Installing a New Oracle XML DB with DBCA • 2. Installing a New Oracle XML DB Manually Without DBCA • 3. Reinstalling Oracle XML DB Oracle and XML

  12. FAQ • Who should use XML DB? 1. B2B applications 2. Developers of Web Services 3. Internet Applications 4. Content-Management Applications 5. Data- and Application Integrators Oracle and XML

  13. FAQ Why is the oracle building XML DB? 1. Oracle sees great value and promise in XML and wants to use XML. 2. Bring more content and its management into the Oracle platform. 3. Easy to build standards-based applications on the Oracle server. Oracle and XML

  14. FAQ • Oracle XML DB Design Issues • Data • Access • Application Language • Processing • References: • http://www.orafaq.net/faqxml.htm • http://www.xml.com/ • http://www.orafaq.org/faqxml.htm Oracle and XML

More Related