September 2014 - users-list

MonetDB Optimizer
by Steffen B 15 Sep '14

15 Sep '14

Hello, I'm writing a back end for Database Supported Haskell (DSH) to target MonetDB. Can I please get some help with running my generated MAL-code though an optimizer? I do not really understand the concept behind this: https://www.monetdb.org/Documentation/Manuals/MonetDB/Optimizers Do I have to generate optimizer code at the appropriate places in my code? Are the optimizer instructions woven into the MAL-Program? Isn't there a optimizer function `a la: optimize :: MalCode -> MalCode? Please be so kind and give me a little bit of futher explaination.

2 1

index on Monetdb
by Bing Zhang 11 Sep '14

11 Sep '14

Hello: I wonder whether the index will give monetdb query more performance or not. For example, like tpc-h queries, if I put index on the particular fields, then the query on over those fields will faster? Thanks & Regards.

2 2

monetdb performance Time measurement
by Bing Zhang 11 Sep '14

11 Sep '14

hi: I am trying to measure query performance of monetdb, but not sure about the time output by using option -ims includes the query results printing time, or it is just the query time. Is there some way to silence the output of queries? Thanks.

2 2

Fwd: COLD RUNS
by Prashant Patel 11 Sep '14

11 Sep '14

Dear all, as a part of my project, i have to check the performance of monetdb column-store database. I am very new to this technology, so i dont know where the monetdb caches its previous query results.. I want to know how can i take results for cold runs on monetdb ( i have tried closing monetdb client and server every time i fire a query , but doesnt seem to clear the cache and i always get hot runs result) so please can anyone help me regarding these.... suggestions are appreciated.. thanks in advance.. Prashant Rajkotiya M.tech. (ICT) DA-IICT ,Gandhinagar

5 5

MonetDB Cluster Management
by Ali Salem 05 Sep '14

05 Sep '14

Hello all, I followed the tutorial on https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/ClusterManagement but I still can't get it to work. I followed all instructions, but *monetdb discover *only returns instance(s) running on the same machine, but not others on the network. I am using three machines running debian, with monetdb installed and configured according to the link above. What am I missing? Your assistance is highly appreciated.

2 4

Messed up MonetDB installation? SQL module not initialized
by Steffen B 05 Sep '14

05 Sep '14

Hello, because of some library stuff I had to reinstall MonetDB on my Linux Mint/Ubuntu maschine. I removed all Packages that had anything to do with monetdb and did a fresh sudo apt-get install monetdb5-sql monetdb-client But now when I start mclient -l mal the SQL-module seems to be broken. I can do a sql.init(); without any errors but when I do t := sql.mvc(); I get: MAPI = (monetdb) /tmp/.s.monetdb.50000 QUERY = t := sql.mvc(); ERROR = !SQLException:mvc:SQL module not initialized Please tell me which additional information you need to help me. Thank you very much Steffen

1 0

JDBC driver problem - rounding decimal numbers during binding
by Radovan Bičiště 04 Sep '14

04 Sep '14

Hello, Today I discovered problem in JDBC driver that caused a very ugly problem with rounding decimal numbers. It rounds decimal numbers during binding. I encountered the bug with the latest driver from Jan2014-SP3 distribution. I filed bug 3561 in MonetDB bug system. Regards, Radovan

1 0

Available binary functions
by Dennis Pallett 02 Sep '14

02 Sep '14

Hi all, I'm just wondering what kind of binary functions MonetDB comes with standard? I'm specifically looking for a function to convert a smallint/int/bigint into a byte array (either big or little endian), concat several byte arrays into a single byte array and encode a byte array as a hex string. Do any such functions exist or do I need to write them myself in C? Best regards, Dennis Pallett

2 2