|
[XQuery Talk Mailing List Archive Home] [By Date] [By Thread] [By Subject] [By Author] [Recent Entries] [Reply To This Message] Finding a XML-Database to fit our needsJohan Mörén johan.moren at gmail.comThu Dec 20 23:38:50 PST 2007
Hi Ken. Document size in this application will range from 50 to 200KB. It's the total size of the collection of documents that will be in the tera byte range. /Johan On Dec 18, 2007 10:19 PM, Ken North <http://x-query.com/mailman/listinfo/talk> wrote: > Michael Kay wrote: > > >> The database literature is full of alternative techniques. > >>... three techniques were recognized: record-level locking (which I > guess > >>equates to node-level in an XML database), page-level locking, and > predicate > >>locks. Fine-granularity locking looks good on paper but the benefits can > >>often be lost because you spend too much time doing lock > acquisition/release > >>and deadlock detection ... > > Which is why yet another alternative was developed. Multi-versioning was > InterBase's claim to fame and a key reason Borland acquired it for the > client-server database wars of the '90s. (InterBase is now Firebird and > Microsoft SQL Server now provides multi-versioning.) > > Clearly we need something more granular than document-level locking, > particularly for very large documents. > > The obvious question -- is the capacity to handle terabyte-sized documents > essential for this application? > Is there no basis for partitioning the data to permit better concurrency > and > parallel execution of queries? Oracle XML DB, for example, supports > parallel > query and a separate, transportable tablespace for XML repositories. > Likewise > DB2 and SQL Server have mature technology for parallel execution. > > > > > > > > > > _______________________________________________ > http://x-query.com/mailman/listinfo/talk > http://x-query.com/mailman/listinfo/talk > -- --- Johan Mörén Postgången 36 6tr 171 45 Solna +46-8-332826 SkypeMe ---> callto://hutchkintoot Visit my blog --> http://cyclelog.blogspot.com "You can't always write a chord ugly enough to say what you want to say, so sometimes you have to rely on a giraffe filled with whipped cream." - Frank Zappa -------------- next part -------------- An HTML attachment was scrubbed... URL: http://x-query.com/pipermail/talk/attachments/20071220/3121c909/attachment.htm
|
Purchase Stylus Studio Online Today!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|






