Strategies for storing tags

  • kangarolf

    Hall of Fame

    Points: 3361

    Hi all,

    I am replacing a fixed category structure with a free form tagging structure.

    The tags will be one (parent record) to many (tag record).

    I like the simplicity of just storing them as delimited varchar columns BUT what I run into is the issue of splitting these back up for the purpose of creating auto suggestions.

    So if we have 'feedback, testing' as a tag entry I can search easily enough but if I wanted to get out a list of individual tasks I'm stumped as how to do it effectively.

    The alternative is to normalise and go with relationship tables.

    Anyone have any thoughts..?

  • Gail Shaw

    SSC Guru

    Points: 1004424

    kangarolf (3/17/2015)


    The alternative is to normalise and go with relationship tables.

    Yup.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply