TagSchema - MySQLForge Wiki - The Diigo Meta page

• 20 Jul 12
  

  Jaspal Sahota

  database tags

• 08 Nov 11
  

  emilchacko

  mysql schema database tagging

• 22 Oct 11
  

  Neil Cook

  mysql schema database tagging tags sql folksonomy tag

  • Schema

     

    The schema involves three tables which represent the many to many relationship between the item and the tag. Here, we deviate from the bookmark paradigm and use a general "item" semantics to indicate that the type of item is irrelevant to the schema design. 

     

    CREATE TABLE Items ( item_id INT UNSIGNED NOT NULL AUTO_INCREMENT , item_name VARCHAR(255) NOT NULL /* Many more attributes of the item... */ , PRIMARY KEY (item_id) ) ENGINE=InnoDB; 

     

    CREATE TABLE Item2Tag ( item_id INT UNSIGNED NOT NULL  , tag_id INT UNSIGNED NOT NULL  , PRIMARY KEY (item_id, tag_id) , INDEX (tag_id) , FOREIGN KEY fk_Item (item_id) REFERENCES Items (item_id) , FOREIGN KEY fk_Tag (tag_id) REFERENCES Tags (tag_id) ) ENGINE=InnoDB; 

     

    CREATE TABLE Tags ( tag_id INT UNSIGNED NOT NULL AUTO_INCREMENT  , tag_text TEXT NOT NULL , PRIMARY KEY (tag_id) ,  UNIQUE INDEX (tag_text) ) ENGINE=InnoDB;
• 14 Aug 11
  

  sql tags mysql schema

• 17 Jun 11
  

  oriolmari
• 22 Mar 11
  

  usingsystem

  tag tagging db table tutorial database

• 11 Jan 11
  

  CK Lee

  database design tag

• 10 Nov 10
  

  gpittau

  • Tagging and Folksonomy Schema Concepts

     

    This page and related pages describe various issues surrounding the Web 2.0 tagging and folksonomy concepts, including discussions on schema architecture, common data access patterns, and replication/scale-out guidelines.
• 23 Mar 10
  

  Salah K

  tag tagging schema data er model

• 14 Feb 10
  

  manu dea

  his page and related pages describe various issues surrounding the Web 2.0 tagging and folksonomy concepts, including discussions on schema architecture, common data access patterns, and replication/scale-out guidelines.

  mysql schema folksonomy tagging tags tag sql database

• 21 Oct 09
  

  Philip Guth

  schema tagging folksonomy tags optimization database tag

  • The schema involves three tables which represent the many to many relationship between the item and the tag. Here, we deviate from the bookmark paradigm and use a general "item" semantics to indicate that the type of item is irrelevant to the schema design.
• 10 Oct 09
  

  Hardy Heron

  article sql mysql tagging schema folksonomy tag tags database design

• 10 Sep 09
  

  Simon Brüchner

  db schema tag database delicious import

• 23 Jun 09
  

  Kai Lautaportti

  mysql schema tagging

• 20 May 09
  

  xiao xigua

  mysql schema database design sql programming web2.0 reference tags tag tagging folksonomy

• 25 Apr 09
  

  Joy Whatever

  database tagging programming

• 24 Mar 09
  

  Eric Rodriguez

  web2.0 social webdev programming article database design del.icio.us sql mysql tagging tags tag folksonomy schema

• 10 Jan 09
  

  veverkap

  del

• 19 Nov 08
  

  quibulicet

  tagging tagschema tags sql

• 29 Oct 08
  

  oscar diaz
  • A tag schema is a database schema which attempts to facilitate the storage and retrieval of tag data, and to allow for increasingly complex data analysis of the relationships formed by linked tags and items.
• 15 Sep 08
  

  Colleen Greene

  Excellent tutorial for designing a tagging taxonomy structure in MySQL.

  mysql database taxonomies

• 23 Jul 08
  

  Craig Boal

  tagging

• 22 Jul 08
  

  gorden wu

  tagging mysql

• 28 Jun 08
  

  giuliano riccio

  mysql tagging schema database

• 19 Jun 08
  

  Aaron Jackson

  database schema mysql

• 25 May 08
  

  Firdaus Nasar

  TAG development datamodel schema

• 29 Apr 08
  

  Scott Moody

  tags schema mysql introduction howto

  • Tagging and Folksonomy Schema Concepts

     

    This page and related pages describe various issues surrounding the Web 2.0 tagging and folksonomy concepts, including discussions on schema architecture, common data access patterns, and replication/scale-out guidelines.
• 21 Mar 08
  

  Jon Phipps

  5stars mysql registry

  • This page and related pages describe various issues surrounding the Web 2.0 tagging and folksonomy concepts, including discussions on schema architecture, common data access patterns, and replication/scale-out guidelines.
• 

  l.m orchard

  databases mysql socialsoftware tags

• 

  Thomas Vander Wal

  A resource for understanding and sharing MySQL database schemas for social bookmarking.

  tag tagging tags folksonomy mysql optimization schema database coding webdev wiki technology socialsoftware sql programming reference socialbookmarking socialcomputing socialtagging social

• 05 Feb 08
  

  Nicolas Perriault

  This page and related pages describe various issues surrounding the Web 2.0 tagging and folksonomy concepts, including discussions on schema architecture, common data access patterns, and replication/scale-out guidelines.

  mysql tags folksonomy database schema architecture optimization sql

• 

  This page and related pages describe various issues surrounding the Web 2.0 tagging and folksonomy concepts, including discussions on schema architecture, common data access patterns, and replication/scale-out guidelines.

  mysql tags folksonomy database schema architecture optimization sql

• 

  Marc Carlucci

  mysql tags folksonomy article database

• 

  matthieu bozec

  tagging tags folksonomy

• 09 Oct 07
  

  Sajith Appukuttan

  Mysql database

• 12 Aug 07
  

  Lawrence C

  mysql tagging

• 17 Jun 07
  

  stefan_ua

  coding folksonomies MySQL schema SQL delicious

• 13 May 07
  

  Benedikt Hanswille

  folksonomy mysql schema tagging web_development

• 04 May 07
  

  Andrew Moist

  mysql tagging schema database tags tag design

• 01 Jan 07
  

  Chris Waigl

  Folksonomies etc in MySQL

  mysql database tagging coding

• 26 Dec 06
  

  Steven Moberg

  tagging

• 25 Dec 06
  

  zigorou

  database DB design folksonomy mysql sql storage tagging tags technology toread webdev wiki schema tag Architecture

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.