- developers-list - monetdb.org

MonetDB Development Environment
by Masood Mortazavi 24 Oct '12

24 Oct '12

Hi -- I'm wondering what development environments (OS, editors, etc.) or IDEs, if any, MonetDB development team are using. Regards, Masood _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

2 1

Announcement: New Oct2012 Feature release of MonetDB suite
by Fabian Groffen 23 Oct '12

23 Oct '12

The MonetDB team at CWI/MonetDB BV is pleased to announce the Oct2012 feature release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <http://www.monetdb.org/>. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Due to a packaging problem on Debian and Ubuntu, no binary packages for these systems exist. We apologise for the inconvenience. We expect this problem to be resolved by the Oct2012-SP1 release. Oct 2012 feature release Build Environment * Removed --enable-noexpand configure option. Java Module * Fixed problem with PreparedStatements and setXXX() methods using column numbers instead of names, bug #3158 Client Package * mclient now accepts URIs as database to connect to. * all strings returned by python2 are unicode, removed use_unicode option * python2 and 3 type convertion speed improvements * python2 uses new style objects now (bug #3104) * split python2 and python3 MonetDB5 Server * Removed module attach since it wasn't used or even tested. * The MAL-to-C Compiler (mcc) was removed. The code wasn't tested and most likely non-functional. Merovingian * Fixed problem where monetdbd would refuse to startup when discovery was set to false, bug #3155 MonetDB Common * Removed the gdk_embedded (and embedded) option. The code wasn't tested and most likely non-functional. * BAT-of-BATs is no longer allowed. It was already not allowed to make these types of BATs persistent, but now they can't be created at all anymore. Bug Fixes * 3084: Timestamp arithmetic very slow (especially on Windows) * 3125: Python tests fail after recent Python API changes * 3155: Provide an option for setting discovery to false _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

1 0

ANSI SQL 2003 Extension OVER() appears to be missing in MonetDB Click to flag this post
by James Becker III 22 Oct '12

22 Oct '12

Hello MonetDB Community. My name is James Becker, my friends call me Jaimi, and I am new to posting messages here, so I hope you will bear with me. I am conducting a POC on MonetDB to see if we can use it to replace Vertica for a large scale read mostly educational reporting application. So far things are showing promise, but the legacy reports lean heavily on OVER(), which doesn't appear to be part of the 11.11.11 release. Am I missing something, or is this the case? If anyone who has run into a similar limitations has any insights as to where I have made a wrong turn, or how to either implement OVER() in MonetDB using either MAL/C, or any suggestions for query work-arounds that would yield similar results, this would be greatly appreciated. Thx. ~jj _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

2 5

datetime extract function performance
by metin d 19 Oct '12

19 Oct '12

Hey, I'm running a small performance test on MonetDB and Postgres. According to my results "extract" function in monetDB (http://www.monetdb.org/Documentation/SQLreference/Temporal) is nearly 10x slower then Postgres. Do you know the reason, or do you have any idea which can make "extract" function faster in MonetDB ? Thanks, Metin _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

2 2

width_bucket function
by metin d 19 Oct '12

19 Oct '12

Hey, In features web page it says that monetDB is based on the SQL 2003 standard, but width_bucket function doesn't work although it is in SQL 2003 standard (http://savage.net.au/SQL/sql-2003-2.bnf.html#width bucket function). Thanks. Metin _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

2 1

Some questions
by Sid Just 19 Oct '12

19 Oct '12

Greetings all, I have a simple question about MonetDB. I'm evaluating different several column-store db and I have some questions about Monet : * Is MonetDB a column-store database ? If yes I can't understand how I can query it with standard SQL (it'so simple bue it seem to be the ONLY column-store db that support SQL) * Can MonetDB scale-out over several machines (to build a cluster) for the same database ? * There is no .NET provider that I can use to connect to MonetDB for fast accessing from C# instead of using ODBC ?In general I'm looking for a database that can perform realtime queries against milions of records, because we are going to build a web application that need real fast access to the data. What are best practices in desing tables in MonetDB ? Thanks a lot to everyone! S _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

1 0

Generating gprof report
by Chi-Young Ku 18 Oct '12

18 Oct '12

Hi, I used the "--enable_profile" option to configure my MonetDB and ran "make clean; make; make install". I, then, started my MonetDB instance and ran the following query: select count(*) from lineitem where l_partkey > 9000; Lastly, I quit from the "mclient" session and issued "monetdbd stop ...". I observed that there are several gmon.out files in different directories in my top build directory. Therefore, I issued the following gprof command: gprof /usr/local/bin/mserver5 ./sql/backends/monet5/gmon.out ./gdk/gmon.out ./monetdb5/extras/mal_optimizer_template/gmon.out ./monetdb5/modules/atoms/gmon.out ./monetdb5/modules/kernel/gmon.out ./monetdb5/modules/mal/gmon.out ./monetdb5/scheduler/gmon.out ./monetdb5/optimizer/gmon.out ./monetdb5/mal/gmon.out However, the output of the above command did not show any calling sequence containing the execution of MAL instructions. Did I miss anything? Thanks in advance. Chi _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

1 0

A couple of minor fixes to HowToStart.rst
by Masood Mortazavi 11 Oct '12

11 Oct '12

I have a couple of minor fixes to HowToStart.rst. Can I use "hg push" to push these changes back to the repository? Regards, Masood _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

1 0

Installation issue
by Masood Mortazavi 11 Oct '12

11 Oct '12

Hi, I started with a clone of MonetDB's mercurial repository. I'm using Ubuntu with Linux kernel 3.0.x I followed the instruction in HowToStart.rst bootstrap, config and make moved forward well. There were no complaints in "sudo make install" . . . However, here's what I get: > ~/work/chi-MonetDBConfig$ which mserver5 /usr/local/bin/mserver5 > ~/work/chi-MonetDBConfig$ sudo mserver5 mserver5: error while loading shared libraries: libmonetdb5.so.13: cannot open shared object file: No such file or directory > ls -al /usr/local/lib/libmonetdb5.so lrwxrwxrwx 1 root root 21 2012-10-11 11:46 /usr/local/lib/libmonetdb5.so -> libmonetdb5.so.13.0.0 > ls -al /usr/local/lib/libmonetdb5.so.13.0.0 lrwxrwxrwx 1 root root 21 2012-10-11 11:46 /usr/local/lib/libmonetdb5.so -> libmonetdb5.so.13.0.0 Do I need to add the shared library path explicitly to my LD_LIBRARY_PATH by hand? It seems that it should be added as part of the installation. No? Regards, Masood _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

2 2

MonetDB - some questions
by Sid Just 11 Oct '12

11 Oct '12

Greetings all, I have a simple question about MonetDB. I'm evaluating different several column-store db and I have some questions about Monet : * Is MonetDB a column-store database ? If yes I can't understand how I can query it with standard SQL (it'so simple bue it seem to be the ONLY column-store db that support SQL) * Can MonetDB scale-out over several machines (to build a cluster) for the same database ? * There is no .NET provider that I can use to connect to MonetDB for fast accessing from C# instead of using ODBC ? In general I'm looking for a database that can perform realtime queries against milions of records, because we are going to build a web application that need real fast access to the data. What are best practices in desing tables in MonetDB ? Thanks a lot to everyone! S _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

1 0