July 2011 - users-list

[MonetDB-users] Problem with Create Function sintaxis
by elarios＠liacs.nl 20 Jul '11

20 Jul '11

Hi, I'm using MonetDB over Fedora 15 and the driver monetdb-1.20-jdbc.jar I have problems with the sintaxis of the following function: ----------------------- create function hts.Get_idimage() returns int begin declare idimag int; select max(Imag_id) into idimag from hts.Image; returns idimag+1; end; ----------------------- the error message is: ----------------------- Error: syntax error, unexpected $end, expecting WHILE in: "create function hts.get_idimage() returns int begin declare idimag int;" SQLState: null ErrorCode: 0 Error occured in: create function hts.Get_idimage() returns int begin declare idimag int ----------------------- Can you give me some clues of how to fix this sintaxis error? I've checked the SQL 2003 framework and the script looks fine. Thanks in advance for your help. Enrique.

4 4

[MonetDB-users] Table with 1 000 000 000 rows
by Eugene Prokopiev 20 Jul '11

20 Jul '11

Hi, is it possible to store 1 000 000 000 rows in one table or I need to use some partitioning algorithm? -- Thanks, Eugene Prokopiev

3 4

[MonetDB-users] Normalization
by Eugene Prokopiev 20 Jul '11

20 Jul '11

Hi, need I use normalization for tables in colum-oriented databases or it will only decreses perfomance without reducing space usage and other advantages? -- Thanks, Eugene Prokopiev

2 1

[MonetDB-users] Information about Loader
by Lowterm 19 Jul '11

19 Jul '11

Hi, I need some information about MonetDB Loader. Where can I find it? Is there any documentation about it? Thanks -- View this message in context: http://old.nabble.com/Information-about-Loader-tp32084241p32084241.html Sent from the monetdb-users mailing list archive at Nabble.com.

4 6

[MonetDB-users] Clustering, Replication, MultiThreading, Restore
by joel vennin 09 Jul '11

09 Jul '11

Hi, I've just discover MonetDB. I've found some documentation but i've still some questions. 1) About replication, i'm unable to find a documentation about replication support inside MonetDB, if it is not supported do you plan to support it natively, or is there some special script to launch in order to have database in sync. 2) About clustering, my understanding about clustering is to allow one client to launch a sql query on a database through merovingian (if i understood). The query is analysed by all nodes of the cluster and then it return the answer. However, it seems it is not the case, if I follow the documentation on the website about clustering, it seems that I will be connected through a round robin fashion to one of the node. Once connected my query will be executed only on that node. 3) About multithreading, I mean multi query execution per user, I think MonetDb support the fact that multi user can connect to the database and launch different query on it. But is it possible to configure the number of concurrent connection, to setup the number of thread that handle queries ? 4) If MonetDb crash, is it possible that db files become corrupted ? In this case, is there a script to fix it ? Thank you for your help Joel

3 5

[MonetDB-users] how store tiff image in monet db?
by rose26 08 Jul '11

08 Jul '11

-- View this message in context: http://old.nabble.com/how-store-tiff-image-in-monet-db--tp32014566p32014566… Sent from the monetdb-users mailing list archive at Nabble.com.

4 3

[MonetDB-users] Installation problem in Fedora 15
by elarios＠liacs.nl 06 Jul '11

06 Jul '11

Hi, I'm interested in using MonetDB in my project and I'm a beginner in this topic, so I'm sorry for the silly questions that I can make. The problem is: I'm trying to install MonetDB-SQL Server in Fedora 15, but when I execute the command: yum install MonetDB-SQL-server5 MonetDB-client The output makes reference to a repository that doesn't exist: http://dev.monetdb.org/downloads/Fedora/15/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found : http://dev.monetdb.org/downloads/Fedora/15/x86_64/repodata/repomd.xml Trying other mirror. http://dev.monetdb.org/downloads/Fedora/15/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found : http://dev.monetdb.org/downloads/Fedora/15/x86_64/repodata/repomd.xml Trying other mirror. Error: Cannot retrieve repository metadata (repomd.xml) for repository: monetdb. Please verify its path and try again Should I downgrade my operating system to Fedora 14? Do you have any suggestions? Thanks for your time and help, Best regards, Enrique.

3 5