This new data server is the first to enable seamless interaction between Extensible Markup Language (XML) and relational data without considering the format, platform or location of the data. More than 750 software developers from 8 countries have made efforts to the advent of "Viper". They have carefully designed and debugged it to make it the preferred information engine in the SOA environment. DB2 9 has made ten 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 redefining the format of XML data or placing it in database large objects. This capability is unique to Viper and will help customers increase the practicality, speed and versatility of their information while greatly reducing the management costs associated with existing data management technologies. It will also significantly reduce complexity and reduce the time it takes for the average developer to create “apps that access both relational and XML data”.
New XML data type that allows customers to store canonical XML documents in a hierarchical table bar.
Supports XML data types in SQL statements and 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, and the calling function can extract XML data from DB2 tables and views.
Supports XML data retrieval function, improving the query efficiency of XML documents.
Provides support for XML in DB2-enabled programming languages, allowing applications to integrate access and storage of XML and relational data.
2. New application and development features:
Support for 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 an integrated development environment that can be used to create, edit, debug, test and deploy DB2 storage processes and user-defined functions. Customers can also use Developer Workbench to develop SQL applications, creating, editing, and running SQL statements and XML queries.
Enhanced DB2 drivers for JDBC and SQLJ comply with the JDBC 3.0 specification and also support SQLJ statements.
The functional characteristics of SQLJ statements are similar to most JDBC methods.
In addition, it also includes other important features: support for many new data types, DB2 unique support for z/OS? Data server IBM DB2 version 9 reliable connection methods, heterogeneous combinations, connection reuse, etc. In addition to supporting Visual Studio 2005, it also includes support for web services, comprehensive 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 also coexist with other DB2 products on the same computer.
3. Added automatic database management function:
Adaptive, self-modulated memory allocation helps users simplify or exclude configuration work of DB2 servers by constantly updating configuration parameters, adjusting buffer pool size and dynamically allocating available memory resources. The DB2 UDB automatic state detection function for z/OS objects allows customers to automate object maintenance policy evaluation through the Control Center's Create and Change Object Policy Wizard to z/OS objects.
Automatic storage support, which can automatically expand the size of databases in disk and file systems, and is now available for multi-partition databases.
Automatic statistics collection, and will start automatically when creating a new database.
According to the environment characteristics of the DB2 database system, the prefetchers process and page cleaner are automatically configured.
New policy options for automatic table and index reorganization provide database administrators with more functions to manage table and index reorganization.
4. Performance and scalability enhancement (storage compression, etc.):
The ability to compress data objects using data line compression technology can help customers save disk storage space and speed up data access.
Statistics view, providing better access plans for improved query capabilities.
Use customized scripts or programs to speed up data loading.
Enhanced materialized query tables (MQTs) provide more powerful support for designing MQTs, better query performance and more complete MQT maintenance.
A larger record identifier (RID) allows each object to have more data pages and each page in the system has more records. On the one hand, it provides convenience for database administrators to use temporary forms of the system and users, and on the other hand, it also facilitates classification and login operations.
The indexed keywords can reach up to 64 groups and can be expanded to 8 KB in size.
5. New security features and enhancements:
Use tag-based access control (LBAC), and perform data access control functions at the column level.
The authorization level of the new Security Manager (SECADM) concentrates several security-related priorities under one priority, increasing control over access to information assets.
The new "restriction" option added in the "Create Database" statement enhances control over entry into the database.
SETSESSIONUSER priority strengthens control over those who have the authority to convert the session user identity. It allows the person who holds the authority to convert to any authorization ID that is granted.
The TRANSFER OWNERSHIP SQL statement provides the ability to change the ownership of database objects.
6. Use table partitioning to improve large database management:
Table partitioning is a data organization plan in which table data is divided into multiple storage objects called table partitions or ranges according to multiple table columns. These storage objects may be stored in different tablespaces or the same tablespace, or both. Advantages of this new feature include:
Ability to create very large tables. Partitioned tables contain far more data than ordinary tables. Dividing tabular data into numerous storage objects helps significantly increase table size.
More flexible management capabilities. Customers can now complete management work in individual data partitions, dividing time-consuming maintenance operations into a series of small operations.
More precise control of index position. Customers can place indexes in different tablespaces and manage them separately.
Quickly and easily access or transfer data. This feature is especially useful in a data warehouse environment where customers often move data in or out of the environment and run queries that support decisions.
Improved query functionality. Separate data by table partitioning to avoid scanning of unrelated data, thereby improving the query processing function.
7. Data recovery enhancement:
Restarting interrupted recovery operations can save valuable time when database recovery while simplifying recovery efforts.
Supports redirect recovery operations, automatically generate scripts in existing backup images.
Ability to rebuild the database from the tablespace backup image. This feature makes DB2 recovery more flexible and diverse, while providing customers with a more comprehensive recovery solution.
8. Autonomous management performance enhancement:
Use adaptive, self-tuning memory allocation to simplify memory management. Self-tuning memory provides dynamic configurations that can positively respond to major changes in workload characteristics.
When a customer creates a database, the automatic statistics data collection function will be automatically activated. With automatic statistics collection, IBM DB2 version 9 automatically runs the RUNSTATS utility in the background to ensure that the correct statistics are collected and maintained.
Automatic storage support for multi-partition databases. This function can automatically expand the capacity of databases in disks and file systems as required.
ALTER TABLE statement enhancement allows customers to change the properties of some tables without stopping or recreating them.
The new policy options provide database administrators with new automatic table and index reorganization capabilities.
You can copy the database plan and create a module plan. Once the database administrator has created the module scheme, they can use it as a template for creating a new view.
The new management SQL routines and views provide a basic, easy-to-use programmable interface to facilitate the management of DB2 with SQL.
Dynamic Fast Communications Manager (FCM) buffering and new configuration parameters can be automatically adjusted through the DB2 database manager.
9. Installation performance enhancement:
New CLI driver (IBM? DB2 driver for ODBC and CLI), customers can install this driver without installing DB2 client software.
More flexible and effective product authorization management
Multiple DB2 versions and patch packages can be installed on the same computer.
The new response file keyword allows IT employees 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 automatic data management features in version 9 of IBM DB2 will continue to help improve database administrator productivity and effectiveness.
Some of these key features include:
Adaptability, self-tuning memory allocation function This new feature simplifies or excludes configuration work for DB2 servers by constantly updating configuration parameters and resizing the buffer pool. Once activated, the feature can dynamically allocate available memory resources between different memory consumption points. In Windows and AIX? operating systems, the self-tuning memory function can also determine the database
[1] [2] Next article