Re: Database structure - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Database structure
Date
Msg-id 20040504162539.GA10698@wolff.to
Whole thread Raw
In response to Re: Database structure  (Svenne Krap <svenne@krap.dk>)
List pgsql-sql
On Tue, May 04, 2004 at 18:10:13 +0200, Svenne Krap <svenne@krap.dk> wrote:
> 
> In the long run, being correct is usually better than being fast (at the 
> point of the implementation), as new hardware easily solves bottlenecks 
> for problems not scaling exponentially.

And it isn't even clear that denormalizing the schema will result in an increase
in speed.

If at some point the tests in various assessments can overlap you may not
want an assessment for each table.

I also noticed that the schema isn't enforcing consistancy between the
tests done and the assessment type being done. This may not really be a
business rule as much as something that might be flagged by the application
for attention as I can see cases where in reality the wrong test is done
and recording its results might be better than throwing the data away.


pgsql-sql by date:

Previous
From: Svenne Krap
Date:
Subject: Re: Database structure
Next
From: Rob
Date:
Subject: Re: Rank