June 2009 - users-list

[MonetDB-users] Books CDs
by CHARTS LICENSING 11 Aug '24

11 Aug '24

Everything you want to know this dynamic artist check. At blueberry hills duck, roomfull story gtgt getting. Intriguing, life in biography. Here music looking for lyrics maybe, youre find which! Download free wallpapers featuring business cmg worldwide is exclusive. Videos latest products been easier. Exclusive estate we consider request use name voice, image. List covered berries charts licensing message! Reelin and rockin about, has everything you? Many exciting, photos him stage click! Artist check, out some quotes read all intriguing. It alive he, did on occasion birthday wednesday? Has everything you want to know this? Quotes read all intriguing life, in biography or. Gtgt getting licks years reelin and. Click here, music looking for lyrics maybe, youre. News celebrates his th rock will never! Chuck berry news celebrates his th rock, will. Browse through many exciting, photos him stage click here. He did on occasion birthday wednesday night at blueberry. Wallpapers featuring business cmg worldwide. Worldwide is exclusive estate we consider, request use name. Want to know this dynamic artist check out. Awards fast, facts clips list covered. Music looking for lyrics maybe youre. Message board downloads tour dates fan, club inquiries. Other sites, download free wallpapers featuring, business cmg worldwide. Request use, name, voice.

2 1

[MonetDB-users] XQuery API and XLink/XUpdate support
by Alexandra Mart�nez 27 Jun '24

27 Jun '24

Hello all, I was wondering if there is any documentation about the API for XQuery (i.e., how to write xqueries from a Java program). Also, I am interested in using some features of XLink and XUpdate on top of my XML database. Is support for any of these in progress? Thanks in advance, Alexandra ______________________________________________________ Click here to donate to the Hurricane Katrina relief effort. http://store.yahoo.com/redcross-donate3/

4 3

[MonetDB-users] Proofreading your professional documents
by Richard Hounslow 24 Feb '24

24 Feb '24

Dear Professor/Lecturer Please excuse us for contacting you directly. We are offering an efficient service to help you ensure your academic and professional work is written in perfect English. We will check the grammar and style of your work and return it to you to meet your requirements and deadlines. Proof-Reading-Service.com can provide you with a professional proofreading service at a very reasonable rate. All our proofreaders are highly qualified native English speakers. Many work as leading academics in their fields and all have extensive experience of proofreading to the highest standards. If you are interested in our service, please take a look at our website: www.proof-reading-service.com All you have to do is send us your document as a word attachment with the deadline and we will guarantee delivery of a perfectly written document to give you complete confidence when you submit your work. The fee is worked out on a flat rate (£6.95 per thousand words or 0.695 pence per word), so you know exactly how much the proofreading will cost in advance. Once we have received your document(s) we will confirm the word count, the price and the deadline. If you have not heard from us within 2 hours during normal business hours after you have sent your work please resend it from a different email account or send the file to proofreadings(a)gmail.com. We look forward to hearing from you! Yours faithfully Proof-Reading-Service.com

2 2

[MonetDB-users] Possible wrong results when Querying
by LeonardF 10 Nov '09

10 Nov '09

Hi There, I have some problem with the row_number() over() function. Consider the following table: create table "table1" ("customer" varchar(40), "product" varchar(40), "price" double) insert into "table1" values ('cust1', 'p1', 100) insert into "table1" values ('cust1', 'p2', 200) insert into "table1" values ('cust1', 'p3', 150) insert into "table1" values ('cust2', 'p1', 300) insert into "table1" values ('cust2', 'p3', 200) The following query over this table: SELECT "customer", "product", "sumprice", (Row_number() OVER(PARTITION BY "customer" ORDER BY "sumprice")) as "rank" FROM ( SELECT "customer", "product", (Sum("price")) AS "sumprice" FROM "table1" GROUP BY "customer", "product") AS "temp" Returns: Customer product sumprice rank Cust1 p1 100 1 Cust1 p2 200 2 Cust1 p3 150 3 Cust2 p1 300 1 Cust2 p3 200 2 But doesn’t it suppose to return the following result set?: Customer product sumprice rank Cust1 p1 100 1 Cust1 p3 150 2 Cust1 p2 200 3 Cust2 p3 200 1 Cust2 p1 200 2 Thanks -- Leonard Forgge -- View this message in context: http://www.nabble.com/Possible-wrong-results-when-Querying-tp22821802p22821… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] ODBC error (specified driver could not be loaded due to system error 126)
by fadk 13 Aug '09

13 Aug '09

