[xquery-talk] Finding a XML-Database to fit our needs
johan.moren at gmail.com
Thu Dec 20 23:38:50 PST 2007
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
On Dec 18, 2007 10:19 PM, Ken North <kennorth at sbcglobal.net> wrote:
> Michael Kay wrote:
> >> The database literature is full of alternative techniques.
> >>... three techniques were recognized: record-level locking (which I
> >>equates to node-level in an XML database), page-level locking, and
> >>locks. Fine-granularity locking looks good on paper but the benefits can
> >>often be lost because you spend too much time doing lock
> >>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
> parallel execution of queries? Oracle XML DB, for example, supports
> query and a separate, transportable tablespace for XML repositories.
> DB2 and SQL Server have mature technology for parallel execution.
> talk at x-query.com
Postgången 36 6tr
171 45 Solna
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." -
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the talk