Articles related to the Teradata Database.

Expand All The Latest
Native Object Store Example Dataset Download
ABOUT THIS DOWNLOAD The download contains the td-usgs dataset. This data is used in examples in the Teradata Vantage™- Native Object Store documentation. USGS Surface-Water Data Sets are provided courtesy of the U.S. Geological Survey. The data has been converted into CSV, JSON, and Parquet data formats. Click the attachment link to download the zipped dataset, unzip the file using your preferred method, and upload the folders in the resulting directory into your object store of choice.
Planning Extended Teradata System outages with Unity 15.10
Benjamin Franklin once observed " 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
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   
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.