MySQL Forums :: Newbie :: appropriate database design and query


Advanced Search

appropriate database design and query
Posted by: gaurav mishra ()
Date: January 14, 2009 11:10AM

hi,
I am working on the project object recognition the thing is our in our algo we extract a very large sized feature vector from each image(ie 2000 values) representing
one vector.and we have about 40,000 images.


details of feature vector
in our algorithm we have 5 types of feature.there are 8 possible values for the first feature 5 for second and then 4 possible values for rest of features.
the vector which we store is that how many pixels belong to each of the possible combination of each type of feature there fore we have 8x5x4x4x4
columns in our vector.

i want to know what will be the best design for our database so that searching will be fastest.

currently we have split the database into 8 tables each corresponding to each type of first feature each table have 320 columns .....
the problem is querying the data is taking a very long time around 40 secs.......

we need to query for all the images which are closest to the query image....
closeness means all the columns values differ not more than 20 from input image feature values

Options: ReplyQuote


Subject Written By Posted
appropriate database design and query gaurav mishra 01/14/2009 11:10AM
Re: appropriate database design and query Rick James 01/14/2009 08:55PM
Re: appropriate database design and query gaurav mishra 01/15/2009 01:36AM
Re: appropriate database design and query hector vass 01/15/2009 03:10AM
Re: appropriate database design and query Rick James 01/15/2009 10:10AM
Re: appropriate database design and query Shishir Mittal 01/19/2009 02:31PM
Re: appropriate database design and query Rick James 01/19/2009 05:25PM


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.