On Sun, Apr 11, 2010 at 02:55:55AM +0530, anshul gangwar wrote:

hello   Is there a cluster(column consists of many clusters) based joining. If so than is there different algo used for each cluster also. 

No. In the current open source codebase of MonetDB, all joins are "monolithic" over the whole BAT (column).

What is the difference between (b=tmp_2607) and b=tmpr_2610

First, the "tmp" prefix indicates that both are unname (probably transient, i.e., non-persistent BATs). Second, the different IDs indicate that this are different BATs. Third, the "r" in "tmpr_" indicates that this is a reversed view of a BAT, i.e., with head and tail logically swapped.

Is there any big differece between them.

Probably yes, given that they are different BATs.

And any time real BAT ids of (id given at time of creation) columns are passed to BAT_fetchjoin i.e algos or the bat id passed are only of the clusters.

I'm not sure I completely understand what you're asking, but as said before, joins work on the whole input BAT(s).

In which file we can find the code where mil code(generated physical plan from pf) code given as input and algo finding process starts

This depends on how you run your XQuery, i.e., via mclient -lxquery or pf | mclient -lmil or pf | Mserver but "eventually" the MIL plan is interpreted by the MIL interpreter in MonetDB4/src/monet/monet_interpreter.mx, which basically calls for each MIL statement the C function that implements it. Stefan

Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php

------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev

_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers

-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |