[Mondrian] Transaction semantics of Mondrian

Julian Hyde julianhyde at speakeasy.net
Thu May 24 20:29:57 EDT 2007


Quite a lot of work. Remember that mondrian has a cache and therefore
the cache would either have to be disabled entirely, read-consistency
would need to be extended over all of the statements which populate the
cache, or the user would need to carefully manage the contents of the
cache using the cache control API.
 
There are other efforts to ensure that mondrian scales to large numbers
of concurrently executing queries, without those queries treating each
other's feet; to make the cache fairer (E.g. a LRU model rather than
garbage-collection); and to be smarter how work is spread between
queries (e.g. combine multiple requests into a SQL statement with uses
the GROUPING SETS construct; and to execute multiple SQL queries in
parallel).
 
So, the challenge is not only to implement this feature, but to address
the other features as well.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Alan Li
Sent: Thursday, May 24, 2007 10:22 AM
To: mondrian at pentaho.org; michael bienstein
Subject: Re : [Mondrian] Transaction semantics of Mondrian


Hi Michael,

How much work would it be to add this functionality to Mondrian?

I can envision it being a configurable mode, where it would be useful
for users that require consistent results in the face of db
update/inserts. 

Alan
 


Date: Thu, 24 May 2007 13:12:19 +0000 (GMT)
From: michael bienstein < mbienstein at yahoo.fr>
Subject: Re : [Mondrian] Transaction semantics of Mondrian
To: Mondrian developer mailing list < mondrian at pentaho.org>
Message-ID: <  <mailto:511062.45567.qm at web25708.mail.ukl.yahoo.com>
511062.45567.qm at web25708.mail.ukl.yahoo.com>
Content-Type: text/plain; charset="iso-8859-1"

No

----- Message d'origine ----
De : Alan Li < alanwli at gmail.com <mailto:alanwli at gmail.com> >
À : mondrian at pentaho.org
Envoyé le : Mercredi, 23 Mai 2007, 23h44mn 14s
Objet : [Mondrian] Transaction semantics of Mondrian 

Many sql statements may be issued as part of one MDX query in Mondrian.
Are all those sql queries (of a single MDX query) run within the same
transaction?

Alan

______________________________ 
_________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070524/0c14a076/attachment.html 


More information about the Mondrian mailing list