OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   RE: [xml-dev] XML Schema for large database

[ Lists Home | Date Index | Thread Index ]

-----Original Message-----
From: CHIUSANO, Joseph [mailto:JCHIUSANO@lmi.org]


It seems reasonable to assume that when committing this information to a
database, one may have to lock multiple tables simultaneously (thereby
violating the best practice rule of "hold locks for as little time as
possible").  That is, the Order table would need to be locked, then the Item
table (while the Order table is locked), etc.   

Why the assumption of table-level locking?  Neither do I see how the
structure of the XML document matters, assuming you have a database that
supports optimistic concurrency and atomic transaction commitment.
 
However, if you're using MS-Access in a multiuser environment, there's no
hope for you anyway. :-)  




 

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS