- users-list - monetdb.org

[MonetDB-users] serial/auto_increment
by George H 25 Sep '06

25 Sep '06

Thanks: I have a large table (40 million+ rows) that I generated with "copy into" statements using several 1g txt files. The table was subsequently subjected to an "order asc" statement and now I need to have a sequence put on it and there I have a problem. A small simple test table illustrates the problem as follows: sql-> create table test (name varchar(10)); sql->alter table test add column seq serial; Error: ALTER TABLE ADD COLUMN: adding column with key constraint not … [View More]

1 0

Re: [MonetDB-users] Shredding DBLP XML document
by Stefan Manegold 22 Sep '06

22 Sep '06

Hi Erwin, shredding dblp.xml works fine for me with MonetDB/XQuery 0.13.1 (latest CVS version) on an Althon64 X2 with 2 GB RAM under Fedora Core 4: ======== # Monet Database Server V4.13.1 # Copyright (c) 1993-2006, CWI. All rights reserved. # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. MonetDB>shred_doc("/tmp/dblp.xml","dblp.xml"); # Elapsed time = 02m 05s 557ms 075us [005us/node] # Shredded 1 XML … [View More]

3 6

Re: [MonetDB-users] Comparing TPC-H benchmark results?
by moredata＠fastmail.net 21 Sep '06

21 Sep '06

