Coming late to the conversation ... Storing ANYthing in an RDBMS is a bad idea (you can tell I'm not a fan :-) And Tumer is just plain wrong when he says what you want "is a relational query". It may be phrased in a relational manner, because that's what most people understand, but LIST HOLDINGS WHEN TITLE = 'Harry Potter' AND LIBRARY = 45 76 102 is a query, written in a database language called ENGLISH, which will do what you want (debugging excepted) and it's not a relational database. Not knowing Zebra, I can't tell you how to solve the problem in Zebra. But I *can* tell you it's got absolutely nothing to do with whether or not Zebra is a relational database. Cheers, Wol -----Original Message----- From: koha-devel-bounces+anthony.youngman=eca-international.com@nongnu.org [mailto:koha-devel-bounces+anthony.youngman=eca-international.com@nongnu.org] On Behalf Of Paul POULAIN Sent: 25 July 2006 11:41 To: Chris Cormack Cc: koha-devel@nongnu.org Subject: Re: [Koha-devel] FW: RDBMS like behaviour or merged result sets fromZEBRA-ZOOM Chris Cormack a écrit :
Hmmm
It sounds like storing the holdings info in zebra is going to be a no go.
I still think that storing information that changes regularly, like issue status, and other holdings info should be stored in something like a rdbms
Would storing the holdings info in mysql (or other rdbms) be a bad thing?
Storing everything in zebra will let user see the document status from z3950 server directly. The no-go is probably why no z3950 server does this : it's too much time consuming. another reason for holding in a separate DB is to have a complete MARC record for holdings. Holdings for UNIMARC exists, even if all the libraries I know uses "recommandation 995" that store holding in 995 field. -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19 _______________________________________________ Koha-devel mailing list Koha-devel@nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel * ************************************************************************ * This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 8272 5300, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. * ************************************************************************ *