41782 – Prioritize Your Work - Using Priority Scheduler This presentation was recorded on May 28, 2009 with Rao Nuthakki.

Most people working on Teradata might have some idea of Priority Scheduler. This presentation will take us into the details of how you can prioritize different types of works that are to run on the system, so as to best utilize the resources available. We will take a look into terms like Resource Partitions, Allocation Groups, Performance Groups and Performance periods and how these influence your system resource usage. We will take a look at how to use Priority Scheduler Administrator. We'll conclude with two common approaches to setting up the Priority Scheduler.
 

43802 – Enhance Business Decisions with Location Data - an Introduction to Geospatial This presentation was recorded on May 20, 2009 with Mike Riordan.

This presentation is an introduction to Teradata's geospatial features. Starting with a brief background to location data and the benefits that geo-location data provides over traditional addresses, we then discuss the powerful functionality now available with Teradata's new spatial data type and methods. The presentation demonstrates some examples of these features using SQL queries, some customer success stories, Teradata's geospatial EDW strengths and finally a view into Teradata's geospatial roadmap.
 

43822 – Teradata Extensibility This presentation was recorded on May 14, 2009 with Mike Watzke.

Over the past several releases Teradata has invested in features to support extending the database to enable Teradata’s parallel infrastructure to be applied to a broader problem space. This session will review the goals and drivers of this initiative. Included will be comparison to emerging parallel application frameworks. The session will highlight several successful production features and applications. An overview will be provided of the components comprising the extensibility framework with some insight into future directions. The session will conclude with some common implementation and management considerations and techniques.
 

41901 – Adjusting Workload Management through System Regulation using TASM This presentation was recorded on May 14, 2009 with Doug Brown & Anita Richards.

Does your system operate in a steady state 7x24? Or is it like most systems, where the nighttime workload mix and priorities differs from the daytime, or when month-end processing is occurring? Do you need to manage your workload differently when the system is under heavy load or is operating under conditions of temporary degradation?

The System Regulation feature of TDWM, as introduced in TD12.0, provides an automated solution, allowing you to define workload management variations depending on the 'state' of your system. It provides opportunities for the environment outside the DBS (such as a dual-active application or a month-end application) to participate in defining that state, thereby participating cooperatively with the DBS in workload management. This session will explore all these benefits and provide guidelines for the most effective use of system regulation functionality.
 

21346 – Roles and Responsibilities of a Teradata DBA This popular presentation was updated and re-recorded on March 27, 2009 with Roger Mann.

The modern data warehouse presents some unique administration challenges. This session will examine the differences a DBA faces when making the transition from a transaction processing environment to a data warehouses, ad-hoc environment. We will identify various roles and responsibilities and give tips for prioritization of the most important functions. We will also examine the additional support requirements the Active Warehouse places on the DBA.