Hello, I too would be interested in TPC-H comparisons of MonetDB versus other open source databases like MySQL and PostgreSQL, in addition to commercial databases like Oracle. If anyone has done such comparisons, please let me know. Martin also mentioned that the plans are not currently optimized but that it is targeted for V5. Are any of these optimizations already in the V5 CVS code (correlated subqueries?)? Thanks in advance. > -----Original Message----- > From: monetdb-users-… [View More]bounces(a)lists.sourceforge.net > [mailto:monetdb-users-bounces@lists.sourceforge.net] On > Behalf Of Martin Kersten > Sent: Saturday, September 16, 2006 7:39 AM > To: monetdb-users(a)lists.sourceforge.net > Subject: Re: [MonetDB-users] Comparing TPC-H benchmark results? > > > If I a remember correctly the scale factor is 0.01 in the > testweb. Beware that some queries in TPC-H require a lot of > intermediate space and the plans produced for MIL are not > optimized. (It is the target for the MonetDB V5 release) > > Actually, we would be interested in experiences in the > upcoming TPC-DS, which is more modern and not well explored > by any system. > > Fabian Groffen wrote: > > Hi, > > > > No need to resubmit your question. It was received, but I'm sorry > > that we've been too busy to answer this question. > > > > On 15-09-2006 21:25:15 +0200, Wouter Scherphof wrote: > >> Hi, > >> > >> The TPC-H benchmark (http://www.tpc.org/tpch/default.asp) > is part of > >> the MonetDB SQL source and the benchmark is run during > weekends, as I > >> can see on the TestWeb > >> > (http://monetdb.cwi.nl/testing/projects/monetdb/Current/sql/.mTests03 > >> /times.html). > >> How > >> should I interpret the listed results? According to TPC, > results should be > >> stated as a "QphH@Size" value, where "QphH" is the number > of queries per > >> hour for the H benchmark, and "Size" is a "scaling > factor". On the TestWeb, > >> the results are stated as seconds of execution time. > > > > The testweb tpc-h is very very very small, to keep both > testweb small > > in diskspace, and to keep the test time reasonable on our slower > > testing machines. > > > >> Is it correct to compute the QphH value as follows: > >> Queries 01-22 took 1.985 seconds, so QphH is (3600 / 1.985) * 22 = > >> 39.899 ? > > > > Well, the testweb framework does way more than just executing the > > test, so the performance time of the test might not be accurate. > > Also, you probably want to test with a higher workload, to > get a more > > accurate result. > > > >> What scaling factor is used in the benchmark runs; is this > 1? Is it > >> possible to let the TestWeb run with scaling factor 100? Because > >> that's the smallest Size for which results are published > on the TPC > >> web site. > > > > It's very small. I don't recall how small, but very very small. > > > >> Did anyone yet try to determine the Price of the test platforms, > >> following the TPC Pricing Spec? TPC-H results normally include a > >> Price/Performance metric in the form of $/QphH@Size, and I guess > >> MonetDB could score particularly well on this metric. > > > > We never really did this. But, feel free to try and setup > such test, > > we are very interested in the outcomes, of course. > > > > > > I hope this answers your questions. > > > > Regards > > > > > ---------------------------------------------------------------------- > > --- > > Using Tomcat but need to do more? Need to support web > services, security? > > Get stuff done quickly with pre-integrated technology to > make your job easier > > Download IBM WebSphere Application Server v.1.0.1 based on > Apache Geronimo > > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057& dat=121642 > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users -- moredata(a)fastmail.net -- http://www.fastmail.fm - IMAP accessible web-mail [View Less]

1 0

[MonetDB-users] schema reconstruction
by Ronald Oussoren 19 Sep '06

19 Sep '06

Hi, I'm trying to build a driver for monetdb for sqlalchemy (a python ORM layer). One of the things I need to do for that is provide a way to reconstruct the (some of) database schema on the fly. It seems to be easily possible to reconstruct most of the table definition from the 'table' and 'columns' tables, but how do I retrieve key contraints? Specifically, given this table definition: create table test ( id integer primairy key, name varchar(10) ) , I get some data in … [View More]

4 3

[MonetDB-users] Comparing TPC-H benchmark results?
by Wouter Scherphof 16 Sep '06

16 Sep '06

Hi, The TPC-H benchmark (http://www.tpc.org/tpch/default.asp) is part of the MonetDB SQL source and the benchmark is run during weekends, as I can see on the TestWeb ( http://monetdb.cwi.nl/testing/projects/monetdb/Current/sql/.mTests03/times.…) How should I interpret the listed results? According to TPC, results should be stated as a "QphH@Size" value, where "QphH" is the number of queries per hour for the H benchmark, and "Size" is a "scaling factor". On the TestWeb, the results are stated … [View More]

3 3

[MonetDB-users] packages for YUM (fedora 5) and PORT (os x intel)?
by Shahbaz 15 Sep '06

15 Sep '06

Hi, I would like to use Monet DB, however the RPMs provided on your webpage don't seem to work for Fedora Core 5. Despite having these libraries installed, rpm -Uvh and rpm -ivh tell me that libMapi, libalgebra, lib_arith, etc. are needed by MonetDB-QL-server-2.12.0-1.x86_64.rpm. (I have AMD 64). Could someone please provide a yum repository so users can' install monetdb just by doing the following: sudo yum install monetdb I don't have an immediate need for a darwin-ports distribution, but … [View More]

2 1

Re: [MonetDB-users] Fedora core 5 64 bit horribly slow compilation
by Fabian Groffen 11 Sep '06

11 Sep '06

On 11-09-2006 18:03:17 +0200, Tomas Brambora wrote: > Hello, Mr. Grofen, Hi Tomas, > I would like to ask whether there have been attempts to compile MonetDB on AMD Athlon 64 mobile achitecture OS Fedora Core 5 (64 bit version). > I ask because I was trying to compile it on my fresh installation of this OS and it just gets stuck on the file "gdk_scanselect.c". Or perhaps it doesn't get stuck, but I let it compile this file for 20 minutes and it didn't make any progress (it keeps on … [View More]

2 1

[MonetDB-users] XML Query Test Suite 1.0 released
by Martijn Faassen 30 Aug '06

30 Aug '06

Hi there, The developers of MonetDB are probably already more than aware of this, but just in case: The w3c has released version 1.0 of the XML Query Test suite. They ask for comments and display reports on the conformance of various systems on their page: http://www.w3.org/XML/Query/test-suite/ http://www.w3.org/XML/Query/test-suite/XQTSReportSimple.html http://www.w3.org/XML/Query/test-suite/XQTSReport.html Perhaps it'd be nice to be included in those reports? Regards, Martijn

2 2

[MonetDB-users] Could not bootstrap buildtools on SunOS 5.10
by Ying Zhang 29 Aug '06

29 Aug '06

Hello, I'm trying to install MonetDB (CVS HEAD) on a SunOS 5.10 32 bits machine (electra at CWI), but I'm already stuck by bootstrapping the buildtools. I've attached the whole output of the bootstrap. Please note the message at the end of the output. I have no idea what is going wrong here, so any help will be appreciated! Kind regards, Jennie ========================================== $ ./bootstrap + rm -f configure + cp configure.ac configure + chmod +x configure + cd Mx + ./bootstrap … [View More]/opt/sfw/share/aclocal/xmms.m4:17: warning: underquoted definition of XMMS_TEST_ VERSION run info '(automake)Extending aclocal' or see http://sources.redhat.com/automake/automake.html#Extending%20aclocal /opt/sfw/share/aclocal/xmms.m4:62: warning: underquoted definition of AM_PATH_XM MS /opt/sfw/share/aclocal/xdelta.m4:7: warning: underquoted definition of AM_PATH_X DELTA /opt/sfw/share/aclocal/vorbis.m4:9: warning: underquoted definition of XIPH_PATH _VORBIS /opt/sfw/share/aclocal/sdl.m4:11: warning: underquoted definition of AM_PATH_SDL /opt/sfw/share/aclocal/progtest.m4:13: warning: underquoted definition of AM_PAT H_PROG_WITH_TEST /opt/sfw/share/aclocal/ogg.m4:8: warning: underquoted definition of XIPH_PATH_OG G /opt/sfw/share/aclocal/lcmessage.m4:11: warning: underquoted definition of AM_LC _MESSAGES /opt/sfw/share/aclocal/imlib.m4:9: warning: underquoted definition of AM_PATH_IM LIB /opt/sfw/share/aclocal/imlib.m4:167: warning: underquoted definition of AM_PATH_ GDK_IMLIB /opt/sfw/share/aclocal/gimpprint.m4:8: warning: underquoted definition of AM_PAT H_GIMPPRINT /opt/sfw/share/aclocal/gimp.m4:8: warning: underquoted definition of AM_PATH_GIM P /opt/sfw/share/aclocal/gettext.m4:11: warning: underquoted definition of AM_WITH _NLS /opt/sfw/share/aclocal/gettext.m4:196: warning: underquoted definition of AM_GNU _GETTEXT /opt/sfw/share/aclocal/ao.m4:9: warning: underquoted definition of XIPH_PATH_AO /usr/share/aclocal/vorbis.m4:9: warning: underquoted definition of XIPH_PATH_VOR BIS /usr/share/aclocal/vorbis-old.m4:9: warning: underquoted definition of AM_PATH_V ORBIS /usr/share/aclocal/pkg.m4:5: warning: underquoted definition of PKG_CHECK_MODULE S /usr/share/aclocal/ogg.m4:8: warning: underquoted definition of XIPH_PATH_OGG /usr/share/aclocal/ogg-old.m4:8: warning: underquoted definition of AM_PATH_OGG /usr/share/aclocal/esd.m4:10: warning: underquoted definition of AM_PATH_ESD /usr/share/aclocal/esd.m4:175: warning: underquoted definition of AM_ESD_SUPPORT S_MULTIPLE_RECORD /usr/share/aclocal/audiofile.m4:12: warning: underquoted definition of AM_PATH_A UDIOFILE /usr/sfw/share/aclocal/gtk.m4:7: warning: underquoted definition of AM_PATH_GTK /usr/sfw/share/aclocal/glib.m4:8: warning: underquoted definition of AM_PATH_GLI B /usr/sfw/share/aclocal/gimpprint.m4:8: warning: underquoted definition of AM_PAT H_GIMPPRINT ./bootstrap: test: argument expected + exit 1 [View Less]

3 7

Re: [MonetDB-users] Could not bootstrap buildtools on SunOS 5.10
by Ying Zhang 29 Aug '06

29 Aug '06

Thanks, your tip helps to get rid of a strange problem in another MonetDB installation of mine. I was also installing monet on a Fedora4, 32bits machine (norma at cwi). I could not install all buildtools in one go while I can install each buildtool separately. After having clean out the buildtools and start all over again, the problem disappeared. But it doesn't help to solve this problem. I will have to find other solutions:) On Mon, Aug 28, 2006 at 10:17:19PM +0200, Martin Kersten wrote:… [View More] > Hello, > I am not the right person, but I spent 2.5 hours yesterday (and friday > too) to re-install my version :-(. > One of the lessons learned, with each step use a fresh window, so that > existing shell variables and aliases are out of the way. > > i.e. > step 1, clean out the builtools (or better save them elsewhere ;-)) > followed by cvs upd > step 2, open a new SUN session window and start the bootstrap sequence. > > good luck ! > > Ying Zhang wrote: > >Hello, > > > >I'm trying to install MonetDB (CVS HEAD) on a SunOS 5.10 32 bits machine > >(electra at CWI), but I'm already stuck by bootstrapping the buildtools. > >I've attached the whole output of the bootstrap. Please note the > >message at the end of the output. I have no idea what is going wrong > >here, so any help will be appreciated! > > > >Kind regards, > > > >Jennie > > > > > >========================================== > >$ ./bootstrap > >+ rm -f configure > >+ cp configure.ac configure > >+ chmod +x configure > >+ cd Mx > >+ ./bootstrap > >/opt/sfw/share/aclocal/xmms.m4:17: warning: underquoted definition of > >XMMS_TEST_ VERSION > > run info '(automake)Extending aclocal' > > or see > > http://sources.redhat.com/automake/automake.html#Extending%20aclocal > >/opt/sfw/share/aclocal/xmms.m4:62: warning: underquoted definition of > >AM_PATH_XM MS > >/opt/sfw/share/aclocal/xdelta.m4:7: warning: underquoted definition of > >AM_PATH_X DELTA > >/opt/sfw/share/aclocal/vorbis.m4:9: warning: underquoted definition of > >XIPH_PATH _VORBIS > >/opt/sfw/share/aclocal/sdl.m4:11: warning: underquoted definition of > >AM_PATH_SDL > >/opt/sfw/share/aclocal/progtest.m4:13: warning: underquoted definition of > >AM_PAT H_PROG_WITH_TEST > >/opt/sfw/share/aclocal/ogg.m4:8: warning: underquoted definition of > >XIPH_PATH_OG G > >/opt/sfw/share/aclocal/lcmessage.m4:11: warning: underquoted definition of > >AM_LC _MESSAGES > >/opt/sfw/share/aclocal/imlib.m4:9: warning: underquoted definition of > >AM_PATH_IM LIB > >/opt/sfw/share/aclocal/imlib.m4:167: warning: underquoted definition of > >AM_PATH_ GDK_IMLIB > >/opt/sfw/share/aclocal/gimpprint.m4:8: warning: underquoted definition of > >AM_PAT H_GIMPPRINT > >/opt/sfw/share/aclocal/gimp.m4:8: warning: underquoted definition of > >AM_PATH_GIM P > >/opt/sfw/share/aclocal/gettext.m4:11: warning: underquoted definition of > >AM_WITH _NLS > >/opt/sfw/share/aclocal/gettext.m4:196: warning: underquoted definition of > >AM_GNU _GETTEXT > >/opt/sfw/share/aclocal/ao.m4:9: warning: underquoted definition of > >XIPH_PATH_AO > >/usr/share/aclocal/vorbis.m4:9: warning: underquoted definition of > >XIPH_PATH_VOR BIS > >/usr/share/aclocal/vorbis-old.m4:9: warning: underquoted definition of > >AM_PATH_V ORBIS > >/usr/share/aclocal/pkg.m4:5: warning: underquoted definition of > >PKG_CHECK_MODULE S > >/usr/share/aclocal/ogg.m4:8: warning: underquoted definition of > >XIPH_PATH_OGG > >/usr/share/aclocal/ogg-old.m4:8: warning: underquoted definition of > >AM_PATH_OGG > >/usr/share/aclocal/esd.m4:10: warning: underquoted definition of > >AM_PATH_ESD > >/usr/share/aclocal/esd.m4:175: warning: underquoted definition of > >AM_ESD_SUPPORT S_MULTIPLE_RECORD > >/usr/share/aclocal/audiofile.m4:12: warning: underquoted definition of > >AM_PATH_A UDIOFILE > >/usr/sfw/share/aclocal/gtk.m4:7: warning: underquoted definition of > >AM_PATH_GTK > >/usr/sfw/share/aclocal/glib.m4:8: warning: underquoted definition of > >AM_PATH_GLI B > >/usr/sfw/share/aclocal/gimpprint.m4:8: warning: underquoted definition of > >AM_PAT H_GIMPPRINT > >./bootstrap: test: argument expected > > + exit 1 > > > > > > > >------------------------------------------------------------------------- > >Using Tomcat but need to do more? Need to support web services, security? > >Get stuff done quickly with pre-integrated technology to make your job > >easier > >Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > >http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > >_______________________________________________ > >MonetDB-users mailing list > >MonetDB-users(a)lists.sourceforge.net > >https://lists.sourceforge.net/lists/listinfo/monetdb-users [View Less]

3 2