Databases Reference
In-Depth Information
support XML and hence your application can leverage the robustness and
scalability of database systems while maintaining flexibility using XML data.
2.2 pureXML in DB2
pureXML is the brand new technology introduced in DB2 9. pureXML enables
storage of well-formed XML documents in the DB2 column of XML data type. By
storing XML data in XML columns, the data is kept in its native hierarchical form,
rather than stored as text or mapped to a relational data model. Since the new
XML store is 100% integrated with DB2, it leverages the performance, scalability,
reliability, and availability of the DB2 engine.
The new XML data type is really a Structured Query Language (SQL) data type,
so querying XML data is easy and fast. You can access relational and XML data
in the same statement. The new pureXML is also integrated with application
programming interfaces (APIs) such as Java Database Connectivity (JDBC),
Open Database Connectivity (ODBC), .NET, embedded SQL, and PHP, which
open doors for a new breed of Web applications with hybrid access to the
relational and XML data. In this section, we discuss the application design
considerations and benefits of pureXML technology in DB2 with respect to
application development.
2.2.1 When to use DB2 pureXML
DB2 pureXML is suited for any application where some or all of the data
processed by the application is represented using XML. DB2 pureXML storage
provides for high performance ingestion, storage, processing, and retrieval of
XML data. Additionally, it also provides the ability to quickly and easily generate
XML from existing relational data.
The types of applications for which pureXML is particularly well suited include:
Business-to-business and application-to-application (A2A) integration
Internet applications
Content-management applications
Messaging-based applications
Web Services
A typical XML-based application has one or more of the following requirements
and characteristics:
XML documents need to be processed or generated.
High performance querying, both within a document and across a large
collection of documents.
Search WWH ::
Custom Search