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.

IoT
IoT
News

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
2020 State of DevOps Report
2020 State of DevOps Report
Download this report today to learn more about the key tools and technologies being utilized, and how organizations deal with the cultural and process changes that DevOps brings. The report also examines the barriers organizations face, as well as the rewards from DevOps including faster application delivery, higher quality products, and quicker recovery from errors in production.
Slideshows
Data Science: How the Pandemic Has Affected 10 Popular Jobs
Cynthia Harvey, Freelance Journalist, InformationWeek,  9/9/2020
Commentary
The Growing Security Priority for DevOps and Cloud Migration
Joao-Pierre S. Ruth, Senior Writer,  9/3/2020
Commentary
Dark Side of AI: How to Make Artificial Intelligence Trustworthy
Guest Commentary, Guest Commentary,  9/15/2020
Register for InformationWeek Newsletters
Video
Current Issue
IT Automation Transforms Network Management
In this special report we will examine the layers of automation and orchestration in IT operations, and how they can provide high availability and greater scale for modern applications and business demands.
White Papers
Slideshows
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