- users-list - monetdb.org

[MonetDB-users] MonetDB/XQuery: performance issues
by Peter van der Kamp 23 Aug '05

23 Aug '05

I've been experimenting with MonetDB/XQuery for some time now and i wonder what kind of machine was used to produce the benchmark results as published on the website. Are there some guidelines ("do's and don'ts") with respect to performance? Peter van der Kamp

3 4

[MonetDB-users] AMD64 version of MonetDB for Windows?
by Cardillo Raymond A Civ AFRL/IFEA 19 Aug '05

19 Aug '05

Has anyone out there taken the time to build an MSI for the AMD64 versions of Windows? The x64 version of Windows was released a few months ago and was available in Beta for a while, so I'm hoping someone has either done this already, or can provide some advice on how to build/compile for this platform. Anyone know of future plans to make this one of the standard platform builds? Windows x64 is only going to grow in popularity from here, especially amongst researchers and others who can benefit from 64 bits. Thanks for any info, Ray Cardillo

2 1

[MonetDB-users] Perl and MonetDB Xquery
by Peter van der Kamp 18 Aug '05

18 Aug '05

LS, As Perl is one of the main programming languages at our institute, I tried the Perl API with MonetDB-Xquery. I succeeded with sending mil statements (with the language parameter set to 'mil') to the server and getting the correct answer, but xqueries failed (with the language parameter set to 'xquery'). This was not a complete surprise as the documentation seems to be ambiguous ("MonetDB/XQuery for POSIX (Linux/Unix) platforms currently only supports MAPI (MonetDB API) to communicate with the XQuery engine."). Following the link to the API's: "Perl binding of the simple Monet API (Mapi) for MIL/SQL database interaction". So, I would like to know if my assumption that currently no xqueries are supported by the Perl API is correct. Peter

4 7

[MonetDB-users] BerkeleyDB
by Rodrigo Schmidt 16 Aug '05

16 Aug '05

Has anyone compared the relative performance between MonetDB (MIL interface) and BerkeleyDB? If so, what were the results? Cheers, Rodrigo

1 0

[MonetDB-users] Re: Support for group by <ordinal> and SQL OLAP functions
by Fabian (MonetDB Project) 12 Aug '05

12 Aug '05

(I'm sending this to the monetdb-users list, as it might help some other people too) Hi, Thanks for your interest in MonetDB/SQL. gustavo wrote: > ... What I´m missing mostly is support for group by a > number of a column. In this way it would be possible to group by na > expression without the use of a derived table (select from select). I don't exactly understand what you want to do. Can you give a concrete (SQL) example that shows what you want to do? I think that would help getting me to understand. > Another > thing that could boost MonetDb usage is SQL OLAP support like stddev, ranks, > running sums/averages, windowing support, rollup and cube. Most of what you mention require a different approach to the data I think. Like running sums or windowing support somehow require you to examine 'streams' of data, thus acting on data as soon as it comes in. I don't think SQL is yet up for this job, the best you can do is simply simulate it. I think CUBE was added to SQL-2003 and therefore might get included, but I don't think on the short term. However, a concrete list of wishes is always welcome! Thanks for your input!

3 2

[MonetDB-users] JDBC driver
by Rodrigo Schmidt 12 Aug '05

12 Aug '05

I installed MonetDB_JDBC-1.2-Blunt-SR1.jar and I am getting the following problem when I try to load MonetDriver using class.forName(): java.lang.UnsupportedClassVersionError: nl/cwi/monetdb/jdbc/MonetDriver (Unsupported major.minor version 49.0). Does any of you know what the problem is? Cheers, Rodrigo

2 9

[MonetDB-users] Problem configuring MonetDB/XQuery
by Peter van der Kamp 11 Aug '05

11 Aug '05

I successfully build MonetDB, prior to configure and build the XQuery front end. However, running configure for this front end stops with: Checking for Mx... no configure: error: No Mx found in PATH I try to build the Mx software, without success. Before continuing I would like to know if the XQuery front end really needs Mx. Thanks. Peter van der Kamp

3 10

[MonetDB-users] inconsistent database
by Rodrigo Schmidt 10 Aug '05

10 Aug '05

Hi, While playing with SQL schemas (creating and eliminating them) I managed to put the database in an inconsistent state. Now I have a schema with nothing inside (neither users nor tables) and apparently I am not able to drop it. When I try, both database server and client crash with an internal error. Is there any monetdb tool that checks the database consistency and recovers it if a problem is identified? Cheers, Rodrigo

2 1

[MonetDB-users] Different storage spaces
by Rodrigo Schmidt 10 Aug '05

10 Aug '05

Hello, In my application I have several processes in a server, each one managing different and non-related pieces of data, which I intend to store in MonetDB databases. As these processes are not related to each other, I would like to put their data in logically different storage spaces, like a different catalog or a different schema inside the database, if not in in different databases themselves. I am just starting with MonetDB and I do not know how I can create new databases, catalogs or schemas and what I should do to configure these things on the server. Can you give me some hints about it? FYI, my application is written in Java and I am using the JDBC interface to connect to the database. Cheers, Rodrigo

2 1

[MonetDB-users] New
by rita kelly 08 Aug '05

08 Aug '05

3 2