Re: Re: [Koha] Is there a language field in mysql tables?
Tuesday, January 25, 2005 00:45 CST Hi, Rachel, Just wanted to add that having the language field would probably be useful for more libraries than not. Albert C. responded to the listserv noting the MARC21 field 041 where language info can be coded (the predominant language of the material in hand should be coded in the 008 fixed field, positions 35-37 inclusive, and this is often considered sufficient coding if the work in question is monolingual). If I understood Zhang's message correctly, though ("I don't need the MARC info too"), that was less of an issue than having the info in the core SQL tables (right?). That distinction brings to mind the question of whether Koha is running off of the MARC records it imports or the tables it populates, stuff which makes cataloguing staff worry. Another notendum: books can be in more than one language. This is fairly common in Canada, where federal and many provincial documents are flip-flop bilingual editions. A more scholarly example, brought to mind by Brooke's regular Latin salutation, is the entire Loeb classical library (Latin or Greek on left page, English translation on right). Whatever the example, MARC coding allows for multiple languages being noted in the 041 but what does Koha do with that data? Just seeking a little clarification on this, Amitiés, yours, confused (as usual), Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada
From: Rachel Hamilton-Williams <rachel@katipo.co.nz> Date: 2005/01/24 Mon PM 05:18:07 CST To: Zhang Chunxiao <tzhcx@hotmail.com> CC: koha@lists.katipo.co.nz Subject: Re: [Koha] Is there a language field in mysql tables?
Hi Zhang
Sorry.I mean that if there is a language field which stores the language of books,not the language of the Koha interface.
We did put one in for UNIDO - they have books in different languages and wanted people to be able to search on that basis - however that was a modified 1.9 I think, and I don't think that field is in the new version.
We are doing an upgrade for UNIDO at the moment, and I'm assuming that's one of the things we'll be changing, so would you like that added to the general release, and I'm assuming you would just choose the UNIDO templates to access it?
It will be a few weeks away, but hopefully not more than that.
Cheers Rachel
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Steven
Just wanted to add that having the language field would probably be useful for more libraries than not.
So would you want the ability to restrict your search based on langague as a default search field as well? There are usually 2 sides (at least :-) to a question like this - what is in the koha DB, what is in MARC, how can that data be searched on, and how will that affect the display.... Sooo, while you can assume that pretty much any field is in the MARC record I think (with 900 odd fields it seems a safe bet :-), depending on what you then want to do with the data, you might need a field for it in the koha db as well - and to map the two together.
Albert C. responded to the listserv noting the MARC21 field 041 where language info can be coded (the predominant language of the material in hand should be coded in the 008 fixed field, positions 35-37 inclusive, and this is often considered sufficient coding if the work in question is monolingual).
If I understood Zhang's message correctly, though ("I don't need the MARC info too"), that was less of an issue than having the info in the core SQL tables (right?). That distinction brings to mind the question of whether Koha is running off of the MARC records it imports or the tables it populates, stuff which makes cataloguing staff worry.
I believe (and someone else might want to jump in and correct me here) that the answer is "both" or posibly "either". When you set up your Koha you can choose to have it running in "marc mode" or not - if you choose "not" then I believe it doesn't "show" the MARC and pretty much runs off the Koha db. I think that you can search either the koha db (smaller and faster) or the MARC db (bigger and slower). The koha db is I think a subset of the MARC db - and is basically automatically "joined" to the marc db, so that the two are kept in sync. Additional info about an item is added to the Koha part - about it's life since entering the library, which MARC isn't interested in. There is a fair amount of info in a MARC record which lots of libraries have no real use for, and give volunteer cataloguers the willies. So we have the most important fields (the must haves :-) in the Koha db. So the question here - is language a "must have". UNIDO thought it was, and it seems a few more might as well - basically it probably depends on where your library is, so it's worth having it maybe in the Koha db.
Another notendum: books can be in more than one language. This is fairly common in Canada, where federal and many provincial documents are flip-flop bilingual editions.
So an item needs a language field that is more like subjects, where you can have more than one.
Whatever the example, MARC coding allows for multiple languages being noted in the 041 but what does Koha do with that data?
I think at the moment, if you are in the MARC mode, then koha searches it if you choose for it to do so. A key thing is what do you want OPAC users to be able to search on - if you want them to search on language then you're likely to want it in the Koha db as well - as you get a bit more control I think.
Amitiés, yours, confused (as usual), Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada
hope it helps Cheers Rachel
Rachel Hamilton-Williams a écrit :
When you set up your Koha you can choose to have it running in "marc mode" or not - if you choose "not" then I believe it doesn't "show" the MARC and pretty much runs off the Koha db.
I think that you can search either the koha db (smaller and faster) or the MARC db (bigger and slower). The koha db is I think a subset of the MARC db - and is basically automatically "joined" to the marc db, so that the two are kept in sync. Additional info about an item is added to the Koha part - about it's life since entering the library, which MARC isn't interested in.
There is a fair amount of info in a MARC record which lots of libraries have no real use for, and give volunteer cataloguers the willies. So we have the most important fields (the must haves :-) in the Koha db. So the question here - is language a "must have". UNIDO thought it was, and it seems a few more might as well - basically it probably depends on where your library is, so it's worth having it maybe in the Koha db.
You get a 19/20 for this answer Rach, (should be put in a FAQ somewhere). (the point you loose is for saying "if you choose "not" then I believe it doesn't "show" the MARC and pretty much runs off the Koha db" : even if you set marc=off, searches are done on MARC part : the MARC search API is correctly optimized, that's not the case of the previous non-MARC search API (that was really slow => unindexed searches sometimes. will be improved in 2.4, with inverted list (marc_words table)) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
participants (3)
-
Paul POULAIN -
Rachel Hamilton-Williams -
Steven F. Baljkas