Using Teradata’s Aster Data for Big Data Analytics

6 Nov

Since moving into my new full-time role focused on big data analytics, I’ve had the opportunity to work extensively with Aster Data, which is a big data analytics platform that Teradata purchased recently.

What is unique about the Aster platform is that they’ve fully incorporated analytics into the database platform through SQL and the MPP distributed architecture. Certainly, other platforms like SQL Server & Netezza offer MPP architecture and analytics. But there are 2 unique characteristics about Aster that I find very impressive and that we are taking advantage of:

  1. Aster allows for your own SQL UDF extensions written in Java using MapReduce. They call this platform SQL-MR. It’s very helpful to our data scientists to be able to have developers code MR functions that can then be called from SQL commands.
  2. We just installed Aster 5.0 which includes SQL-H, which will allow us to enable queries across data stored in Aster’s schemas together with data that we keep in Hadoop clusters, using Hive & HCatalog:

If you want to try some of these out for yourself on Aster, they’ve made an Express version available that you can download as a VM image here:

Best, Mark


One Response to “Using Teradata’s Aster Data for Big Data Analytics”


  1. Using Teradata's Aster Data for Big Data Analytics « Big Data Analytics » BlinkMoth Software Industries | BlinkMoth Software Industries - November 10, 2012

    […] This Teradata Blog Post From Teradata – Google Blog Search: […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Microsoft SQL/BI and other bits and pieces


Current & Breaking News | National & World Updates

Tech Ramblings

My Thoughts on Software

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Insight Extractor - Blog

Paras Doshi's Blog on Analytics, Data Science & Business Intelligence.

The SQL Herald

Databases et al...

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

Bill on BI

Info about Business Analytics and Pentaho

Big Data Analytics

Occasional observations from a vet of many database, Big Data and BI battles

Blog Home for MSSQLDUDE

The life of a data geek

%d bloggers like this: