[Hsqldb-developers] Better Transaction Handling and Cache Enhancement

2004-01-18 Thread Daniel Schaller
Hi, I and a fellow student of me are currently working on our diploma thesis at the Dresden University of Technology (Germany), Chair for Database Technology. Our thesises deal about multi-version concurrency control and cache-constrained based caching enhancements in relational databases.

Re: [Hsqldb-developers] Better Transaction Handling and Cache Enhancement

2004-01-18 Thread fredt
-- How modular is the current transaction support integrated with the rest of HSQLDB? Hard to say how modular it is, but it is a simple scheme and is covered in a few classes. Session keeps a list of rows deleted / inserted in memory and when a commit is performed, the list is discarded. If a roll

Re: [Hsqldb-developers] Better Transaction Handling and Cache Enhancement

2004-01-18 Thread Daniel Schaller
Hallo Fred, Thanks for your quick response. On Sun, 18 Jan 2004 16:42:14 -, fredt <[EMAIL PROTECTED]> wrote with possible deletions: This simple scheme means changes by other sessions are visible (READ_UNCOMMITTED) and conflicts between actions by two sessions are not resolved. I have rea

Re: [Hsqldb-developers] Better Transaction Handling and Cache Enhancement

2004-01-18 Thread fredt
Re HSQLDB/R, it is not complicated as it uses a well developed framework for replication. The HSQLDB side though must be improved with better transaction isolation so that only committed transactions are replicated. No direct work has been done on multi-version concurrency but some side issues hav

Re: [Hsqldb-developers] Better Transaction Handling and Cache Enhancement

2004-01-18 Thread Daniel Schaller
On Sun, 18 Jan 2004 17:34:11 -, fredt <[EMAIL PROTECTED]> wrote with possible deletions: Re HSQLDB/R, it is not complicated as it uses a well developed framework for replication. The HSQLDB side though must be improved with better transaction isolation so that only committed transactions

Re: [Hsqldb-developers] Better Transaction Handling and Cache Enhancement

2004-01-18 Thread Harald Niesche
Daniel Schaller wrote: Fredt wrote: I don't know what "cache-constrained based caching enhancements" is, but any enhancement sounds like a good idea :) Your work could fit neatly with our future plans so I would welcome your involvement. ok, we will try to have a short description of it in Englis

Re: [Hsqldb-developers] Better Transaction Handling and Cache Enhancement

2004-01-18 Thread Daniel Schaller
On Sun, 18 Jan 2004 19:41:39 +0100, Harald Niesche <[EMAIL PROTECTED]> wrote with possible deletions: Daniel Schaller wrote: Fredt wrote: I don't know what "cache-constrained based caching enhancements" is, but any enhancement sounds like a good idea :) Your work could fit neatly with our future

Re: [Hsqldb-developers] Better Transaction Handling and Cache Enhancement

2004-01-18 Thread fredt
comments inline Fred - Original Message - From: "Daniel Schaller" <[EMAIL PROTECTED]> To: "fredt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: 18 January 2004 18:26 Subject: Re: [Hsqldb-developers] Better Transaction Handling and Cache Enhancement On Sun, 18 J