On Fri, 2006-01-06 at 11:17, Elias Torres wrote: > Additionally, we have a question of what to do with spaces. Should tags > be multi-word or not? My suggestion to Phay (one of our developers) was > to use spaces as separators in the input field, therefore not supporting > spaces. But we could do multiple things to support spaces, such as > quoting multi-word tags. I believe Flickr supports multi-words but they > remove the spaces from the tags, but technorati does maintain spaces. I > don't like them myself, because I think it fragments the tag space much > more than single words and you could still use intersections to get the > sort of the same result. >
I prefer the del.icio.us style, where spaces are separators and are not supported in tags. I think this is the easiest for users to understand and work with. -- Allen > > > > > > > create constraint defined_tags_name as > > > normal_tag_name=proper(user_tag_name) > > > > > > create constraint defined_tags_entry_date as > > > entry_date = select entry_date from entry > > > where definedtags.entry_name = entry.entry_name > > > > > > and the following indexes > > > > > > create dt.tags on definedtags > > > as author_name, entry_name, normal_tag_name unique > > > > > > create dt.tags2 on definedtags > > > as normal_tag_name > > > > > > create dt.entries on definedtags > > > as author_name, entry_name > > > > > > create dt.date_written > > > on definedtags as entry_date. > > > > > > I have written this in a hurry so it may not be though out as well as > > > some of my writing, but hopefully this is collaborative development. > > > Also I have difficulty in commenting on and reading some of the > > > front-end & java orientated stuff. (I have ordered a couple of books to > > > help me catchup). Hopefully this is helpfull > > > > > > > I think this all makes sense to me so far and I certainly appreciate the > > help. I think getting the data model correct is a *very* important issue > > before we move forward with implemenatation, so I'm glad we are having this > > discussion. > > > > -- Allen > > [1] http://www.tartarus.org/~martin/PorterStemmer/def.txt > [2] http://torrez.us/archives/2005/07/13/tagrank.pdf > > > > > > > > > > > > Elias Torres wrote: > > > > > > >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. > > > >> > > > >> > > > >> > > > >> > > > > > > -- > > > > > > 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. > > > > > > >
