
Oracle Database 10g XML & SQL: Design, Build, & Manage XML Applications in Java, C, C++, & PL/SQL
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Cover Page
- Oracle Database 10g XML & SQL: Design, Build & Manage XML Applications in Java, C, C++ & PL/SQL
- Copyright Page
- Contents
- Introduction
- Part I Oracle and the XML Standards
- 1 Introducing XML
- What Is an XML Document?
- The Prolog
- The Body
- Well-Formed XML Documents
- Valid XML Documents
- XML Namespaces
- XML and the Database
- Database Schema and XML Documents
- Mapping XML Documents to a Database Schema
- Summary
- 2 Accessing XML with DOM, SAX, JAXB, and StAX
- Parsing and Binding an XML Document
- Accessing XML Using the DOM
- Introducing the DOM APIs
- DOM Level 2
- DOM Level 3
- Oracle DOM APIs in C
- Accessing XML with SAX
- SAX Level 1 and Level 2
- Using SAX APIs
- Oracle SAX APIs in C
- Accessing XML with Java Binding
- The Input XML Schema
- Generating XML Classes
- Binding to an XML Instance
- XML Document Created by Java Application
- Accessing XML with StAX
- Best Practices
- DTD Caching
- Skipping the &!DOCTYPE& Tag
- Cutting and Pasting Across Documents
- 3 Transforming XML with XSLT and XPath
- Programmatic Invocation of the XSLT Processor
- Navigating XML with XPath
- XPath Expressions
- Introducing XSLT Stylesheets
- XSL Templates
- The XSLT Process Model
- &xsl:apply-imports&
- &xsl:apply-templates&
- Introducing XSLT 2.0
- Grouping
- Function Definitions
- Multiple Result Documents
- Temporary Trees
- The Oracle XSLT Extensions
- Useful Built-in Java Oracle XSLT Extensions
- The XSLT Virtual Machine
- XSLT and the Database
- Best Practices
- Tuning Tips for XSLT
- The document() Function in XSLT
- Improving the Overall Performance of XSLT for Multiple Transformations
- 4 Validating XML with DTDs and XML Schemas
- Introducing the DTD
- Validating XML Against DTDs
- Introducing the XML Schema Language
- Simple and Complex Datatypes
- Validating XML with XML Schemas (XSDs)
- XML Document Models and the Database
- Mapping DTDs to Database Schemas
- Mapping XML Documents to a Database Schema
- Supported Database Mappings
- Best Practices
- Designing Your Schema
- Elements vs. Attributes
- Designing Element and Attribute Names
- Loading External DTDs from a JAR File
- 5 XML Operations with XQuery
- Introducing XQuery
- Basics
- Expressions
- Query Prolog
- Introducing XQueryX
- The Oracle XQuery Engine
- Setting Up the Environment
- Testing Your Installation
- Querying XML Documents
- Running in Interactive Mode
- Querying XML from the Command Line
- Querying XML with XQueryX
- XQuery and the Oracle Database
- XQuery API for Java
- Querying XML in the Database
- Best Practices
- XQuery Versus XSLT 2.0
- XQuery Versus SQL/XML
- 6 XML Messaging and RPC with SOAP
- Introducing SOAP
- Literal, Encoded SOAP Messages
- One-Way and Two-Way SOAP Messaging and RPCs
- Using SOAP and the Oracle XDK
- SOAP Client
- SOAP Server
- SOAP Handlers
- Using SOAP and the Oracle Database
- Oracle Streams AQ Support
- AQ Servlet
- Enqueuing and Dequeuing Messages
- Using SOAP from PL/SQL
- Best Practices
- SOAP vs. JAX-RPC
- SOAP vs. JMS
- 7 Putting It All Together with XML Pipeline, JSPs, and XSQL
- Introducing the XML Pipeline Processor
- Multistage XML Processing
- Processing XML with JSPs and XML Beans
- DOMBuilder Bean
- XSLTransformer Bean
- DBAccess Bean
- XMLDBAccess Bean
- XMLDiff Bean
- XMLCompress Bean
- XSDValidator Bean
- Using XML Beans in JSPs
- Introducing the XSQL Page Publishing Framework
- The XSQL Pages
- Installing the XSQL Servlet
- Submitting Queries to the XSQL Servlet
- Transforming the XSQL Output with Stylesheets
- Inserting XML Documents with the XSQL Servlet
- Updating Data with the XSQL Servlet
- Using JSPs and XSQL Pages
- Best Practices
- Creating a More Secure Connection
- When You Need Simple JSP XML Functionality
- Part II Oracle XML Management for DBAs
- 8 Getting Started with the Oracle XML Database
- A Brief History of XML Support in Oracle Database
- Setting Up the Oracle XML Database
- Installing Oracle XML Database
- Installing the Sample Database Schemas
- Creating a User to Run the XMLType Samples
- Setting Up a WebDAV Folder
- What Is the Oracle XML Database?
- XMLType
- XMLType Views
- SQL/XML Processing
- Oracle XML DB Repository
- Oracle Text
- Oracle Advanced Queuing
- XML Database and Standards
- Designing the XML Database
- How to Store XML Data
- How to Retrieve and Generate XML
- How to Search XML Data
- How to Design XML Database for Web Applications
- How to Design XML Database for Messaging Application
- Summary
- 9 Storing XML Data
- Storing XML Documents in CLOB XMLTypes
- Updating and Querying CLOB XMLTypes
- Dealing with Character Encoding for CLOB XMLTypes
- Storing XML Documents in XML Schema-based XMLTypes
- XML Schema Registration
- XML Schema Annotations
- XML Data Loading
- XML Schema Validation
- Oracle XML DB Repository
- Storing XML Documents in Relational Tables
- XML SQL Utility
- TransX Utility
- DBMS_XMLSTORE
- Using External Tables
- Schema Evolution
- Best Practices
- Handling Document Type Definitions
- Creating XML Schema-based XMLTypes
- Specifying Namespaces
- Summary
- 10 Generating and Retrieving XML
- Generating XML from SQL Data with SQL XML Functions
- XMLELEMENT() and XMLATTRIBUTES()
- SYS_XMLGEN()
- XMLFOREST()
- XMLSEQUENCE()
- XMLCONCAT()
- XMLAGG()
- SYS_XMLAGG()
- XMLCOLATTVAL()
- UPDATEXML()
- Generating XML from SQL Data with DBM XMLGEN
- Canonical Mapping
- Print Formatting
- Data Fetching
- Using REF Cursor
- Using Bind Variables
- Dealing with Special Characters
- Retrieving Using XMLType and SQL/XML Functions
- extract() and existsNode()
- EXTRACTVALUE()
- Generating XML Schemas
- Creating XMLType Views
- Processing XML
- Dealing with XML Fragments
- DOM Editing
- Best Practices
- Summary
- 11 Searching XML Data
- XPath-Based Searches
- Searching the XML Document Using XPath
- How XPath-Based Searching Works
- Optimizing XPath-Based Queries Using Indexes
- Full Text Search
- Searching XML Using Oracle Text
- How Oracle Text Search Works
- Optimizing Oracle Text Searches
- Advanced Text Searches
- Best Practices
- When to Use XPath-Based Searches
- When to Use Oracle Text Searches
- When to Use Oracle Text Partitioned Indexes
- Summary
- 12 Managing the Oracle XML Database
- Installed Oracle XML DB Components
- Configuring the Oracle XML DB
- Understanding xdbconfig.xml
- Configuring xdbconfig.xml
- Security Management
- Protecting Data in the Oracle XML DB Repository
- Securing DBUri Operations
- Summary
- Part III Oracle XML for Java Developers
- 13 Getting Started with Oracle XML and Java
- The Oracle XDK Java Libraries
- xmlparserv2.jar
- xml.jar
- xschema.jar
- oraclexsql.jar and xsqlserializers.jar
- xmlcomp.jar, xmlcomp2.jar, xmldemo.jar, and jdev-rt.zip
- xsu12.jar
- classgen.jar
- xdb.jar
- xmlmesg.jar
- transx.zip
- orai18n.jar
- classes12.jar and ojdbc14.jar
- The JDK Environment
- Setting Up the JDK Environment
- Using the XDK with Oracle JDeveloper
- Setting Up an XDK Environment
- Setting Up a Database Connection
- Creating an XDK Component Palette
- Summary
- 14 Building an XML-Powered Web Site
- An XML-Enabled FAQ Web Site
- Designing the Framework
- Creating the FAQ Database
- Designing the FAQ Schema
- Creating a Database User
- Registering the FAQ Schema
- Loading the FAQs
- Connecting the FAQ Web Site to the XML Database
- Building the XSQL Home Page
- Creating the FAQ List
- Filtering the FAQ List
- Adding Pagination to the FAQ Listing
- Displaying the FAQ and Answers
- Creating a Glossary
- Creating the Glossary Schema
- Loading the Glossary
- Linking to the Glossary
- Displaying the Glossary Definitions
- Searching the FAQs
- Summary
- 15 Creating a Portal Site with XML and Web Services
- Designing the Framework
- Designing the Static and Dynamic Areas
- Creating the Dynamic Areas
- Creating the Static Areas
- Adding the Portal Functionality
- Creating the User Schema
- Creating the Login Area
- Creating the User Application Form
- Creating an Administration Page
- Summary
- 16 Developing an XML Gateway Application with SOAP and AQ
- Designing the Framework
- A Conventional Solution
- A Stream-Based One-Step Solution
- Interfacing to the Internet
- Creating the Framework
- Creating the Database Schema
- Creating the XML Purchase Orders
- Creating the XML Messaging Gateway
- Creating the Messaging Schema
- Creating the AQ Agent and Queue
- Creating the AQ PO Process Procedures
- Extending the Framework
- Extending the Application's Functionality
- Submitting SOAP Messages
- Handling of xsi:types in POs
- Generating an E-Mail Confirmation
- Summary
- 17 Developing XML-Based Reusable Components
- Designing the Framework
- Simple Pipeline Examples
- SAX Parsing and Printing
- Parsing and Checking for Differences
- Building the Pipeline Application
- The XSDSchemaBuilder Process
- The XSDValProcess Process
- The XSDConditionalValProcess Process
- Running the Pipeline Application
- Processing an Invalid Document
- Processing a Document That Is Valid Against the Remote Schema
- Processing an Invalid XML Document with Consistent Local and Remote XSDs
- Processing an Invalid Document Against Both Schemas with Change
- Summary
- Part IV Oracle XML for C Developers
- 18 Getting Started with Oracle XML and C
- The Oracle XDK C Libraries
- libxml10.a, libxml10.so, and oraxml10.dll
- libcore10.a, libcoresh10.so, and libcore10.dll
- libnls10.a and oranls10.dll
- libunls10.a and oraunls10.dll
- Setting Up Your C XML Development Environment
- UNIX Setup of XDK C Components
- Checking Your C Run-Time Environment
- Setting Up Your C Compile-Time Environment
- Windows Setup of XDK C Components
- Checking Your C Run-Time Environment
- Setting Up Your C Compile-Time Environment
- Confirming Your C Compile-Time Environment
- Setting Up Microsoft Visual C/C++
- Summary
- 19 Building an XML-Managed Application
- Designing the Framework
- The XML Media Files
- Creating an XML Configuration File
- Defining the XSLT Stylesheets
- Defining the Profiles
- Creating the XSL Stylesheets
- Creating the publishcat Application
- Summary
- 20 Build an XML Database OCI Application
- Designing the Framework
- Setting Up the OCI Application Environment
- The OCI XML Application Headers
- The OCI XML Application Libraries
- The OCI XML Application Make Files
- The Update Application
- Initializing the OCI Application
- Retrieving a DOM of the Record List via OCI
- Performing Unified DOM Operations
- Running the xmlupdate Application
- Summary
- 21 Create an XML-Configured High-Performance Transformation Engine
- Designing the Framework
- Compiling Stylesheets with xslcompile
- Running the XSLT Virtual Machine with xsbtransform
- Summary
- Part V Oracle XML for C++ Developers
- 22 Getting Started with Oracle XML and C++
- The Oracle XDK C++ Libraries
- libxml10.a, libxml10.so, and libxml10.dl
- libcore10.a, libcoresh10.so, and libcore10.dll
- libnls10.a and oranls10.dll
- libunls10.a and oraunls10.dll
- Setting Up Your C++ XML Development Environment
- UNIX Setup of XDK C++ Components
- Checking Your C++ Run-Time Environment
- Windows Setup of XDK C++ Components
- Checking Your C++ Run-Time Environment
- Setting Up Your C++ Compile-Time Environment
- Setting Up Microsoft Visual C/C++
- Summary
- 23 Build an XML Database OCI C++ Application
- Designing the Framework
- Setting Up the C++ OCI XML Application Environment
- The OCI XML Application Headers
- The OCI and C++ XML Application Libraries
- Creating the C++ OCI Helper Class
- Initializing the C++ Database XML Application
- Handling OCI Errors
- Connecting to the Database
- Disconnecting from the Database and Cleaning Up
- Creating the C++ Query Application
- Selecting into an XMLType
- Initializing the XDK for XMLType XOB Access
- Querying an XMLType with the C++ XDK APIs
- Running the Application
- Summary
- 24 Building an XML Data-Retrieval Application
- Designing the Framework
- Building the cppextract Application
- Creating the Generic Functions
- Instantiating the Generic Functions with cppextractForce
- Creating the Main Program with cppextractMain
- Running the cppextract Application
- Running cppextract in Extraction Mode
- Running cppextract in Splitter Mode
- Extending the Framework
- An XML Document Pruning Use Case for cppextract
- A Content-Management Use Case for cppextract
- Summary
- Part VI Oracle XML for PL/SQL Developers
- 25 Getting Started with Oracle XML and PL/SQL
- Setting Up the Environment
- PL/SQL XML Processing Techniques
- Parsing XML
- Processing XML Using DOM
- Processing XML Using XSLT
- Setting Up Oracle JVM
- Summary
- 26 Building PL/SQL Web Services
- Building and Publishing the First Database Web Service
- Setting Up the Database Schema
- Publishing the PL/SQL Web Service Using Oracle JDeveloper 10g
- Calling the Web Service from Clients
- Debugging the Web Service
- Consuming a Web Service Within the Oracle Database
- Constructing SOAP Messages
- Sending Out SOAP Messages Using UTL_HTTP
- Extending the Application
- When to Build Web Services in the Database Server
- Setting Up the Security Protection
- Building Different Types of Web Services
- Summary
- 27 Extending PL/SQL XML Functionality with Java
- Creating the Java Stored Procedure to Process XML
- Implementing the Java Code
- Deploying the Java Code to the Oracle JVM
- Creating the PL/SQL Specification
- Running the Java Stored Procedure
- Simplifying Deployment of Java Stored Procedures Using Oracle JDeveloper 10g
- Processing XML in the Oracle JVM
- Resolving URL References
- SAX XML Processing
- Developing Your Own Java Stored Procedures
- When to Use Java Stored Procedures
- How to Debug Java Stored Procedures
- Summary
- 28 Putting It All Together
- The Oracle XML Platform
- XML Processing Tier Decisions
- Database Design Decisions for XML
- XMLType CLOB
- XMLType Views
- XML Stored in the Oracle XML DB Repository
- Java, C, C++, and PL/SQL Decisions
- Extending the Oracle XML Platform
- A XML Standards Bodies and Open Specifications
- Introducing the W3C Specifications
- W3C XML Specification
- W3C DOM Specification
- SAX Specification
- W3C Namespace Specifications
- W3C XML Schema Specification
- W3C XML Query Specification
- W3C XSLT and XPath Specification
- W3C XML Pipeline Definition Language Specification
- W3C XML Protocol
- Java Community Process Specifications
- Sun JAXB Specification
- Sun JAXP Specification
- Sun StAX Specification
- ISO SQL/XML Specification
- Oracle Technical Resources
- Other Helpful Resources
- Glossary
- Index
- International Contact Information
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.