Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 01 Mar 2007 @ 02:02:05 GMT


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


Subj:   Access locks and the future
 
From:   Geoffrey Rommel

In the beginning, Teradata was not designed with data warehousing in mind. The founders simply thought that there would be a market for really large databases, and data warehousing eventually turned out to be the most common application for large relational DBMS's.

Data warehousing is now mature, and in the near future we may be facing a shift in the most likely applications for Teradata (or are we facing it now?). Active data warehousing is just the first sign of this shift. More and more applications demand real-time loading and quicker response times.

Not long ago, the usual recommendation was to put access locks in all views. In the face of the shift toward active DW and more nearly real- time data, isn't it time to rethink this recommendation? Shouldn't we be designing our systems in ways that allow the customers to see the most up-to-date data without unnecessarily slowing down loads?

I ask this merely to get a discussion started.



     
  <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: 15 Jun 2023