Tags: Database schemas - The Diigo Meta page

• 03 Sep 15
  
• 30 Aug 15
  

  Serge Courrier

  Internet Web [typologie] Web_social tag folksonomy Tagging schemas database média_social réseau_social Web_2.0

• 27 Nov 12
  

  meysam69

  create tags system

  php

• 18 Nov 12
  

  Alireza Sarabchi

  database tagging tags mysql programming schema development

• 02 Aug 12
  

  Chris Laslett

  tagging

• 08 Jul 12
  

  John Doe

  tagging tags mysql database schema sql programming delicious

• 01 Apr 12
  

  Dominik Mozny

  How to create database schema for tags.

  tag database schema create

• 14 Mar 12
  

  steve_hoang01

  algorithm tags mysql

• 

  Justin Endacott

  database tagging tags mysql sql schema design

• 12 Mar 12
  

  highestwatermark

  Tag の実装方法

  tag

• 06 Mar 12
  

  oxygen84

  Makes some sense, somewhat confused by primary keys though.

  database tagging schema

• 31 Jan 12
  

  Jeffrey Carpenter

  mysql tagging database tags sql article dev search schema db design topology delicious performance sysadmin programming reference

• 11 Jan 12
  

  abhijit nandy

  rdbms

• 05 Jan 12
  

  Daniel Carrier

  database tags schema

• 01 Nov 11
  

  Andreas Formiconi

  database tags tagging mysql sql del.icio.us schema

• 17 Sep 11
  

  vishal garg

  Implement tags using mysql and php

  tag php web mysql delicious

  • denormalized.
• 22 Aug 11
  

  kostas romporas

  tagging mysql del.icio.us

• 15 Aug 11
  

  zahidadeel

  database design tags tagging

• 09 Jun 11
  

  S LN
  • =====================
      Site-Party–Tag
     =====================
      site_id
      party_id
      tag_id
     =====================
• 06 Jun 11
  

  dkovachev

  database tagging schema

• 25 May 11
  

  Juha Lahti

  database tags programming

• 22 May 11
  

  ces fab

  database schema for tags

  database-schema database-design

• 19 May 11
  

  Paul Cottrell

  database tagging tags mysql sql

  • my performance tests
  • MySQLicious” solution
  • “Scuttle” solution
  • “Toxi” solution

  2 more annotations...

• 07 Apr 11
  

  Sunan Yang

  database tagging schema

• 05 Mar 11
  

  terpimost

  db tags sql schema performance

• 30 Jan 11
  

  usingsystem

  Toxi

  tag tagging performance database db delicious diagram tutorial

• 29 Jan 11
  

  Anthony Lepki

  database tagging tags programming sql schema

• 28 Jan 11
  

  eugene trileski

  mysql del.icio.us tags

• 15 Jan 11
  

  Imke Gideonse

  3 voorbeelden van tags gebruiken in een database. Namelijk in 1, 2 of 3 tabellen.

  tag database boekenbieb

• 24 Dec 10
  

  Khánh Trần

  database tags keyword design sql

• 14 Dec 10
  

  Naoj Gior

  tags database schema mysql

• 09 Dec 10
  

  S. Dalb

  requete(sujet) delicious(sujet) schéma-de-métadonnées(sujet) delicious

• 24 Nov 10
  

  David Heller

  database tagging schema toxi

• 18 Nov 10
  

  renatoaquino

  architecture database tagging folksonomy

• 17 Nov 10
  

  Arek L

  development db web2.0 mysql architecture articles

• 30 Oct 10
  

  Recently, on del.icio.us mailinglist, I asked the question “Does anyone know the database schema of del.icio.us?” . I got a few private responses so I wanted to share the knowledge with…

  programming tags database

• 05 Oct 10
  

  bbonifield

  'bookmark', 'webservice', 'semweb'

  programming sql MySQL

• 26 Aug 10
  

  Probe Probe

  数据库如何组织tag

  Database MySQL for:nkuilli@gmail.com

• 16 Aug 10
  

  Reg Man

  Database Design Tags

• 06 Aug 10
  

  Mohamed Salem Korayem

  tagging tags architecture database schema design sql delicious tutorials performance search q

• 04 Aug 10
  

  jonnynr5

  database mysql tagging tags programming

• 29 Jul 10
  

  Rick Callahan

  mamacasting

• 06 Jul 10
  

  T B

  tags database schema mysql

• 02 Jul 10
  

  artworklv

  development programming tags solution

• 30 Jun 10
  

  Nidal Al Hariri

  database tags tagging mysql schema

• 

  Walter Wang
• 
• 24 Jun 10
  

  Jon E Eguiluz

  mysql php tags programming sql for:@twitter

• 03 Jun 10
  

  Jacob H

  programming design database tags tagging mysql sql development web2.0 howto php tutorial webdev del.icio.us schema

• 16 May 10
  

  oriolmari

  database tags schema

• 18 Apr 10
  

  Pawel Czopowik

  tags ***** tagging sql programming development howto database schema db design C:_Users_pczopowik_Downloads_delicious (1).html

• 31 Mar 10
  

  Katxalot kakarot

  tag cloud from beginning

  programacion

• 23 Mar 10
  

  Salah K

  tag tagging schema data er model

• 27 Feb 10
  

  jason prins

  tags database design

