Skip to main content

TagSchema - MySQLForge Wiki

Popularity Report

Total Popularity Score: 0

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...

Rank

Bookmark History

Saved by 14 people (5 private), first by anonymouse user on 2007-05-10


Public Sticky notes

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.

Highlighted by smoody

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.

Highlighted by jonphipps

The recommended solution for an efficient, normalized tagging schema is a refinement on the Toxi solution. The storage engine used in the recommended solution is the InnoDB storage engine, because of its benefits of higher concurrency limits, referential integrity, and a clustered data organization, which makes primary key lookups very fast. Primary key lookups are the dominant data access pattern in tagging schema, which makes InnoDB an ideal storage engine, especially for the master server in a replicated setup (see more below)

Highlighted by ken