René, Thank you for your comments, we need critical input as well as encouragement and assistance.
The situation we have with the Bibliographic data is the standard we intend to use is MODS "Metadata Object Description Schema" ( http://www.loc.gov/standards/mods/ ) which is expressed and maintained as an XML schema. We plan to store the bibliographic data in the documents internally in an XML file conforming to this schema in the save file package. The problem we have is that the MODS schema is complex and it is difficult producing a suitable SQL schema that will not be broken with any changes to the MODS schema. We have not yet found anyone who has produced a SQL schema that maps the MODS XML schema. This is a problem we need to tackle, as we need to be able to support the use of SQL databases for bibliographic system. So we will need to produce a MODS schema to SQL schema mapping and a MODS data - SQL data import/export filter. Any suggestions and help would be appreciated. On Mon, 24 Jan 2005 10:01 pm, René Peinl wrote: > Hi Rob and David, > Sorry for being destructive a little bit, but I'm not sure wether use of an > XML database is really advisable. There may be a few advantages, but there > are also a number of disadvantages. First of all, as far as I understand, > users can chose which database they want to use for the management of > literature. After an XML database is introduced this choice is very limited > as there are only few XML databases at all and only a subset of them is > free. The performance advantage mentioned is often not really there as > relational databases are much more advanced, tested and optimized than XML > database currently are. In addition to that, I can't believe that any OO > user has more than a few hundred or at most some few thousand records for > literature. With the integration of XML features in relational databases it > seems obvious to me, that XML databases will go the same way that object > oriented databases did. Their importance diminished and today hardly > anybody uses them. So if an XML database connection should make it into OO > than I would recommend to introduce it only as an option, not as mandatory > element. Kind regards > René Peinl > > > -----Ursprüngliche Nachricht----- > Von: Rob Winchester [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 24. Januar 2005 11:46 > An: [email protected] > Betreff: Re: [xml-dev] XML-Database Support in OOo ? > > > Hi David, > > Im not really able to really answer this but would something like the > X/Open XA protocol (resource manager) be helpful here? Ie something that is > sort of both DB and "business logic"). In the back of my mind I see OOo > being integrated with this feature (esp. something like IBM MQ xml) but Im > not ready to implement anything. > > > http://www.databasejournal.com/features/mssql/article.php/1756161 > > http://cbbrowne.com/info/tpmonitor.html > > Your project is very impressive, btw! > > Rob Winchester > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
