Teradata Express 15.0 is now available so that you can evaluate the new features of Teradata. Teradata Database 15.0 is the newest release of Teradata’s industry-leading RDBMS.  This release extends Teradata’s leadership in several key areas, and continues to position Teradata Database as the database of choice for Integrated Warehousing, Business Analytics, and participation in the Unified Data Architecture.  

Statistics provides valuable information to the optimizer to make decisions on generating optimal explain plan.  The information about the statistics can be obtained by using the “Help Statistics” command however the displayed data cannot be used to join with other tables.  The article provides a java stored procedure and DDL which extracts the output of "Help Statistics" at Table and Column level and capture the data into tables. 

The captured data in the tables helps with:

Teradata is announcing new Teradata Express 14.10 images. These new images are at patch level 14.10.00.02 which represents the current shipping version of Teradata 14.10. This gives you access to the recently released Teradata 14.10 database for your test and development needs.

Important

These images represent a departure from the from the TD 14.0 and TD 13.10 releases.

Teradata Express for VMware Player (TDE-V) is a free, fully operational Teradata Virtual Machine with up to one terabyte of storage. Imagine being able to install a fully operational Teradata database on your PC and be running queries in five minutes, easy as 1-2-3.

There are lies, damned lies and … statistics.  Statistics are “the science that deals with the collection, classification, analysis, and interpretation of numerical facts or data, and that, by use of mathematical theories of probability, imposes order and regularity on aggregates of more or less disparate elements.”  At least that is according to the definition provided by the Merriam-Webster Dictionary.  Many other more philosophical definitions have been provided for statistics over time, as well as many observations regarding the value of statistics.

Cloud Computing is a computing service provisioning and delivery model in which users get access to dynamically scalable computing capacity over the network in a pay-as-you-use payment scheme. While its attractiveness may differ depending on whom you've talked to, its service-oriented nature gives users two important benefits: ease of application deployment (someone else's hard works laying down the hardware and software foundation) and on-demand access anytime from anywhere. These characterstics make Cloud Computing ideally suited for developers who want to quickly try something out in an isolated "good" environment without the overhead of system setup or the capital expenses of paying for systems they no longer need after they are done. 

Teradata Corporation is pleased to announce the availability of new Teradata Express versions based on our recently released version 14.0 of the Teradata database. The Teradata Express program is a freely licensed virtual instance of the Teradata database. It is fully functional for evaluation, test and development purposes.

Teradata Express for VMware (TDE-V) is a free, fully operational Teradata VM with up to one terabyte of storage. Imagine being able to install a fully operational Teradata database on your PC and be running queries in five minutes, easy as 1-2-3.

Everyone is aware of Teradata’s continued commitment to reducing the footprint and resource usage of data by adding compression capabilities and the result on perm space savings and performance, by reducing block size, IO and spool usage.  

While this new functionality is great, I would like to suggest that you not ignore a basic best practice step in implementing your data warehouse model.  In this case, I would like to suggest that before compression, you look at 'right sizing' your data first. 

The following information covers a handful of the basics of the Teradata architecture, to help new Teradata users better understand what considerations should go into creating a table.