[XML4Lib] Database schema for MARCXML?

[Clay Redding]

Hi Jacob,

If you are required to use a relational database for this, what I have 
to say might not help.  I've long since given up trying to map common 
XML metadata formats to RDBMS -- especially ones that don't translate 
very well (like Mike said).  These days I largely use native XML dbs 
(such as eXist or X-Hive) to do this sort of XML work, and the 
development time (even factoring in learning XQuery) seems shorter than 
working out a RDBMS schema.  Alternatively, I've used PostgreSQL, which 
allows you to store the XML as a whole file inside a table.  Then you 
use a hybrid of SQL and XPath/XSLT to interact with the data:

http://www.throwingbeans.org/postgresql_and_xml_updated.html

Clay

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.
>
> Thanks,
> Jacob Glenn
> _______________________________________________
> XML4Lib mailing list
> XML4Lib at webjunction.org
> http://lists.webjunction.org/mailman/listinfo/xml4lib