I try to create a database that users can add their own tags for their posts, and be able to search in the database. I don't know how do I make a tag based database, how arrange them and how search for tags! Please help me find reference for it!
Algorithm for tagged search engine ?!?
Of course in the world of database design there are many ways to organize data (schemas). The link I have specified below covers this very topic of tagging posts and three possible ways to normalize the database to handle running queries. Some have performance advantages with more complex queries and some are a bit less fragmented but allow much more simplistic queries.
The link will show you how to setup the tables and run the appropriate queries for your schema type.
Good luck with the project.
No comments:
Post a Comment