Oracle Database 11g : building Oracle XML DB applications / Jinyu Wang.

Format:

Book

Author/Creator:

Wang, Jinyu, 1972- author.

Series:

Oracle Press.

Oracle Press

Language:

English

Subjects (All):

Oracle (Computer file).

Database management.

XML (Document markup language).

Application software--Development.

Application software.

Relational databases.

Physical Description:

1 online resource (xvi, 396 p.) : ill.

Edition:

1st edition

Other Title:

Building Oracle XML DB applications

Place of Publication:

New York : McGraw-Hill, [2011]

Language Note:

English

System Details:

text file

Summary:

Master the XML Programming Features in Oracle Database 11 g Develop, debug, and administer data-backed XML applications using the expert instruction and best practices in this Oracle Press guide. Oracle Database 11g: Building Oracle XML DB Applications discusses the latest development tools, technologies, and components. Find out how to set up Oracle XML Database (Oracle XML DB), build XML applications in Oracle JDeveloper 11 g , work with XSLT stylesheets, and incorporate full-text search. Troubleshooting, performance tuning, and security are also covered in this comprehensive resource. Create, store, and query XML types using Oracle XML DB Load XML documents into relational tables and define SQL views Parse and validate schema with Oracle XDK for Java and PL/SQL packages Merge documents, generate reports, and transform data using XSLT Construct applications from Oracle XML DB Web services Use Oracle JDeveloper 11 g to design and deploy XML applications Integrate Oracle Text and Oracle Secure Enterprise Search features Streamline the development process using Oracle Application Express

Contents:

Cover

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

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

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

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 JAXB with XML Schemas

6 Navigating XML with XPath

XPath Basics

Processing XPath in Java

Extracting XPath from XML Documents

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

8 XML Query

XQuery Expressions

Using XMLQuery()

Querying XMLType Objects

Querying Relational Tables

XQuery Beyond the Basics

Using Functions

Nested XQuery Expressions

Numeric Calculations

Oracle XQuery Extensions

ora:contains()

ora:matches()

ora:replace()

9 XML and Relational Tables

Creating XML from Relational Tables

Using SQL/XML Functions

Using XQuery

Using DBMS_XMLGEN or XMLType()

Creating a Relational View on XML Data

Loading XML into Relational Tables

Loading Excel Spreadsheet Content into Relational Tables

Loading XML Data

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

PART II MANAGING ORACLE XML DATABASE

11 XML DB Installation

Installing Oracle XML DB

Simple Installation Review

Detailed Installation Review

Reinstall Oracle XML DB

Set Up XML DB Repository

Installing Oracle XDK

Validate Oracle XDK Installation

Set Up Oracle XDK Command-line Utilities

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

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

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

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

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

17 Pulling It All Together

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

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.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on print version record.

ISBN:

9786613357823

9781283357821

1283357828

9780071751285

0071751289

OCLC:

1024274943