Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 27 Nov 2002 @ 14:26:19 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: When to Use Teradata
From:   Adam DeYoung

We use DB2 for near-real time processing and Teradata for analytical processing of historical data. Our DB2 repository is updated constantly, where our Teradata box is loaded daily or weekly, depending on the subject area.

We have a published data strategy document that defines the platform through a list of standard questions. Some of these questions include:

Do you need to access data that is less than one day old? DB2. More than one day old? Teradata.

Do you need to update the data in question on a daily basis? DB2. Read only? Teradata.

Do you have a high volume of queries daily and/or require a response time SLA? DB2.

Do you need to retain your data for more than 30 days? Teradata

We basically defined the strengths and configuration of each platform and created a document to help the customer arrive at the platform decision with us, rather than telling them where their data would be. It gives us the opportunity to explain the decision so they leave the discussion informed.

Adam DeYoung
Advanced Teradata Certified Professional

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020