Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Database Schema for delicious ( Tag Structure)

Re: Database Schema for delicious ( Tag Structure)

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: 25 Feb 2006 10:40:22 -0800
Message-ID: <1140892822.531201.246320@i40g2000cwc.googlegroups.com>


friend.05 wrote:
> Hi,
>
> I have design database model for Tag structure. Do u think del.icio.us
> has same structure ?
> I am also including heirarchy of tags, which delicious has not
> implemented.
>
>
> Database Schema :
>
> create user ( userid integer,
> login varchar (255) )
>
>
> create tag ( tagid integer,
> tagname varchar (255)
> tagitemcount integer )
>
> create item ( itemid integer,
> itemdescription varchar (255),
> itemurl varchar (255) )
>
> create hierarchy ( hierarchyid integer,
> hierarchyname varchar(255) )
>
>
> All these tables I have consider has many - many to relation so
> associated tables will be there.
>
> create usertag ( userid integer
> tagid integer )
>
> create useritem ( itemid integer,
> userid integer )
>
> create tagitem ( tagid integer,
> itemid integer )
>
> create taghierarchy ( tagid integer,
> hierarchyid integer )
>
>
>
> I want to write query for popular tags. and queries related to tag
> database.
>
>
> Reference site :
>
> del.icio.us
> http://flickr.com/photos/tonreg/tags/landscape/

What language is that? Not valid SQL anyway. With not a single key in sight a list of column names doesn't tell us much and may generate false assumptions.

What is your question?

--
David Portas
Received on Sat Feb 25 2006 - 12:40:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US