Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Posted Jun 23, 2010

In-Database Processing Tool from Teradata Boosts Business Intelligence

By DatabaseJournal.com Staff

Online Analytic Processing gets a boost upward with Teradata Corporation’s newly available Teradata Aggregate Designer software. This administrative tool automates creation of Aggregate Join Indexes (AJI) inside the Teradata data warehouse database that enable:

  • aggregation of data as it is loaded into the warehouse to support commonly used analytic dimensions and pre-determined business queries
  • the Teradata optimizer to provide optimized performance for all OLAP solutions
  • improve performance, while reducing cube creation and the non-necessary movement of data

Other benefits from Teradata Aggregate Designer include fast in-database processing and rich data for analytics, both of which contribute to improved business insight.

View Article

Daily News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.