Here are a couple of swell ideas about tagging the library catalog. The first generates tags based upon subject headings from the catalog by using a particular table in the db.
http://www.daveyp.com/blog/index.php/archives/127/
and then there are user contributed tags:
http://tags.library.upenn.edu/
It seems that ajax is the magic.