[XML4Lib] Database schema for MARCXML?

[Andrew Nagy]

Clay, Hope all is well across the river in Princeton.

I was wondering if you have used the Postgres XPath functions?  I saw 
the site that you referenced below and it says that the xpath library is 
now apart of the core package.  But after searching Postgres's site for 
"XPath", i find nothing.  Do you know of any documentation about this 
anywhere?  I'd like to give it a shot, but I am curious as to what 
capabilities are available.

Thanks!
Andrew

Clay Redding wrote:

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