SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Simple Metadata


Simple Metadata

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63027 Visits: 19112
Comments posted to this topic are about the item Simple Metadata

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
karen-608264
karen-608264
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 2
Tags can be thought of as property values for an instance of an object. Adding a tag is like extending an object definition by adding a new property and setting a value for an instance of that object. The difficulty is in defining the relevant properties of the entire object up-front. The intent and purpose and audience must be understood from the usage start or else there must be the capability to evolve the definition (this may break some of its historical usages though). In some cases, it could be helpful to associate a "measurable degree" to the property which indicates just how much the value assigned to the object is a good fit relative to a defined list of possible values. The category and subcategories should always be in the set of tags for an object in some way, shape or form.
Jeff Kunkel-812485
Jeff Kunkel-812485
Old Hand
Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)

Group: General Forum Members
Points: 331 Visits: 112
Great editorial Steve!

This is a topic that we could see more of. Articles that discuss the use of tags, how to implement them in the area of SQL development and something that details the conceptual switch of using cats and sub-cats to using tags. Your team appears to have made that transition very well on the site.

Good job!
Cade Roux
Cade Roux
SSC Veteran
SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)

Group: General Forum Members
Points: 206 Visits: 491
You can always use tags and then build a taxonomy later based on the tags.

A project I developed (an inhouse used equipment sale/trading site - which eventually got canned before release as the business decided to get out of that part of the business), but we used tags and a tag cloud to allow flexibility to the users and administrators of the system and then used the tags that emerged to make some hierarchies amongst some of the tags.

The tags were great for maintenance, browsing and search, and then identifying certain popular emergent tagging behaviors and building hierarchies later allowed us to make very malleable hierarchies (since the hierachy was simply a many-to-many tag relationship, and had nothing to do with the items being tagged.)
David Reed-223505
David Reed-223505
SSC Veteran
SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)

Group: General Forum Members
Points: 280 Visits: 380
I've blogged about the perils of tagging, especially tagging that's done by the great unwashed. A search engine that relies solely on tags is very weak, IMO. Searching for Mexican Food... on CodePlex? It can be a good source of entertainment, though. Tongue It's a corollary to the skepticism required when reading Wikipedia: don't trust and verify more carefully.

Show us your tag cloud, Steve!
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63027 Visits: 19112
I'd like to get a cloud up there and thanks for the comments.

I think it would look funny as I haven't done a great job of tagging things outside of a category/sub category until the last couple months.

I'll work on making it better and we'll see if it helps.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
StarNamer
StarNamer
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1650 Visits: 1992
One use of tags I've encountered which has an interesting side-effect is Google mail.

Google allows messages to have "labels" (aka "tags") rather than setting up a folder-based system. Any message can have any number of labels, so it is simply a tag system, but, of course, existing mail clients see the tags as "folders", which means the tags have to include any hierarchy explicitly (e.g. 'SQL', 'SQL/SSIS', 'SQL/SSRS'). If you just use basic tags ('SQL', 'SSIS', 'SSRS') then you get a flat view.

Google mail is also currently limited to displaying matches on single labels, whereas a proper tagging system should be able to search multiple tags, which is, of course, the effect being achieved by the hierarchy type tags.

Derek
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63027 Visits: 19112
I need to look at Google mail. I've heard it searches well, and it should. Right now my account is an archive where I send stuff I want to keep w00t

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Cade Roux
Cade Roux
SSC Veteran
SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)SSC Veteran (206 reputation)

Group: General Forum Members
Points: 206 Visits: 491
Steve Jones - Editor (12/16/2008)
I need to look at Google mail. I've heard it searches well, and it should. Right now my account is an archive where I send stuff I want to keep w00t


gmail search is not as good as regular google search. For some reason the gmail engine is different from the regular google engine: in particular partial word matches, if you search for "book" instead of "books" it will not match.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63027 Visits: 19112
Now that sounds like Live search! Tongue

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search