Re: db design for measurement data?

Go to a good bookstore and take a look at the data warehousing books. Skim through a few will give you an overview and you can decide if this is an approach that would be useful.

"Ronald Schirmer" <roschi_at_hrz.tu-chemnitz.de> wrote in message news:3B091420.21E82C87_at_hrz.tu-chemnitz.de...
> Hi Van,
>
> thanks for your reply.
>
> > It depends on what you want to do with the data. Do you need every row
> > available or will summaries suffice?
>
> I will need every row. There will be no chance to shorten or summarize
> the measurement results.
>
> > Does the data have to be available immediately or is some lag permitted?
>
> Depends on what you consider "some lag" :-) . When a query (e.g. via web
> frontend) is made to the data base, the results should be retrieved
> within a few minutes.
>
> > Can you use a datawarehouselike star schema?
>
> I've already heared about "datawarehouselike" things - but I've got no
> clue what that is? Could you, please, explain or do you no a useful URL
> dealing with that topic?
>
> > How long do you have to keep the data available online?
>
> This is going to be a long term project, so there's no
> end-of-store-date.
>
> > Can you partition your tables (in Oracle)?
>
> I'm not sure yet, which dbms to use. I wanted to decide after the db
> design.
>
> Thanks for every hint.
>
> Ronald.
Received on Sun Jul 22 2001 - 01:24:19 CEST