[XML4Lib] Database schema for MARCXML?

[marc]

jkglenn at umich.edu wrote:
> Hello,
> 
> Hopefully the list is willing to entertain a naive question from a MARC 
> and XML newbie. I'm trying to figure out the best way to store MARCXML 
> records in a relational database, and am wondering if there are any 
> standard database schemas out there for doing this. In particular I 
> would like to avoid having to write database queries to replicate the 
> functionality of CCL commands that search a particular set of MARC 
> fields. I've found some limited info on the Library of Congress website, 
> but nothing very helpful. If someone could point me in the right 
> direction I would be most grateful.
> 

Hi Jacob

Depending on what you want to do with the MarcXML, and how you want to 
search it, a relational database might be the wrong tool to deploy.

In case you have the possibility to relax your problems constrains, and 
accept a pure XML DB, the various available XML DB's might be a very 
good choice.

An introduction to native XML DB's is here:

http://www.xml.com/pub/a/2001/10/31/nativexmldb.html

Some of the well-known XML DB's:

http://exist.sourceforge.net/
http://xml.apache.org/xindice/
http://www.sleepycat.com/products/bdbxml.html


In addition, I'd like to point out that we - Index Data - have a very 
competitive and high-performance open source text-and-XML database
which is tailored to the needs of the library sector.

It's called Zebra, you can get it for free under the GPL license:

http://www.indexdata.com/zebra/

Zebra has native support for MARCXML and binary MARC records, and speaks 
in addition the library sector standard Z39.50 protocol, as well as the 
  SRU web service.

You find more information here:

http://www.indexdata.com/zebra/doc/

I hope these pointers might help you solving your problem.

Your's sincierely, Marc Cromme, Index Data




> Thanks,
> Jacob Glenn
> _______________________________________________
> XML4Lib mailing list
> XML4Lib at webjunction.org
> http://lists.webjunction.org/mailman/listinfo/xml4lib
> 


-- 

Marc Cromme, cand. polyt, Ph.D
Senior Developer, Project Manager

Index Data Aps
Købmagergade 43, 2
1150 Copenhagen K.
Denmark

tel: +45 3341 0100
fax: +45 3341 0101

http://www.indexdata.com

INDEX DATA Means Business
for Open Source and Open Standards