Teradata Database Delivers Real-Time Agility

By Darryl K. Taft  |  Posted 2012-10-24 Print this article Print

“We were impressed by the flexibility, performance, and compression during our testing of Teradata Columnar," said Kevin C. Wyderka, director of data warehouse and business intelligence at Cars.com. “We’re getting unmatched performance from our Teradata Database today, and we anticipate the use of Teradata Columnar will take our performance and compression to the next level, without requiring query or application changes.”

Meanwhile, the Teradata Active Data Warehouse Private Cloud provides elastic performance on demand. With elastic performance on demand, users can access extra data warehouse resources to seamlessly address sudden surges in business activity, driven by such events as the launch of major marketing campaigns, unexpectedly high demands in fad-driven manufacturing orders, or seasonal holiday demand swings. Teradata systems are designed to use full computing resources, and with a pay-for-use pricing approach for data warehousing, companies can deliver business users the flexibility to meet ongoing analytic demands.

“In the retail business, sometimes a product will become popular very quickly,” said Oliver Ratzesberger, vice president Information Analytics and Innovation at Sears Holdings Corp., in a statement. “We need extra analytic firepower during those times to meet this unplanned demand. Teradata’s Active Data Warehouse Private Cloud gives us the elastic performance we need, when we need it, on a pay-per-use basis. With this burst capacity, we can quickly scale to meet the dynamic needs of our business users.”

The Teradata Database also delivers temporal analytics to enable customers to create a historical picture of enterprise business transactions and activities. In doing so, companies have the power to select a historical point in time and analyze data based on the retrospective view. Temporal analytics helps customers uncover unique insights and patterns about their business. The Teradata Database automatically executes the complex modifications and inserts the required data to maintain a complete change history when a user submits a simple update command.

“Using the Teradata Temporal functionality, we have been able to expand temporal history to critical components in our data warehouse,” Glenn Dick, director of information delivery for the Belk department store chain, said in a statement. “Business users across Belk’s marketing, merchandising and operations will have more detailed insight to ensure the merchandise that shoppers want is available, when they want it. In addition, Teradata Temporal automatically handles effective dates and history when we load data, eliminating lengthy, in-house developed post-processing methods, and decreasing our time-to-market for sourcing new data. It provides all the benefits of systemically controlling time, while the database does the work.”

Teradata allows customers to store and process geospatial data along with other business data when responding to queries. The results of the analysis can be delivered through a business intelligence tool, or shown on a map or other visualization tool. Teradata has high-performance geospatial capabilities built into the data warehouse. The geospatial capability adds another data dimension for customers seeking to increase the intelligence abilities of their business.

In addition, the Teradata Database has an intelligent virtual storage solution, which automatically migrates data between drive types based on its frequency of use or temperature. This achieves optimum performance to meet the extreme service-level demands of business users. Teradata Virtual Storage places the data on the most cost-effective storage device. And users have easy access to the data because it can all be kept in the warehouse for faster business decision making. The data no longer needs to be moved or placed in different storage mediums. Teradata Virtual Storage leverages solid-state and hard-disk drives, to achieve more intelligent multi-temperature data management where the “hot” data is the most frequently used and “cold” data is least used. Staff intervention is not required with Teradata’s automated self-managing design, which eliminates laborious database administration, the company said.


Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel