Re: Database design for scientific tests
Thanks for catching the typo with the value field. I had it right in the ERD but coded it incorrectly.
I understand the idea of having the test_data_type field reference a list, and it does work for storing the data, but the "order" matters since this is tabular data that needs to be recreated or could have graphs as output. For instance:
Reference table:
id | name
__________________
1..|..pressure
2..|..saturation
Data I'm trying to store:
Pressure | Saturation
__________________
1..............|..99
2..............|..98
3..............|..60
How it looks stored (other PK and FK data would be included in this table also):
test_data_type | test_data_value
___________________________________
1........................|.....1
2........................|.....99
1........................|.....2
2........................|.....98
1........................|.....3
2........................|.....60
These can be stored as described, but there is importance in pairing 1 and 99, 2 and 98, etc because for graphing you need to know that the saturation is 99 when the pressure is 1. Even for just recreating the data as tables this would be important.
Any thoughts on how to "pair" these, other than just assuming the order is correct? Assuming anything sounds like a bad idea to me.
Things do get more complicated, but they also make much, much more sense.
Thank you once again!
Subject
Views
Written By
Posted
4184
June 22, 2009 06:44PM
1918
June 24, 2009 08:27AM
2018
June 24, 2009 09:24AM
1841
June 24, 2009 12:00PM
1658
June 24, 2009 02:20PM
1555
June 24, 2009 02:43PM
Re: Database design for scientific tests
1846
June 24, 2009 03:46PM
1891
June 24, 2009 06:05PM
2075
June 25, 2009 09:41AM
1413
June 25, 2009 12:34PM
2079
June 25, 2009 02:01PM
1691
June 25, 2009 02:28PM
2007
June 25, 2009 02:53PM
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.