Re: db design for measurement data?

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:45 CEST