Re: Specifying all biz rules in relational data

mAsterdam wrote:

> robert wrote:

>> ...  the batch processing
>> COBOL folk will simply not allow even 3rd normal form structures.  they
>> simply don't chew as fast as VSAM flat files for that kind of processing.

Marketing databases benefit greatly from batch processing, as I would imagine would any largely static database.

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.

-- 
Kenneth Downs
Use first initial plus last name at last name plus literal "fam.net" to
email me