From: Todd Benson <caduceass@...>
Date: 2008-04-02T02:20:09+09:00
Subject: Re: should I use a database or a flat file?

On Tue, Apr 1, 2008 at 12:13 PM, Todd Benson <caduceass@gmail.com> wrote:
>
>  Maybe we are talking about different things.  By data integrity, I
>  mean you can be certain not just that the data was entered correctly,
>  but also that it coincides with the relationships present.  In a
>  modified version of the OP's model, for example...
>
>
>  Cat1
>  -name1
>  -name2
>  -name3
>  -etc...
>
>  Cat2
>  -name4
>  -name5
>  -name6
>  -etc...
>
>  Cat3
>  -name1
>  -name2
>  -name3
>  etc...
>
>  Note the same category names, but in different categories.
>
>  Now, surely, you can say, "Well, the application logic will take care
>  of that ambiguity."  But I say we should continue to separate
>  application logic from data logic.
>
>  I'm no CS guy, so I don't know the correct terms for this, but I do
>  see the potential pratfalls.
>
>  There certainly is a time and place for this, but I've found it's
>  usefulness generally not that beneficial.
>
>  Todd
>

Sorry Lionel; missed the OP's "But each name will go in only one
category".  I do still think it wouldn't be that bad to use a DB.

Todd