[pm-h] complex data structure help
Paul Archer
tigger at io.com
Tue Mar 28 13:11:02 PST 2006
1:30pm, Matt Sisk wrote:
> Paul Archer wrote:
>> 11:31am, Paul Archer wrote:
>>
>>
>>> <snip>
>>>
>>> Only that seems inefficient. Could I normalize that somehow?
>>>
>> I talked this over with a coworker. He suggested one table each for users,
>> client machines, and filesystems, just for lookups. Then one table for a
>> combination of the three, and one table for timeperiods with the bytes
>> written or read for each time period.
>>
>
> That's not just normalized...it's first normal form. ;)
>
> (more or less)
> Matt
Hmmm...so what would it take to get it to 3rd normal form?
More information about the Houston
mailing list