MySQL Forums
Forum List  »  MySQL Workbench

Re: Database design for scientific tests
Posted by: Martin Karm
Date: June 25, 2009 09:41AM

I see what you're saying. It isn't so much that the order of the data in the database tables matters, but that certain pieces need to be associated so the output is correct.

What do you think about adding a column named "line", where the number represents the line that you are working with for that particular sample.

For the example table:

Pressure | Temperature
______________________
...12........|.....21
...13........|.....22
...14........|.....23
...15........|.....24

would look like: (test_data_type 1 is pressure, 2 is temperature)

test_data_type | test_data_value | line
____________________________________
1........................|........12................|........1
2........................|........21................|........1
1........................|........13................|........2
2........................|........22................|........2
1........................|........14................|........3
2........................|........23................|........3
1........................|........15................|........4
2........................|........24................|........4

(Terrible tables again, sorry. Can I use html with these forums?)

This way you can query and group by line. It also adds some order to the tables.


For the most part this is a one time input of a lot of data, but I think it's prudent to assume more data may be added in the future, and that someone will really hate me if they find out who developed this database without the future in mind.

Thanks again for your help and advice, it is much appreciated as always.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Database design for scientific tests
2014
June 25, 2009 09:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.