Introduction to the ten features of IBM database DB2 9 (1)

Introduction: IBM database DB2 9It is an important achievement in the development history of databases and brings a new dawn to the development of databases. This article mainly introduces the top ten features of IBM database DB2 9, so that you can better understand the IBM database DB2 9.

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 the World Wide Web Consortium (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. Enhanced Performance and scalability (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) provides 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 systems 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 label-based access control (LBAC) to improve row-and column-level data access control.

The authorization level of the new Security Manager (SECADM) puts several security-related priorities under a priority name, improving 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.