TagSchema - MySQLForge Wiki
Popularity Report
![]() |
|||
![]() |
|||
![]() |
|||
![]() |
|||
![]() |
|||
![]() |
URL Tag Cloud
Bookmark History
Saved by 14 people (5 private), first by anonymouse user on 2007-05-10
- Firdausnasar on 2008-05-25 - Tags TAG , development , datamodel , schema
- Smoody on 2008-04-29 - Tags tags , schema , mysql , introduction , howto
- Ken2016 on 2008-04-17 - Tags Diigo , - , Ken's , Bookmarks
- Ken2015 on 2008-04-16 - Tags Diigo , - , Ken's , Bookmarks
- Ken2013 on 2008-04-16 - Tags Diigo , - , Ken's , Bookmarks
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


Public Comment