Re: Specifying all biz rules in relational data
Date: Tue, 21 Sep 2004 22:52:07 -0400
Message-ID: <yNKdnZlKDaZodc3cRVn-qQ_at_comcast.com>
"Kenneth Downs" <firstinit.lastname_at_lastnameplusfam.net> wrote in message news:2pnqic.44v.ln_at_mercury.downsfam.net...
> Every three months you do an NCOA on a marketing database, National Change
> of Address. Reading and writing 10 million rows in a transactional
> database is very bad news. You just don't need ACIDity on a row-by-row
> basis. What we do is dump the file to disk, run it through the process,
> erase the tables, and reload them. This is three complete read/write
> passes and it is still 100 times faster than buying the overhead of
ACIDity
> on the updates.
Yes but reading and writing 10 million rows in a data warehouse is a piece
of cake.
The moral: Not all databases should be transactional databases.
Received on Wed Sep 22 2004 - 04:52:07 CEST