[Koha-devel] FW: RDBMS like behaviour or merged result sets fromZEBRA-ZOOM

[Anthony Youngman]

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 at nongnu.org [mailto:koha-devel-bounces+anthony.youngman=eca-international.com at nongnu.org] On Behalf Of Paul POULAIN
Sent: 25 July 2006 11:41
To: Chris Cormack
Cc: koha-devel at 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 at 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.

* ************************************************************************ *