Teradata has introduced Aggregate Designer software, a new desktop administrative tool that optimises Online Analytic Processing (OLAP) implementations providing faster in-database processing and richer data for analytics.
According to Teradata, the new offering 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 optimiser to provide optimised performance for all OLAP offerings.
The company claims that AJI performance optimisations benefit BI vendor’s offerings and can improve the performance by 100 times, while also reducing cube creation and the non-necessary movement of data.
Randy Lea, vice president of product and services at Teradata, said: "The answer is to access the data directly from the data warehouse reducing data duplication and movement. 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 available from Teradata, with additional Business Intelligence Optimizer products to be available later in 2010 that offer accessibility to user-friendly analytics supported by fresh, detailed data.
