- developers-list - monetdb.org

[Monetdb-developers] final execution plan
by Puneet Birwa 11 Mar '10

11 Mar '10

hello, can anyone tell me how in monetdb/xquery we can see what is the final plan with the help of which query is executed i.e how can i find the plan generated at run time for query execution (which tells that which join operation is performed at particular node). The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

2 1

[Monetdb-developers] A SERIOUS CONCURRENCY CONTROL BUG
by oursql 09 Mar '10

09 Mar '10

There is a bug in monetdb, you can run the following script in two clients(mclient.exe), and before test, please disable autocommit option. user A: USER B: CREATE TABLE TEST(C1 INT PRIMARY KEY, C2 INT); INSERT INTO TEST VALUES(1,1); COMMIT; SELECT C2 FROM TEST WHERE C1=1; SELECT C2 FROM TEST WHERE C1=1; UPDATE TEST SET C2=10 WHERE C1=1; UPDATE TEST SET C2=30 WHERE C1=1; COMMIT; COMMIT;--CONFLICT, NEED TO ROLLBACK; ROLLBACK; UPDATE TEST SET C2=30 WHERE C1=1; SELECT C2 FROM TEST WHERE C1=1; --THE RESULT IS 10, NOT 30. TOO BAD! 2010-03-09 oursql

1 0

[Monetdb-developers] monetdb cost model
by anshul gangwar 08 Mar '10

08 Mar '10

hello , Is the cost model used at compile time or at runtime for estimation of cardinalities Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/

2 1

[Monetdb-developers] Fw: monetdb cost model
by anshul gangwar 08 Mar '10

08 Mar '10

hello , Is the cost model used at compile time or at runtime for estimation of cardinalities please reply as soon as soon as possible Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/

3 2

[Monetdb-developers] need help in monetdb
by anshul gangwar 08 Mar '10

08 Mar '10

hello how can we get the final executed plan i.e at run time in monetdb. as pysical-algebra-plan only shows the result after compilation time. And at runtime what does it acually does i.e after sampling what does it decide i.e type of join or others thing also. The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

2 1

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/optimizer/Tests ifthencst.stable.out, , 1.3, 1.4
by Stefan Manegold 07 Mar '10

07 Mar '10

FYI: this test has been failing in the Feb2010 branch since Feb 25 2010, i.e., possibly triggered by checkins on Feb 24 2010. http://monetdb.cwi.nl/testing/projects/monetdb/Stable/MonetDB5/.mTests103/G… Note that the output it (now) produces with the Feb2010 branch is different from what been approved here in the CVS head. Stefan On Sun, Mar 07, 2010 at 08:05:00PM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/optimizer/Tests > In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv3208/Tests > > Modified Files: > ifthencst.stable.out > Log Message: > Approve output > > > Index: ifthencst.stable.out > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/ifthencst.stable.out,v > retrieving revision 1.3 > retrieving revision 1.4 > diff -u -d -r1.3 -r1.4 > --- ifthencst.stable.out 17 Oct 2009 21:22:35 -0000 1.3 > +++ ifthencst.stable.out 7 Mar 2010 20:04:57 -0000 1.4 > @@ -26,8 +26,6 @@ > io.print("never executed"); > exit d; > end tst; > -[ "always executed" ] > -[ "always executed" ] > function user.main():void; > # some frontend generates the following code > mdb.list("user","tst"); > > > ------------------------------------------------------------------------------ > 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-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins > -- | 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 |

1 0

[Monetdb-developers] is there exist any histogram or any other statistic in monetdb/xquery
by Puneet Birwa 07 Mar '10

07 Mar '10

hello, can someone tell me that how monetdb keep track of cardinality of result of query for generating optimal plans or it is completely independent of histogram or anything which keep track of cardinality of result of query. The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

2 1

[Monetdb-developers] Fw: Re: Fw: Re: Fw: Re: need help in monetdb xquery interface
by anshul gangwar 07 Mar '10

07 Mar '10

