Teradata Database Delivers Real-Time Agility

By Darryl K. Taft  |  Posted 2012-10-24

Teradata Database Delivers Real-Time Agility

WASHINGTON -- Teradata, a provider of analytic data solutions, has announced new database capabilities that enable customers to deliver real-time agility.

The new Teradata Database capabilities include workload management features, Teradata Data Lab with Smart Loader, Teradata Studio and Teradata Virtual Machine Edition. With this announcement, Teradata taps into the more than 200 new capabilities released in the previous two years, including analytical innovations in the areas of columnar, geospatial, hybrid storage, private cloud and temporal. These most recent innovations simplify and automate database management, expand self-service and provide flexible deployment options, the company said.

Teradata announced the new capabilities at its 2012 Partners user conference here.

“Teradata draws on the intelligence of the best and brightest engineers in its labs located in the U.S. and around the world to provide capabilities that pay tangible dividends for our customers,” said Scott Gnau, president of Teradata Labs. “Teradata earned its place as a data warehouse trailblazer by consistently delivering industry-leading product innovations that enable our customers to be more agile and productive in ways that power revenue growth.”

The Teradata Database offers two levels of workload management to simplify and automate data management: Integrated Workload Management  and Teradata Active System Management.

Teradata Integrated Workload Management is available across all Teradata workload-specific platforms. The technology enhances control over system resources by adding disk and I/O control in addition to managing central processing units (CPU) to ensure fair use of the valuable system resources. With “deterministic prioritization,” Teradata ensures that the most important work gets done first and also provides mechanisms to stabilize the response times and maximize resource usage during planned and unplanned peaks. The ability to give operational workloads high priority has been a long-standing Teradata capability. Now with the “tactical tier” capability, Teradata provides even more performance for agile workloads. For example, this is important when the data warehouse is processing analytical reports and a frontline call center representative submits a query to the database to get an immediate answer to a customer’s question.

With the Teradata Active System Management (TASM), customers with a Teradata Active Enterprise Data Warehouse can be assured that business users’ queries get the priority they deserve. The new workload management feature, Service Level Goal Prioritization, allows administrators to allocate resource usage based on tiers of users or specific groups. For example, frontline call center representatives can be assigned a set of database service level goals that meet their unique customer service business intelligence needs. Marketing, finance and human resources can be assigned different service-level goals based on their business needs. The new Virtual Partition feature, also a part of TASM, now enables system resources to be allocated for users based on specific geographic regions, business units or other categories. For example, organizations with operations in different geographic regions can ensure that one region’s usage won’t impact other regions’ use of the same data warehouse. These workload management features require Teradata Database 14 with SLES 11, which will be available by the end of 2012, the company said.

Teradata Studio is a new tool that simplifies database administration. Teradata consolidated multiple tools into one, and with a simple point-and-click capability, administrators can perform hundreds of functions. Teradata Studio offers a new way to visualize and manage the database and reduce the steps necessary to perform everyday management tasks. Built in the Java and Eclipse Rich Client Platform (RCP) framework, Teradata Studio has been designed as an open tools platform and can run on Windows, Linux and Mac OS operating systems. Teradata customers will benefit from the many high-quality Eclipse features focused on administration and the scratch-pad query tool.

Teradata Database Delivers Real-Time Agility

Business analysts want to be able to load data without having to rely on IT. The new smart loader feature of Teradata Studio provides Teradata Data Lab users self-service capability to empower users to load data not already in the data warehouse. This feature creates tables that dynamically provide the freedom to experiment with analytics and explore the creative uses of data within the database, which ultimately transforms data into intelligence needed to propel the business. Analysts can load external data into their data lab for analysis in combination with production data, test new analytic theories and collaborate with other users. With Teradata Data Lab, innovative companies can rapidly test new theories that can lead to breakthrough ideas and results.

To provide customers with flexible Teradata Database deployment options, the new Teradata Virtual Machine Edition 14 can be dynamically deployed on the current VMware ESXi private cloud infrastructure. The Teradata Virtual Machine Edition is delivered on a virtual symmetric multiprocessing system (SMP) with the Teradata Database installed. The Teradata Virtual Machine Edition offers the database administrator or developer a place to test new Teradata software releases, experiment with physical database design changes, or prototype applications. Teradata leverages the flexible and agile VMware private cloud environment to accelerate the development and test process by removing constraints on system deployment choices, thus increasing the chances for breakthrough business results. Once development and testing is completed, the verified changes or new application can be applied to the production Teradata Database environment running on a Teradata workload-specific platform.

Available with customer service support, Teradata Virtual Machine Edition accommodates work with more than 2 terabytes of data. With minimal IT administrative personnel or procurement department involvement, a virtual system can be created in minutes. Teradata Virtual Machine Edition delivers a stand-alone SMP Teradata system through the VMware virtualization environment to provide additional test and development flexibility and efficiency, complementing the ability to use Teradata’s existing workload-specific platforms for more scalable and higher-performance test and development.

“The desire for automated decision making and better business intelligence capabilities will drive enterprises to capture more data than what can be used,” said Neil Raden, CEO and principal analyst at Hired Brains. “These requirements put pressure on the database to manage more data and applications, thus driving enterprises to seek out innovative technology. Thinly stretched database administrators will seek out easy-to-use, self-administering databases, to reduce complexity and speed support to the frontlines of business.”

These four new or enhanced capabilities are a part of a larger group of analytical innovations that Teradata recently brought to market in the areas of columnar, geospatial, hybrid storage, private cloud and temporal.

Companies no longer have to deploy a separate system to take advantage of columnar performance, Teradata said. Teradata earlier introduced Teradata Columnar, which integrates column- and row-based tables. Unlike other relational database vendors, the columnar capability from Teradata allows users to mix and match column- and row-based physical storage within the data warehouse to meet the requirement of the applications, the company said.

Teradata Database Delivers Real-Time Agility

“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.

Rocket Fuel