RE: [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: address@hidden [mailto:address@hidden On Behalf Of Paul POULAIN
Sent: 25 July 2006 11:41
To: Chris Cormack
Cc: address@hidden
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
address@hidden
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.

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