hello, I just want to know about current monetdb version. Whether it does any optimization at compile time or not or it fully does at run time only. where can i get the information about the optimization strategy of monetdb. May be the specific src code file to refer of monetdb. can you please refer some research papers on monetdb optimization strategy etc. On Sat, Mar 06, 2010 at 07:27:09PM +0530, anshul gangwar wrote: > > > how can we get the estimate of the size of result of query based on any two attributes with varying rangeAnshul Well, I guess you'd need to browse the related research literature for XML/XQuery cost modeling / result size estimation techniques --- however, to my knowledge that area is not yet as well charted and understood as cost modeling / result size estimation for relational algebra and SQL. Of course, the details highly depend on your XML document structure and data distribution as well as the shape and characteristics of your XQuery queries ... Stefan > On Sat, Mar 06, 2010 at 11:32:03AM +0530, anshul gangwar wrote: > > > > > > --- On Fri, 5/3/10, Martin Kersten <Martin.Kersten(a)cwi.nl> wrote: > > > > From: Martin Kersten <Martin.Kersten(a)cwi.nl> > > Subject: * Re: [Monetdb-developers] need help in monetdb xquery interface > > To: "anshul gangwar" <anshul1886(a)yahoo.co.in> > > Date: Friday, 5 March, 2010, 11:26 PM > > > > anshul gangwar wrote: > > > hello , > > > I want to know whether there is any expression or command or anything equivalent to explain sql construct. Also What is the way to > > There is material for you to study on the website: > > http://monetdb.cwi.nl/SQL/Documentation/SQL-Runtime-Features.html > > http://monetdb.cwi.nl/SQL/Documentation/EXPLAIN-Statement.html#EXPLAIN-Stat… > > > get histogram statistics i.e way to find that histogram exists on attribute or not through Xquery interface. not through sql . > > MonetDB does not rely on separate statistics tables. > > > > > Please reply as soon as possible. > > > > > > thank you. > > > > > > Actually i want the xquery construct equivalent to sql explain construct and > > MonetDB/XQuery does not provide such feature. > > To see the equivalent of the SQL EXPLAIN output, i.e., the MIL plan > generated from your XQuery query, you need to use the Pathfinder stand-alone > compiler "pf"; see > `pf --help` > and/or > `pf --fullhelp` > for details. > > > so how it simulates histogram features i.e to get that percentage of query etc. > > Like MonetDB/SQL also > MonetDB/XQuery does not rely on separate statistics > such as histograms. > > Stefan > > > > > > Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!. > > > Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ > ------------------------------------------------------------------------------ > 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(a)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 | The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

4 4

[Monetdb-developers] Fw: Re: Fw: Re: Fw: Re: Fw: Re: need help in monetdb xquery interface
by anshul gangwar 07 Mar '10

07 Mar '10

hello, what are these statistical guides based on data guides in monetdb. And did monetdb stores these statistical guides(data guides). And if yes where it stores it & how can we access it . & does the physical algebra plan depend only on these statistical guides at compile time without actually running the query. And what are children Histogram & Typed valued Histogram , & are these Histograms are stored & if yes how can we access it. Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!. The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

1 0

[Monetdb-developers] Fw: Re: Fw: Re: need help in monetdb xquery interface
by anshul gangwar 06 Mar '10

06 Mar '10

how can we get the estimate of the size of result of query based on any two attributes with varying rangeAnshul On Sat, Mar 06, 2010 at 11:32:03AM +0530, anshul gangwar wrote: > > > --- On Fri, 5/3/10, Martin Kersten <Martin.Kersten(a)cwi.nl> wrote: > > From: Martin Kersten <Martin.Kersten(a)cwi.nl> > Subject: * Re: [Monetdb-developers] need help in monetdb xquery interface > To: "anshul gangwar" <anshul1886(a)yahoo.co.in> > Date: Friday, 5 March, 2010, 11:26 PM > > anshul gangwar wrote: > > hello , > > I want to know whether there is any expression or command or anything equivalent to explain sql construct. Also What is the way to > There is material for you to study on the website: > http://monetdb.cwi.nl/SQL/Documentation/SQL-Runtime-Features.html > http://monetdb.cwi.nl/SQL/Documentation/EXPLAIN-Statement.html#EXPLAIN-Stat… > > get histogram statistics i.e way to find that histogram exists on attribute or not through Xquery interface. not through sql . > MonetDB does not rely on separate statistics tables. > > > Please reply as soon as possible. > > > > thank you. > > > Actually i want the xquery construct equivalent to sql explain construct and MonetDB/XQuery does not provide such feature. To see the equivalent of the SQL EXPLAIN output, i.e., the MIL plan generated from your XQuery query, you need to use the Pathfinder stand-alone compiler "pf"; see `pf --help` and/or `pf --fullhelp` for details. > so how it simulates histogram features i.e to get that percentage of query etc. Like MonetDB/SQL also MonetDB/XQuery does not rely on separate statistics such as histograms. Stefan Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!. Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/

2 1