Teradata Merges Databases On One Track - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.


Teradata Merges Databases On One Track

Improved software lets warehouses answer tactical and strategic queries

Union Pacific Corp. taps into its 4-terabyte data warehouse for serious strategic planning -- everything from analyzing the prices it charges customers to scrutinizing the traffic patterns of its freight cars. But for day-to-day tactical decisions such as scheduling train crews, the railroad operates many separate databases, and managing them all is a challenge, says Paul Evans, enterprise data warehousing senior manager.

This week Teradata, the NCR Corp. division that supplies Union Pacific's data warehouse technology, will debut an upgrade of the Teradata suite that will help to erase the gulf between strategic and tactical business-intelligence technology. Teradata 7.0 advances the active data warehouse concept of processing data in real time and providing analysis capabilities to front-line employees.

Paul Evans, enterprise data warehousing senior managing at Union Pacific.

Union Pacific wants its Teradata data warehouse to help make tactical decisions, Evans says.
"We're definitely looking at doing more consolidation and turning the data warehouse into a platform for broad decision making," Evans says. Union Pacific has already begun increasing the capacity of its data warehouse to 7 terabytes in anticipation of merging it with the railroad's tactical databases using Teradata 7.0.

The data warehouse, now updated daily, will be refreshed as often as once a minute. Evans expects the number of employees who use the warehouse to grow from around 4,000 to as many as 10,000 within five years.

Until now, building a data warehouse for strategic and tactical analysis has been practically impossible, because data is organized differently for each process. Strategic queries analyze huge amounts of historical information across many dimensions, such as time and geography. Tactical queries are narrower in scope and involve less data, but they require faster answers using data that's updated frequently, sometimes even in real time.

Teradata 7.0 offers enhancements for building data warehouses for both kinds of analysis. A partitioned primary index organizes database tables for strategic and tactical queries. A query priority-scheduling tool balances a data warehouse's workload, giving priority to queries from, say, a ticket-counter agent serving a customer over a marketing analyst using the warehouse to research ticket sales.

Last week, Teradata struck a deal to resell Informatica Corp.'s data-integration software, including its PowerCenter RT real-time product, for quickly moving high volumes of data from operational systems into data warehouses. That, combined with other Teradata 7.0 enhancements, will help data warehouse managers update information in real time or near-real time.

"Teradata is a couple of years ahead of everybody else," says Richard Winter, president at consulting company Winter Corp. He estimates that only 5% to 10% of all data warehouse users today need the scalability and performance enhancements Teradata 7.0 offers.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
The State of Cloud Computing - Fall 2020
The State of Cloud Computing - Fall 2020
Download this report to compare how cloud usage and spending patterns have changed in 2020, and how respondents think they'll evolve over the next two years.
2021 Outlook: Tackling Cloud Transformation Choices
Joao-Pierre S. Ruth, Senior Writer,  1/4/2021
Enterprise IT Leaders Face Two Paths to AI
Jessica Davis, Senior Editor, Enterprise Apps,  12/23/2020
10 IT Trends to Watch for in 2021
Cynthia Harvey, Freelance Journalist, InformationWeek,  12/22/2020
Register for InformationWeek Newsletters
Current Issue
2021 Top Enterprise IT Trends
We've identified the key trends that are poised to impact the IT landscape in 2021. Find out why they're important and how they will affect you.
White Papers
Twitter Feed
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.
Sponsored Video
Flash Poll