Re: appropriate database design and query

[gaurav mishra]

Thanks for the reply.
We are not storing images in the database, so we don't need any blob data type, all are integer values between 0 and 20000 with maximum values in the range 0 to 1000.

The problem is we don't have a single table. Presently we have 8 tables each with 320 columns to accommodate (320*8=)2560 values corresponding to each image.
Is the number of tables appropriate?

Following your description, the query should be
SELECT imageId from table1
INNER JOIN table2
using (imageId)
INNER JOIN table3
using (imageId)
...
table8 using (imageId)
WHERE table1.a BETWEEN ?-20 and ?+20
AND table1.b BETWEEN ?-20 and ?+20
AND table1.c BETWEEN ?-20 and ?+20
table2.a BETWEEN ?-20 and ?+20
AND table2.b BETWEEN ?-20 and ?+20
AND table2.c BETWEEN ?-20 and ?+20
table3.a BETWEEN ?-20 and ?+20
AND table3.b BETWEEN ?-20 and ?+20
AND table3.c BETWEEN ?-20 and ?+20
...
table8.a BETWEEN ?-20 and ?+20
AND table8.b BETWEEN ?-20 and ?+20
AND table8.c BETWEEN ?-20 and ?+20

Am I right?