Re: db design for measurement data?

It depends on what you want to do with the data. Do you need every row available or will summaries suffice? Does the data have to be available immediately or is some lag permitted? Can you use a datawarehouselike star schema? How long do you have to keep the data available online? Can you partition your tables (in Oracle)?

Van

"ronald schirmer" <roschi_at_hrz.tu-chemnitz.de> wrote in message news:3B05150F.743865AA_at_hrz.tu-chemnitz.de...
> Hi,
>
> I have to design a data base for storing time depending measurement
> data. The data should be accessable via web frontend. The data (e.g.
> quantities of a photovoltaic system) is logged at every second and may
> contain the quantities shown below:
> - global radiation
> - electrical power
> - current
> - voltage
> - temperature of the PV - module
> - e.t.c.
>
> This means, there will be 86400 new rows (tuples) a day according to a
> usual relational data modelling scheme. With my little knowledge of data
> base design (ER-model, normalization) I've got no idea, how to create a
> data model for such a problem.
> Does anyone have a good link or knows useful literature or has
> experience in designing data bases for such topics?
>
> Thank sou very much for every hint.
>
> Ronald.
Received on Sat May 19 2001 - 05:44:25 CEST