Articles related to the Teradata Database.

Expand All The Latest
Planning Extended Teradata System outages with Unity 15.10

Benjamin Franklin once observed "...in this world nothing can be said to be certain, except death and taxes". Planned down time can easily be added to that list. It's a certainty that any given IT system will require some planned down time to address security fixes, make configuration changes, or expand storage and compute capacity. Smart businesses always stay ahead of these demands, and promptly patch or upgrade their systems, but that often comes with a cost in down time.

Introducing Teradata Virtual Machine -- Community Edition
Community Edition is a SUSE Linux Enterprise Server (SLES) operating system and Teradata Database packaged into a virtual container that runs in a VMware vSphere ESXI virtualized environment on third-party hardware. Community Edition software consists of a template and associated property files and scripts. When a Community Edition virtual machine is deployed, it operates as a fully functional instance of the configured Teradata Database. Once deployed by the VMware administrator, Community Edition can be used to evaluate Teradata Virtual Machine and the Teradata Database.
 
Note: You must have administrative privileges on the destination VMware environment to install and configure Community Edition virtual machines.
Extract and analyze SHOWBLOCKS/SHOWWHERE data as easy as pie

Tired of parsing the output from Ferret SHOWBLOCKS and SHOWWHERE commands?  You don’t need to do that anymore with the release of the SQL SHOWBLOCKS and SQL SHOWWHERE features. The SQL SHOWBLOCKS feature is available in Teradata Database 15.0, and SQL SHOWWHERE is available in 15.10. These new features allow you to easily extract SHOWBLOCKS and SHOWWHERE data, which can subsequently be queried for analysis using SQL.

Teradata’s Path to the Cloud - Secure Zones

Database users are increasingly becoming more comfortable with storing their data in database systems located in public or private clouds. For example, Amazon RDS (relational database service) is used by approximately half of all customers of Amazon’s AWS cloud.

Hybrid Row/Column-stores: A General and Flexible Approach

Guest post by Dr. Daniel Abadi, March 6, 2015

Optimizing Disk IO and Memory for Big Data Vector Analysis

Optimizing Disk IO and Memory for Big Data Vector Analysis

Daniel Abadi  Nov 11, 2014  This is a guest post by Dr. Abadi   http://blogs.teradata.com/data-points/optimizing-disk-io-and-memory-for-big-data-vector-analysis/

Teradata QueryGrid and Adaptive Optimization

Teradata QueryGrid and Adaptive Optimization:

Not Your Typical DBMS-Hadoop Connector

Dr. Daniel Abadi  October 17, 2014

Thisis a guest post by Dr. Abadi also posted at http://blogs.teradata.com/data-points/teradata-querygrid-and-adaptive-optimization/ 

 

Identifying Used, Unused and Missing Statistics

New DBQL logging options USECOUNT and STATSUSAGE, introduced in Teradata Database 14.10, enable the logging of used and missing statistics.  The output of this logging can be utilized to find used, unused, and missing statistics globally (for all queries) or for just a subset of queries.

Teradata Express Support for SQL H -- Install Instructions SQL H

The following instructions should help you set up and configure the Teradata SQL H capability with your Hadoop instance. First, however, you need to download and start up a Teradata Express image with the SQL H Connector installed. On the Teradata Express for VMware Player, download on of the following two versions.

Teradata Database Enhancement Requests

Teradata Database Enhancement Requests

Do you have a Teradata Database enhancement request? You can submit your Teradata Database enhancement request at: http://www.teradata-partners.com/partners-user-group/enhancement-requests

The submitted Enhancement Requests are reviewed monthly by the Product Advisory Council (PAC), who is supported by the Partners User Group.

Pages