Teradata Database Delivers Real-Time Agility

Teradata announced several new capabilities to its database that take advantage of new technology including the new Teradata Studio, Smart Loader and more.

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.