Designing a tagging system
I need some advice :-)
I want to implement a tagging system to an article script instead of the traditional category-based system.
For example, user writes their article then enters one or more tags "php, database, zend" for it. These tags are then used when searching to bring up relavent articles.
I have come up with three ideas for the design of the tagging system:
When saving tags we just update that articles
When searching for tags, a simple
When generating tag clouds, a query is run to fetch everything in the
tag_id - An auto_increment id for this tag
tag - The tag itself (eg, "php")
articles - a space-seperated list of article_id's that use this tag (eg, "1 4 15 18 19 76")
When saving tags we would have to fetch the
When searching for tags we just do a simple search of the
When generating tag clouds we just select the tags column and a count(article_ids) to generate the weighting, etc.
This one has three tables:
Articles is just the regular un-touched articles table.
Tags would have the following structure:
tag_id - An auto_incrment id for this tag
tag - the tag itself
article_tags would have the following structure:
tag_id - links to the tag in the
article_id - links to the article in the [inline]articlesp/inline] table
When saving tags, you just add a new tag to the tags/article_tags tables. When removing a tag you would just remove the row from the articles_tags table.
When searching for tags you would do a simple join query since all fields have a single value it would be simple.
When generating tag clouds you would just do a join on the tags table with a count(tag_id) for weighting
Those are the options so far and I am leaning towards number 3 as it seems to be the most logical.
What do you guys thing? Anything I'm missing? Any other options you can think of?
At first I'm leaning towards idea #1, but on second read, I'm gonna go with idea #3. The most logical one to me that is. If you search, you search on articles, but through the usage of tags. You can either search on the title (perhaps split by the whitespace) or on tags. Of course, a lot of other options can be implemented like date or author, but non of that now.
I think the most wise way to approach this is to indeed link them together.
The process of searching is then rather simple. If the searchquery matches a tag from the tags table, it then shows every article and retrieves the information. Of course, linking them by ID to simply "SELECT article_id FROM articles WHERE article_id = $tagsQueryID".
I hope this gives you a bit of perspective.
Whenever I have built a tagging system I have gone with #3.
Number 3 is indeed the most logical one and will make it easier to count tags and select what articles belong to what tags.
Inserting tags will be easy, you'll probably do an explode in the data, remove spaces and unwanted characters and then add each one to the DB.
What you really have to think about is tag maintenance. If somebody wants to edit the tags of his/her article, are you going to display each tag in a different form field and let the user edit/delete them individually? You could implode the tags back into a comma-seperated list and then you first delete all tags for that article and add them again. What I'm trying to point out is that #3 has it's advantages but it also makes tag maintenance a little more complicated than #1 for example. :-)
The best way, like DeMo suggested, is to make it comma seperated , or perhaps with a more common way. Although I would suggest that, for the users sake, a comma and a space like in meta tags is the best way.
First you would make the user enter their information. Then you would split it on the space-comma value and make the array filter out all sorts of invalid chars, like quotes and slashes. Do not add slashes, since I had difficulty with the search when I did.
|All times are GMT. The time now is 01:28 AM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0