Government // Enterprise Architecture
01:31 PM
Doug Henschen
Doug Henschen
Connect Directly

Teradata Raises Data Warehousing Bar

Point-in-time insight and processor upgrades highlight next-generation database, hardware and analytic strategy announcements.

Making a battery of announcements at its annual Partners conference, Teradata on Monday reinforced its position as a leader in data warehouse with sweeping upgrades of its database, hardware and analytics strategy.

If 2009 marked the year in which Teradata filled out its hardware family, 2010 is mostly about filling out the company's vision for analytics. The strongest strategic message centered on Teradata Accelerated Analytics, which packages the company's diverse analytic capabilities and partnerships as a portfolio.

A few components of that portfolio are new, like temporal (time-based) insight and analyses of unstructured data sources, such as Hadoop and social media sources. Several components of the portfolio already exist but have been upgraded.

Support for OLAP analysis, for example, is not new, but a Terredata Aggregate Designer now recommends optimal indexes for Microsoft, MicroStrategy, Oracle, SAP BusinessObjects and SAS OLAP environments. In addition, a new Excel plug-in gives Excel Pivot Tables direct access to Teradata, giving end users self-service access to data.

Underscoring the company's independence, the Teradata Accelerated Analytics portfolio reaches out to an extensive community of partners and third-party vendors. For example, Teradata supports a growing set of in-database processing approaches for SAS, IBM SPSS and KXEN commercial analytics. This latest release specifically steps up support for open source R tools and analytic models.

At the center of the news is Teradata 13.10, the latest release of the vendor's database, which supports improved compression and temporal (point-in-time) analyses. Improved compression is a frequent and always-welcome improvement in databases as it lets organizations cram more data into existing deployments. New block-level and algorithmic compression are said to work together to increase routine compression up from 2X to 3X into the 3X to 4X range. That matches rates recently claimed by competitors EMC Greenplum and Netezza.

Teradata CEO Mike Koehler
Teradata CEO Mike Koehler

The temporal advances in 13.10 make it a time-aware database that can track changes over the history of data.

  • Insurance companies need to understand who had policies when and when they changed coverage levels; otherwise, they can't bill customers and handle claims appropriately.
  • Manufacturers need time-based analysis to gauge sales performance. How do you fairly calculate commissions or bonuses when territories have changed in the middle of a month or year?
  • Retailers have to understand brand and category performance amid change. If ice cream is moved from frozen foods to dairy, how do you accurately measure year-end performance of each department or related suppliers?
All of these analyses typically require complicated and time-consuming approaches. The Teradata 13.10 optimizer supports "as of" and "as if" queries that can handle all these analyses without point-in-time copies or complicated calculations.

1 of 2
Comment  | 
Print  | 
More Insights
Threaded  |  Newest First  |  Oldest First
Register for InformationWeek Newsletters
White Papers
Current Issue
Top IT Trends to Watch in Financial Services
IT pros at banks, investment houses, insurance companies, and other financial services organizations are focused on a range of issues, from peer-to-peer lending to cybersecurity to performance, agility, and compliance. It all matters.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on for the week of October 9, 2016. We'll be talking with the editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll