Teradata unveils SW tool for database processing

SAN DIEGO, US: Teradata Corporation recently introduced the Teradata Aggregate Designer software, which optimizes Online Analytic Processing (OLAP) implementations providing faster in-database processing and richer data for analytics.

With this innovation from Teradata, customers will be able to enhance their business intelligence solutions resulting in better, faster insights that contribute to business growth, said a press release.

The ideal business intelligence solutions directly accesses data from the data warehouse.  However, some solutions still extract a subset of the data and build separate physical data cubes in a local server or in a spreadsheet. 

This type of solution architecture faces many challenges, which include data inconsistency, lengthy data extractions and data duplication. These challenges lead to an inconsistent view of the business, lost business opportunities due to the delay in data availability, as well as hidden costs that typically range in the hundreds of thousands of dollars.

"The answer is to access the data directly from the data warehouse reducing data duplication and movement," said Randy Lea, vice president of product and services, Teradata Corporation.

"The result is a dramatic reduction in costs, increased query performance and freed-up resources that can be used to do more analytics, which drives more business value."

The Teradata Aggregate Designer is a desktop administrative tool that automates the creation of Aggregate Join Indexes (AJI) within the Teradata data warehouse database. AJIs aggregate data as it is loaded into the warehouse to support commonly used analytic dimensions and pre-determined business queries.

AJIs are automatically used by the Teradata optimizer to provide optimized performance for all OLAP solutions, said the release. 

"Joint Teradata and Microsoft customers have greatly benefited from leveraging the easy-to-use Microsoft business intelligence tools running on the high performance Teradata data warehouse to deliver intelligence to all workers in the enterprise," said Donald Farmer, principal program manager, Microsoft SQL Server Business Intelligence Management Team. 

"The Teradata Aggregate Designer tool natively supports Microsoft SQL Server Analysis Services and automatically implements the AJIs providing our customers with fast and optimized implementations."

The Teradata Aggregate Designer is now available from Teradata, with additional Teradata Business Intelligence Optimizer products to be available later in 2010 offering accessibility to user-friendly analytics supported by fresh, detailed data.