This link has been bookmarked by 72 people . It was first bookmarked on 10 May 2007, by someone privately.
-
20 Jul 12
-
08 Nov 11
-
22 Oct 11
-
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
-
17 Jun 11
-
22 Mar 11
-
11 Jan 11
-
10 Nov 10
-
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
-
14 Feb 10
-
21 Oct 09
-
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
-
10 Sep 09
-
23 Jun 09
-
20 May 09
-
25 Apr 09
-
24 Mar 09
-
10 Jan 09
-
19 Nov 08
-
29 Oct 08
-
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 GreeneExcellent tutorial for designing a tagging taxonomy structure in MySQL.
-
23 Jul 08
-
22 Jul 08
-
28 Jun 08
-
19 Jun 08
-
25 May 08
-
29 Apr 08
-
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
-
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.
-
-
Thomas Vander WalA 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 PerriaultThis 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
-
09 Oct 07
-
12 Aug 07
-
17 Jun 07
-
13 May 07
-
04 May 07
-
01 Jan 07
-
26 Dec 06
-
25 Dec 06
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.