I found some posts on this tags issue
Tags: Database Schemas
http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html
and some performance tests on the above schema
Tagsystems: Performance tests
http://www.pui.ch/phred/archives/2005/06/tagsystems-performance-tests.html
The way I thought about doing it in normal SQL with joins was basically the second approach, having it mostly normalised but just using the tagname as the tad id.
Now, the question remains of how to do this in BigTable without any joins? The full text search schema still remains but I don't think that's a scalable solution so I'm not really interested in that approach.
Tags: Database Schemas
http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html
and some performance tests on the above schema
Tagsystems: Performance tests
http://www.pui.ch/phred/archives/2005/06/tagsystems-performance-tests.html
The way I thought about doing it in normal SQL with joins was basically the second approach, having it mostly normalised but just using the tagname as the tad id.
Now, the question remains of how to do this in BigTable without any joins? The full text search schema still remains but I don't think that's a scalable solution so I'm not really interested in that approach.
No comments:
Post a Comment