Re: Need help to organize database

On Tuesday 21 December 2004 22:00, Bruno Wolff III wrote:
> On Wed, Dec 22, 2004 at 00:16:06 +0000,
>
>   "Vladimir S. Petukhov" <vladimir@sycore.org> wrote:
> > On Tuesday 21 December 2004 21:21, Bruno Wolff III wrote:
> > > On Tue, Dec 21, 2004 at 20:47:31 +0000,
> > >
> > >   "Vladimir S. Petukhov" <vladimir@sycore.org> wrote:
> > > > Ok, this is a real example:
> > > >
> > > > CREATE TABLE account (
> > > >   val1     BIGINT      NULL,
> > > >   val2    BIGINT      NULL,
> > > >  ...
> > > >
> > > >   daypos    SMALLINT    NULL,   -- Day position
> > > >   hourpos   SMALLINT    NULL,   -- Hour position
> > > >   id        INT         NULL  -- Link to the object
> > > > );
> > >
> > > That approach is reasonable but depending on what the val* columns mean
> > > you might each of those as a separate role. You didn't add a lot of
> > > information, but that they appear to be the same type suggests that you
> > > might want one row per value. But without knowing what they mean it is
> > > hard to say.
> >
> > OK, i want to store ststistic information, ingoing/outgoing traffic,
> > ingoing/outgoing errors(val1-val4) for example...
>
> Those sound like different domains then for each column. So you probably do
> want to keep the 8 values in one row.
> I also noticed that you marked a lot of these values as NULL. I think that
> daypos, hourpos and id form the primary key and you probably don't want to
> allow NULLs for these.
Yes, of course, this is example only.
But relation between tables is not important now...
I whant to ask - is it a good idea to store 1 time's data (value1-4) per row
in 24*31 rows? May be it is better and quicker to store, for example, 2
time's data per row (value1-4, day 1,  value1-4, day 2) or other structure?