Re: Dynamic table

2009/6/16 Greg Stark <gsstark(at)mit(dot)edu>

> On Tue, Jun 16, 2009 at 12:21 PM, A B<gentosaker(at)gmail(dot)com> wrote:
>
> I don't think think it's fair to call this EAV actually. It sounds
> like the integers are a collection of things which represent the same
> thing. Ie, they're all bank balances or all distances driven, just for
> different time periods. Storing all objects representing the same
> thing in the same column is just a regular normalized table, not EAV.
>
> You might want to consider partitioning the table of integers by type
> to facilitate dropping the old ones. But that's an administrative
> trick, not a fundamental schema design decision.

Unfortunatly there is no "type" here. One can make no distinction between
the integers and one can not tell when they are added or dropped.