October 2007 - 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] (no subject)
by Matt Magoffin 11 Aug '08

11 Aug '08

Hello, I am interested in evaluating MonetDB/XQuery. I have some XML collections for a project I work on that are of 1-2 million individual XML documents for which I use XQuery to access for OLAP style reporting operations. This is a Java-based project, and while working on this project I developed a thin XQuery-centric API so that I could evaluate/use many different XQuery implementations, which my company released as an open source project called Xaj (http://sourceforge.net/projects/xaj) Currently I am using a Berkeley DB XML implementation, but am interested in exploring other options. I'd like to implement a MonetDB version of this API now, but I am having some difficulty finding out how to effectively access MonetDB through Java. So far I was able to use the MonetDB JDBC driver to construct XQuery statements and get XML results, and also I was able to construct MonetDB pf:add-doc() statements to add documents, but I am wondering if this is the best approach (and if so, how to add documents to a remote MonetDB server using the pf:add-doc() mechanism). The API I am trying to implement you can view here, to give you an idea what I'm trying to do: http://xaj.svn.sourceforge.net/viewvc/xaj/xaj/src/net/sf/xaj/XmlDb.java?rev… It was somewhat modeled after the defunct XML:DB API, but focused just on add/store/XQuery operations. Any help/advise would be greatly appreciated! -- m@

2 3

[MonetDB-users] db log shrink
by Colin Foss 17 Apr '08

17 Apr '08

Is there any method, besides restarting the database, of shrinking the sql log file? When I am performing a large set of large inserts (via COPY INTO) the log file gets very large. I wish there was a way to cycle the log file. Also during these large batches of inserts the database server becomes less and less responsive until I am forced to restart the server. Upon restart and the normal recovery monet returns to a very responsive state.

3 2

[MonetDB-users] JDBC insert performance
by chinarinde 11 Mar '08

11 Mar '08

Hi all, I am new to monetDB and ran into the following problem (I'll try to be as verbose as I can, perhaps it helps helping me): I've installed MonetDB server 5.0.0, clients and commons 1.18.2 and sql 2.18.2 on Ubuntu Feisty. Then I've taken the JDBC example which is available online and modified it to be able to insert data into a test database. More specifically I'm using prepared statements and executeBatch() together with the monetdb-1.6 JDBC driver. Which is quite successful until about 5 million records are inserted - afterwards the speed of the inserts drops dramatically. I've experimented with different batch sizes (10000 records seems to work ok), and I've tried to understand the chapter about memory tuning for MonetDB (not sure yet about how to use mem_cursize() though). In any case at first inserting 2 million records only takes about 5 minutes (measured with Javas System.timemillis), later on this time increases and the server gets rather unresponsive. I found only two posts concerning the speed of JDBC inserts (from January 2007 I think) and I would be interested if a solution or explanation has been found off-list. Thank you -- View this message in context: http://www.nabble.com/JDBC-insert-performance-tf4589411.html#a13100422 Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] "merovingian" usage
by Venks 31 Oct '07

31 Oct '07

Recent installation of MonetDB showed the following text at the end of the installation. ==================================== You can start using MonetDB/SQL by starting /root/countdb/bin/merovingian in the background. Read the merovingian(1), monetdb(1) and mclient(1) manpages to learn how to create a database and afterwards connect to it. ==================================== Is "merovingian" ready for usage? When I type "merovingian" I am getting the following error: =============================================================================== unable to create .merovingian_lock file in /root/countdb/var/MonetDB5/dbfarm: No such file or directory =============================================================================== That's because there is no MonetDB5 directory yet. This may be of importance to us as I need to do the following: - Run MonetDB in background - Create the database directory, LOG, CheckPoint and any other files related to any database in a user specified directory. Right now I am using mserver5 executable in a script to start MonetDB in the background. This script was provided by you (Fabian) Please let me know if I need to start using "merovingian" for my needs. Thanks, -Venks

6 14

[MonetDB-users] On Java/JDBC compatibility
by Sander Kruseman 31 Oct '07

31 Oct '07

I thought this might be of interest to some of you. New Java releases are normally upwards binary-compatible with prior releases with only few minor/niche exceptions. This implies that one should normally be able to use recent JVM versions to run MonetDB's (JDBC) class/jar files, even if these were compiled with an older JDK version. See: http://java.sun.com/j2se/1.5.0/compatibility.html and: http://java.sun.com/javase/6/webnotes/compatibility.html#binary Note that the opposite does not hold: class/jar files cannot be run with a JVM older than that from the JDK used to compile them. (Every newer JDK marks its generated class files with a different class file version number, which is checked by the JVM.) I hope this helps. Sander Kruseman

1 0

[MonetDB-users] SQL DELETE bug?
by Sander Kruseman 30 Oct '07

30 Oct '07

Hi, Using server v5.0.0 on Windows with the JDBC terminal v1.18.0, SQL DELETE statements appear to fail. Working in autocommit mode, I issue the following commands: create table test (id int unique not null, name varchar(10) not null); insert into test (id, name) values (1, 'jan'); delete from test where id = 1; select * from test; I get no rows, as was to be expected. However, using DbVisualizer (also using JDBC) I can still see the one inserted table row (after Reload View). After restarting both server and JDBC terminal, I also get the row when using the JDBC terminal. Bug or ignorance? Note that I am using my own schema having been setup with its own user, similar to the VOC tutorial. kind regards, Sander Kruseman

2 2

[MonetDB-users] Large Databases
by algatt 29 Oct '07

29 Oct '07

I am trying to create a large database almost 10GB (TPC-H). When I try to bulk load a 7GB file the server does not work anymore. First, the server quits in the middle of the bulk load, then when I try to re-start the server it does not start showing a message about the OS not having enough space. Then I split the 7GB file into individuals 1GB files, after I upload around 4GB individually, the server crashes. Then when I re-start the server it does not start stating that the BACKUP folder cannot be accessed and not enough permissions! I am using MonetDB 5 on Windows XP 1GB RAM. Any ideas? Thank You. alan -- View this message in context: http://www.nabble.com/Large-Databases-tf4710020.html#a13462531 Sent from the monetdb-users mailing list archive at Nabble.com.

3 3