Subscribe to Terdata Developer Exchange - RSS feed for all blogs Latest blog posts
19 Mar 2012

"Pagination" refers to the technique commonly used by web applications to display a section of a larger query result, and let the user jump backwards and forwards to particular sections. Google, for example, uses this technique to display search results.

This article assumes that your queries routinely return more row data than can fit into a single 1 MB response message sent from the Teradata Database to the Teradata JDBC Driver.

19 Mar 2012

There are data models that use surrogate keys as part of primary key/primary index definition.

Examples are: Industry and Homegrown models.

The use of surrogate keys is usually considered when loading different source systems with different natural keys on the same integrated data model. This implies a conversion of the different natural keys into a standard surrogate key that can be used for all source systems.

13 Mar 2012

Schumpeter’s blog had (yet another) interesting entry a couple of weeks back:  “Now for some good news.”  It reviews a couple of authors’ view that we are on the cusp of future abundance due to upcoming technical breakthroughs.  The four drivers of the future are listed as the:

10 Mar 2012


We can establish a JDBC Connection with URL that specifies a database name, e.g.

jdbc:teradata://<some host>/DATABASE=<some database>

After the Connection is opened, is there any way to determine what database is in use? And is there any way to switch to a different database?


06 Mar 2012

Ordered analytical functions enable parallel processing by freeing processes from flat logic. They also produce simpler Set SQL statements, which as a general rule can be expected to perform better than more complex Set SQL statements.

05 Mar 2012

This article is a continuation of Part 2: Backbone.js + Require.js, Further Modularization and Just in Time Dependency Loading. It describes how to use a cache manifest to improve just in time dependency loading performance. It also provides a cache priming alternative in the event that the user’s browser does not support a cache manifest, i.e. IE.

23 Feb 2012

A new R package for Red Hat Linux has been added to the teradataR 1.0.1 release. This new package provides the same functionality as in the previously released Windows and Mac OS X packages, but is built for Red Hat Linux. This version was built and tested on Red Hat Linux 6.2 32-bit. (The R version for Red Hat Linux is 2.14.1)

Installing this package is the same as any normal R package; just extract it into your R library area, or use the install.packages command with the file path.

17 Feb 2012

Accurately identifying how much a table has grown since statistics on a column were last collected is an important prerequisite for the statistics extrapolation process.  Once table growth has been detected, then stale statistics can be adjusted accordingly.  Extrapolations based on table growth will be be more accurate if statistics are being regularly collected on the system-derived column PARTITON, whether or not a table is partitioned.

02 Feb 2012

In this blog I would like to share my knowledge on how you can use a Java External Stored Procedure (JXSP) to write to a file on a file system. 

In order to perform an IO operation (e.g. write to a text file) from the JXSP, you need to do the following :

23 Jan 2012

If you are a TASM user, there is an option that springs up when you create a workload, labeled Enforcement Priority. The option name sounds a little more intimidating than it actually is. I’d like to take this opportunity to explain what enforcement priority is, what it actually does, and what it doesn’t do, and just how seriously you should take it.