Introduction to nine features of IBM database DB2 9 (1)

IBM DB2 9 is the most important achievement of IBM's five-year development project in the database field. It transforms the traditional static database technology into an interactive dynamic data server, this allows you to better manage all types of information, such as documents, video and audio files, images, and webpages. This new data server is the first to achieve seamless interaction between extensible markup language XML) and relational data, without considering the data format, platform, or location.

More than 750 software developers from 8 countries have made great efforts to launch Viper. They have carefully designed and debugged it, strive to make it the preferred information engine in the SOA environment.

IBM DB2 9 has made ten significant advances, including patented "pureXML" technology, groundbreaking "Venom" Storage compression, and enhanced automated data management capabilities.

1. New XML features

Without the need to redefine the XML data format or place it in a large database object, IBM DB2 9 allows users to seamlessly manage common relational data and pure XML data. This capability is unique to Viper and will help customers increase the practicability, speed, and multi-functionality of their information, while greatly reducing management costs related to existing data management technologies. It will also significantly reduce complexity and reduce the time it takes for common developers to create "applications that access link data and XML data at the same time.

The new XML data type allows customers to store standard XML documents in hierarchical table columns.

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

Supports the new XQuery language developed by W3C. IBM DB2 9 allows customers to directly call the XQuery language. The calling function can extract XML data from DB2 tables and views.

Supports the retrieval of XML data, improving the query efficiency for XML documents.

It provides support for XML in the DB2 programming language and allows applications to integrate access and storage of XML and relational data.

2. New applications and development features

Supports application development tools and new features of native XML data storage, 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 stored procedures and user-defined functions. You 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 complies with the JDBC 3.0 specification. It also supports SQLJ statements. The functions and features of SQLJ statements are similar to those of most JDBC methods.

In addition, it also includes other important features: support for a wide range of new data types, DB2's unique support to z/OS-oriented®The reliable connection method, heterogeneous combination, and connection reuse of the Data Server IBM DB2 9.

In addition to Visual Studio 2005, it also supports Web services, local XML data storage, and the ability to build applications and Web sites without coding.

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

3. added the automatic database management function.

Adaptive and Self-tuning memory allocation. By constantly updating configuration parameters, adjusting the buffer pool size, and dynamically allocating available memory resources, you can simplify or eliminate the configuration of the DB2 server.

The DB2 UDB automatic status detection function for z/OS objects allows users to create and change object policies in the control center wizard, automate the evaluation of object Maintenance policies by enabling DB2 UDB for z/OS objects.

Automatic Storage is supported to automatically expand the size of databases in disks and file systems. It can now be used for multi-partition databases.

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

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

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

4. Performance and scalability, enhanced storage compression, etc)

Using row compression technology to compress data objects can help customers save disk storage space and speed up data access.

The statistical data view provides better access plans for improved query functions.

Use custom scripts or programs to speed up data loading.

Enhanced materialized query table MQT can provide enhanced support for MQT design, better query performance, and better MQT maintenance.

A larger record identifier (RID) allows more data pages for each object and more records for each page in the system. On the one hand, it facilitates database administrators to use temporary tables of the system and users, on the other hand, it is easy to perform classification and login operations. The index keyword can be up to 64 groups, and the size can be expanded to 8 KB.

5. New security features and enhancements

Use the label-Based Access Control LBAC) to improve the row-and column-level data access control function.

The authorization level of the new security manager SECADM, which puts several security-related priorities under one priority, improves the control of access to information assets.

The "restriction" option added to the "create database" statement enhances control over database access.

The SETSESSIONUSER priority improves the control of the person with the power to change the session user's identity. It allows the person in charge of this power to convert to any authorized authorization ID.

The transfer ownership SQL statement provides the ability to change the permission of database objects.