Oracle Database 10g XML & SQL: Design, Build, & Manage XML Applications in Java, C, C++, & PL/SQL / Edition 1
  • Alternative view 1 of Oracle Database 10g XML & SQL: Design, Build, & Manage XML Applications in Java, C, C++, & PL/SQL / Edition 1
  • Alternative view 2 of Oracle Database 10g XML & SQL: Design, Build, & Manage XML Applications in Java, C, C++, & PL/SQL / Edition 1

Oracle Database 10g XML & SQL: Design, Build, & Manage XML Applications in Java, C, C++, & PL/SQL / Edition 1

by Mark Scardina, Ben Chang, Jinyu Wang
     
 

View All Available Formats & Editions

ISBN-10: 0072229527

ISBN-13: 9780072229523

Pub. Date: 06/28/2004

Publisher: McGraw-Hill Professional Publishing

Written by members of the Oracle XML group, this is a must-have reference for all IT managers, DBAs, and developers who want to learn the best practices for using XML with Oracle’s XML-enabled products. Includes real-world case studies based on the authors’ experience managing Oracle’s XML Discussion Forum--a community of 20,000+ XML component users.

Overview

Written by members of the Oracle XML group, this is a must-have reference for all IT managers, DBAs, and developers who want to learn the best practices for using XML with Oracle’s XML-enabled products. Includes real-world case studies based on the authors’ experience managing Oracle’s XML Discussion Forum--a community of 20,000+ XML component users.

Product Details

ISBN-13:
9780072229523
Publisher:
McGraw-Hill Professional Publishing
Publication date:
06/28/2004
Series:
Oracle Press Series
Pages:
600
Product dimensions:
7.50(w) x 9.20(h) x 1.14(d)

Table of Contents

