August 2008 - users-list

[MonetDB-users] Announcement: new minor release of MonetDB Clients package
by Sjoerd Mullender 12 Aug '08

12 Aug '08

The MonetDB team at CWI is pleased to announve a bug fix release for the MonetDB Clients package. A number of bugs in the ODBC driver have been fixed: - fixes for the handling of UTF-8 encoded queries and query parameters; - fixes for dealing with wide characters. There is also a fix for mclient: - the timer (-t/--time option) could overflow. There are new Windows installers for the ODBC driver, and there are new RPMs for Fedora 8 and 9. All of this for both 32 and 64 bit architectures. There is also a new Super Source Ball. -- Sjoerd Mullender

1 0

Re: [MonetDB-users] MonetDB rpm issues
by Stefan Manegold 11 Aug '08

11 Aug '08

On Mon, Aug 11, 2008 at 10:52:34AM +0100, John Baxter wrote: > Stefan, > > Sorry about the html format, it is just the default, i've changed it to > plain text now. Thanks! > cenos == centos, my mistake. > > CentOS is basically the same as Red Hat Enterprise server but rebranded. > I feel it is more stable than fedora core and as it is also open source > it is just as usable. > > I'm sorry, i didn't realise i would have to compile it first, i'll do > that today, thank you for the tips about what order to do it in. > > One last thing, i'm sure i read somewhere that the sql implementation is > the same as postgresql. Is this still correct, and is the implementation > exactly the same or are there some exceptions? Well, we do not follow or copy any other SQL implementation (in particular not their modification and/or extensions of the standard), but rather (try to) stick to teh standard. For details see http://monetdb.cwi.nl/SQL/Documentation/index.html and in particular http://monetdb.cwi.nl/SQL/Documentation/SQL-Reference.html Stefan > Thanks again for your assistance. > > Kind Regards > > John > > > Stefan Manegold wrote: >> Hi John, >> >> On Fri, Aug 08, 2008 at 04:26:09PM +0100, John Baxter wrote: >> >>> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> >>> <html> >>> <head> >>> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> >>> </head> >>> <body bgcolor="#ffffff" text="#000000"> >>> Stefan, >>> >>> Thanks very much for replying, i really appreciate it. >>> >>> These are the RPM's i have tried: >>> >>> MonetDB5-server-5.6.0-4.src.rpm >>> MonetDB-SQL-2.24.0-4.src.rpm >>> >>> I'm only installing this on a local centos install. I downloaded the >>> RPM's to the root of the filesystem and ran them from there. >>> I'm running cenos from it's GUI at the moment so it would be the GUI >>> >> ^^^^^ >> Typo (i.e., "cenos" == "centos") or is that the application/tools you use to >> install RPMs? >> I don't know CentOS and/or it's adminstrative tools at all. Sorry. >> >> However, the "platform independent" RPMs are *source* RPMs that cannot be >> installed directly using, e.g., `rpm -i`. Instead, they have to be compiled >> (into platform-specific binary RPMs, first, e.g., via `rpmbuild --rebuild` >> or `rpmbuild --recompile`. >> >> See your systems RPM documentation (e.g., `man rpm` / `man rpmbuild` and/or >> http://www.rpm.org/ for a detailed documentation of RPM. >> >> >> Before compiling/building and installing >> MonetDB5-server-5.6.0-4.src.rpm >> and MonetDB-SQL-2.24.0-4.src.rpm >> >> you first need to compile/build and install >> MonetDB-1.24.0-4.src.rpm >> and MonetDB-client-1.24.0-4.src.rpm >> >> >> Stefan >> >> >> ps: We would greatly apprechiate if you would not sedn HTML(-only) >> emails/postings --- plain text is more than sufficient (and much easier >> to handle) ... >> >> >> >>> that gave me the error messages. >>> >>> Thanks >>> >>> John >>> >>> Stefan Manegold wrote: >>> <blockquote cite="mid:20080808151929.GA10101@cwi.nl" type="cite"> >>> <pre wrap="">Hi John, >>> >>> which "platform independent RPM's" are you refering to? >>> >>> On our download page on SF we only provide Fedora 8 & 9 (binary) RPMs as >>> well as source-RPMs --- only the latter are platform independent, except >>> that the target OS need to obviously provide RPM support in general. >>> >>> How exactly do you try to install the (source?) RPMs? >>> >>> And who (i.e., which program) give the error messages? >>> >>> Stefan >>> >>> On Fri, Aug 08, 2008 at 03:49:45PM +0100, John Baxter wrote: >>> </pre> >>> <blockquote type="cite"> >>> <pre wrap="">Stefan, >>> >>> I hope you don't mind me e-mailing you. You were kind enough to help >>> me once before when i was having trouble installing MonetDB and i'm >>> having trouble again. >>> >>> I'm trying to install the platform independent RPM's on centos 5.2 >>> but it is saying that it "cannot install source packages" and then >>> "no packages were given for installation" >>> >>> Are the RPM's usable at the moment? >>> >>> If you can offer any advice that would be great. >>> >>> Thank you >>> >>> Kind Regards >>> >>> John Baxter >>> </pre> >>> </blockquote> >>> <pre wrap=""> >>> </pre> >>> </blockquote> >>> >>> <pre class="moz-signature" cols="72">-- Co: Baxter Designs >>> >>> Web: <a class="moz-txt-link-freetext" href="http://www.baxterdesigns.co.uk">http://www.baxterdesigns.co.uk</a> >>> >>> Mail: <a class="moz-txt-link-abbreviated" href="mailto:john@baxterdesigns.co.uk">john(a)baxterdesigns.co.uk</a> >>> >>> Tel: 07968754215</pre> >>> </body> >>> </html> >>> >>> >> >> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >>> Build the coolest Linux based applications with Moblin SDK & win great prizes >>> Grand prize is a trip for two to an Open Source event anywhere in the world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> MonetDB-users mailing list >>> MonetDB-users(a)lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>> >> >> >> > > -- > Co: Baxter Designs > > Web: http://www.baxterdesigns.co.uk > > Mail: john(a)baxterdesigns.co.uk > > Tel: 07968754215 -- | 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 |

3 5

[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

Re: [MonetDB-users] MonetDB rpm issues
by Stefan Manegold 11 Aug '08

11 Aug '08

Hi John, which "platform independent RPM's" are you refering to? On our download page on SF we only provide Fedora 8 & 9 (binary) RPMs as well as source-RPMs --- only the latter are platform independent, except that the target OS need to obviously provide RPM support in general. How exactly do you try to install the (source?) RPMs? And who (i.e., which program) give the error messages? Stefan On Fri, Aug 08, 2008 at 03:49:45PM +0100, John Baxter wrote: > Stefan, > > I hope you don't mind me e-mailing you. You were kind enough to help me > once before when i was having trouble installing MonetDB and i'm having > trouble again. > > I'm trying to install the platform independent RPM's on centos 5.2 but > it is saying that it "cannot install source packages" and then "no > packages were given for installation" > > Are the RPM's usable at the moment? > > If you can offer any advice that would be great. > > Thank you > > Kind Regards > > John Baxter -- | 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 |

2 2

[MonetDB-users] Announcing MonetDB support for Ruby on Rails
by Michalis Polakis 10 Aug '08

10 Aug '08

Hello folks, I developed the MonetDB adapter for Rail's ActiveRecord. It will enable you to work with MonetDB databases in Ruby on Rails. You are more than welcome to try the code, give me some feedback, and maybe help me maintain it. To get the code visit : http://rubyforge.org/projects/monetdb-ror Thanks, Michalis Polakis

1 0

[MonetDB-users] MonetDB Indexes and Data Types
by Ross Bates 09 Aug '08

09 Aug '08

Hi All - I'm new to MonetDB and just getting my feet wet. Quick question for the experts. Does the data type of the column impact the performance of the indexes created on the fly by MonetDB? In other words, should I expect WHERE clauses on INT columns to perform faster than VARCHAR like I would in a tradtional row store? Many Thanks, Ross

2 1

[MonetDB-users] full text search?
by mark 09 Aug '08

09 Aug '08

hi, i am beginning with monetdb. is there any support for full text search on monet-db via plugin or natively? thanks a lot

2 1

[MonetDB-users] COPY INTO on Ubuntu 64bit is slow
by Cronje Fourie 08 Aug '08

08 Aug '08

Hi guys.... I've got to machines running Monet. 1. Quad core Intel with 4GB RAM, Ubuntu 8.04 32BIT (server ed) 2. AMD64 Quad Core, 4GB RAM, KUbuntu 8.04 64BIT (kde 3.5.9) On system 1 I can do a "copy into" of 6million records in no time at all :) On system 2 the same function, with the exact same data takes forever. Any thoughts on the reason? Is this a memory related issue? Cronje

7 12

[MonetDB-users] [XQuery] Communicate with Java?
by Chaojing Yang 08 Aug '08

08 Aug '08

Dear all, I'm a totally newbie and try to implements an LDAP-application over MonetDB/XQuery due to efficient search performance of column-store. Like the example XQueryLoad.java does i have succeed to import a XML-file and now come my questions: * How can i manipulate my XML-files with JAVA? Like doing searches and changes over XML-files. * How is the performance of Subtree-search? Like doing searchs over the whole tree or any subtrees. As once discussed in http://comments.gmane.org/gmane.comp.db.monetdb.user/1027, i'm in the same situation. Best regards, Chaojing Yang -- ------------------------------------------------------------------------------------------------------------------------------------------ Email: chaojing.yang(a)gmail.com Blog: http://goethe-ist-taoist.blogspot.com/ §1 Ich widerspreche der Nutzung oder Übermittlung meiner Daten für Werbezwecke oder sowie andere unbefugte Verwendungszwecke. (§ 28 Abs. 4 BDSG=Bundesdatenschutzgesetz). §2 Durch die Datenübertragung bzw. Kommunikation per E-Mail liegt ein Verstoß gegen das BDSG vor, da ihre Daten insoweit nicht ausreichend geschützt sind. Ich bitte Sie daher, mir schriftlich zu bestätigen, dass Sie mit dem Verstoß gegen das BDSG einverstanden sind und keine Schadensersatzanspräche bzw. Unterlassungsanspräche mir gegenüber geltend machen. §3 Der Inhalt dieser Nachricht ist vertraulich und nur für den oben angegebenen Empfänger bestimmt.

5 8

[MonetDB-users] Does MonetDB's JDBC Driver support CachedRowSet??
by sateesh 07 Aug '08

07 Aug '08

Hi All, I am wondering what JDBC Spec does the MonetDB's JDBC Driver conform to ? (is it JDBC3.0 ,4.0) We would like to use the pagination at the Database level and hence i want to know whether the JDBC Driver has any implementation of CachedRowSet.. Thanks Sateesh -- View this message in context: http://www.nabble.com/Does-MonetDB%27s--JDBC-Driver-support-CachedRowSet---… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1