circle.ch :: Finding related tags to blog posts

circle.ch weblog by Urs Gehrig

A weblog about libre software, law, technology, politics and the like.

2013-05-11T15:38:07

Academic, Android, Apache, Apple, Art, Best Of, Biotech, Civil Society, Content Management, Cooking, Copyright, Creative Commons, Crosspost, Culture, Database, Deutsch, DRM, Economy, Education, Event, Gadget, General, Geodata, Government, Health, Howto, Humor, Innovation, Intellectual Property, Java, Language, LaTeX, Law, Linux, Media, Moblog, Mozilla, Music, Office, Open Content, Open Source, P2P, PHP, Podcast, Politics, Privacy, Projects, Random Thought, Rant, Science, Search, Social Network, Software, Sport, Talks, Technology, Technology Transfer, Travelling, Weblog, Wiki, Wireless and Mobile, XML

06. September 2005

As you can see there are in most cases "Related tags" listed with each blog post. Those tags have been automatically chosen for each post. Most of them fit to the post, some do not. If you look at the post just before this one, you can see that the content is written in German. Amazingly there is e.g. a tag called "deutsch". The code behind is no rocket science. All I do is looking for matching entries in the database and group by the categories found for those entries. That's it.

One method to refine the results could be that the content of a blog post should be tokenized, stemmed [1], and put into a FULLTEXT search query against the existing entries. That code on the other hand is not yet finished ;)

[1] http://google.ch/search?q=define:stemmer