what I think is right? the ideas and intension of MAL optimizers contain
three parts: 1. programming language/compiler optimization 2. databose query
optimization 3. some optimization only for column-oriented database but not
for row-oriented database,such as mitosis,mergtable,dataflow etc.as a who
Thanks very much, you means the ideas and intension of MAL optimizers
contain three parts: 1. programming language/compiler optimization 2.
databose query optimization 3. some optimization only for column-oriented
database but not for row-oriented database,such as
mitosis,mergtable,dataflow etc
Bes
The ideas / intension of some MAL optimizers, such as alias removal, dead
code elimination, (to some extend) join ordering, etc. are generic and
traditional, both in database query optimization and progarmming language /
compiler optimization. The genral optimizer design and architecture
combinin
Thanks，professor Stefan Manegold,when I use explain,I get the optimizer MAL
plan.
I have another question, so we know that many classic optimizer for
row-oriented database，and can I say the MAL optimizer is unique for
column-oriented database such as MonetDB? or some of MAL optimizer is unique
for
On Wed, Aug 11, 2010 at 04:23:42PM +0800, kun ren wrote:
> I read sql_optimizer setting in monetdb5.conf ,and default setting is:
> sql_optimizer=default_pipe
> default_pipe=inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,
I read sql_optimizer setting in monetdb5.conf ,and default setting is:
sql_optimizer=default_pipe
default_pipe=inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,garbageCollector,dataflow,history,multiplex
so there ar
Yes, if you write MAL "by hand" (or have some program create it) that does
explicitly call a MAL optimizer, that MAL optimizer is indeed used to
optimize the MAL code according to its very purpose.
Stefan
On Wed, Aug 11, 2010 at 03:49:47PM +0800, kun ren wrote:
> It is only used by SQL? and how t
It is only used by SQL? and how to designation the optimiser？but when I
write MAL,for example,
i:=0;
b:= "done";
barrier go:= true;
c:=i+1;
d:="step";
v:=d;
io.print(v);
i:=c;
redo go:= i<2;
exit go;
io.print(b);
optimizer.aliasRemoval();
the last optimizer.aliasRemoval() is used for optimizing?
On 11-08-2010 15:25:15 +0800, kun ren wrote:
> Recently,I am intersting in MAL optimize，and have read the manual of the
> MAL optimize, but it is so long, Possible if we want to use mal optimize ,we
> must degignation the optimize consideration, such as alias removal,
> constant expression,jo
