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: Jay Dee <ais01479_at_aeneas.net>
Date: Sun, 26 Feb 2006 01:10:08 GMT
Message-ID: <Qd7Mf.96408$tK4.88588@tornado.ohiordc.rr.com>


David Portas wrote:

> friend.05 wrote:
> 

>>Hi,
>>
>>I have design database model for Tag structure. Do u think del.icio.us
>>has same structure ?

No.

>>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.

Guessing that the next fragments represent some sort of cycle,

>>create usertag ( userid integer
>> tagid integer )
>>
>>create useritem ( itemid integer,
>> userid integer )
>>
>>create tagitem ( tagid integer,
>> itemid integer )

...the process that populates this will be interesting:

>>create taghierarchy ( tagid integer,
>> hierarchyid integer )

But maybe not as interesting as getting useful information out of such a design.

>>
>>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 - 19:10:08 CST

Original text of this message

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