DB2 9 's nine daxin characteristics _DB2

Source: Internet
Author: User
Tags db2 db2 client db2 driver ibm db2 create database xquery
The DB2 tutorial that is being looked at is: DB2 9 's nine daxin features.

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. DB2 9 has made 10 major 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.

Also included are other important features: support for many new data types, DB2 unique support to Z/OS? Data server IBM DB2 version 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.

4, Performance and scalability enhancements (storage compression, etc.):

Compressing data objects with data row compression technology can help customers save disk storage space and speed data access.

A statistical view that provides a better access plan for improving query functionality.

Use custom scripts or programs to speed up data loading.

Enhanced materialized query tables (MQTS) provide more robust support for design mqts, better query performance, and improved MQT maintenance.

A larger record identifier (RID) allows each object to have more data pages, with more records per page in the system, which facilitates the use of system and user temporary forms on the one hand, and facilitates classification and logon operations on the other.

The keywords for the index can reach up to 64 groups, and the size can be expanded to 8 KB.

5. New security features and enhancements:

Improve data access control at the row and column levels using tab based access control (LBAC).

The authorization level of the new security Manager (SECADM), which centralizes several security-related priorities to a priority name, and increases control over access to information assets.

The new restrictions option in the CREATE DATABASE statement enhances control of access to the database.

The Setsessionuser priority reinforces the control of the person who has the power to convert the session user's identity. It allows the person in possession of the power to be converted to any given authorization ID.

TRANSFER ownership SQL statements provide the ability to change the ownership of database objects.

6, use the table partition to improve the large database management:

A table partition is a data organization plan in which tabular data is divided into multiple table columns and grouped into a number of storage objects called table partitions or scopes. These storage objects may be stored in different table spaces or in the same table space, or both. Advantages of this new feature include:

The ability to create very large tables. A partitioned table contains far more data than a normal table. Dividing tabular data into many storage objects helps to significantly increase the table size.

More flexible management skills. Customers can now manage their work in individual data partitions, dividing time-consuming maintenance operations into a series of small operations.

Control the index position more precisely. Customers can place indexes in different table spaces and manage them separately.

Fast, easy access to data or data transfer. This feature is particularly useful in data warehousing environments where customers often move or move data in this environment to run queries that support decision making.

Improved query functionality. The function of query processing can be improved by separating data from table partition, avoiding scanning irrelevant data.

7. Data Recovery enhancement:

Restarting an interrupted recovery operation saves valuable time while restoring the database while simplifying the recovery effort.

Support for redirected recovery operations to automatically generate scripts in existing backup mirrors.

The ability to reconstruct the database from a tablespace backup mirror. This feature makes DB2 's recovery more flexible and versatile, while providing customers with a more comprehensive recovery solution.

8, independent Management performance enhancement:

Simplifies memory management with adaptive, self-tuning memory allocations. Self-tuning memory provides dynamic configuration and can respond positively to significant changes in workload characteristics.

When the customer creates the database, the automatic statistics collection function starts automatically. With automated statistical data collection, IBM DB2 version 9 automatically runs the Runstats utility in the background, ensuring that the correct statistics are collected and maintained.

Auto-storage support for multiple partitioned databases. This feature automatically expands the capacity of the database in the disk and file systems, as required.

ALTER TABLE statement enhancements allow customers to change the properties of some tables without having to stop or recreate the table.

The new policy options provide database administrators with new forms and indexes for automatic reorganization.

You can copy the database plan and create the module scenario. Once the database administrator has created the module scenario, they can be used as a template for creating a new view.

The new management SQL routines and views provide a basic, easy-to-use, programmable interface for managing DB2 with SQL.

Dynamic Fast Communication Manager (FCM) buffering and new configuration parameters can be automatically adjusted through the DB2 database Manager.

9, Installation performance enhancement:

New CLI drivers (IBM for ODBC and CLI)? DB2 driver, the customer can install the driver without installing the DB2 client software.

More flexible and effective product licensing management

You can install multiple DB2 versions and patch packs on the same machine.

New response file keywords allow IT staff to install DB2 products without interacting with end users.

Automatic evolution-from Stinger to Viper

Based on the enhancements introduced in version 8.2, the new automated data management features in IBM DB2 9 will continue to help improve the productivity and effectiveness of database administrators.

Some of the key features include:

Adaptive, self-tuning memory allocation feature This new feature simplifies or excludes the configuration of the DB2 server by constantly updating configuration parameters and resizing the buffer pool. Once started, the feature can dynamically allocate available memory resources between different memory consumption points. In Windows and AIX? In the operating system, the self tuning memory function can also determine the database

[1] [2]  next

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.