I read that there was a bug like this before, but its been fixed. Its seems like installing ODBC drivers is a problem for windows. Can you assist with this ? I am running winXP using the MonetDB 32 installer. http://sourceforge.net/tracker/?func=detail&atid=482468&aid=1902879&group_i… Also, is it possible to only build the client (to use mapi) on winXP given that I have MonetDB installed. ? Thanks for your help. -- View this message in context: http://www.nabble.com/ODBC-error-%28specified-driver-could-not-be-loaded-du… Sent from the monetdb-users mailing list archive at Nabble.com.

4 4

[MonetDB-users] Announcement: May2009-SP1 bug fix release
by Sjoerd Mullender 30 Jun '09

30 Jun '09

The MonetDB team at CWI/MonetDB BV is pleased to announce the May21009-SP1 bug fix release of the MonetDB suite of programs. This is a bug fix release for last month's May2009 release. More information on this release can be found at <http://monetdb.cwi.nl/projects/monetdb/Development/Releases/May2009/#May200…>. The sources and binaries are available at <http://monetdb.cwi.nl/projects/monetdb/Download/>. -- Sjoerd Mullender

1 0

Re: [MonetDB-users] problem with MonetDB
by Stefan Manegold 29 Jun '09

29 Jun '09

Dear Christoph, I'm currently traveling, hence only a quick reply. Most probably, the reason that your haven't receive any answer to your question, yet, is that noone seems to have an answer, yet. Looking at your report, again, I do have a couple of questions and suggestions (inlined below) that might help you and us to locate the origin of your problem. On Mon, Jun 29, 2009 at 05:37:56PM +0200, Christoph Beekmans wrote: > Dear Mr. Manegold, > > i have a problem with MonetDB and i sent my problem to the user-mailing > list. > Unfortunately nobody answered on my topic and this is a few weeks ago and > i wasn't the first to mail the problem. > > So i decided to contact someone of the cwi-team directly and i hope you > are able > to help me in some way. > > Here the message i sent to the mailing list: > >> Hi everybody, >> >> I posted my issue a few weeks ago, but i got no answer, so >> i try i again. >> >> I installed MonetDB on Windows with the geom module and Which version of MonetDB are you using/talking about? >> afterwards i tried to execute a query with some geometric data types. >> But after a few changes to the query and execution i got an error. What data did you load? What kind of queries did you run? Which error did you get? >> After that i had to restart MonetDB but i got an error message that >> the system tables couldn`t be loaded. Could you quote the exact error message? >> If i start the server without geom support it starts fine but the sql >> client >> can`t connect: >> >> "Connection terminated >> Press any key to continue . . . " Does the server continue running, or does it crash in that case? If the latter, is there any error message on the server console/window? If so, which? >> If i start the server with geom support it loads the sql and geom modules >> but shuts down after that without error message. Could you try running the server on a new empty database? Does that work? If so, could you then replay the steps you did before to see, whether you can reproduce the crash and (potential) corruption of the database? >> Even a reinstall didn't fix it so the error must be somewhere else. did you remove your database before/after the reistall, or are you (still) using the same (possibly corrupoted) database? >> Has anyone an idea about that? >> >> Please help, >> Thanks. > > I would be grateful for an answer, > Christoph Hope this helps for now ... Stefan -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0

[MonetDB-users] String performance
by Alex Bo. 29 Jun '09

29 Jun '09

Hi, How can I know if a string field in a table has a hash table or not? I am asking this because I noticed that string fields with millions of unique values run very slowly, and from your documentation I understood that if I add too many unique strings to a column, then internally Monet will stop using a hash-table, and performance will be affected. Thanks. -- View this message in context: http://www.nabble.com/String-performance-tp24256780p24256780.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Missing JDBC-driver
by Sten Hjelmqvist 25 Jun '09

25 Jun '09

Hello, I've downloaded MonetDB5-SQL-Installer-i386-20090530.msi <http://monetdb.cwi.nl/downloads/Windows/May2009/MonetDB5-SQL-Installer-i386…> for windows. However there was no JDBC-driver in the package. After some searching on Google I found one called "jdbcclient.jar". But I still cannot connect to the database as I get a error message saying that the "demo"-database does not exist. What am I missing? Thanks in advance. --------------------------------------- Sten Hjelmqvist DataKonsult MERdata AB Sveavägen 33, 111 34 Stockholm Mobil : 0708 305616 E-mejl : sten.hjelmqvist(a)merdata.se <mailto:sten.hjelmqist@merdata.se> Webb : www.merdata.se <http://www.main.se/> ---------------------------------------

3 7

[MonetDB-users] disk usage
by dariuszs 25 Jun '09

25 Jun '09

Hi, I've loaded 60 GB of data file into a table. On Windows (NTFS) the size of dbfarm changed to 80GB but on Linux (ext4 or reiserfs) dbfarm changed to 180GB. Why is that? Thanks. Dariusz.

5 15