Teradata Scalability Enhancements in 8.2

Teradata announces scalability enhancements to the upcoming, 8.2 version of its proprietary database. Enhancements include:

* Teradata’s system can now create partitions in join indexes. Oracle 10gR2 has the broadest range of indexing schemas to support fast query performance. These include B-Tree indexes, B-Tree cluster indexes, Hash Cluster Indexes, Reverse Key Indexes, Bitmap Indexes, Bitmap Join Indexes, Function-based indexes, and Domain Indexes. Oracle has had Materialized Views for facts and dimensions with SQL rewrite since Oracle 8i, and bitmap join indexes since Oracle 9i.
* Teradata claims it has also made join indices more flexible, allowing them to be used in conjunction with database triggers that monitor events and act on data events to further improve query performance.  It claims better support for event monitoring, simplified systems management and high-system availability, all areas in which Oracle 10gR2 excels.
* Teradata has also added a Java Messaging interface for its data-loading utilities to make it easier for the system to pull in data from disparate data sources.  Pulling data from non-Teradata sources has historically been a significant weakness for Teradata, making it a nightmare for many customers to create analytic applications sourced from diverse data sources. In contrast, Customers have unlimited data source access with Oracle.


* Needless to say, Warehouse 8.2 comprises of a suite of pre-bundled Teradata software, hardware, including the Teradata Database V2R6.2, Teradata Tools and Utilities 8.2, and the NCR 5450 Server that was introduced in early 2006, and consulting services, so a customer that wants the enhanced functionality, must go through an expensive Teradata upgrade, often equivalent in price to a brand new Oracle system.
* Teradata is giving its customers the privilege to prepay for Warehouse 8.2 today, but they can’t install the new system until next year. By all indications, Teradata needed something to announce at its user conference.