Catalogue of topics (?)

2007-12-15
2013-05-30
  • Hi,

    sorry for my english, but it's easier for me to talk anbout chicks and computers in this language, than to use specific librarian jargon.

    I need to do the catalogue of all topics that are in the database in fields "Topical term or geographic name as entry element: (1 to 5)". I prefere to add it in the start page for every user, to help him find a book from specific topic (as you can see here: http://biblioteka.loesje.pl/opac/index.php\). How to get those data from the database and sort it alphabetically?

    K.

     
    • See SQL code below. Note that this will only work for OpenBiblio 0.4.0 - 0.6.0 and that the next version (1.0) will have a different database structure.

      I think it's a good idea to present the public some kind of list of topics for a library. When confronted with an OPAC, someone will try only a few search phrases at best. For finding "known items", this may work, but guessing keywords is not efficient for a discovery process. Selecting topics from a list, as in your current implementation, would be more convenient.

      I can see a possible disadvantage if the list becomes longer, but I'm not sure how orientation and navigation could be improved.
      Perhaps the public would appreciate a printed list?
      A while ago I announced a report written for the OpenBiblio reports system that can be helpful too:
      http://obiblio.sourceforge.net/index.php/Reports/TopicsWithBibliographyCount
      The report is finished and OK, but not yet published.

      [sql]
      select distinct topic1 as topic
      from biblio
      where topic1 !=''
      union
      select distinct topic2 as topic
      from biblio
      where topic2 !=''
      union
      select distinct topic3 as topic
      from biblio
      where topic3 !=''
      union
      select distinct topic4 as topic
      from biblio
      where topic4 !=''
      union
      select distinct topic5 as topic
      from biblio
      where topic5 !=''
      order by topic
      [/sql]

      Good luck,

      Hans