Database Design for Tagging [closed]

by

Here’s a good article on tagging Database schemas:

http://howto.philippkeller.com/2005/04/24/Tags-Database-schemas/

along with performance tests:

http://howto.philippkeller.com/2005/06/19/Tagsystems-performance-tests/

Note that the conclusions there are very specific to MySQL, which (at least in 2005 at the time that was written) had very poor full text indexing characteristics.

More Related Contents:

  1. Recommended SQL database design for tags or tagging [closed]
  2. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  3. Create unique constraint with null columns
  4. Subqueries vs joins
  5. Database design for a survey [closed]
  6. Database Structure for Tree Data Structure [closed]
  7. Are soft deletes a good idea? [duplicate]
  8. Database Design for Revisions?
  9. Storing money in a decimal column – what precision and scale? [closed]
  10. How to store a list in a column of a database table
  11. Serial numbers per group of rows for compound key
  12. PostgreSQL: Which Datatype should be used for Currency?
  13. Why (and how) to split column using master..spt_values?
  14. Is there common street addresses database design for all addresses of the world? [closed]
  15. Facebook database design?
  16. How to create a multi-tenant database with shared table structures?
  17. Name database design notation you prefer and why?
  18. Can I set ignore_dup_key on for a primary key?
  19. Select (retrieve) all records from multiple schemas using Postgres
  20. Which datatype should be used for currency?
  21. Use email address as primary key?
  22. Composite Primary Keys : Good or Bad?
  23. SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?
  24. Which database design gives better performance?
  25. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  26. What is the best way to implement soft deletion?
  27. Is there a severe performance hit for using Foreign Keys in SQL Server?
  28. Is this a good way to model address information in a relational database?
  29. Temporal database design, with a twist (live vs draft rows)
  30. Single or multiple databases

Leave a Comment