DB2 9 Detailed description of XML best practices and related content

This article mainly describes DB2 9 XML best practices. We all know that IBM has done a lot of work to improve XML performance, especially to cope with the increase in data volume and query complexity, however, as with all data management systems, pureXML also requires good settings and some adjustments.

For some suggestions on XML performance tuning, see the section "getting excellent DB2 9 XML query performance" in the relevant content.

The XML database market has been increasingly competitive over the past 10 years, but the IBM hybrid approach is very advanced, which makes XML an inherent part of daily data management. To achieve this goal, IBM has enhanced the features, reliability, and performance of pureXML. IBM first made some research and then made many performance improvements in DB2 9.5.

Although XML has become the main data language on the Internet, IT is actually a standard for data exchange, and has almost become a part of Web Services and SOA, but some DBAs (and even the entire IT department) I am still hesitant to accept it. DB2 9 and pureXML introduce the reliability, scalability, and manageability of relational databases into the DB2 9 XML field, while avoiding the disadvantages of other legacy storage methods. Therefore, IT staff who are skeptical about XML performance should change their mindset.

Related content

Excellent XML query performance

XML applications usually require high performance. The primary responsibility for achieving good performance is the responsibility of Application designers and DBAs. In Matthias Nicla's developerWorks article "DB2 9's 15 best practices for pureXML performance", he explains how to use DB2 9's pureXML technology to produce the best performance. The following summarizes the first five tips.

Rationally select the granularity of the XML document. When designing XML applications and XML document structures, you must determine which business data is included in a single XML document. When selecting between fine granularity, medium granularity, and coarse granularity, you need to consider which granularity the application mainly uses to access and process data. If you are not sure, You should prefer to use smaller granularity and smaller XML documents.

The above content is a description of the DB2 9 XML best practices, hoping to help you in this regard.