Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 07 Apr 2016 @ 08:50:45 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Multiple session inserts to the same table
 
From:   Frydryszak, Marek

I can imagine few solutions, all are artificial, because such application should be rather run on transactional database, not DWH.

1. (TD15.10) - use partition level locking and partition the table e.g. by userid.

2. Create as many such tables as maximum number of multiple users. Other users should access the tables through locking for access view which contains "union all" operators.

3. Multiple processes insert rows into work tables ( e.g. que tables). Separate process started as often as required from cron insert-select work tables into the final.



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