Sign in  |  Register
Advanced search
Publication Cover

CITATION

Wang, Jinyu. Oracle Database 11g Building Oracle XML DB Applications. US: McGraw-Hill Osborne Media, 2011.

Oracle Database 11g Building Oracle XML DB Applications

Authors: Jinyu Wang

Published:  July 2011

eISBN: 9780071751285 0071751289 | ISBN: 9780071751292
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • PART I BASIC CONCEPTS AND TECHNOLOGIES
  • 1 Introducing Oracle XML DB
  • What Is Oracle XML DB?
  • What Is Provided by Oracle XML DB?
  • What Is Native XML Storage?
  • Well-Formedness Rules
  • XML Encoding
  • Special Characters
  • Summary
  • 2 Native XML Storage: XMLType
  • Creating XMLTypes
  • XML Schema–based XMLType
  • Querying XMLTypes
  • Updating XMLTypes
  • Transforming XMLTypes
  • Reading Binary XMLTypes in Java
  • Summary
  • 3 XML Database Repository
  • Creating Resources
  • Deleting Resources
  • Querying XML DB Repository
  • Using RESOURCE_VIEW and PATH_VIEW
  • Using XDBUriType
  • Linking to Resources
  • Updating Resources
  • Version Control
  • Using XML DB Repository Events
  • Creating Event Handlers
  • Registering Event Handlers
  • Summary
  • 4 Parsing XML
  • DOM Parsing in Java
  • Basic DOM Parsing
  • Splitting XML Using DOM
  • Scalable DOM Parsing
  • Cutting and Pasting Across Documents
  • DOM Parsing in SQL
  • Retrieving and Creating a CDATA Section
  • Importing a DOM Node
  • SAX Parsing
  • Basic SAX Parsing
  • SAX Print
  • Parsing Binary XML
  • Writing XML to Binary XML
  • Reading from Binary XML
  • Summary
  • 5 Validating XML
  • DTD Validation
  • Using Oracle XDK Command-Line Utility
  • Using Oracle XDK Java APIs
  • Using Oracle XML DB
  • XML Schema Validation
  • XML Schema and Namespaces
  • Using Oracle XDK Command-Line Utility
  • Using Oracle XDK Java APIs
  • Using Oracle XML DB
  • Using JAXB with XML Schemas
  • Summary
  • 6 Navigating XML with XPath
  • XPath Basics
  • Processing XPath in Java
  • Extracting XPath from XML Documents
  • Summary
  • 7 XSL Transformations
  • Understanding XSLT Processing
  • Basic XSLT Features
  • Multiple XML Inputs
  • Building an XSL Index
  • Creating XSLT Extensions
  • Advanced XSLT Features
  • Modularizing XSLT Processing with Temporary Trees
  • Merging Duplicates with Grouping
  • Creating Outputs with Multiple Outputs
  • Running XSLT
  • Using Oracle XDK Java
  • Using Oracle XML DB
  • Summary
  • 8 XML Query
  • XQuery Expressions
  • Using XMLQuery()
  • Querying XMLType Objects
  • Querying XML DB Repository
  • Querying Relational Tables
  • XQuery Beyond the Basics
  • Using Functions
  • Nested XQuery Expressions
  • Numeric Calculations
  • Oracle XQuery Extensions
  • ora:contains()
  • ora:matches()
  • ora:replace()
  • Summary
  • 9 XML and Relational Tables
  • Creating XML from Relational Tables
  • Using SQL/XML Functions
  • Using XQuery
  • Using DBMS_XMLGEN or XMLType()
  • Using Oracle XDK Java
  • Creating a Relational View on XML Data
  • Loading XML into Relational Tables
  • Loading Excel Spreadsheet Content into Relational Tables
  • Loading XML Data
  • Summary
  • 10 Searching XML
  • Using ora:contains()
  • Using Oracle Text
  • Basic Oracle Text Search on XML
  • Using XML Section Groups
  • Indexing Oracle XML DB Repository
  • Using Oracle Secure Enterprise Search
  • Preparing the Index Data
  • Creating a Database Data Source
  • Crawling the XML Data
  • Enabling XML Content Navigation
  • Creating a Source Group
  • UI Customization
  • Searching XML
  • Refining the Search Result Cache
  • Summary
  • PART II MANAGING ORACLE XML DATABASE
  • 11 XML DB Installation
  • Installing Oracle XML DB
  • Simple Installation Review
  • Detailed Installation Review
  • Installing Oracle XML DB
  • Reinstall Oracle XML DB
  • Set Up XML DB Repository
  • Installing Oracle XDK
  • Validate Oracle XDK Installation
  • Set Up Oracle XDK Command-line Utilities
  • Summary
  • 12 XML DB Storage
  • XML Storage Options
  • Object-Relational XMLType
  • Binary XMLType
  • Creating Binary XMLType
  • Partitioning Binary XMLType
  • XMLIndex on Binary XMLType
  • Managing XML DB Storage
  • XMLType Tables and Columns
  • XMLType Views
  • XML Schemas
  • XML DB Repository
  • XML Indexes
  • Summary
  • 13 XML DB Backup and Recovery
  • Back Up XML DB with RMAN
  • Back Up in NOARCHIVE Log Mode
  • Back Up in Archive Log Mode
  • Importing and Exporting XML with Data Pump
  • XMLType Stored as a Table Column
  • XMLType Tables
  • XML Schema–based XMLType Tables and Columns
  • Summary
  • 14 XML DB Security and Performance Tuning
  • Oracle XML DB Security
  • XML DB Repository ACLs
  • Setting Up ACL for Network Services Access
  • Oracle XML DB Performance Tuning
  • Basic XML Processing Performance
  • Bulk XML Loading Performance
  • XQuery Performance Tuning
  • Summary
  • PART III BUILDING XML APPLICATIONS
  • 15 XML DB Web Services
  • Setting Up XML DB Web Services
  • Querying Oracle Database with Web Services
  • Publishing PL/SQL Functions/Procedures
  • Creating PL/SQL Packages and Functions
  • Reviewing the WSDL of the PL/SQL Function
  • Calling PL/SQL XML DB Web Services in Java
  • Summary
  • 16 Using Oracle JDeveloper 11g
  • Creating the First XML Project
  • Creating XML Documents
  • Validating XML with XML Schema
  • Transforming XML with XSLT
  • Running Oracle XML Java Program
  • Creating Java Stored Procedures: Basics
  • Setting Up Oracle Java Virtual Machine
  • Creating the Java Program
  • Creating Database Connections
  • Deploying Java Stored Procedures
  • Creating PL/SQL Specifications
  • Running Java Stored Procedures
  • Remote Debugging of Java Stored Procedures
  • Creating Java Stored Procedures: Advanced Topics
  • Summary
  • 17 Pulling It All Together
  • Creating XML Documents
  • Storing XML in XML DB Repository
  • Creating an SQL View
  • Adding Contact IDs
  • Reformatting the Data String
  • Publishing XML in APEX
  • Creating a Report
  • Editing XML
  • Displaying XML
  • Exporting Contacts
  • Integrating with Full-Text Search
  • Sending Emails Using Oracle XML DB
  • Creating an Email Template
  • Selecting an Email Template
  • Previewing Emails
  • Sending Emails
  • Summary
  • A Installing Oracle Application Express in Oracle Database 11g
  • Configuring Oracle APEX
  • Step 1: Check APEX Installation in Oracle Database 11g
  • Step 2: Check DAD Setup
  • Step 3: Configure Oracle APEX in Oracle Database 11g
  • Step 4: Unlock the ANONYMOUS User
  • Step 5: Set Up Oracle Database HTTP Server
  • Step 6: Set Up ACL Security
  • Step 7: Validate APEX Access
  • Uninstalling Oracle APEX
  • Reinstalling Oracle APEX
  • Step 1: Install Oracle APEX and Set Up DAD
  • Steps 2–7: Set Up DAD, Configure APEX in DB, and More
  • Setting Up APEX Development Environment
  • Creating a Workspace
  • Index