Tagging and Folksonomy Schema Design for Scalability and Performance
Tagging and Folksonomy Schema Design for Scalability and Performance The document discusses schema designs for tagging and folksonomy in SQL databases. It proposes a normalized schema with separate tables for tags, tag mappings between items and tags, and tag statistics. It provides examples of common queries for related items, related tags, and filtering results based on multiple included and exc
ã‚¿ã‚°ã¨ã‚ªãƒ³ãƒˆãƒã‚¸ãƒ¼
ã‚¿ã‚°ã¨ã¯ä½•ã‹ del.icio.usã®What are tags?ã‹ã‚‰ ブックマークãªã©ã‚’æ•´ç†ã—ãŸã‚Šå¾Œã§æ€ã„出ã™ãŸã‚ã«ã€è‡ªåˆ†ã§è‡ªç”±ã«ä¸Žãˆã‚‹1語ã®èª¬æ˜Ž ã‚¿ã‚°ã¯éšŽå±¤ãŒãªã自由ãªã®ã§ã€ã‚ã¦ãŒã„ã¶ã¡ã®åˆ†é¡žã«ç„¡ç†ã«åˆã‚ã›ã‚‹è‹¦åŠ´ãŒãªãã€æ‰±ã„ã‚„ã™ã„ ã»ã‹ã®äººã®ã‚¿ã‚°ã¨åˆã‚ã›ã¦ã€é–¢å¿ƒäº‹é …ã«ã¤ã„ã¦ã®å”調型レãƒã‚¸ãƒˆãƒªã‚’構築ã§ãã‚‹ 統制ã•ã‚Œãªã„自由ãªã‚ーワード 手軽ã«åˆ©ç”¨ã§ãã€æ–°ã—ã„ç¾è±¡ã‚‚ã™ãã‚¿ã‚°ã«ã§ãã‚‹ æ—¢å˜ã®çµ±åˆ¶èªžå½™ã§ã¯æ–°ã—ã„å‹•ãã«å¯¾å¿œã§ããªã„ 一方ã€å¤šæ•°ã®ãƒ¦ãƒ¼ã‚¶ãŒä¸Žãˆã‚‹ã‚ーワードã«ã¯ã€åŒç¾©èªžã€å¤šç¾©èªžãŒå¿…然的ã«å«ã¾ã‚Œã‚‹ 体系化ã®ãªã„フラットãªç©ºé–“ 階層ã§ã¯ãªãã€ã‚ーワードã®çµ„ã¿åˆã‚ã›ã§è©³ç´°æ¦‚念を柔軟ã«è¡¨ç¾ 一方ã€éšŽå±¤ã‚’利用ã—ãŸã‚°ãƒ«ãƒ¼ãƒ—化や関連概念ã®æ¤œç´¢ã¯ã§ããªã„ 統計的ãªã‚°ãƒ«ãƒ¼ãƒ—や関連付ã‘ã¯ã‚る程度å¯èƒ½ ã‚¿ã‚°ã®ã‹ãŸã¡ 対象ã€ãƒ¦ãƒ¼ã‚¶ã€ã‚ーワードã®3大è¦ç´ ã‚¿ã‚°ã¯ã€ã‚¿ã‚°ã‚’与ãˆã‚‹å¯¾è±¡ã€ã‚¿ã‚°ã‚’与ãˆã‚‹ãƒ¦ãƒ¼ã‚¶ã€ã‚¿ã‚°ã«ç”¨ã„
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
http://mikos.co.uk/tags/
Job Board WordPress Theme
Sliding Tags
{{#tags}}- {{label}}
{{/tags}}