|
contents | software | |||||||
| Teradata Warehouse 8.2 Is Available Teradata has 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. For example, if a call center application always combines information from two tables to display customer information, a performance improvement technique is to create a join index to eliminate the processing to combine the data during each query. If this customer information is revenue-related, the join index can then also be partitioned so that a query looking for this month's revenue versus this month three years ago will query two months versus the entire 36 months of history. Consequently, this query would roughly take about 5 percent of the time, providing a dramatic performance improvement. 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 Data Base 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. write your comments about the article :: © 2006 Computing News :: home page |