Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 02 Jan 2014 @ 09:29:06 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Queue Tables
From:   David Clough

Thanks for the benefit of your experience on the Queue usage, Dieter.

I'm using your 'Stop the Queue with High Value entry' mechanism, whilst coding the Consume Stored Procedure to run forever, as also suggested.

The whole usage of Queue Tables turned out to be some much simpler than I'd expected it would be (even though I've got a lot of Procedural code around it), and it really opens up new possibilities in handling mixed workloads.

I suppose, as a mixed workload paradigm, the Queue mechanism would fit the bill, or I guess the other way would be to have a cheap Operational Database, supported by a TPump Queue mechanism.

The important thing, it seems to me, is to ensure Users have the right level of expectation from allowing updates directly into Teradata. ?The worst thing would be to give them the impression it can be an operational Database, like Oracle - it is not.

Anyway, let's look forward to an interesting New Year.


David Clough
Senior BI Database Designer

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