Loading...

Teradata Database Management

"It [Teradata Active System Management] really acts like a traffic cop for us. We tell it the priority of the different pieces of workload by the time of the day."

Scott DeLap, Director, Frontier Communications Corporation , Teradata Magazine

As the world industry leader in data warehousing, Teradata pioneered the science of database management. Today you can store your data in an enterprise data warehouse from Teradata and take advantage of the best-of-breed Teradata Database. And now Teradata brings you a full suite of database management tools to make the most of these advanced capabilities.

 

Features & Benefits

Primary Components

Teradata Viewpoint is a portal-based system management solution that allows DBAs and system administrators to access Teradata system performance information from virtually anywhere.

Teradata Manager is a PC-based graphical systems management platform containing a powerful, fully featured suite of specialized tools and applications to centrally monitor and control the Teradata Database.

Teradata Replication Services ensure that the data in your transactional data stores and your Teradata Database are synchronized. Teradata Replication Services replicate data from multiple relational and non-relational data sources into Teradata Databases. Changes to data within a data source are propagated to specified targets within seconds. It also ensures that the data in your backup or dual active databases are up-to-date. If any part of your system is unavailable, Teradata Replication Services will remember where you left off and catch up once the resource becomes available again.

Teradata Performance Monitor

Teradata Dynamic Query Manager is a successful, proven tool for managing complex and analytical queries before they reach Teradata. Teradata DQM supports proactive workload management by allowing users to schedule requests to run at particular times, and it supports reactive workload management by delaying requests until a heavy workload inside Teradata has subsided.

Teradata Query Scheduler provides a database request scheduling service, scheduling queries through client applications, such as the Scheduled Request Viewer and Teradata SQL Assistant. Teradata Query Scheduler can also migrate to earlier versions of the Teradata QS database, set up user profiles, schedule and monitor SQL requests, and save, process and execute client requests that have been scheduled.

Teradata Dynamic Workload Manager is a highly reliable, next-generation systems management tool that does exactly what its name implies: manages requests to your Teradata Database according to your company's business needs.

Teradata Active System Management is a goal-oriented, automatic management and advisement technology that supports performance tuning, workload management, capacity planning, configuration and system health management.

Teradata Workload Analyzer helps with the analysis of varying workloads based on historical usage data from the Teradata Database.

Next Steps

Teradata Express Edition

Experience Teradata Express Edition — a free developer version of Teradata 12.0. It provides an unlimited opportunity to work with Teradata on Windows workstations and laptops for development testing and learning.

Download Now

How can we help?

Contact us for insights and answers to your questions.

Contact Teradata