The nine-DB2 features of IBM Database 9

IBM DB2 9 is the most important result of IBM's five-year development project in the database field, transforming traditional static database technology into an interactive dynamic Data server that enables users to better manage all types of information, such as documents, video and audio files, pictures, Web pages, and so on. The new data server pioneered seamless interaction between Extensible Markup Language (XML) and relational data without having to consider the format, platform, or location of the data.

More than 750 software developers from 8 countries have worked on the advent of "Viper", which has been carefully designed and debugged to make it the preferred information engine in an SOA environment.

IBM DB2 9 has made 10 significant advances, including patented "PureXML" technology, breakthrough "venom" storage compression, and enhanced automated data management capabilities.

1. New XML Features:

IBM DB2 9 allows users to seamlessly manage common relational and pure XML data without having to redefine the format of the XML data or place it in a large database object. This capability is unique to Viper, which will help customers increase the usability, speed, and versatility of their information while significantly reducing the management costs associated with existing data management technologies. It will also significantly reduce complexity and reduce the time that ordinary developers spend creating "simultaneous access to relational data and XML data applications."

A new XML data type that allows customers to store canonical XML documents in a hierarchical table column.

Supports XML data types in SQL statements and Sql/xml functions.

Supports the new XQuery language developed by the World Wide Web Consortium (WWW). IBM DB2 9 allows customers to invoke the XQuery language directly, invoking functionality to extract XML data from DB2 tables and views.

The retrieval function of XML data is supported, and the query efficiency of XML document is improved.

Provides support for XML in programming languages that support DB2, allowing applications to consolidate access and storage of XML and relational data.

2, the new application and development characteristics:

Support for application development tools and native XML data store new features, allowing applications to access and store XML and related data.

DB2 Developer Workbench is a comprehensive development environment that can be used to create, edit, Debug, test, and deploy DB2 storage processes and user-defined functionality. Customers can also use Developer Workbench to develop SQL applications, create, edit, and run SQL statements and XML queries.

The enhanced DB2 driver for JDBC and SQLJ conforms to the JDBC 3.0 specification and also supports SQLJ statements. The functional characteristics of the SQLJ statement are similar to those of most JDBC methods.

In addition, there are other important features: support for many new data types, DB2 unique support to the z/os® data server IBM DB2 9 Reliable connection mode, heterogeneous combination, connection reuse and so on.

In addition to supporting Visual Studio 2005, it includes support for Web services, full support for local XML data storage, and the ability to build applications and Web sites without writing code.

The enhanced DB2 Runtime client supports 64-bit computing and can coexist with other DB2 products on the same computer.

3, new automatic database management functions:

Adaptive, self-tuning memory allocation helps users simplify or exclude the configuration of DB2 servers by constantly updating configuration parameters, adjusting buffer pool size, and dynamically allocating available memory resources.

The DB2 UDB automatic state detection feature for z/OS objects allows customers to automate the evaluation of object maintenance policies for z/OS objects by using the control center creation and Change Object Policy Wizard.

Automatic storage support, which automatically expands the size of databases in the disk and file systems, and is now available for multiple-partition databases.

Automatic statistical data collection, which starts automatically when a new database is created.

According to the environmental characteristics of DB2 database system, the prefetchers process and the page cleaner are automatically configured.

New policy options for automatic table and index reorganization to provide database administrators with more administrative table and index reorganization functions.