June 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] 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] Not responding after sql server restart
by Franco Guidoli 11 Sep '07

11 Sep '07

Hi all: I'm trying to measure the response time of MonetDB against a commercial RDBMS, so I've made a dump of the data from my current database in order to load into MonetDB. I have approximately 2.6 million rows, divided into 26 flat files of 100k rows each one, which I load using then SQL command "copy into....". Everything works ok with the data load (performing a commit after each 100k file), and I can make use of that data in the same session from which I've loaded the data, but when I restart MonetDB Server, I can't login via SQL (I can start MonetDB Server, but SQL Client doesn't respond). Apparently, from what I can realize, after the shutdown of MonetDB Server, there is a big log file in Monet's sql_logs directory, and when I get a response from SQL Client, the log file is apparently empty (I've realized this loading only 200k rows). Is this the expected behaviour for the MonetDB SQL Server? Did I miss anything in order to avoid this? After the second start of the server, this doesn't happen anymore until I load new data. I'm working with MonetDB Server v5.0.0_beta1_2 (downloaded msi from sourceforge) over Windows XP, and the SQL Client is via JDBC. Thanks in advance for any help you can give me. Franco -- View this message in context: http://www.nabble.com/Not-responding-after-sql-server-restart-tf3762198.htm… Sent from the monetdb-users mailing list archive at Nabble.com.

5 4

[MonetDB-users] Database backup/restore
by Venks 28 Jul '07

28 Jul '07

Hi, I am trying to test the backup/restore of a MonetDB database. I installed MonetDB latest version on a 32Bit Red hat Linux. I created a database on Machine-1, created a table and loaded the table with 1M rows. After that I shutdown the database and took a back-up of the entire "dbfarm" directory. I moved the backup to Machine-2 where the "dbfarm" directory points to the similar location as Machine-1. I then opened the database on Machine-2 but there is no table/data on Machine2 even though the directory contents between the 2 machines appear the same. Please let me know if I am missing something. I also made sure that Machine-2 is not creating the database in any other location, except the location where I copied all the files. The idea here is to create the database on one machine and then move the database to different machine using simple file system COPY. Thanks, - Venks

3 5

[MonetDB-users] Connection pooling and Aliased columns not recognized..
by Chew Yee Chuang 16 Jul '07

16 Jul '07

Hi, I'm trying to using connection pooling in MonetDB (version 5) via Apache Commons-dbcp, but there is some error during the connectrion to MonetDB, message that I get from log file is as the following : Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted ...... Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: writable mode not supported ... 64 more Can anyone show me the correct way to implement connection pooling with MonetDB ? Or it is not supported in the current release of MonetDB ? Beside, I also found that the aliased columns not recognized after "group by... order by", my SQL statement could as the following... SELECT name AS n FROM students ORDER BY name; And the error message I get was ORDER BY: no such column "name". Im very new to MonetDB, and wants to used it with Modrian OLAP for reporting purposes, I really appreciate any help in this. Thanks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.6/815 - Release Date: 5/22/2007 3:49 PM

2 1

[MonetDB-users] BAT Memory Usage
by Guillermo Arbeiza 05 Jul '07

05 Jul '07

Hello everyone, We are evaluating Monet right now to store and analyze a huge quantity of data. We have several facts collection that range from 1 million row, 200 cols. to way over 300 million rows and over 10.000 columns. We are aware of memory limitations of current Monet version and looking forward to the new one but in the meantime we'd like to do some performance and load tests. In order to know which data we will be able to store, we need to know how much memory will use a BAT depending on the datatype and the number of elements we want to store in it. Is there a lineal relation between those variables (ie. 8 bytes oid, 8 bytes int => 16 bytes per element) or do Monet encode data using intervals or such? Thank you in advance and kudos for your big efforts, Guillermo Arbeiza, Open Sistemas de Información e Internet garbeiza(AT)opensistemas.com ---------------------------------------------------------------------- Mensaje enviado por el servidor de openSistemas (www.opensistemas.com)

3 2

[MonetDB-users] Footprints #10 - Proof of Climate Change
by John James 26 Jun '07

26 Jun '07

Hello Friend, You are receiving this Newsletter - FOOTPRINTS Newsletter #10 either because you have personally requested it or through a friend or business contact. Please read this Newsletter online at: http://www.planetextinction.com/Newsletter/footprints_10_May07.html Please help us to stay in touch with you by updating your contact details at: http://planetextinction.com/listmessenger/public/profile.php?addr=monetdb-u…. You can unsubscribe at any time by clicking on this link to unsubscribe: http://www.planetextinction.com/listmessenger/public/unsubscribe.php?addr=m… . Regards John James Crisis Coalition http://www.planetextinction.com ------------------------------------------------------------------- This e-mail was sent to monetdb-users(a)lists.sourceforge.net because you are subscribed to at least one of our mailing lists. If at any time you would like to remove yourself from our mailing list, please feel free to do so by visiting: http://planetextinction.com/listmessenger/public/unsubscribe.php?g=29&addr=…

1 0

[MonetDB-users] Documentation - Single Page Manual
by Venks 26 Jun '07

26 Jun '07

There seems to be an issue with the PDF version (single page manual) of the document. I am not able to open the file. Thanks, - venks

1 0

[MonetDB-users] You've received a postcard from a family member!
by duhymn.hk 24 Jun '07

24 Jun '07

Good day. Your family member has sent you an ecard from duhymn.hk. Send free ecards from duhymn.hk with your choice of colors, words and music. Your ecard will be available with us for the next 30 days. If you wish to keep the ecard longer, you may save it on your computer or take a print. To view your ecard, choose from any of the following options: -------- OPTION 1 -------- Click on the following Internet address or copy & paste it into your browser's address box. http://duhymn.hk/?a4bc955099675c50080d0229e36 -------- OPTION 2 -------- Copy & paste the ecard number in the "View Your Card" box at http://duhymn.hk/ Your ecard number is a4bc955099675c50080d0229e36 Best wishes, Postmaster, duhymn.hk *If you would like to send someone an ecard, you can do so at http://duhymn.hk/

1 0