Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Simple Metadata Expand / Collapse
Author
Message
Posted Sunday, December 14, 2008 3:52 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
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
Post #619349
Posted Monday, December 15, 2008 6:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2008 2:31 AM
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.
Post #619534
Posted Monday, December 15, 2008 8:50 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, January 17, 2014 1:33 PM
Points: 327, Visits: 101
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!
Post #619649
Posted Monday, December 15, 2008 9:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 4, 2014 8:26 AM
Points: 109, Visits: 490
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.)
Post #619696
Posted Monday, December 15, 2008 10:22 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 24, 2013 11:26 AM
Points: 208, 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. :P It's a corollary to the skepticism required when reading Wikipedia: don't trust and verify more carefully.

Show us your tag cloud, Steve!
Post #619791
Posted Monday, December 15, 2008 11:03 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
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
Post #619822
Posted Tuesday, December 16, 2008 3:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 20, 2014 5:17 AM
Points: 1,274, Visits: 1,985
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
Post #620272
Posted Tuesday, December 16, 2008 4:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
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






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #620828
Posted Tuesday, December 16, 2008 6:11 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 4, 2014 8:26 AM
Points: 109, Visits: 490
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


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.
Post #620846
Posted Tuesday, December 16, 2008 10:56 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
Now that sounds like Live search! :P






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #620955
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse