Tag System Implementation in Database

Question

Current Structure

table [Tags]

TagID
TagName

table [Stores]

StoreID
StoreName
StoreCategory
StoreTagID

this will only make the store have one tag , how can I implement it to allow more than one tag I made tags group but not working also parsing but its usless like tagid:tagname,tagid:tagname...... for the same row but not efficient.

possible duplicate of How do you recommend implementing tags or tagging — Martin Smith
– Martin Smith, Commented Sep 4, 2011 at 11:31

rbone · Accepted Answer · 2011-09-04 11:44:56Z

3

A common way to do this sort of thing is to create a third table e.g.

table [Store_Tags]

StoreID
TagID

Getting the tags for the Store then requires a join against Store_Tags to Tags e.g.

SELECT TagName FROM Tags INNER JOIN Store_Tags USING(TagID) WHERE StoreID = ?

An alternate approach would be to avoid using the Tag table and put the TagName directly in the Store_Tags table, it really depends how you intend to use the data.

answered Sep 4, 2011 at 11:44

rbone

934 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rbone Over a year ago

So the idea behind the Store_Tags table is that it enables you to have multiple tags for the store. Whenever you want to add a new tag to the store you insert a new row with the StoreID and the TagID of the new tag.

genesis · Accepted Answer · 2011-09-04 11:53:45Z

1

StackOverflow has all tags in separated DB table

Posts
  PostId
PostTags
  PostId
  TagId
Tgas
  TagId
  TagName

you can do similar

edited Sep 4, 2011 at 11:53

answered Sep 4, 2011 at 11:31

genesis

51.1k20 gold badges99 silver badges127 bronze badges

3 Comments

Martin Smith Over a year ago

Have you a link to support that? Seems very unlikely to me as this can't be indexed making searches by tag inefficient.

Martin Smith Over a year ago

Ah Ok. But notice they also have a PostTags table. That tag list is presumably a denormalised version of that.

genesis Over a year ago

@MartinSmith: ah yes, you're right. data.stackexchange.com/stackoverflow/q/111595 ... edited

Collectives™ on Stack Overflow

Tag System Implementation in Database

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related