Design Questions

Hi!

I've a table with measured values from nmr spectroscopy. For each measurement there are rows like this:

id structure values

1    1          3.5
2    1          3.6
3    1          4.2
4    1          5.2
5    1          7.5
6    2          4.2
7    2          6.3
8    2          8.2

In my database there are about 40 values per structure. With having the nmr data in the database I need an efficient solution for the following retrieval task.

Find the structures which have the values x1 .. xn, tolerance=d so for each xn the structure can hold a value that matches 0-100%

At the moment my result work with php array and n selects to my database which is indeed not efficient.

Does anybody has an idea how I can perform a better search? Maybe there is a better way to store the values?

Thanks

Alex Received on Sat Jul 21 2001 - 18:33:32 CDT