Re: Specifying all biz rules in relational data

From: Laconic2 <laconic2_at_comcast.net>
Date: Tue, 21 Sep 2004 22:52:07 -0400
Message-ID: <yNKdnZlKDaZodc3cRVn-qQ@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 Tue Sep 21 2004 - 21:52:07 CDT