DB2
Universal Database

DB2 version 5.2 is the world's one true universal database.
 

Related links:

DataLinks

DB2 Product Info

DB2 Benchmarks

DB2 UDB is number one in benchmark performance.

lmaden's database researchers continue to make a wide variety of enhancements to the functionality and performance of DB2 UDB. In Version 5.2 of DB2 UDB, we have added user-defined structured types, complete with subtyping and reference types, to support typed tables and views. These new features enable application developers to more directly capture the conceptual schema for their enterprises (i.e., their business objects) in DB2 schemas and queries. We also designed and implemented the capability to define Automatic Summary Tables and Replicated Tables, which materialize frequently-referenced computations redundantly to enhance query performance. The hash join method and a new type of join method to perform star-joins using Dynamic Bit-Map Indexes were both contributed by Almaden researchers. These performance enhancements have helped DB2 UDB to achieve leading performance and price-performance records in the TPC-D complex-query benchmark.

Further out, we are enhancing DB2 UDB's SQL table functions with universal data access capabilities such as OLE DB, which enable applications to access and join heterogeneous data stored in a variety of relational and non-relational data sources such as external indexes, spreadsheets, Notes, and mail databases. We are prototyping techniques to do multi-query optimization and exploit sampling techniques to reduce the data that must be accessed to give users a "feel" for the data. Together with Software Solutions developers in Toronto, we have prototyped a "wizard" using the DB2 UDB Optimizer that recommends indexes to speed query processing.

Almaden researchers are experimenting with techniques that may one day allow the DB2 UDB Optimizer to actually "learn" from its mistakes and improve its choice of execution plan over time!

Almaden Home | IBM Research | Legal | Feedback