Teradata, a division of NCR Corporation, announced the availability of Teradata Warehouse 8.2, a suite of software, hardware and consulting services, that builds on capabilities to infuse real-time intelligence into front-line operations, customer service and strategic planning supporting both strategic decision-making and thousands of daily operational tasks.

The technical enhancements built into Teradata Warehouse 8.2 expand its ability to deliver real-time intelligence. These unique capabilities offer fast performance, a significant volume of concurrent queries, high-system availability, event monitoring, easy integration into the enterprise, simplified system management, and unparalleled support of short operational as well as long strategic workloads.

Teradata Warehouse 8.2 incorporates key product refinements identified by industry-leading customers that rely on their active data warehouse. These active data warehouses, deployed across many industries, have led to enhancements that reduce the cost and effort for implementation and increase the predictability of the mixed workloads, both short-term operational and long-term strategic queries.

For example, a Teradata financial services customer with an active data warehouse was able to evaluate consumer transactions across all channels to better understand its customer's needs. Selected transactions triggered messages to be sent to branch managers or telephone customer service representatives with recommendations for customized product offers, resulting in a marked improvement in sales.

The enhancements incorporated into Teradata Warehouse 8.2 have boosted the speed and predictability of high-frequency queries from applications that support front-line customer representatives. One enhancement now enables Teradata to create partitions in join indexes. The partitions act as alphabetical tabs in a notebook allowing the database to look only in the relevant section and eliminating the need to scan tens of millions of rows in the join index, responding to the query faster as a result. Join indexes, which combine data from multiple tables, are often created to speed the performance of high-volume queries from front-line applications.

If an application combines the information from two tables to display information about a customer calling a call center, a join index can eliminate the processing to combine the data during each query. This is important because table sizes are continuously growing with the storage of more data. As tables grow, the new ability to expand the use of partitioning allows the query to continue to meet performance requirements without adding additional processing power to the system.

Teradata has also enhanced the flexibility of using join indexes along with database triggers to further improve query performance, which is especially important for time-sensitive front-line workloads. Triggers monitor specific business activity and can initiate various activities when a predefined event occurs, and are commonly used when real-time notification of an event is critical to the business.

To further enhance the ability of the Teradata data warehouse to integrate within the enterprise, Teradata has adopted Microsoft.Net architecture with the release of the .Net Data Provider and has also released the 64-bit Open Database Connectivity driver. These data connectivity utilities create a bridge between Teradata and applications. In addition, Teradata has developed an interface for its data-loading utilities for Java Message Service, an industry standard enterprise messaging system, which expands the ability to access disparate data sources within or outside the enterprise.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access