?
Solved

Creating a tagging system

Posted on 2007-10-18
4
Medium Priority
?
184 Views
Last Modified: 2010-04-06
Hi there,

I need some help planning and executing a content tagging system (such as the one Flickr has to tag pictures). I want to know what is the correct way to design the database in the best optimized way to have tags stored at and related to the content they wrere `tagged` to.
I need the tags to be used for pictures, blog posts and some more extra content.
Also, I don't have any idea how to make popular tags be bigger and vice versa

Please notice - I don't want any ready code or examples, just theory guide lines.

P.S. I use ASP and Access database.

Thanks :-)
0
Comment
Question by:shmulik15
  • 2
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
strickdd earned 1000 total points
ID: 20108262
Depending on the size of your site, you may want to look at a MySQL or MS SQL DB. It will be a lot faster and better in the long run.

As far as the DB structure, I would say you need 3 tables:

ItemToTag
    ItemID
    Description
    etc.


ItemTags
    ItemID
    TagID


Tags
   TagID
   Description


The first table contains all the information about your item, i.e. a picture. The Last table contains all possible tags that can be associated with an Item. The middle table will link the PK of the first table to the PK of the last table which will allow you to easily get all tags associated with a particular item.
0
 

Author Comment

by:shmulik15
ID: 20109688
Thanks !

As for my second question - How do I make display of "popular tags", the popular the bigger etc?
0
 
LVL 28

Expert Comment

by:strickdd
ID: 20110058
Make the table like this instead:

Tags
   TagID
   Description
   Populate (bit)

Then in your code determine if it is popular and add a style around it.
0
 

Author Comment

by:shmulik15
ID: 20110167
Your popular field gave me an idea, I'll add something that counts the tags every 24 hours and rate them.

Your help is much appreciated.
Thanks again.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
While opting for any web-to-print solution, you need to discuss with your team and some of your end users and know their opinions about your decisions. In this article we list down some questions you need to ask yourself.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question