Databases Reference
In-Depth Information
High levels of security and easy control over them.
Usage of languages such as Java that support open standards such as SQL,
XML, XQuery, and Extensible Stylesheet Language Transformation (XSLT).
Access to information using standard Internet protocols such as File Transfer
Protocol (FTP), HTTP/Web, or JDBC.
Hybrid access to and ability to query relational and XML data.
Validation of XML documents.
2.2.2 Designing pureXML-based applications
This section discusses the preliminary design criteria you can consider when
planning your DB2 pureXML-based application. Here are several questions to
ask and our recommendations:
Will your data be mostly XML, a combination of relational and XML, or
non-XML?
Deciding how your data storage model will look mostly depends on the kind of
application you are developing and the kind of data it will use. Sometimes, it
might make more sense to store XML data in a relational table and query it
using standard SQL if your XML data is highly regular and queried the same
way over time. Often, you would want to store and represent data as XML
throughout its life.
Will your tables be XML schema-based or non-schema-based?
If your data is XML schema-based, you need to register the schema with DB2
XML schema repository, so that applications can use them to validate the
data. You can experience performance issues if schema validation is used.
How will other applications and users access your XML and other data?
The data access model really depends on the programming interface. DB2
supports the common application programming interfaces to access and
manage XML data in pureXML.
What kind of indexing will best suit your application? Will you need to use
XML value index or full text search index? Or both?
You need to design indexes carefully for high performance data access.
Text-based search or fuzzy search implementation needs to use full text
indexes. This will depend on the nature of the application.
In which languages will you program your application?
Java, .Net, and PHP are the most common languages a Web application
uses. However, you might consider the latest community-developed
Search WWH ::
Custom Search