Send users-list mailing list submissions to
users-list@monetdb.org
To subscribe or unsubscribe via the World Wide Web, visit
https://www.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
users-list-request@monetdb.org
You can reach the person managing the list at
users-list-owner@monetdb.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users-list digest..."
Today's Topics:
1. RE: problem with Jan2014 build (Bas Kaptijn)
2. Re: What differences between monetdb and mongodb for
analytical data? (Ying Zhang)
----------------------------------------------------------------------
Message: 1
Date: Tue, 21 Jan 2014 11:55:38 +0000
From: Bas Kaptijn <b.kaptijn@chs.nl>
To: "users-list@monetdb.org" <users-list@monetdb.org>
Subject: RE: problem with Jan2014 build
Message-ID:
<a553ef932478438e82367f954b701a0f@AMSPR05MB211.eurprd05.prod.outlook.com>
Content-Type: text/plain; charset="us-ascii"
Some last info: the problem disappears when using the no_mitosis_pipe optimizer pipeline.
sql>set optimizer='no_mitosis_pipe';
operation successful (0.139ms)
sql>SELECT * FROM source1 WHERE SUBSTRING(SOURCE,1,2)='04' LIMIT 1 OFFSET 400000;
+-----------------------------------------------------------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------+
| file | line | source |
+=============================================================================+========+====================================================================================================================================================+
| /home/bkaptijn/DDDB/.tmpinputdir/9772_9999_20130501_20130531_Schade_516.ASC | 430664 | 04999999999999999999999999999999999999999
:
+-----------------------------------------------------------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------+
1 tuple (1.1s)
sql>set optimizer='default_pipe';
operation successful (0.305ms)
sql>SELECT * FROM source1 WHERE SUBSTRING(SOURCE,1,2)='04' LIMIT 1 OFFSET 400000;
+------+------+--------+
| file | line | source |
+======+======+========+
+------+------+--------+
0 tuples (798.870ms)
Regards, Bas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20140121/3561c927/attachment-0001.html>
------------------------------
Message: 2
Date: Tue, 21 Jan 2014 17:01:39 +0100
From: Ying Zhang <Y.Zhang@cwi.nl>
To: Communication channel for MonetDB users <users-list@monetdb.org>
Subject: Re: What differences between monetdb and mongodb for
analytical data?
Message-ID: <CCA5DD07-4C20-46E2-AE90-52A62BB9342D@cwi.nl>
Content-Type: text/plain; charset=iso-8859-1
On Jan 20, 2014, at 16:40, Edgar Mejia <omejiasq@gmail.com> wrote:
> I had 6 months works as monetdb and this is great for analytical data, datawarehouses and cubes. Which is faster of these two databases in percentage for reading?
Hello Edgar,
Thank you very much for your complements. However, there is no simple answer to questions like which system is faster, since it highly depends on the exact use case scenario. I think the best you can do is run your use cases using both systems to find the trade-offs of these two systems for your application.
> I can to do clustering, to use (map-reduce, handoop) as monetdb for large amounts of information? any have any documentation for this?
What amount of information are you talking about?
With kind regards,
Jennie
>
>
> Thanks,
>
>
>
> Edgar M
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
------------------------------
Subject: Digest Footer
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
------------------------------
End of users-list Digest, Vol 17, Issue 8
*****************************************