patternMinor
Recommendations for building a big search engine
Viewed 0 times
enginesearchbuildingbigforrecommendations
Problem
I am creating a image search engine that would probably have millions of images tagged with keywords. Basically it would be something like Google Image search.
So I want to ask for any tips on designing the database of the application.
What kind of database system to use? How would the images table look like to store that huge quantity? How do I create the relation between the keywords and the image to be able to do a very quick search?
The programming will be done using a PHP Framework.
Thank you,
Alex.
So I want to ask for any tips on designing the database of the application.
What kind of database system to use? How would the images table look like to store that huge quantity? How do I create the relation between the keywords and the image to be able to do a very quick search?
The programming will be done using a PHP Framework.
Thank you,
Alex.
Solution
you might consider to use an indexing framework like Apache Lucene as well. If not, I would recommend to model an inverted index like database. An inverted index uses keywords as key identifier for a set of images.
Inverted Index Table:
Image Table
Inverted Index Table:
keyword image_ids
"sun" : [1,5,6]Image Table
image_id size ...
1 200x300 ...Code Snippets
keyword image_ids
"sun" : [1,5,6]image_id size ...
1 200x300 ...Context
StackExchange Database Administrators Q#17779, answer score: 4
Revisions (0)
No revisions yet.