Re: Database Schema for delicious ( Tag Structure)

David Portas wrote:

> friend.05 wrote:
> 

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