• 25 Feb 10
  

  Andrew Leer

  tags database mysql del.icio.us tag design

• 06 Feb 10
  

  b Clark

  tags database schemas

• 05 Feb 10
  

  Michael Simborg

  database tags tagging mysql sql programming schema del.icio.us meta taxonomy UX UXD UI IA resource reference DEV IT FED

• 04 Jan 10
  

  shaoshuai0102

  tagschema decious

• 28 Dec 09
  

  Guido Marini

  howto tag

• 21 Dec 09
  

  timitalia

  tmp tags db

• 19 Nov 09
  

  M Iqbal

  quotes motivation

• 17 Nov 09
  

  rehanog

  database universion

• 23 Oct 09
  

  Andreas Climent

  database mysql sql php

• 17 Oct 09
  

  kmadej

  database tags tagging programming sql

• 14 Oct 09
  

  andrewdick

  database design schema SQL

• 18 Sep 09
  

  Edgar Muñoz

  database tags tagging mysql programming sql del.icio.us schema

• 10 Sep 09
  

  Anton Anisimov

  разные схемы тегирования

  tags schema webdev database

• 26 Aug 09
  

  Anja Lorenz

  tagging programming database schema delicious

• 20 Aug 09
  

  R2 Web2

  database tagging mysql webdev performance

• 12 Aug 09
  

  mi ba

  tag tags database tagging schema sql

• 25 Jul 09
  

  thesuffixed

  database

• 16 Jul 09
  

  torifat

  database mysql programming development php

• 10 Jul 09
  

  Mu Kinger

  mysql tagging tutorial

• 17 Jun 09
  

  John Pouliezos

  eresource tagging schema for:testidis

• 18 May 09
  

  Emlio Olivares

  django programming couponking

• 15 May 09
  

  Guilherme da Silva Mello

  Interesting database tags mysql sql programming schemas

• 07 May 09
  

  Sven W.

  database tagging development

• 01 May 09
  

  Tami Weiss

  tagging tags database mysql sql programming

• 26 Apr 09
  

  osqxivh

  database tags tagging schema design model

• 07 Apr 09
  

  sixspeed

  dbschema tag

• 20 Mar 09
  

  Damian Bannon

  programming Database tags sql

• 18 Mar 09
  

  Very Simple

  database del.icio.us tags tagging

• 05 Mar 09
  

  Panupan Sriautharawong

  database schema

• 27 Feb 09
  

  徐 晓炜(Shawn)

  database tagging mysql schema delicious tags

  • If you want to have more complicated queries like (bookmarks OR bookmark) AND (webservice or WS) AND NOT (semweb or semanticweb) the queries tend to become very complicated. In these cases I suggest the following query/computation process:

     
     
    1. Run a query for each tag appearing in your “tag-query”: SELECT b.id FROM tagmap bt, bookmark b, tag t WHERE bt.tag_id = t.tag_id AND b.id = bt.bookmark_id AND t.name = "semweb"
     
    2. Put each id-set from the result into an array (that is: in your favourite coding language). You could cache this arrays if you want..
     
    3. Constrain the arrays with union or intersection or whatever.
     
     

    In this way, you can also do queries like (del.icio.us|delicious)+(semweb|semantic_web)-search. This type of queries (that is: the brackets) cannot be done by using the denormalized “MySQLicious solution”.
     This is the most flexible data structure and I guess it should scale pretty good (that is: if you do some caching).
• 23 Feb 09
  

  Adi Setiawan

  database tutorial sql tag tagging

• 

  Joy Whatever

  database tagging tips

• 15 Feb 09
  

  Mustafa Navruz

  php database tags mysql

• 13 Feb 09
  

  Mark Whitaker

  tag tags tagging database schema sql programming development client:cherry work client

• 15 Jan 09
  

  Jason Heppler

  programming tags mysql web2.0 webdevelopment delicious analysis

• 07 Jan 09
  

  Shiki Shiji

  Bookmarks tags tagging database architecture mysql tag

• 24 Dec 08
  

  monkey mynd

  tags database mysql webdesign

• 17 Dec 08
  

  africangirl

  folksonomien delicious

• 05 Dec 08
  

  Thomas Broust

  sql tags

• 16 Nov 08
  

  Eric Rodriguez

  web2.0 social webdev programming article database del.icio.us sql tagging tags schema

• 11 Nov 08
  

  pshah2k

  Tagging

• 21 Oct 08
  

  Richard Klein

  implementing delicious style tagging

  database design schema tagging

• 12 Oct 08
  

  jpburstrom
• 09 Oct 08
  

  mega fan

  cpsc431

• 07 Oct 08
  

  David Sabaté

  bases_de_dades tagging

• 

  davidsabate

  bases_de_dades tagging

Page Comments

• 
  tomo on 2006-08-06
  del.icio.usのDBスキーマを実装する方法
• 
  toxi on 2006-08-24
  “Toxy” solution. Toxy came up with a three-table structure. Via the table “tagmap” the bookmarks and the tags are n-to-m related. Each tag can be used together with different bookmarks and vice versa.
• 
  Pete McKinstry on 2006-10-01
  organizes its data in
• 
  Darius on 2007-01-01
  the 3 possible schemas for a delicious-style tagging... but it really doesn't delve into the recommendation-engine part...

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.