XDK Sample Code:
XML Data Streaming for Enterprise Applications Using PL/SQL and SAX

April, 2002

Dealing with XML in enterprise applications, the challenges are how to efficiently handle the huge amount of XML documents too large to be processed in memory and how to allow the dramatic dynamic access and processing of these documents.

In this paper, I will present the strategy of using the SAX interface to stream the XML data into database tables, thereby allowing the user to process the data using PL/SQL and SQL. I will also show how to access and process the data from different database sessions at the same time. The benefits of this strategy are:

• SAX interfaces allows efficient data streaming for large XML documents
• XPATH-based XML Mapping provides XML data indexing
• Makes use of the efficient data management capability of the Oracle database

Prerequisite:

• Oracle Database 8.1.6 and above.
• XML Developer's Kit (Java Package), e.g. xdk_java_9_2_0_2_0.tar.gz

Document

• XML Data Streaming for Enterprise Applications Using PL/SQL and SAX [PDF]

Download the Demonstration

The download includes the installation instructions, Java and SQL source code.

• Download Sample Code

Related Documents

• Oracle9i Java Stored Procedures Developer's Guide
• Oracle9i XML Reference
• Getting Started with XDK for PL/SQL
• Building Server-Side XML Schema Validation from PL/SQL