Archives of the TeradataForum
Message Posted: Wed, 01 Mar 2007 @ 02:02:05 GMT
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.
|