Professional Web Applications Themes

Tagging System - MySQL

well, this is not a completely mysql related topic, but i tihnk mysql users/developers might be interested in the topic, so i post here... Q. What is the best database table design for a tagging system? Consider the following examples... tags for item A : coke cola tags for item B : fanta drink tags for item C : coke pepsi drink .... .... so the following set are generated: (only one-level depth) set for the tag "coke" : cola pepsi drink .... any idea on this?...

  1. #1

    Default Tagging System

    well, this is not a completely mysql related topic, but i tihnk mysql
    users/developers might be interested in the topic, so i post here...


    Q. What is the best database table design for a tagging system?

    Consider the following examples...


    tags for item A : coke cola
    tags for item B : fanta drink
    tags for item C : coke pepsi drink
    ....
    ....

    so the following set are generated: (only one-level depth)

    set for the tag "coke" : cola pepsi drink
    ....

    any idea on this?

    howachen@gmail.com Guest

  2. #2

    Default Re: Tagging System


    [email]howachen[/email] wrote:
    > well, this is not a completely mysql related topic, but i tihnk mysql
    > users/developers might be interested in the topic, so i post here...
    >
    >
    > Q. What is the best database table design for a tagging system?
    >
    > Consider the following examples...
    >
    >
    > tags for item A : coke cola
    > tags for item B : fanta drink
    > tags for item C : coke pepsi drink
    > ...
    > ...
    >
    > so the following set are generated: (only one-level depth)
    >
    > set for the tag "coke" : cola pepsi drink
    > ...
    >
    > any idea on this?
    this looks like a thesaurus. there's stuff out there on thesaurus db
    construction - also, tematres provide open source thesaurus management
    which I've heard good things about.

    strawberry Guest

Similar Threads

  1. FND: Connection Tagging
    By Unregistered in forum Brainstorming Area
    Replies: 0
    Last Post: April 13th, 03:36 AM
  2. flash tagging
    By darlenesanche in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: May 18th, 03:56 PM
  3. XML: tagging groups that are not together in layout
    By Rowan_Ferguson@adobeforums.com in forum Adobe Indesign Windows
    Replies: 4
    Last Post: June 2nd, 01:40 PM
  4. problem with html tagging and forms
    By lisafitz in forum Web Design
    Replies: 1
    Last Post: January 11th, 05:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139