Welcome David to the Roller list.
Thank you for your post. I have read your blog post on a tag data
model for Roller. I'm looking forward to your relational algebra and
query cost analysis. I wanted to tell you that we (IBM) have already
added basic tagging support to Roller and it actually supports a
TagCloud. I am supposed to put a proposal in the roller wiki so others
could comment and once I do that, you could put your comments there as
well.
Just to kickstart the conversation I'm including the tagging table we
are currently using.
create table weblogentrytag (
id varchar(48) not null primary key,
entryid varchar(48) not null,
name varchar(255) not null,
tagtime timestamp not null
);
We have basically two tables: entries and entry2tags, but are missing
a tag table. At first, I was very set on having a tag table and use a
foreign key to "save" space on repetitive tag names. But I was shown
it's not really a big space saving technique, especially since tag
names are relatively short storing a guid or int would almost be
comparable in space. There are also increased costs in inserting and
joining on tables to get tag names if using a foreign key, so we have
settle on this for now until we have other queries requirements. I'll
be summarizing all of our changes to roller to support tagging in a
wiki proposal soon.
Regarding the use of the list, some people have been using nabble.com
to interact with it. Maybe you can give it a try. I simply use gmail.
http://www.nabble.com/Roller-f12275.html
Regards,
Elias
On 1/4/06, David Levy <[EMAIL PROTECTED]> wrote:
> I have documented a data model for tags. This is held at my blog
>
> http://blogs.sun.com/roller/page/DaveLevy?entry=implementing_tags_in_a_database
>
> I have a graphic demonstrating the relationship between authors,
> articles and tags and illustrating the first and obvious indexes. (I
> have identified that both "Date Published" and tag aggregates are
> missing from the model). Since the model was built to help me
> understand del.icio.us, I call the entities Users, Bookmarks and Tags,
> but hopefully its simple to see that these are pretty synonomous to
> authors, articles and tags.
>
> I hope that this is useful for those looking at implementing tags.
>
> I am still working out how to use the mail-list, so I hope that x-refing
> you to my blog isn't deprecated. I also need to work how to maintain
> thread connections i.e. undertake a reply.
> --
>
> Dave
>
> <http://www.sun.com> * David Levy *
> *Sun Microsystems Ltd.*
> 55, King William St.,
> London EC4R 9ND United Kingdom
>
> Phone +44 (0) 20 7469 9908/x18308
> Mobile +44 (0) 7710-360922
> Blog http://blogs.sun.com/DaveLevy
> Email [EMAIL PROTECTED]
>
> Sun Proprietary & Confidential . This e-mail message is for the sole use
> of the intended recipient(s) and may contain confidential and
> privilidged information. Any unauthorised review, use, disclosure or
> distribution is prohibited. If you are not the intended recepient,
> please contact the sender by reply e-mail and destroy all copies of the
> original message.
>
>