Introductionxix
Part IOracle and the XML Standards
1Introducing XML3
What Is an XML Document?4
Well-Formed XML Documents7
Valid XML Documents8
XML Namespaces9
XML and the Database11
Database Schema and XML Documents11
Summary14
2Accessing XML with DOM, SAX, JAXB, and StAX15
Parsing and Binding an XML Document16
Accessing XML Using the DOM17
Accessing XML with SAX28
Accessing XML with Java Binding42
Accessing XML with StAX45
Best Practices47
3Transforming XML with XSLT and XPath49
Programmatic Invocation of the XSLT Processor51
Navigating XML with XPath54
Introducing XSLT Stylesheets55
XSL Templates56
The XSLT Process Model56
Introducing XSLT 2.057
The Oracle XSLT Extensions59
The XSLT Virtual Machine60
XSLT and the Database61
Best Practices61
4Validating XML with DTDs and XML Schemas63
Introducing the DTD64
Validating XML Against DTDs66
Introducing the XML Schema Language66
Simple and Complex Datatypes68
Validating XML with XML Schemas (XSDs)73
XML Document Models and the Database75
Best Practices79
5XML Operations with XQuery83
Introducing XQuery84
The Oracle XQuery Engine89
Querying XML Documents91
XQuery and the Oracle Database92
Best Practices93
6XML Messaging and RPC with SOAP95
Introducing SOAP96
Using SOAP and the Oracle XDK99
Using SOAP and the Oracle Database100
Best Practices104
7Putting It All Together with XML Pipeline, JSPs, and XSQL105
Introducing the XML Pipeline Processor106
Processing XML with JSPs and XML Beans108
Introducing the XSQL Page Publishing Framework116
Best Practices125
Part IIOracle XML Management for DBAs
8Getting Started with the Oracle XML Database129
A Brief History of XML Support in Oracle Database130
Setting Up the Oracle XML Database132
What Is the Oracle XML Database?140
XML Database and Standards148
Designing the XML Database149
Summary156
9Storing XML Data157
Storing XML Documents in CLOB XML Types158
Storing XML Documents in XML Schema-based XML Types159
Storing XML Documents in Relational Tables176
Using External Tables184
Schema Evolution185
Best Practices186
Summary188
10Generating and Retrieving XML189
Generating XML from SQL Data with SQL XML Functions190
Generating XML from SQL Data with DBM XMLGEN199
Retrieving Using XML Type and SQL/XML Functions206
Generating XML Schemas209
Creating XML Type Views211
Processing XML212
Best Practices216
Summary218
11Searching XML Data219
XPath-Based Searches220
Full Text Search230
Best Practices239
Summary240
12Managing the Oracle XML Database241
Installed Oracle XML DB Components242
Configuring the Oracle XML DB244
Security Management248
Summary251
Part IIIOracle XML for Java Developers
13Getting Started with Oracle XML and Java255
The Oracle XDK Java Libraries256
The JDK Environment258
Using the XDK with Oracle JDeveloper260
Summary266
14Building an XML-Powered Web Site267
An XML-Enabled FAQ Web Site268
Designing the Framework268
Creating the FAQ Database269
Connecting the FAQ Web Site to the XML Database274
Adding Pagination to the FAQ Listing277
Displaying the FAQ and Answers280
Creating a Glossary283
Searching the FAQs287
Summary288
15Creating a Portal Site with XML and Web Services289
Designing the Framework290
Designing the Static and Dynamic Areas293
Adding the Portal Functionality301
Creating an Administration Page307
Summary311
16Developing an XML Gateway Application with SOAP and AQ313
Designing the Framework314
Creating the Framework317
Creating the XML Messaging Gateway323
Extending the Application's Functionality341
Summary342
17Developing XML-Based Reusable Components343
Designing the Framework344
Simple Pipeline Examples345
Building the Pipeline Application352
Running the Pipeline Application360
Summary362
Part IVOracle XML for C Developers
18Getting Started with Oracle XML and C365
The Oracle XDK C Libraries366
Setting Up Your C XML Development Environment367
Summary374
19Building an XML-Managed Application375
Designing the Framework376
The XML Media Files377
Creating an XML Configuration File378
Creating the XSL Stylesheets383
Creating the publishcat Application386
Summary391
20Build an XML Database OCI Application393
Designing the Framework394
Setting Up the OCI Application Environment395
The Update Application397
Initializing the OCI Application398
Retrieving a DOM of the Record List via OCI401
Performing Unified DOM Operations406
Running the xmlupdate Application407
Summary408
21Create an XML-Configured High-Performance Transformation Engine409
Designing the Framework410
Compiling Stylesheets with xslcompile411
Running the XSLT Virtual Machine with xsbtransform414
Summary418
Part VOracle XML for C++ Developers
22Getting Started with Oracle XML and C++421
The Oracle XDK C++ Libraries422
Setting Up Your C++ XML Development Environment423
Summary431
23Build an XML Database OCI C++ Application433
Designing the Framework434
Setting Up the C++ OCI XML Application Environment435
Creating the C++ OCI Helper Class437
Initializing the C++ Database XML Application438
Handling OCI Errors439
Connecting to the Database440
Disconnecting from the Database and Cleaning Up441
Creating the C++ Query Application443
Selecting into an XML Type444
Initializing the XDK for XML Type XOB Access446
Querying an XML Type with the C++ XDK APIs447
Running the Application449
Summary450
24Building an XML Data-Retrieval Application451
Designing the Framework452
Building the cppextract Application452
Running the cppextract Application459
Extending the Framework460
Summary462
Part VIOracle XML for PL/SQL Developers
25Getting Started with Oracle XML and PL/SQL465
Setting Up the Environment466
PL/SQL XML Processing Techniques466
Setting Up Oracle JVM480
Summary480
26Building PL/SQL Web Services481
Building and Publishing the First Database Web Service482
Consuming a Web Service Within the Oracle Database492
Extending the Application497
Summary499
27Extending PL/SQL XML Functionality with Java501
Creating the Java Stored Procedure to Process XML502
Running the Java Stored Procedure504
Simplifying Deployment of Java Stored Procedures Using Oracle JDeveloper 10g505
Processing XML in the Oracle JVM507
Developing Your Own Java Stored Procedures515
Summary517
28Putting It All Together519
The Oracle XML Platform520
XML Processing Tier Decisions521
Database Design Decisions for XML522
Java, C, C++, and PL/SQL Decisions524
Extending the Oracle XML Platform527
AXML Standards Bodies and Open Specifications529
Introducing the W3C Specifications530
W3C XML Specification530
W3C DOM Specification531
SAX Specification531
W3C Namespace Specifications532
W3C XML Schema Specification532
W3C XML Query Specification532
W3C XSLT and XPath Specification533
W3C XML Pipeline Definition Language Specification533
W3C XML Protocol533
Java Community Process Specifications534
Sun JAXB Specification534
Sun JAXP Specification534
Sun StAX Specification534
ISO SQL/XML Specification534
Oracle Technical Resources535
Other Helpful Resources535
Glossary537
Index549

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >