[XML4Lib] Database schema for MARCXML?

[Brian Sheppard]

My reading of this is that one uses an SQL query to retrieve a well- 
formed chunk of xml, then processes that separately with whatever xsl  
tools you prefer (e.g. perl's XML::LibXSLT).
-Brian

On Oct 11, 2006, at 1:05 PM, Andrew Nagy wrote:

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

------------------------------------------------------------------------ 
---------------------
Brian Sheppard
  bboru at umich.edu
------------------------------------------------------------------------ 
---------------------
"J'appuyais tendrement mes joues contre les belles joues de l'oreiller,
qui, pleines et fraîches, sont comme les joues de notre enfance."