Re: A Question on Integrety
Date: Mon, 15 Dec 2003 15:42:10 -0000
"Jerry Gitomer" <jgitomer_at_erols.com> wrote in message
> Some possible approaches to your problem:
> 1. Put raw data in files and don't move it into the database until it
> is fully validated.
> 2. Have two tables, one for validated data and one for unvalidated
> data. Move after validation complete.
> 3. Add a bit mask column where each bit represents one of the columns
> requiring validation. As a column is validated in a row set the
> appropriate bit in the bit mask. This approach would allow you to
> extract fully validated rows for inclusion in your directory and to
> generate reports, statistical or detailed, on any selected validation
Thanks for the reply Jerry,
I had considered option 2, although I'm not entirely happy with it! Option 3 is an interesting approach, which may be of use for publishing purposes as you say.
Received on Mon Dec 15 2003 - 16:42:10 CET