DB2 Enterprise Server Edition

Time Travel Query

• Reduce development costs and improve efficiency when working with temporal data.
• Make your database time-aware and keep a history of your data changes by using temporal tables.
• Query data as it appeared at different points in time.
• Avoid the cost and effort required to build, maintain and administer a complex temporal infrastructure.

XML database management with DB2 pureXML

• Process and manage XML data in its native hierarchical format for more sophisticated business capabilities.
• Provide intelligent XML data management services that can reduce administrative overhead, simplify your database design and make XML applications less complex.
• Integrate XML data intact into a relational database structure, allowing users to take full advantage of DB2 relational data management features.
• Manage both relational and XML data for better runtime performance and reduced storage and development costs.

Multi-temperature data management capabilities

• Take advantage of multi-temperature data management to place hot data on the fastest and most expensive disks and place other data on less expensive storage devices.
• Make optimal use of existing storage devices to minimize storage costs

High availability and disaster recovery functions

• Use self-tuning memory management and other autonomic features to significantly reduce daily database maintenance.

Data access at your fingertips

• Synchronizes data seamlessly between mobile devices and the main system with IBM Mobile Database and IBM Mobile Database Synch technology.
• Offers toolkits and database connections tools to help ensure the right data is delivered to the right mobile devices quickly and transparently.

Efficiency enhancements, autonomic tasks and security features

• Take advantage of automated tasks, including memory allocation and business policy maintenance to free time for database administrators (DBAs) to focus on activities that add more business value.
• Simplify storage management by using automatic maintenance functions to perform database backups, keep statistics current and reorganize tables and indexes.
• Work with a suite of security features that effectively control unauthorized access to the database.
• Help non-DB2 application developers write DB2 applications more easily with multivendor SQL and application programming interface (API) support.
• Accelerate time to value with full cross-vendor support for many APIs, including Java Database Connectivity (JDBC), Open Database Connectivity (ODBC) and Microsoft .NET. Use additional support for other SQL functions and data types.