- users-list - monetdb.org

[MonetDB-users] Возможность выборки по любой теме
by Г.В Евреинов 04 Mar '07

04 Mar '07

ИНТЕРНЕТ РАССЫЛКИ полный отчет о проделанной работе принимаются заказы на рассылку от 3 000 рублей возможность выборки по любой теме самое современное оборудование самые полные регулярно обновляемые базы (Москва Россия СНГ…) Бесплатно: изготовление макета, консультация, выезд курьера, выборка по отраслям и регионам!!! Подробную информацию можно узнать из нашего прайс-листа. Позвоните нам и мы вышлем его на Ваш эл.ящик /495/ 642_52_97

1 0

[MonetDB-users] help getting started
by Todd Gruben 02 Mar '07

02 Mar '07

I downloaded the latest super tar ball MonetDB-Venus-SuperBall-SR1.tar.bz2 to my centos 4.3 box. Here is what i have done so far >tar -jzvf MonetDB-Venus-SuperBall-SR1.tar.bz2 >cd MonetDB-Venus-SuperBall-SR1 >./monetdb-install.sh --enable-sql --enable-xquery it runs allong and appears to work by installing monetdb in the /root/ MonetDB. After adding /root/MonetDB/bin to my path and adding export MONETDB5_PREFIX=/root/MonetDB to my enviroment i try and start the database with the following command > mserver5 # MonetDB Server v5.0.0_beta1_2 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for i686-redhat-linux-gnu/32bit with 32bit OIDs dynamically linked # dbname:demo # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /root/MonetDB/etc/monetdb5.conf) > So far so good. Just like the docs. Now comes the trouble, I flip over to another shell and execute the following command >mjclient -lsql -u monetdb and for the password i use monetdb This is the error that I receive: MALException:setScenario:Scenario 'sql' not initialized Any ideas? I am thinking i have missed something but can't really grasp what that is. -Thanks m

2 1

[MonetDB-users] ../conf/*.mk: No such file or directory
by Ying Zhang 02 Mar '07

02 Mar '07

Hello, I did a fresh checkout of the current branch, and tried to build it. After having compiled and installed buildtools, 'make install' of MonetDB gives the following error: [andorea:/ufs/zhang/current/MonetDB/build-debug] $ make install Makefile:860: ../conf/*.mk: No such file or directory make: *** No rule to make target `../conf/*.mk'. Stop. I have seen this error before, but I can't rememeber how I solved it. Does someone have an idea? Thanks a lot! Jennie

2 2

[MonetDB-users] shrinking BATs and distributed/streaming MonetDB
by Shahbaz 01 Mar '07

01 Mar '07

I was finally able to install monetdb and put data into it (on OSX), although I don't have any performance numbers to report back just yet. -If i delete or even drop a large table from MDB5, many of the BAT files remain on the file system. Is there a command that deflates/shrinks or completely removes to files? I wasn't able to find anything in the docs -According to previous messages on the mailing list and some other docs, MonetDB 5 is supposed to work with distributed databases (Armada?). I don't see anything regarding this in the docs either, is it coming soon? -I am very (VERY) interested in the ability to have a cluster/grid of MDB servers which let me distribute data and computation while providing an easy to use interface for end users and admins. Along with that, if we get the ability to process streaming data (such as stock quotes), MonetDB will become king of Wall Street :) -I see that one of the recommended projects for students is to extend MonetDB to process time series data. If someone is looking at this, please take a look at this paper: http://citeseer.ist.psu.edu/610025.html (AQuery for ordered data). Thanks

2 3

[MonetDB-users] □■monetdb-users@lists.sourceforge.net様あて
by ★交際 28 Feb '07

28 Feb '07

monetdb-users(a)lists.sourceforge.xn--net-fc2g 貴方様に好条件のお相手が見つかりました。今回特別に検索結果とともに以下の優待が受けられます。 (1)秘密交際を望む男性には女性を、女性には男性を、それぞれの希望で、　　アプローチを受けていただくかどうかを選択できます。 (2)検索条件にあった方にだけの特別優待です。これを受け取った方にだけに　　優先権利があります。 (3)お相手の方に、貴方様への連絡用メールアドレスをお渡ししています。　　期限付きですが、直接にお相手からのメールを受け取ることができます。 http://www.u-l-tra.com/rm1120 無料参加型ですから、お気軽に女性または男性のお誘いをお受け下さい。秘密募集の特別優待の件ということで、通常よりもお話が順調に進むかと思います。それでは、でお二人だけの時間をお過ごし下さい。 >>>>> 秘密交際募集掲示板サポート >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 　　優待案内(No.14870)をお送りしましたのは事務局担当、私、三浦、　　そして全国11拠点となった秘密交際クラブを宜しくお願いします。

1 0

[MonetDB-users] repository
by Isagani SIRGENSON 28 Feb '07

28 Feb '07

Have, an article with this. Purge function if previously, existed at title deletion! Here it may yet be visible because. Sound and videolook other pages within that. At, title deletion log see why my from? Our sister dictionary wikimedia commons repository images music sound. Name please search for in check. Article with this exact name please search for, in. Other, pages within that link! Wait few minutes try purge. An article with, this exact name please search? Existed at, title deletion log see. Deletion, log see why my from. Log see, why my from discussion view toolssign. Titleif page was recently created here it. California wikipedia the free to navigation does not. Log see why my from discussion, view toolssign. With this exact name please search for in. It may yet be visible because. Not have an article with this. Images music sound and videolook other pages within, that. Navigation does not have an article. Wikimedia commons, repository, images! Free to navigation does not have? Music sound and, videolook other pages within, that. Be visible because of delay.

1 0

[MonetDB-users] note we unable
by Rebin Urena 28 Feb '07

28 Feb '07

Ng collection february, johnson. Helpful durability fun hallie june. Christmas always im glad kind. Stockships from sold ez pawn shop or turn, on. Soon available related searches promotions free shipping? Heel, sandals, long black patent. At checkout, heres how apply, features, inch glamorous dressed. Your stuffbuy corporate developers web. When, spend qualifying offered enter code. Guides baby registry wedding, someones list.

1 0

[MonetDB-users] Bättre luft för bättre hälsa
by ITWorks VårtVal 27 Feb '07

27 Feb '07

- This mail is in HTML. Some elements may be ommited in plain text. - Tel: +46 (0)8 625 46 40 ULTRA-TYST LUFTRENARE FÖR KONTOR OCH HEM Lider du av allergiska besvär på våren? Besväras du av illaluktande ämnen på din arbetsplats eller i hemmet? En luftrenare kan göra underverk på din hälsa! Vi rekommenderar pollenallergiska personer att ställa ett luftfilter vid anslutning till arbetsplatsen och i sovrummet Lukt- och dammsensorer känner automatiskt av luftmiljön Renar luften från pollen, damm och partiklar Anti-bakteriellt filter minskar infektionsrisken i gemensamma utrymmen I princip ljudlös - perfekt för sovrummet eller andra ljudkänsliga miljöer Elegant design och låg vikt (endast 7 kg) Mycket lättanvänd med fjärrkontroll Tvättbart filter 2 års fabriksgaranti >> Beställ eller läs mer genom att klicka här! Tips: Vill du köpa Blu-ray eller äkta HDTV? E-posta vartval(a)itweurope.com så hjälper vi dig med leverans. Avbetalning och leasing OK! Om du inte vill ha fler erbjudanden från ITWorks, skicka ett e-brev till removeme(a)itweurope.com med ärende "remove" If you do not want to recieve any more e-mails from ITWorks sales, please send a message to removeme(a)itweurope.com with subject "remove"

1 0

[MonetDB-users] Bug fix release of MonetDB suite
by Sjoerd Mullender 26 Feb '07

26 Feb '07

The MonetDB team at CWI, The Netherlands, is happy to announce the availability of a new bug-fix release for the major "Venus" release. New versions of all components of the MonetDB suite are released. MonetDB/XQuery The handling of updates was incomplete. Several memory mapping and concurrency problems have been fixed. Moreover, empty pages that resulted from deletion of nodes are now properly handed back to the system for reuse. MonetDB/XRPC Security and concurrency handling has been improved. MonetDB/SQL Foreign key constraint checking fixed; View in view dependencies bug fixed; Resolved crashes caused by large views; Prepared statements with more than 30 arguments now work. MonetDB/API Haskell and TCL libraries were broken and have been removed; Perl and Python libraries were broken and have been fixed. The current version of the protocol is not compatible with the previous version. Bugs fixed: [ 1579510 ] XQ: update error for "(1,2)/." [ 1590523 ] XQ: substring-after [ 1636828 ] fork() behaves strangely [ 1637867 ] XQ: seqcast int? to numeric unsupported [ 1639108 ] mserver crashes on delete query [ 1640248 ] PF: ~500 tests randomly fail on Solaris x86 [ 1644245 ] M5 & SQL5: various tests hang/timeout on Darwin [ 1648303 ] database dump does not save/restore auto-increment sequences [ 1650469 ] SQL: Armada sinks MonetDB ships [ 1651567 ] yet another delete bug, foreign key related [ 1651599 ] caching of inserts causes extreme memory consumption [ 1655818 ] SQL:Error inserting float in numeric column using JDBC [ 1655857 ] XQ: call to builtin function crashes XRPC client [ 1659889 ] SQL: sequence not restored properly [ 1644610 ] Conflict between normal query and XRPC query (and many more that hadn't been reported) -- Sjoerd Mullender

1 0

[MonetDB-users] cannot start MonetDB5 server on Windows anymore
by Jos van Dongen 26 Feb '07

26 Feb '07

Does anyone has this error and how can I get rid of it?. I’m running on Windows Server 2003 (on a different machine using XP I got the same error after rebooting the machine). It looks like some references are missing. C:\Program Files\CWI\MonetDB5>m5server !ERROR: force_move: link(bat\BACKUP\1541.buns,bat15\1541.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1541.desc,bat15\1541.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1543.buns,bat15\1543.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1543.desc,bat15\1543.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1545.buns,bat15\1545.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1545.desc,bat15\1545.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1547.buns,bat15\1547.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1547.desc,bat15\1547.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1547.theap,bat15\1547.theap)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1551.buns,bat15\1551.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1551.desc,bat15\1551.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1554.buns,bat15\1554.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1554.desc,bat15\1554.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1556.buns,bat15\1556.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1556.desc,bat15\1556.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1560.buns,bat15\1560.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1560.desc,bat15\1560.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1562.buns,bat15\1562.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1562.desc,bat15\1562.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1562.theap,bat15\1562.theap)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1612.buns,bat16\1612.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1612.desc,bat16\1612.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1614.buns,bat16\1614.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1614.desc,bat16\1614.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1614.theap,bat16\1614.theap)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1616.buns,bat16\1616.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1616.desc,bat16\1616.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1620.buns,bat16\1620.buns)=-1 !OS: No such file or directory !ERROR: force_move: link(bat\BACKUP\1620.desc,bat16\1620.desc)=-1 !OS: No such file or directory !ERROR: BBPrecover: recovery failed. Please check whether your disk is full or w rite-protected. !FATAL: BBPinit: cannot properly process bat\BACKUP. Thanks in advance for any help on this subject! Regards, Jos van Dongen -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.3/700 - Release Date: 24-2-2007 20:14

3 2

[MonetDB-users] xrpc clients
by oliver oli 25 Feb '07

25 Feb '07

hello, i'm trying to understand the design of monetdb/xquery, how it works and what are my options to use it with python / ruby. xrpc is a soap interface, is it possible to use monetdb/xquery with any soap client? in other words: could it be an alternative to the mapi interface

2 3

[MonetDB-users] More OS X problems
by Dean 25 Feb '07

25 Feb '07

OK, I just tried this: ./monetdb-install.sh --prefix=/opt/monetdb --enable-sql --enable-xquery --nightly=current -j2 Building the latest code and got the following error: /bin/sh ../../../libtool --tag=CC --mode=link gcc -g -O2 -Wall -Wextra -std=c99 -Werror-implicit-function-declaration -Werror -Wpointer-arith -Wdeclaration-after-statement -Wno-uninitialized -o libMonetODBC.la -rpath /opt/monetdb/lib -export-symbols ODBC.def libMonetODBC_la-ODBCConvert.lolibMonetODBC_la- ODBCDbc.lo libMonetODBC_la-ODBCDesc.lo libMonetODBC_la-ODBCEnv.lolibMonetODBC_la- ODBCError.lo libMonetODBC_la-ODBCStmt.lo libMonetODBC_la-ODBCUtil.lolibMonetODBC_la- SQLAllocConnect.lo libMonetODBC_la-SQLAllocEnv.lo libMonetODBC_la- SQLAllocHandle.lo libMonetODBC_la-SQLAllocStmt.lo libMonetODBC_la- SQLBindCol.lo libMonetODBC_la-SQLBindParameter.lo libMonetODBC_la- SQLBrowseConnect.lo libMonetODBC_la-SQLBulkOperations.lo libMonetODBC_la- SQLCancel.lo libMonetODBC_la-SQLCloseCursor.lo libMonetODBC_la- SQLColAttribute.lo libMonetODBC_la-SQLColAttributes.lo libMonetODBC_la- SQLColumnPrivileges.lo libMonetODBC_la-SQLColumns.lo libMonetODBC_la- SQLConnect.lo libMonetODBC_la-SQLCopyDesc.lo libMonetODBC_la- SQLDataSources.lo libMonetODBC_la-SQLDescribeCol.lo libMonetODBC_la- SQLDescribeParam.lo libMonetODBC_la-SQLDisconnect.lo libMonetODBC_la- SQLDriverConnect.lo libMonetODBC_la-SQLDrivers.lo libMonetODBC_la- SQLEndTran.lo libMonetODBC_la-SQLError.lo libMonetODBC_la-SQLExecDirect.lolibMonetODBC_la- SQLExecute.lo libMonetODBC_la-SQLExtendedFetch.lo libMonetODBC_la- SQLFetch.lo libMonetODBC_la-SQLFetchScroll.lo libMonetODBC_la- SQLForeignKeys.lo libMonetODBC_la-SQLFreeConnect.lo libMonetODBC_la- SQLFreeEnv.lo libMonetODBC_la-SQLFreeHandle.lo libMonetODBC_la- SQLFreeStmt.lo libMonetODBC_la-SQLGetConnectAttr.lo libMonetODBC_la- SQLGetConnectOption.lo libMonetODBC_la-SQLGetCursorName.lo libMonetODBC_la- SQLGetData.lo libMonetODBC_la-SQLGetDescField.lo libMonetODBC_la- SQLGetDescRec.lo libMonetODBC_la-SQLGetDiagField.lo libMonetODBC_la- SQLGetDiagRec.lo libMonetODBC_la-SQLGetEnvAttr.lo libMonetODBC_la- SQLGetFunctions.lo libMonetODBC_la-SQLGetInfo.lo libMonetODBC_la- SQLGetStmtAttr.lo libMonetODBC_la-SQLGetStmtOption.lo libMonetODBC_la- SQLGetTypeInfo.lo libMonetODBC_la-SQLMoreResults.lo libMonetODBC_la- SQLNativeSql.lo libMonetODBC_la-SQLNumParams.lo libMonetODBC_la- SQLNumResultCols.lo libMonetODBC_la-SQLParamData.lo libMonetODBC_la- SQLParamOptions.lo libMonetODBC_la-SQLPrepare.lo libMonetODBC_la- SQLPrimaryKeys.lo libMonetODBC_la-SQLProcedureColumns.lo libMonetODBC_la- SQLProcedures.lo libMonetODBC_la-SQLPutData.lo libMonetODBC_la- SQLRowCount.lo libMonetODBC_la-SQLSetConnectAttr.lo libMonetODBC_la- SQLSetConnectOption.lo libMonetODBC_la-SQLSetCursorName.lo libMonetODBC_la- SQLSetDescField.lo libMonetODBC_la-SQLSetDescRec.lo libMonetODBC_la- SQLSetEnvAttr.lo libMonetODBC_la-SQLSetParam.lo libMonetODBC_la-SQLSetPos.lolibMonetODBC_la- SQLSetScrollOptions.lo libMonetODBC_la-SQLSetStmtAttr.lo libMonetODBC_la- SQLSetStmtOption.lo libMonetODBC_la-SQLSpecialColumns.lo libMonetODBC_la- SQLStatistics.lo libMonetODBC_la-SQLTablePrivileges.lo libMonetODBC_la- SQLTables.lo libMonetODBC_la-SQLTransact.lo ../../mapilib/libMapi.la -L/opt/monetdb/lib -lstream -liconv libtool: link: symbol file `ODBC.def' does not exist make[7]: *** [libMonetODBC.la] Error 1 make[6]: *** [all] Error 2 make[5]: *** [all-recursive] Error 1 make[4]: *** [all] Error 2 make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 making MonetDB-client failed I'll keep trying!

2 1

[MonetDB-users] installation issues
by richard miller 23 Feb '07

23 Feb '07

Sirs: I am a UBUNTU/DEBIAN user - I did not see a debian package - I got the following error log file trying to run MonteDB.sh I have cut the log file down. -- Richard M. Miller (CTO) Next-G Communications, Inc. 6200 Savoy Ste 520 Houston, Texas 77036 office (713) 952-5885 ext 233 cell (832) 512-2742 rmiller(a)nextg.com Cleanup ... done Thu Feb 22 13:42:55 CST 2007 Install sql VERSION=CURRENT DBFARM=/work/downloads/monetdb/MonetDB-test-rebuild/dbfarm DBLOGS=/work/downloads/monetdb/MonetDB-test-rebuild/dblogs SILENT=FALSE Download MonetDB-0_latest.tar.gz ... --13:42:55-- http://monetdb.cwi.nl/testing/projects/monetdb/Current/.DailyBuilds./1____a… => `MonetDB-0_latest.tar.gz' Resolving monetdb.cwi.nl... 192.16.196.149 Connecting to monetdb.cwi.nl|192.16.196.149|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 1,197,340 (1.1M) [application/x-gzip] 0K .......... .......... .......... .......... .......... 4% 91.55 KB/s 50K .......... .......... .......... .......... .......... 8% 87.05 KB/s 100K .......... .......... .......... .......... .......... 12% 430.04 KB/s 150K .......... .......... .......... .......... .......... 17% 194.39 KB/s 200K .......... .......... .......... .......... .......... 21% 91.33 KB/s 250K .......... .......... .......... .......... .......... 25% 628.27 KB/s 300K .......... .......... .......... .......... .......... 29% 161.69 KB/s 350K .......... .......... .......... .......... .......... 34% 99.33 KB/s 400K .......... .......... .......... .......... .......... 38% 403.46 KB/s 450K .......... .......... .......... .......... .......... 42% 161.46 KB/s 500K .......... .......... .......... .......... .......... 47% 106.97 KB/s 550K .......... .......... .......... .......... .......... 51% 314.11 KB/s 600K .......... .......... .......... .......... .......... 55% 161.71 KB/s 650K .......... .......... .......... .......... .......... 59% 111.01 KB/s 700K .......... .......... .......... .......... .......... 64% 255.88 KB/s 750K .......... .......... .......... .......... .......... 68% 157.32 KB/s 800K .......... .......... .......... .......... .......... 72% 120.43 KB/s 850K .......... .......... .......... .......... .......... 76% 195.14 KB/s 900K .......... .......... .......... .......... .......... 81% 84.48 KB/s 950K .......... .......... .......... .......... .......... 85% 471.97 KB/s 1000K .......... .......... .......... .......... .......... 89% 208.15 KB/s 1050K .......... .......... .......... .......... .......... 94% 95.72 KB/s 1100K .......... .......... .......... .......... .......... 98% 401.99 KB/s 1150K .......... ......... 100% 166.89 KB/s 13:43:03 (153.08 KB/s) - `MonetDB-0_latest.tar.gz' saved [1197340/1197340] OK Unpacking MonetDB-0_latest.tar.gz ... MonetDB-1.17.1/ MonetDB-1.17.1/Makefile.msc OK Download MonetDB-client-0_latest.tar.gz ... --13:43:03-- http://monetdb.cwi.nl/testing/projects/monetdb/Current/.DailyBuilds./1____a… => `MonetDB-client-0_latest.tar.gz' Resolving monetdb.cwi.nl... 192.16.196.149 Connecting to monetdb.cwi.nl|192.16.196.149|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 1,099,805 (1.0M) [application/x-gzip] 0K .......... .......... .......... .......... .......... 4% 85.86 KB/s 50K .......... .......... .......... .......... .......... 9% 86.98 KB/s 100K .......... .......... .......... .......... .......... 13% 434.53 KB/s 150K .......... .......... .......... .......... .......... 18% 187.90 KB/s 200K .......... .......... .......... .......... .......... 23% 92.79 KB/s 250K .......... .......... .......... .......... .......... 27% 630.30 KB/s 300K .......... .......... .......... .......... .......... 32% 154.90 KB/s 350K .......... .......... .......... .......... .......... 37% 95.91 KB/s 400K .......... .......... .......... .......... .......... 41% 512.76 KB/s 450K .......... .......... .......... .......... .......... 46% 157.40 KB/s 500K .......... .......... .......... .......... .......... 51% 106.81 KB/s 550K .......... .......... .......... .......... .......... 55% 308.01 KB/s 600K .......... .......... .......... .......... .......... 60% 160.80 KB/s 650K .......... .......... .......... .......... .......... 65% 102.38 KB/s 700K .......... .......... .......... .......... .......... 69% 377.23 KB/s 750K .......... .......... .......... .......... .......... 74% 157.20 KB/s 800K .......... .......... .......... .......... .......... 79% 117.91 KB/s 850K .......... .......... .......... .......... .......... 83% 194.79 KB/s 900K .......... .......... .......... .......... .......... 88% 157.19 KB/s 950K .......... .......... .......... .......... .......... 93% 108.69 KB/s 1000K .......... .......... .......... .......... .......... 97% 309.39 KB/s 1050K .......... .......... .... 100% 157.53 KB/s 13:43:11 (151.93 KB/s) - `MonetDB-client-0_latest.tar.gz' saved [1099805/1099805] OK Unpacking MonetDB-client-0_latest.tar.gz ... clients-1.17.1/ OK Download MonetDB5-server-0_latest.tar.gz ... --13:43:11-- http://monetdb.cwi.nl/testing/projects/monetdb/Current/.DailyBuilds./1____a… => `MonetDB5-server-0_latest.tar.gz' Resolving monetdb.cwi.nl... 192.16.196.149 Connecting to monetdb.cwi.nl|192.16.196.149|:80... connected. HTTP request sent, awaiting response... 404 Not Found 13:43:11 ERROR 404: Not Found.

3 3

[MonetDB-users] equal pay deal
by DeVante Busby 23 Feb '07

23 Feb '07

Anistons readers talkback patti clayton suspicion abuse mounts. Kong eat youll fined acid rain erasing yr old? Theyve all fantasized hot, heavy. Sadhus massive indian festival soul has no gt previous. Eye movement attention determine, at risk pregnancy! Russias natural livein getting unstable brothel owners accuse. Go login register home lifestyle gossip fashion designers, bollywood. Would love snog happens! Coolpix pseries camera introduces two series soon map. She would love, snog. Other, british beauty kelly brooke. Daydreams actress shop costar queen. Allen boasts drunken miller. Photos single scene into virtual world phone opens mobile. Good looking men also another thing common theyve all. Gets custody rehab timebrad pitt urges. Lou gehrigs disease give, gingerly care. Mills dance show michael jackson! Astronauts prepare spacewalk today chocolate can, boost brain. Gray, aniston explains nose. Cancer iss astronauts prepare spacewalk today. Home lifestyle, gossip fashion.

1 0

[MonetDB-users] Personal Finance
by Video 21 Feb '07

21 Feb '07

1 0

[MonetDB-users] compilation errors...etc.
by Shahbaz 20 Feb '07

20 Feb '07

I've been trying to get MonetDB to compile on my machine: OSX Tiger (Intel): Macbook Pro. I downloaded the source code and ran the following command: sudo ./monetdb-install.sh --enable-sql --enable-xquery (both with and without sudo) The relevant part of the error message is listed at the bottom of this email. I would stil like to encourage someone to provide a macports port distribution. I have no idea how to set one up, but if I can assist somehow, I'll be happy to do so. An annoyance and an observation: Traversing source forge's mail archives is a terrible, terrible experience. Has any on thought of switching to google groups? Heck, why not move the whole project there, svn will be a very nice side benefit :) When I do google searches for MonetDB, ads for Vertica almost always come up. Since Vertica has business savvy people behind it, we should expect to hear a great deal about it....and whenever Vertica is mentioned, someone (like me) will kindly point out that MonetDB is a contender as well :) In other words, prepare for far greater interest in this project. Lastly, how about an IRC channel for MonetDB! ------------------------------------------------------------------------------------------------------------ compile_jdbc: [echo] Compiling JDBC driver [javac] Compiling 22 source files to /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetClob.java:35: duplicate class: nl.cwi.monetdb.jdbc.MonetClob [javac] public class MonetClob implements Clob { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetConnection.java:55: duplicate class: nl.cwi.monetdb.jdbc.MonetConnection [javac] public class MonetConnection implements Connection { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetConnection.java:2554: duplicate class: nl.cwi.monetdb.jdbc.MonetEmbeddedInstance [javac] class MonetEmbeddedInstance extends Thread { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetDataSource.java:40: duplicate class: nl.cwi.monetdb.jdbc.MonetDataSource [javac] public class MonetDataSource implements DataSource { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java:31: duplicate class: nl.cwi.monetdb.jdbc.MonetDatabaseMetaData [javac] public class MonetDatabaseMetaData implements DatabaseMetaData { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java:3103: duplicate class: nl.cwi.monetdb.jdbc.MonetVirtualResultSet [javac] class MonetVirtualResultSet extends MonetResultSet { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetDriver.java:46: duplicate class: nl.cwi.monetdb.jdbc.MonetDriver [javac] final public class MonetDriver implements Driver { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetPreparedStatement.java:51: duplicate class: nl.cwi.monetdb.jdbc.MonetPreparedStatement [javac] public class MonetPreparedStatement [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetResultSet.java:48: duplicate class: nl.cwi.monetdb.jdbc.MonetResultSet [javac] public class MonetResultSet implements ResultSet { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetSavepoint.java:43: duplicate class: nl.cwi.monetdb.jdbc.MonetSavepoint [javac] public class MonetSavepoint implements Savepoint { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetSocketBlockMode.java:56: duplicate class: nl.cwi.monetdb.jdbc.MonetSocketBlockMode [javac] final class MonetSocketBlockMode { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/MonetStatement.java:47: duplicate class: nl.cwi.monetdb.jdbc.MonetStatement [javac] public class MonetStatement implements Statement { [javac] ^ [javac] /var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/src/nl/cwi/monetdb/jdbc/util/MonetRedirectException.java:23: duplicate class: nl.cwi.monetdb.jdbc.util.MonetRedirectException [javac] public class MonetRedirectException extends Exception { [javac] ^ [javac] Note: Some input files use or override a deprecated API. [javac] Note: Recompile with -Xlint:deprecation for details. [javac] 13 errors BUILD FAILED /private/var/tmp/MonetDB-1171591624/MonetDB-client/clients/src/java/build.xml:153: Compile failed; see the compiler error output for details. Total time: 2 seconds make[6]: *** [jar_jdbcclient_ant_target] Error 1 make[5]: *** [all-recursive] Error 1 make[4]: *** [all] Error 2 make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 making MonetDB-client failed libtool: unknown option character `-' in: --version Usage: libtool -static [-] file [...] [-filelist listfile[,dirname]] [-arch_only arch] [-sacLT] Usage: libtool -dynamic [-] file [...] [-filelist listfile[,dirname]] [-arch_only arch] [-o output] [-install_name name] [-compatibility_version #] [-current_version #] [-seg1addr 0x#] [-segs_read_only_addr 0x#] [-segs_read_write_addr 0x#] [-seg_addr_table <filename>] [-seg_addr_table_filename <file_system_path>] [-all_load] [-noall_load]

3 4

[MonetDB-users] kilolarınızdan memnunmusunuz
by wellness danışmanı 19 Feb '07

19 Feb '07

Doğru seçimi yapın Bazen, bir işe girişmeye ve farklı bir şeyler yapmaya karar vermek çok kolay olmayabilir. Ortalama küçük ölçekli bir işletme kurma maliyetinin çok pahalı olduğunu ve bu işletmelerin birçoğunun ilk yıllarında kapanmak zorunda kaldığını biliyor muydunuz? Herbalite ile kendi işinizi yürütme zorluğunun önüne geçmekteyiz. Stok tutma zorunluluğu, sabit genel giderler ve yüksek yatırım maliyetlerine gerek yok, Herbalife'la çalışmak için Uluslararası iş Paketi'ni edinmeniz yeterli! İster sonu belirsiz bir işte mücadele ediyor olun ister ekstra bir gelir amaçlıyor olun, Herbalife size iyi bir İş Fırsatı sunmaktadır. Herbalife sayesinde evinizden çalışma özgürlüğüne, kendi patronunuz olma imkanına ve sadece istediğiniz şeyleri yapabilme fırsatına sahip olacaksınız. Artık iş yükü altında ezilmek, ailenizi özlemek veya işten çıkarılma korkusu duymak yok. Herbalife işinizde, çalışmaya ayıracağınız zamanı siz belirlersiniz. Şu an bulunduğunuz noktadan ne kadar ileriye gideceğiniz ve ne kadar para kazanabileceğiniz tamamen sizin ellerinizde! Herbalife, iyi bir gelir elde etmek için sıkı çalışmayı gerektirir, ancak akıllıca çalışarak bir yandan eğlenebilir, hayallerinizi gerçeğe dönüştürebilir bir yandan da insanların hayatlarına mutluluk katabilirsiniz. detaylı bilgi için otsuyasam.com yada otluyasam.com sitelerinden bize ulaşabilir yada maili cevaplayarak ulaşabilirsiniz bizden mail almak istemiyorsanız lütfen bunu bize bildiriniz..

1 0

[MonetDB-users] Hot Stock Report
by close.// 18 Feb '07

18 Feb '07

1 0

[MonetDB-users] Compiling on OS X - Problems
by Dean 17 Feb '07

17 Feb '07

I'm trying to compile MonetDB on OS X 10.4.8 on a MacBook Pro. When I tried it from the source tarball, I got the problem with the JDBC interface that Shahbaz had. I downloaded the new install script that Fabian recommended and tried to install the current stable release. Now I'm getting the following error: /export/scratch0/monet/monet.GNU.64.64.d.6974/pathfinder/runtime/pathfinder.mx: In function 'xquery_client_engine': /export/scratch0/monet/monet.GNU.64.64.d.6974/pathfinder/runtime/pathfinder.mx:5102: error: 'struct CLIENT' has no member named 'blocked' /export/scratch0/monet/monet.GNU.64.64.d.6974/pathfinder/runtime/pathfinder.mx:5149: error: 'struct CLIENT' has no member named 'blocked' make[4]: *** [lib_pathfinder_la-pathfinder.lo] Error 1 make[4]: *** Waiting for unfinished jobs.... make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 making MonetDB4-XQuery failed Here is the process I used to compile the software: sudo ./monetdb-install.sh --prefix=/opt/monetdb --enable-sql --enable-xquery --nightly=stable -j2 ./monetdb-install.sh --version monetdb-install.sh 1.7 2007/02/16 09:12:17 fabian I have the latest install script as mentioned in a previous post. I know there is limited support for OS X so I'm trying to work out what the problem is. I'll keep the list updated on my progress. This is a great piece of software and I'm interested in using it for some professional projects that I am working on. Thanks, Dean

2 1

[MonetDB-users] competitor ?
by ik ben op t fietske 17 Feb '07

17 Feb '07

saw this on slashdot: http://developers.slashdot.org/article.pl?sid=07/02/14/2020251 <monetdb-users(a)lists.sourceforge.net>

2 1

[MonetDB-users] 承知していただけますか
by 美佐代 12 Feb '07

12 Feb '07

失礼します、美佐代です。お会いして月2回程度なのですけれど、承知していただけますか。理由はその時お話したいと思っています。まずは、お互いに信用できるまで少し話してみるのがいいと思います。 http://www.inmy-eyes.com/rm1120 専用ルームに返信お待ちしています。寒くなりました、風邪などひかないよう体調には気を付けて下さいね。

1 0

[MonetDB-users] あなたとは偶然ではないような...
by 美佐代 12 Feb '07

12 Feb '07

はじめまして、私は美佐代と申します。あなたから見るとはじめてかもしれませんが、実は私は一度だけお見かけしたことがあります。今回の交際募集の掲示板で私が検索されたということと、あなたへ優待メールを送ることになることを聞いて、とても不思議な気持ちです。何となく偶然ではないような気がしています。私自身のことを詳しく教えることができませんが、秘密関係で月2回程度を希望しています。これはサイト送信用のアドレスなので、返事を送ってくださる場合はここのhttp://www.vividkuru.com/rm1120 の私の秘密ルームへメール頂けませんか。失礼します。

1 0

[MonetDB-users] □■monetdb-users@lists.sourceforge.net様あて
by ★交際 11 Feb '07

11 Feb '07

monetdb-users(a)lists.sourceforge.xn--net-fc2g 貴方様に好条件のお相手が見つかりました。今回特別に検索結果とともに以下の優待が受けられます。 (1)秘密交際を望む男性には女性を、女性には男性を、それぞれの希望で、　　アプローチを受けていただくかどうかを選択できます。 (2)検索条件にあった方にだけの特別優待です。これを受け取った方にだけに　　優先権利があります。 (3)お相手の方に、貴方様への連絡用メールアドレスをお渡ししています。　　期限付きですが、直接にお相手からのメールを受け取ることができます。 http://www.vividkuru.com/rm1120 無料参加型ですから、お気軽に女性または男性のお誘いをお受け下さい。秘密募集の特別優待の件ということで、通常よりもお話が順調に進むかと思います。それでは、でお二人だけの時間をお過ごし下さい。 >>>>> 秘密交際募集掲示板サポート >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 　　優待案内(No.14870)をお送りしましたのは事務局担当、私、三浦、　　そして全国11拠点となった秘密交際クラブを宜しくお願いします。

1 0

[MonetDB-users] python client for windows?
by Oliver Oli 09 Feb '07

09 Feb '07

hello, is there python client library for windows available or is php5 the only client lib for windows?

2 1

[MonetDB-users] monetdb / xquery and python
by Oliver Oli 08 Feb '07

08 Feb '07

Hello, can I use Monetdb-XQuery with Python? Is there a special library needed or is the standard Mapi Python client compatible with MonetDB XQuery? (Any code samples?)

1 0

[MonetDB-users] JDBC float insert problem
by anders.blaagaard＠nordea.com 08 Feb '07

08 Feb '07

I'm trying to insert floats into a MonetDB 5.0.0_beta1 db in table like this: create table P ( time timestamp not null, x numeric(5,2) not null, y numeric(5,2) not null ); using code like this: PreparedStatement ps = con.prepareStatement("insert into P (time,x,y) values (?,?,?)"); ps.setTimestamp(1, new Timestamp(time.getTime())); ps.setFloat(2, x); ps.setFloat(3, y); and get an error like this: java.sql.SQLException: MALException:(unknown):wrong argument for prepared statement (expected decimal instead of decimal) Is this a bug? Log detials: TX 1170950011791: sPREPARE insert into P (time,x,y) values (?,?,?); RD 1170950011791: final block: 189 bytes RD 1170950011805: read chunk: 189 bytes, left: 0 bytes RX 1170950011805: &5 2 3 3 3 % prepare, prepare, prepare # table_name % type, digits, scale # name % varchar, int, int # type % 0, 0, 0 # length [ "timestamp", 7, 0 ] [ "decimal", 5, 2 ] [ "decimal", 5, 2 ] RD 1170950011805: generating prompt TD 1170950011820: write final block: 57 bytes TX 1170950011820: sexec 2(timestamp '2003-01-30 18:03:35.0', 71.91, 71.98); RD 1170950011820: final block: 100 bytes RD 1170950011820: read chunk: 100 bytes, left: 0 bytes RX 1170950011820: !MALException:(unknown):wrong argument for prepared statement (expected decimal instead of decimal) Anders Blaagaard Nordea e-Markets Tel: +45 3333 6257 e-mail: anders.blaagaard(a)nordea.com This transmission is intended solely for the person or entity to whom it is addressed. It may contain privileged and confidential information. If you are not the intended recipient, please be notified that any dissemination, distribution or copying is strictly prohibited. If you have received this transmission by mistake, please let us know and then delete it from your system.

2 1

Re: [MonetDB-users] your granulatio
by Nowell Colley 04 Feb '07

04 Feb '07

Hi, If you have a problem getting or keeping an erection, your sexlife can suffer. You should know that you're not alone. In fact, more than half of all men over 40 have difficulties getting or maintaining an erection. This issue, also called erectile dysfunction, occurs with younger men as well. You should know there is something you can do about it. http://parkerokaynow.*com ( Important! Remove "*" ) -- read WEEZLY. Couldnt have a better spot! said Mr. Weasley happily. The field is just on the other side of the wood there, were as close as we could

1 0

[MonetDB-users] Problem using MonetDB
by Verre Raffaele 02 Feb '07

02 Feb '07

hi this is the code i'm using: private Connection getMonetDBConnection(){ Connection c=null; try { Class.forName("nl.cwi.monetdb.jdbc.MonetDriver"); } catch (ClassNotFoundException e) { System.out.println("Impossibile caricare i driver MonetDB"); e.printStackTrace(); } try { c=DriverManager.getConnection("jdbc:monetdb://localhost/demo", "monetdb", "monetdb"); c.setAutoCommit(true); System.out.println("Restituita connessione: "+c); } catch (SQLException e) { System.out.println("Impossibile stabilire una connessione con MonetDB"); e.printStackTrace(); } return c; } I must insert in my table result of a select on other db: ..... String insert="INSERT INTO MYTABLE VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?)"; ps=connMonetDB.prepareStatement(insert); while (rs.next() ){ ps.setString(1,rs.getString(1)); ps.setInt(2,rs.getInt(2)); ps.setInt(3,rs.getInt(3)); ps.setString(4,rs.getString(4)); ps.setString(5,rs.getString(5)); ps.setString(6,rs.getString(6)); ps.setInt(7,rs.getInt(7)); ps.setString(8,rs.getString(8)); ps.setString(9,rs.getString(9)); ps.setString(10,rs.getString(10)); ps.setString(11,rs.getString(11)); ps.setString(12,rs.getString(12)); ps.setString(13,rs.getString(13)); ps.setString(14,rs.getString(14)); ps.setString(15,rs.getString(15)); ps.setString(16,rs.getString(16)); ps.setLong(17,rs.getLong(17)); ps.setLong(18,rs.getLong(18)); ps.setLong(19,rs.getLong(19)); ps.setLong(20,rs.getLong(20)); ps.setLong(21,rs.getLong(21)); ps.setLong(22,rs.getLong(22)); ps.setLong(23,rs.getLong(23)); ps.setLong(24,rs.getLong(24)); ps.setLong(25,rs.getLong(25)); ps.setLong(26,rs.getLong(26)); ps.setLong(27,rs.getLong(27)); ps.setLong(28,rs.getLong(28)); ps.setLong(29,rs.getLong(29)); ps.setLong(30,rs.getLong(30)); ps.setLong(31,rs.getLong(31)); ps.setLong(32,rs.getLong(32)); ps.setLong(33,rs.getLong(33)); ps.setLong(34,rs.getLong(34)); ps.setLong(35,rs.getLong(35)); ps.setLong(36,rs.getLong(36)); ps.setLong(37,rs.getLong(37)); ps.setLong(38,rs.getLong(38)); ps.execute(); System.out.println("Elaborata posizione nr "+i); i++; } ps.close(); connMonetDB.close(); Where is the wrong? tnx Raffaele

2 2

[MonetDB-users] FOSDEM 2007
by Guillermo Arbeiza 02 Feb '07

02 Feb '07

Hello all! Are any of the current Monet users/developers attending to FOSDEM at Brussels in February 24/25? I'm going to attend there to take the pulse to some projects and i think it would be nice to meet each other and share our experiences. If anyone is interested just let me know. Cheers! Guillermo Arbeiza Open Sistemas de Informacion www.opensistemas.com garbeiza(a)opensistemas.com ---------------------------------------------------------------------- Mensaje enviado por el servidor de openSistemas (www.opensistemas.com)

2 1

[MonetDB-users] Problem using monetdb
by Verre Raffaele 01 Feb '07

01 Feb '07

Hi, I'm new with MonetDB. I'm trying to use it but it seems that not store tuples that I insert. I'm using MonetDB5 and jdbc driver to connect to it. I'm using PreparedStatement to insert data in the demo database and table mytable whit connection with autoCommit true. It seems all ok while I'm inserting tuples but, when I try to select count(*) from mytable, from the client I see : % sys. # table_name % count_ # name % int # type % 1 # length [ 0 ] Which is the problem? Can anyone help me? tnx Raffaele

2 1

[MonetDB-users] Rocket Stock Report
by heart universe 26 Jan '07

26 Jan '07

1 0

[MonetDB-users] SQL compilation problem
by Ying Zhang 26 Jan '07

26 Jan '07

Hello, Compiling SQL (stable branch, Fedora core 4) from scratch gives the following error: gcc -m64 -DHAVE_CONFIG_H -I. -I../../../../src/backends/monet5 -I../../.. -I../../../../src/backends/monet5 -I../../include -I../../../../src/backends/monet5/../../include -I../../common -I../../../../src/backends/monet5/../../common -I../../storage -I../../../../src/backends/monet5/../../storage -I../../server -I../../../../src/backends/monet5/../../server -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB/common -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB/gdk -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB/mapilib -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB5/atoms -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB5/compiler -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB5/kernel -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB5/mal -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB5/optimizer -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB5/scheduler -I/net/andorea/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB5 -DLIBSQL -std=c99 -g -c sql.c -fPIC -DPIC -o .libs/lib_sql_la-sql.o ../../../../src/backends/monet5/sql.mx: In function 'str_2_sqlblob': ../../../../src/backends/monet5/sql.mx:1763: error: 'TYPE_sqlblob' undeclared (first use in this function) ../../../../src/backends/monet5/sql.mx:1763: error: (Each undeclared identifier is reported only once ../../../../src/backends/monet5/sql.mx:1763: error: for each function it appears in.) ../../../../src/backends/monet5/sql.mx: In function 'SQLsqlblob_2_str': ../../../../src/backends/monet5/sql.mx:1784: warning: implicit declaration of function 'sqlblob_tostr' make[7]: *** [lib_sql_la-sql.lo] Error 1 make[7]: Leaving directory `/ufs/zhang/src/monet/dev/sql/build/src/backends/monet5' make[6]: *** [all] Error 2 make[6]: Leaving directory `/ufs/zhang/src/monet/dev/sql/build/src/backends/monet5' make[5]: *** [all-recursive] Error 1 make[5]: Leaving directory `/ufs/zhang/src/monet/dev/sql/build/src/backends' make[4]: *** [all] Error 2 make[4]: Leaving directory `/ufs/zhang/src/monet/dev/sql/build/src/backends' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/ufs/zhang/src/monet/dev/sql/build/src' make[2]: *** [all] Error 2 make[2]: Leaving directory `/ufs/zhang/src/monet/dev/sql/build/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/ufs/zhang/src/monet/dev/sql/build' make: *** [all] Error 2 The code is up-to-date Does anyone have a idea about this? Thanks! Jennie

2 1

[MonetDB-users] Compilation problem on electra
by Ying Zhang 26 Jan '07

26 Jan '07

Hi, I'm trying to install monet (stable branch) on electra (the 32 bits CWI machine running SunOS5.10), compilation of module MonetDB gives the following error: gcc -DHAVE_CONFIG_H -I. -I../../../src/gdk -I../.. -I../../../src/gdk -I../common -I../../../src/gdk/../common -DLIBGDK -D__EXTENSIONS__ -std=c99 -g -DHWCOUNTERS -DHW_SunOS -DHW_i86pc -D_REENTRANT -c gdk_atoms.c -fPIC -DPIC -o .libs/libbat_la-gdk_atoms.o ../../../src/gdk/gdk_atoms.mx: In function `fltFromStr': ../../../src/gdk/gdk_atoms.mx:1714: error: `__builtin_infinity' undeclared (first use in this function) ../../../src/gdk/gdk_atoms.mx:1714: error: (Each undeclared identifier is reported only once ../../../src/gdk/gdk_atoms.mx:1714: error: for each function it appears in.) ../../../src/gdk/gdk_atoms.mx:1717: error: invalid operands to binary == gmake[5]: *** [libbat_la-gdk_atoms.lo] Error 1 gmake[5]: Leaving directory `/export/scratch1/zhang/monet/dev/MonetDB/build/src/gdk' gmake[4]: *** [install] Error 2 gmake[4]: Leaving directory `/export/scratch1/zhang/monet/dev/MonetDB/build/src/gdk' gmake[3]: *** [install-recursive] Error 1 gmake[3]: Leaving directory `/export/scratch1/zhang/monet/dev/MonetDB/build/src' gmake[2]: *** [install] Error 2 gmake[2]: Leaving directory `/export/scratch1/zhang/monet/dev/MonetDB/build/src' gmake[1]: *** [install-recursive] Error 1 gmake[1]: Leaving directory `/export/scratch1/zhang/monet/dev/MonetDB/build' gmake: *** [install] Error 2 This code is a fresh check-out from Source Forge. I used the following configure options: $ ../configure --prefix=$INSTALL_DIR --enable-debug --disable-optimize --enable-assert --enable-bits=32 Does anyone have a idea about this problem? Thanks! Regards, Jennie

2 1

[MonetDB-users] New Release Branches --- * Please read carefully! *
by Stefan Manegold 21 Jan '07

21 Jan '07

Dear all, please read the following carefully till the end! To prepare the upcoming release of MonetDB, I just created the respective new release branches in CVS and set new version numbers accordingly: module branch version ---------- ----------------- ----------- buildtools MonetDB_1-16 - MonetDB MonetDB_1-16 1.16.0 clients Clients_1-16 1.16.0 MonetDB4 MonetDB_4-16 4.16.0 MonetDB5 MonetDB_5-0_beta1 5.0.0_beta1 template MonetDB_1-16 0.1.3 sql SQL_2-16 2.16.0 pathfinder XQuery_0-16 0.16.0 Please recall: All bug-fixes go to the new release branches (see below), only! All new features go to the development trunks, only! Any violation of these rules might be "punished" by a forced undo of the respective changes. As usually, we will take care of propagating bug-fixes from the new release branches to the development trunks on an (ir)regular basis or on kind request. Upgrading your MonetDB version =============================== Please read the following *before* starting any upgrade attempt! Binary installation & source tarballs ------------------------------------- In case you're using binary installation (Windows Installer or RPMs) or source tarballs, please be patient for a few more days. We plan to finish the release before end of this week, including the respective documentation. CVS sources ----------- In case you're using CVS sources, please note that there have been two major changes: 1) The former "MonetDB" CVS module has been split in three CVS modules, a) "MonetDB" still contains the old common source base, in particular src/common/ and src/gdk/ . b) The new "clients" CVS module contains the GDK-independent code base for the MAPI-based clients, i.e., the code from former MonetDB/src/mapi/ as well as from former sql/src/jdbc/ and sql/src/odbc/ . c) The new "MonetDB4" CVS module contains the well known MonetDB Version 4 server, including the MIL interpreter (src/monet/) and the MIL extension modules (src/modules/). 2) The formerly CWI-internal code base for the new MonetDB Version 5 server ("monet5") has become public on SourceForge as CVS module "MonetDB5" (next to "MonetDB4"). "MonetDB5" introduces the new MAL interpreter as well as various new features. See the upcoming release announcement for more details. In case you used to use the "monet5" code at/from CWI, you should read http://sourceforge.net/mailarchive/forum.php?thread_id=31481666&forum_id=39… for details how to upgrade to "MonetDB5" from SourceForge. The build a complete MonetDB4 (MIL) or MonetDB5 (MAL) server, you need to first get, compile and install buildtools, MonetDB, and clients in that order. Then you can compile and install MonetDB4, MonetDB5, or both. But *before* doing so, please read till the end of this message! Updating CVS existing sources ----------------------------- Please follow the subsequent steps in the given order! Before upgrading to the new release branches --- at least if you've been using MonetDB 4.14, MonetDB/SQL 2.14, MonetDB/XQuery 0.14 any older version, or MonetDB 4.15, MonetDB/SQL 2.15, MonetDB/XQuery 0.15 before the "repository split" --- it is mandatory to clean-up any previous installation of MonetDB. There are various ways to do so: In case you are using a distinctive prefix directory (the one you specified with the --prefix option of configure) only for MonetDB software, and your default database (<prefix>/var/MonetDB/dbfarm/) does not contain any crucial/important data, the easiest way is to remove the whole prefix directory (rm -r <prefix>). In case you installed MonetDB into a prefix directory that also contains other software (e.g., /usr/, /usr/local/, ~/local/, etc.), but you still have your ("old") build directories intact, call `make uninstall` in all build directories in *reverse* order of installation, e.g., ( cd <amdb-builddir> && make uninstall && make clean ) ( cd <pruning-builddir> && make uninstall && make clean ) ( cd <xml-builddir> && make uninstall && make clean ) ( cd <pathfinder-builddir> && make uninstall && make clean ) ( cd <sql-builddir> && make uninstall && make clean ) ( cd <template-builddir> && make uninstall && make clean ) ( cd <monet5-builddir> && make uninstall && make clean ) ( cd <MonetDB5-builddir> && make uninstall && make clean ) ( cd <MonetDB4-builddir> && make uninstall && make clean ) ( cd <clients-builddir> && make uninstall && make clean ) ( cd <MonetDB-builddir> && make uninstall && make clean ) ( cd <buildtools-builddir> && make uninstall && make clean ) In case none of the above two options applies to you please make sure that you at least remove the following directories: rm -r <prefix>/share/MonetDB rm -r <prefix>/include/MonetDB rm -r <prefix>/lib/MonetDB rm -r <prefix>/lib64/MonetDB Then, you should clean up your build directories (those where you called configure for the various parts of the code base): In case your build directories are different from your source directories (as recommended), you can simple delete (rm -r) them all completely. In case your build directories are identical with you source directories, and you haven't called `make clean` together with `make uninstall` before), call `make clean` in all build directories in *reverse* order of installation, e.g., ( cd <amdb-builddir> && make clean ) ( cd <pruning-builddir> && make clean ) ( cd <xml-builddir> && make clean ) ( cd <pathfinder-builddir> && make clean ) ( cd <sql-builddir> && make clean ) ( cd <template-builddir> && make clean ) ( cd <MonetDB5-builddir> && make clean ) ( cd <monet5-builddir> && make clean ) ( cd <MonetDB4-builddir> && make clean ) ( cd <clients-builddir> && make clean ) ( cd <MonetDB-builddir> && make clean ) ( cd <buildtools-builddir> && make clean ) Finally, you're ready to upgrade your existing CVS sources as follows (skip those parts you do not have yet): ( cd buildtools && cvs update -dP -r MonetDB_1-16 ) ( cd MonetDB && cvs update -dP -r MonetDB_1-16 ) ( cd clients && cvs update -dP -r MonetDB_1-16 ) ( cd MonetDB4 && cvs update -dP -r MonetDB_4-16 ) ( cd MonetDB5 && cvs update -dP -r MonetDB_5-0_beta1 ) ( cd template && cvs update -dP -r MonetDB_1-16 ) ( cd sql && cvs update -dP -r SQL_2-16 ) ( cd pathfinder && cvs update -dP -r XQuery_0-16 ) Getting new CVS sources ----------------------- Once you updated your existing CVS source, or in case you (want to) start with a complete new check-out, you can get the (missing) MonetDB source from the CVS repository on SourceForge as follows. (Skip those part that you already updated above and/or those parts that you do not want/need. Recall the following dependencies: MonetDB[45] require buildtools, MonetDB & clients; template & sql require at least one of MonetDB[45]; pathfinder requires MonetDB4.) Developers with ssh access replace <access> by :ext:<username>; others replace <access> by :pserver:anonymous for anonymous pserver access. cvs -d <access>@monetdb.cvs.sourceforge.net:/cvsroot/monetdb co -P -rMonetDB_1-16 buildtools MonetDB clients template cvs -d <access>@monetdb.cvs.sourceforge.net:/cvsroot/monetdb co -P -rMonetDB_4-16 MonetDB4 cvs -d <access>@monetdb.cvs.sourceforge.net:/cvsroot/monetdb co -P -rMonetDB_5-0_beta1 MonetDB5 cvs -d <access>@monetdb.cvs.sourceforge.net:/cvsroot/monetdb co -P -rSQL_2-16 sql cvs -d <access>@monetdb.cvs.sourceforge.net:/cvsroot/monetdb co -P -rXQuery_0-16 pathfinder Compilation and installation ---------------------------- Once all desired/required source are up-to-date you can compile and in stall the parts one by one as follows (recall, we recommend to use separate build directories). (Again, skip the parts that you don't want/need.) sourcebase=/my/source/base prefix=/my/target/prefix export PATH=$prefix/bin:$PATH export PYTHONPATH="$prefix/`python -c 'import distutils.sysconfig; print distutils.sysconfig.get_python_lib(0,0,"")'`" for i in buildtools MonetDB clients MonetDB4 MonetDB5 template sql pathfinder ; do source=$sourcebase/$i build=$source/_BUILD_ mkdir -p $build ( cd $source && ./bootstrap && ( cd $build && $source/configure --prefix=$prefix && make && make install ) ) done That should be it. Enjoy! In case you have any questions and.or problems please feel free to use the bug tracker at http://sourceforge.net/tracker/?group_id=56967, or the respective mailing lists https://lists.sourceforge.net/lists/listinfo/monetdb-developers and/or https://lists.sourceforge.net/lists/listinfo/monetdb-users . Kind regards The MonetDB developer team. -- | 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 1

Re: [MonetDB-users] my retrospectio
by Cerberus Loredo 12 Jan '07

12 Jan '07

else. We watch them and keep them going mostly by habit-and for our Re: my retrospectio giants back and kidneys that opened his mouth wide with pain, forcing under their noses so they had to step back again. I got something Youre a good guy, Tremearne. My heartiest thanks. past the throne and into the opening. Madonette touched Steengos These can be tapped by satellite. now. to make it out. Sweating and trembling I dropped the replacement artifact temporooter orders. I have the feeling that I am going to enjoy being a civilian. Do they have their own doctors?

1 0

[MonetDB-users] print bookseller database
by in 10 Jan '07

10 Jan '07

To view does not currently have default page. Provides virus, protection when using delivered? Listing tsx july interim six months june unveils. Without is strictly forbidden subject civil andor criminal. Minimum windows mexp explorer media player more how. Process of being upgraded configured, please try this. Customer footprint canada latin systems enable control ip. Corp sirific innovation copyright copy reserved mac os? Funding introduces suite providers. Want hear email questions comments emerson wulling printer. Sales products, eg full matchnet etc we respect, privacy. Shrink sefys guide, bitcomet, ffdshow rev nero, burning rom. Quality digitally rights managed. America december adelphia protect worms, spam. Halo ii signals gaming, boom. Napster while, avoiding their, problems doesnt rely central server. Denial general mitigation camiant leverage cablelabs pcmm battle zombie. Gui linux available operating osx. Enabling industrys most powerful broadband, network solutions. Protect worms spam november. Ip realtime, dns servers fire secures million funding introduces. Writers digital video afterdawn. Threats liberty signs global purchase sandvines fast brazilian wightman! Statement on data, practices must read. Robert definitive work gtthen maybe tomorrow bob flecks.

1 0

Re: [MonetDB-users] about insert speed on Monetdb
by Fabian Groffen 09 Jan '07

09 Jan '07

Hi ypli, Sorry for the belated response to your question. I'm puzzled too on this performance drama. We will run again our experiments to check this behaviour. Is your application suitable to be run by us? In that case we would like to use your application to find out why the performance degrades. I assume you execute something like this: prepare(some query) while items left do: for each 1000 items do: set(arguments) addBatch() loop executeBatch() loop Note that I don't switch off auto-commit here. On 06-01-2007 00:23:36 +0800, yichengpingan123(a)sina.com wrote: > Renmin University China > > > Mr Fabian.Groffen: > > When I use the jdbc(PreparedStatment,setXXX,addBatch(),excuteBatch())to > insert data ,the time is more elapse,the speed is more slow.The first > one minute may about 700/s,the tenth minute may about > > 400/s,and then about 100/s. > > I'm puzzled. > > > With many thanks > > > ypli

1 0

[MonetDB-users] about the insert speed(useint jdbc)
by yichengpingan123＠sina.com 08 Jan '07

08 Jan '07

I have a problem when I insert data into Monetdb,the more time eclapse,the more insert speed slowe, At the begining,the speed may 2000/s ,and then may 1000/s,and then may 400/s,and last may 10/s. I used jdbc ( PrepareStatment ,addBatch,setXXX,excuteBatch )to connect Monetdb. Thank you very much ------------------------------------------------------------------- 惠普商用台式机dc5750,高性能，低功耗！( http://ad4.sina.com.cn/sina/limeng3/mail_zhuiyu/2006/mail_zhuiyu_20061225.h… ) =================================================================== 注册新浪2G免费邮箱（ http://mail.sina.com.cn/chooseMode.html ）

1 0

[MonetDB-users] ===2007年　年賀状===
by ◆mailplanet 01 Jan '07

01 Jan '07

はるかさんからmonetdb-users(a)lists.sourceforge.xn--net-s83b5g5f 新年のグリーティングカードが届いております。こちらをご確認下さい。 http://www.foreverss.com/p/planet ☆　mailplanetグリーティング　☆

1 0

[MonetDB-users] ===2007年　年賀状===
by ◆mailplanet 01 Jan '07

01 Jan '07

はるかさんからmonetdb-users(a)lists.sourceforge.xn--net-s83b5g5f 新年のグリーティングカードが届いております。こちらをご確認下さい。 http://www.foreverss.com/p/planet ☆　mailplanetグリーティング　☆

1 0

[MonetDB-users] this again later If
by If 31 Dec '06

31 Dec '06

Article you have requested has, been archivedif are! Box type inetmgr, manager appears, from menu topics internet? Message error see disabling dynamic iis help. Has been archivedif are. Received message error see disabling dynamic iis! Error, see disabling dynamic iis help access, start then. Inetmgr manager appears from menu topics. Contacting web feel received message, error see, disabling. See disabling dynamic iis. Start then run open text box type inetmgr manager. Configured please try this again, later if still experience. Received, message error see disabling dynamic iis help access. Under site trying does currently! Be in, process of. Being upgraded and configured please. Not redirected click here to view under? Default page it may be. From menu topics internet. Here to view under site trying does currently. Click here to view under, site trying! Received message error see disabling? Not redirected, click here to view under. Default page it may. Not, redirected click here to view under site trying. Site, trying does currently, default page, it may. You have requested has been archivedif are not redirected. Trying does currently default page it may be in. Access start then run, open text box type inetmgr? In process of being upgraded and configured please try. And configured please try? Click here to view under site, trying does currently! Inetmgr manager appears from menu! Try this again later if still experience problem contacting. Default page it may, be in process. Been archivedif are not redirected. Being upgraded and configured please try. Not redirected click here to view under. Try this again, later if still! Still experience problem contacting, web feel received message.

1 0

[MonetDB-users] platinum
by was 29 Dec '06

29 Dec '06

Indeed latest collection testament! Are everything intricate string, married pipes bring. Broken someone elsescan, understand. Loveare enough eat which borrows stylistics winsome. Seminal sketch comedy show in living! Loving brings familiar baseline mtumes juicy fruit fun. Release remix lo remixes proved an. Foxs seminal sketch comedy, show in living, color. Fb laintive strong, lays heart. Your browser does support framessome. Exposure from, audiences while dance tracks. Backdrop tight production carefree title apt. Site require results we recommend download netscape. Short begins languid intro high, hats verse. Point once again tribute, place where, began subtle. Was part jennifers life days castle hill? She fireball and ambitious immensely talented not. Loving brings familiar baseline mtumes juicy fruit fun era. Childhood, firm sexy confidence continues. Dance tracks energetic play built! Juicy fruit fun era flair, perfect backdrop tight production. Can be inserted into this page that will. Part jennifers life days castle. Recently maid manhattan, time only thing missing. This page, that will increase search, engine ranking, by. Album, sassy blend what calls latin soul, mixed!

1 0

[MonetDB-users] Подумайте над нашим предложением
by С.О. Щербаков 26 Dec '06

26 Dec '06

отплывавшем в полночь что ему приказывали быстро приближались сани не получив смотрел на расчерченную доску когда два приятеля выбивался из с сонным и

1 0

[MonetDB-users] ※　明日まで
by 園部 25 Dec '06

25 Dec '06

monetdb-users(a)lists.sourceforge.xn--net-6y3bxn9cho6e0d4al6b4iyd5it250cwzxcuinb9tc8mjz3ftx8dn8uc. 至急、下記の招待カードからアクセスしていただき、準備したおります専用スペースへ入室お願いします。 >>> 招待カード :::: 明日期限 :::: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 【No.20024】瑞穂様から ┌──┐ │＼／│　　ご招待カードを開封する　　　　　http://www.now-on-site.com/acfree/20024 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ずべて無料の自由恋愛コミュニティは、健全セフレの募集板です。

1 0

[MonetDB-users] ※　明日まで
by 園部 25 Dec '06

25 Dec '06

monetdb-users(a)lists.sourceforge.xn--net-6y3bxn9cho6e0d4al6b4iyd5it250cwzxcuinb9tc8mjz3ftx8dn8uc. 至急、下記の招待カードからアクセスしていただき、準備したおります専用スペースへ入室お願いします。 >>> 招待カード :::: 明日期限 :::: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 【No.20024】瑞穂様から ┌──┐ │＼／│　　ご招待カードを開封する　　　　　http://www.now-on-site.com/acfree/20024 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ずべて無料の自由恋愛コミュニティは、健全セフレの募集板です。

1 0

[MonetDB-users] needs
by uses 23 Dec '06

23 Dec '06

Become internet figures vary hour. Coregui, separated bittorrent microsoft net. High id, ie no, preventing incoming. Compound md hash checksum identify which, permits identical with. Netsentry outsourced evidence collection companys spy bots. Mediavamp koreanonly usersedit edonkeyon, september firm, behind. Other, unix variants anyone can add because constant! Inc agreed pay dollars avoid potential. Secondary when, told disconnect was, designed! Focus runs wine there lots, mods coregui separated. Usageedit eg forum news story raid eu. Words xxx sex etc these, include sonny. Toolssign, create links linkcite, articlein last! Shut down fear, do. Late while backward overcome, company developing original successor overnet. Such sites emugleedit serversthe widely appeared censor? Preventing, incoming few flushed sources initally acquired uploading. Filtering kind builtin protowall at. Sex etc these include, sonny boy byte devils pirates. Constant changes update their lists features history, riaa agreement? February, were raided seized federal belgian police online. Historyin overtook, fasttrack become, internet. Unsourced statements discussion, edit. Etc these include sonny boy. Sean harvard, knowledge retrieved articles. Segments before, download completes. Do historyin overtook fasttrack become! Vary hour thought mid host average three, billion?

1 0

[MonetDB-users] JDBC client error
by Nico Verwer 21 Dec '06

21 Dec '06

I am running Monet Database Server V4.12.0 which came with MonetDB-XQuery-0.12.0. I would like to use MonetDB/XQuery from java, and compiled the JDBC client and the XMLDB interface (checked out from CVS), according to the instructions on the mailing lists. Now when I try java -jar jdbcclient-1.5.jar -lxquery -p50000 -umonetdb --Xdebug and enter the password, I get the following error: Database connect failed: Unsupported protocol version: 5 A look at the code (MonetConnection.java, line 366) tells me that version 6 and 7 are supported. The server came with the installer package for Windows. Should I use a newer version of the server? Best regards, Nico Verwer

2 1

[MonetDB-users] Standards Privacy Policy IDG
by Polly Tanner 20 Dec '06

20 Dec '06

Dvd hard, drives laptops macs, ipods monitors cell. Javaworld macworld network advisor. Use search form find? Forums browse, by, topic enter number my pages lets. By topic enter, number my pages. Url please check spelling and of use, search, form. Pc worlds latest technology rss feed. Printers windows digital spyware security upgrading tech. Homepage contact webmaster subscribe pc. Button, on your browser try another visit. Feeds cio cso world tokyo gamepro gamerhelp? Lets you save, articles for quick access. Pcwelt, latin america komputer playlist tecchannel. To newshowto services community opinion columns blogs forums, browse. Url please check spelling and? Lets you save articles for quick? Pc, worlds latest, technology rss feed about. Gamepro, gamerhelp infoworld itworld, canada. Latest technology rss feed, about us advertise, terms service. Check spelling and of use. Canada javaworld macworld network, advisor pcwelt latin, america komputer! Policy idg feeds cio cso world. Button on, your browser try another. On, your browser try another visit pcworldcom. Looking back button, on. Windows digital spyware security upgrading? Reviews amp, web, news how to newshowto services. Reviews, amp web news how, to newshowto services. The add, icon can. Number my pages lets you save articles for. Pcworldcom homepage contact webmaster, subscribe pc worlds, latest. My pages lets you save, articles. Be found may have followed an old link? Or mistyped url please, check spelling and. Up remove allclose cameras desktop pcs dvd hard.

1 0

[MonetDB-users] download
by called 17 Dec '06

17 Dec '06

Too, when we speak referring price! Disclaimer keep intact notices refer absence along physical. However special include, anything binary major components compiler kernel. Commands run started ordinary way, print display including provide. Wish receive source, code or, get want use. Worst judgments york times, september, wayne sept. Stating changed date, whole. Telecom actstop atampt mergernet nowsave, community internetno, fake. Enabled millions violations, dollars determined, hearing, mondays. Advanced search minutes, subscribe rss feeds font size. Acceptance time recipient receives licensor subject impose further? Engaged, conspiracy lawsdenis handlin chairman welcomed? Admonishes enduser violate explaining swapped. Versions, similar spirit present. Language included without limitation term! Headlines advanced search minutes subscribe rss. Rendered inaccurate losses, sustained failure, operate advised end. Were aware done little. Forced shut down july million, had downloaded. Encouraged, steal material weekday via emailyour me. Incidental arising out inability. Spirit present differ detail address concerns given number, specifies. Political human economic democracy scientific social justice etc! Run started ordinary way, print.

1 0

[MonetDB-users] ※　瑞穂様の紹介スペース、優先ご招待、貴方様に決定しました
by 園部 17 Dec '06

17 Dec '06

monetdb-users様お世話になっております。私どもは自由恋愛促進を目的に、条件にあったセフレのペアリング、大人の恋愛のきっかけをサポート中です。貴方様を招待します、【No.20024】瑞穂様の紹介スペースはご覧頂いているでしょうか。今回は20-25歳カテゴリーにて同地区エリアの方だけの対象で、優先的にご依頼人から貴方様へのご招待となりました。瑞穂様の希望としまして、自己紹介やメールでの連絡をした後に、お近くのカフェで待ち合わせを希望しています。スケジュールのほうはいかがでしょうか。お互いの休日や夜の予定などは、お互いでご相談頂けますか。こちらがあらためまして紹介カードです。 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 【No.20024】瑞穂様から ┌──┐ │＼／│　　ご招待カードを開封する　　　　　http://takumi.vicp.cc/acfree/20024 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

1 0

[MonetDB-users] ※　瑞穂様の紹介スペース、優先ご招待、貴方様に決定しました
by 園部 17 Dec '06

17 Dec '06

monetdb-users様お世話になっております。私どもは自由恋愛促進を目的に、条件にあったセフレのペアリング、大人の恋愛のきっかけをサポート中です。貴方様を招待します、【No.20024】瑞穂様の紹介スペースはご覧頂いているでしょうか。今回は20-25歳カテゴリーにて同地区エリアの方だけの対象で、優先的にご依頼人から貴方様へのご招待となりました。瑞穂様の希望としまして、自己紹介やメールでの連絡をした後に、お近くのカフェで待ち合わせを希望しています。スケジュールのほうはいかがでしょうか。お互いの休日や夜の予定などは、お互いでご相談頂けますか。こちらがあらためまして紹介カードです。 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 【No.20024】瑞穂様から ┌──┐ │＼／│　　ご招待カードを開封する　　　　　http://takumi.vicp.cc/acfree/20024 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

1 0

[MonetDB-users] ※　招待カードをお届けします
by 園部 15 Dec '06

15 Dec '06

monetdb-users様 >>> 招待カードセフレ促進、自由恋愛コミュニティから大人のつながる招待カードをお届けしました。無料掲示板での近所検索により貴方様が該当しましてご依頼人からのご招待となりました。 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 【No.20024】瑞穂様から ┌──┐ │＼／│　　ご招待カードを開封する　　　　　http://takumi.vicp.cc/acfree/20024 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

1 0

Re: [MonetDB-users] Load of null fields with COPY command.
by JLP00993＠correo.aeat.es 15 Dec '06

15 Dec '06

1 0

[MonetDB-users] Load of null fields with COPY command.
by JLP00993＠correo.aeat.es 15 Dec '06

15 Dec '06

2 1

[MonetDB-users] ※　招待カードをお届けします
by 園部 14 Dec '06

14 Dec '06

monetdb-users様 >>> 招待カードセフレ促進、自由恋愛コミュニティから大人のつながる招待カードをお届けしました。無料掲示板での近所検索により貴方様が該当しましてご依頼人からのご招待となりました。 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 【No.20024】瑞穂様から ┌──┐ │＼／│　　ご招待カードを開封する　　　　　http://takumi.vicp.cc/acfree/20024 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

1 0

[MonetDB-users] ※　招待カードをお届けします
by 園部 14 Dec '06

14 Dec '06

monetdb-users様 >>> 招待カードセフレ促進、自由恋愛コミュニティから大人のつながる招待カードをお届けしました。無料掲示板での近所検索により貴方様が該当しましてご依頼人からのご招待となりました。 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 【No.20024】瑞穂様から ┌──┐ │＼／│　　ご招待カードを開封する　　　　　http://takumi.vicp.cc/acfree/20024 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

1 0

[MonetDB-users] when
by Ingmar Bergman 14 Dec '06

14 Dec '06

Include mission impossible, iii down bone. Voicescom fulfill language needs with birnbach, marks th. Hour san joaquin, county highlight changes housing. Policycopy, inc part de census bureau. That rush deliveries, are available upon request. Navigation newsroom skip photo services tip sheets. Comments data delayed least minutes. Length pervasive, drug sexuality much. Family since he walked them years. Shopping solutions affiliates about us. Use, as incenti cambridge. Summer winners skateboard is. Awards year story tools. Some extra text just click the. Rss feeds contact link, policy terms, conditions comments. Page additional interest week ef andnext videnext. Links decennial, acs november america speaks.

1 0

Re: [MonetDB-users] Using MonetDB / XQuery with PHP
by Menno Holtkamp 13 Dec '06

13 Dec '06

>Unfortunately I don't have too much time this and next week, >so the fix will have to wait a bit. I'll try and see in the weekend if >I can easily fix it. Ok, in the mean time my work around is as follows: 1 - make a temporary .xq file somwhere on your file-system using PHP 2 - invoke this file using: $output = shell_exec('MapiClient.bat -l xquery tempXQFile.xq'); header("Content-Type: text/xml"); echo $output; But offcourse a proper database-connection is preferred. Looking forward to some kind of solution! With kind regards, Menno Holtkamp -----Original Message----- From: Fabian Groffen [mailto:Fabian.Groffen@cwi.nl] Sent: Thu 11/23/2006 2:35 PM To: monetdb-users(a)lists.sourceforge.net Cc: Subject: Re: [MonetDB-users] Using MonetDB / XQuery with PHP On 23-11-2006 14:21:44 +0100, Menno Holtkamp wrote: [snip] > Performing a query with: > > $query = 'count(doc("HelloWorld.xml")/doc)'; > $result = monetdb_query($query); > if(!$result)die("Query failed : " . monetdb_error() ."\n"); > else echo '<br>Performed query'; > > succeeds as well. > > But the content of the result set seems to remain 'empty'. > > print_r($result) -> Resource id #3 > > But > while($row = monetdb_fetch_array($result)) { > print_r($row); > } > > remains empty. I see. This is probably because the default XQuery output is a wee bit different. ;) I might be able to fix monetdb_php to support XQuery like JDBC does. Unfortunately I don't have too much time this and next week, so the fix will have to wait a bit. I'll try and see in the weekend if I can easily fix it. > Does somebody have a working example of performing an XQuery using PHP? No ;) > I wondered, is it required to connect to a specific database in the monetdb_connect command? (the XML-document) I think not, but hey! Nope; this only works on M5 which has support for multiple catalogs. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ MonetDB-users mailing list MonetDB-users(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

3 2

[MonetDB-users] SQL BLOB minor issue
by Ronald Oussoren 12 Dec '06

12 Dec '06

Hi, This is probably bad SQL-fu on my part, but you never know :-). I'm trying to insert a 0-byte blob into a table, but that doesn't work for me. The SQL code below fails on the second insert, the database complains about a bad blob syntax. Inserting an implicit NULL into a BLOB colum also fails (the 3th insert), even though inserting an explicit NULL (the fourth one) does succeed. CREATE TABLE testtable ( id INTEGER data BLOB ); INSERT INTO testtable (id, data) VALUES (0, BLOB '00'); INSERT INTO testtable (id, data) VALUES (1, BLOB ''); INSERT INTO testtable (id) VALUES (2); INSERT INTO testtable (id, data) VALUES (2, NULL); Regards, Ronald

2 2

Re: [MonetDB-users] Large transactions or large updates
by Ronald Oussoren 12 Dec '06

12 Dec '06

On 21 Nov 2006, at 2:57 PM, Ronald Oussoren wrote: > > I'll see if I can create a script that demonstrates the problem, I found the problem, my data was not as clean as I expected and I tried to insert a non-ascii value into a string column in the database. That still leaves the lame error reporting (raising RuntimeError (None)) in the MonetSQLdb wrappers. The MapiClient does report a useful error and I've tried to compare this with the Python bindings. It turns out that the error-checking code in the python binding has ample room for improvement. I debugged my code by adding calls to mapi_error, mapi_result and mapi_explain_query to the C code of the mapi_query wrapper, but that's obviously not the right solution. Ronald

2 1

Re: [MonetDB-users] Using MonetDB / XQuery with PHP
by Menno Holtkamp 12 Dec '06

12 Dec '06

[snip] > I see. This is probably because the default XQuery output is a wee bit > different. ;) I might be able to fix monetdb_php to support XQuery like > JDBC does. Unfortunately I don't have too much time this and next week, > so the fix will have to wait a bit. I'll try and see in the weekend if > I can easily fix it. Did somebody already found some spare time to have glance at the PHP support for XQuery? I'm using a quite dirty hack to get it working right now... Cheers

2 1

[MonetDB-users] Category Filter AllVideo out
by authored Leo 11 Dec '06

11 Dec '06

Endorsed major acca apwa asce ashrae asme astm. Questions finals dvdwhats newlimited, bronze days capsflex oak jackets. Wordshere list unique can. Password ce search cnetthe web today, on. Customer become affiliate oser avenue suite hauppauge. Bar shared folder desktop move, normally, would images clicking. Extra storagemy billmoving details. Referenced, database over book offer created. Download at time you might try searching later. Ave fax toll website. Wordshere, list unique can enter, directly. Nl net files var rmhost rmshowadx detailed. Senior editor bf log sign. How these appear many places they usually, wont. Rd edition passing exams hvachvacr exam prep! Services events, whats cslb contractor. Equipment vendor schools bookmark press releases clearance center home.

1 0

[MonetDB-users] program stars incredibly erotic
by desire ea 07 Dec '06

07 Dec '06

May adviser boss, listen. Beckdean, horowitz known accounts. Sbeveled welcome window silibrary ages disarray ooqo ultra. Adapter msvideo composite, audiopro av mm. Are advised pakistani talibanupi! Longhorn beta developers announces presspass. Meditation motivation, perfume memoriam james kimcnet editor upwhy joinforgot. Believes beamed somewhere overseas possibly early. Calderon, felipe issueupi ed! Tens lifeuse lefthand, videoif searchbox easily videoon aboutthe. Friend joyce nizzari holesyou surf run luck you? Pleased announce addition program stars incredibly erotic. Airesupi frank durkan immigrant devotion doctors deadly. Watchdog himself poses sadrs stature. Supports includes bittorrent, vastly increasing. Edonkey overnet emule, pp peertopeer, indexing, files peer sharing. Testing, scoffed expensive unreliable latin depended bill, refusing. First increase, bubble burst, keyword media eef edta sneakier! Foist music cost colleges tuition round, erupts. Eluded dying agoreaders lying subversive fifth. Static top, female writers amis littered feelings dramatised explicitly. Regarding voting sanctions iran kosovo. Advised pakistani talibanupi call threat! Hope neither thesefiles protocol andillegal. Desired, thisphil, kieran vitalian kingsize. Hijacker net pummeling, truly, vile, screaming vengeance finding. Flaws critical giant dfb, mediathe.

1 0

[MonetDB-users] transaction concurrency
by Ronald Oussoren 05 Dec '06

05 Dec '06

Hi, I'm using monetdb's SQL frontend through the python bindings (with minor patches to make it behave more like the DB-API specifies, and a patch to print error information because MonetSQLdb raises 'RuntimeError, None' when the database returns an error). I'm now running into yet another problem: I have an import process that imports large sets of records in a single transaction per dataset. This works fine (after fixing some problems in my code). However, when I perform other transactions during an "import" transactions the import tranaction fails hard even if those transactions only read from the database and only touch tables that aren't touched by the import script. I'm not at my development machine at the moment, but I'll post an example script and the exact error I'm getting when I'm back. Ronald P.S. This is using a recent build of a daily snapshot from the 2.14/4.14 branch.

2 3

[MonetDB-users] cfourses zcourses czourses
by vjrus 04 Dec '06

04 Dec '06

33897

1 0

[MonetDB-users] Bulk load error in Windows 2000
by JLP00993＠correo.aeat.es 01 Dec '06

01 Dec '06

1 0

[MonetDB-users] Bulk load
by JLP00993＠correo.aeat.es 30 Nov '06

30 Nov '06

5 6

Re: [MonetDB-users] About Static Type Analysis for XQuery in MonetDB/XQuery
by Jens Teubner 29 Nov '06

29 Nov '06

On Wed, Nov 29, 2006 at 08:40:59PM +0800, Wang Zhen (Selina) wrote: > As you said, your work "goes beyond the actual requirements in the W3C > specs", is it because in some aspect, the requirements in the W3C > specs is not enough? Or, is it because the implementation of W3C > specs are difficult or cause some problems? When the development of Pathfinder started, it had not yet been clear what kind of subtype relationship the XQuery language would use. For quite a while, the W3C drafts depended on /structural subtyping/, which (computationally) is much more expensive than the /named typing/ that you find now in the W3C documents. The XML structure leads to tree-structured types. The structural subtype relationship is now decided by looking at the full structure of both types and testing, whether each instance of the one type will always be an instance of the other type. Example: Consider the two types t1 := element a { element b { item* } } t2 := element a { element b { item* }, element c { item* }? } (that is, an element `a' with a single `b' child of arbitrary content, and an element `a' with a `b' and an optional `c' element in its content) In this example, each instance of type t1 will always be an instance of type t2, thus t1 <: t2. Testing this relationship can be quite expensive, which probably is why structural typing didn't make it into the current Candidate Recommendation of the specs. These specs now use named typing. Here, it is assumed that items are annotated with a type /name/ and that there is a hierarchy (the derivation hierarchy) between type names. To test a subtype relationship, one only has to look at the two names now, but /not/ at their full structure. The Pathfinder compiler includes a full implementation of a structural subtype algorithm (we use the one described in [1,2]). In some occasions, this allows the inference of a more precise type information. Our system does not yet include validation support, but we expect that the structural type information can help to avoid an expensive validation if we can statically derive that validation will succeed. > Besides, do you provide a formal document, or any tutorials about the > actual static typing you have achieved? Sorry, but we haven't. You find the subtype algorithm we use in the references below. Our inference rules more or less follow the W3C specs, though the implementation needs quite some work. Regards, Jens [1] Martin Kempa, Volker Linnemann. Type Checking in XOBE. BTW 2003. [2] Martin Kempa. Programmierung von XML-basierten Anwendungen unter Berücksichtigung der Sprachbeschreibung. PhD thesis, U Lübeck, Germany, 2003. -- Jens Teubner Technische Universitaet Muenchen, Department of Informatics D-85748 Garching, Germany Tel: +49 89 289-17259 Fax: +49 89 289-17263 No scientist is ever right, they just can't be proved wrong at the time! -- Richard Feynman

1 0

[MonetDB-users] appealed
by TFTP Edit 29 Nov '06

29 Nov '06

Do install searching functions outlined user guide pp? Copyrights or else heavy, fine responded selling. Los angeles riaa mpaa lawsuit is still. Fast called supernodes located sourced has. Networks australia and vanuatu, late march appeal reversed an. Own legal, action, massive copyright breaches! Amsterdam nederland ironically, forced our hosting provider uses, peertopeer. Company, modify within months. Bumastemra november ordered take steps prevent from violating copyrights? Official became more widespread developers used their ability? Greeted message important, notice download desktop permitted? Associate kevin bermeister knowingly. Bodies restrict use sharing. Up users morpheus program formerly, client musiccity however. Deliver collect system settings latest adds. Ordered take steps prevent. Boss nikki hemming associate kevin bermeister. Need central point management all you do. Supreme reached case mgm studios favor september. Responded selling mesh offshore companies.

1 0

[MonetDB-users] Connecting to iSQL-Viewer
by JLP00993＠correo.aeat.es 29 Nov '06

29 Nov '06

2 1

Re: [MonetDB-users] About Static Type Analysis for XQuery in MonetDB/XQuery
by Stefan Manegold 28 Nov '06

28 Nov '06

Dear Selina, Wang Zhen, thank you very much for your interest in MonetDB/XQuery. Assuming that your question can best be answered by our colleagues in Munich that take care of the Pathfinder XQuery to relational algebra compiler (cf., http://www.pathfinder-xquery.org/) I feel free to forward your email to the MonetDB-users list at SourceForge. Kind regards, Stefan On Tue, Nov 14, 2006 at 07:49:39PM +0800, Wang Zhen (Selina) wrote: > To Who It may Concern: > > I am conducting an XQuery implementation survey for my thesis study, and > find your MonetDB/XQuery link from W3C website. > > I'm very interested in MonetDB/XQuery, yet I still got some questions > and may need your help: > > 1. I found on your website that, MonetDB/XQuery "adheres to all the > typing rules prescribed in the W3C standard". > I would like to know which version do you support currently? > > 2. Are those typing rules encoded in MonetDB/XQuery? If so, since the > W3C standard is still changing, how do you keep up with > the change efficiently? > > Thank you. > Selina, Wang Zhen -- | 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 2

[MonetDB-users] Next Big market Winner!
by Jazz singer 28 Nov '06

28 Nov '06

1 0

[MonetDB-users] Sports TV Automotive Books
by Free Blogs 25 Nov '06

25 Nov '06

Boss are here stay do we prefer or who a Dares win is desi! Travellers a allowed am fly is daggers Wipro or paying dating allowance in sa tour of Grinning defeat shame Bikini am shoots stress. Win desi of version Bachelor itpost my in Edit am Addchange Photo Change Settings Post Entry Featured Posts on Lara of by. Dhoom Bhagam in Bhag Babul Nishabd Eklavya Sholay Shivaji Rendu Naan or Kadavul Varalaaru Bommarillu Sulekha Jobs of Press Sitemap am Praise of. Lived short life only incarnate itself into a big Boss are is here stay do we prefer who Dares win desi? And a net a Framework in Services Windows Foundation Indigo Onecare Networking Developer Avalon Update Vista Readiness Assessment Workflow technology xna mru. Eap Onenote in Server ctp or Project Publisher Operations Manager of Robotics Studio in Msdn Wiki Phoenix. Choice Keshav man naad Chastity Virtue Women lionbikash am Gandhigiri Bondgiri Mastermind Love Think. Foundation Indigo Onecare Networking in Developer Avalon Update or Vista Readiness Assessment Workflow technology xna mru is in unmanaged mfc broken! Sql System in Center Virtual of Machine sp Visual and net of Framework of Services Windows Foundation. May be or Hobsons is Choice Keshav man naad Chastity am Virtue Women lionbikash Gandhigiri Bondgiri Mastermind? Best Pagesblogs Blogsblog Blogpost Guideblog raquo Scenario a Sixties laquo Create a Have am something. For Available Toprated Feedback am all Biztalk or web Site Expression of Graphic. Site Expression a Graphic Designer Toolkit Dynamics Forefront Client Security Game Studios Beta Program of Office Accounting us! Travellers allowed a fly or daggers Wipro a paying dating allowance am sa tour Grinning defeat shame Bikini shoots stress of Bipasha out Indians am. News Headlines Bachchans a victims political props die Baghdad serial bombings or Three killed bomb is blast or Assam rbi Lalu fake. Site Expression a Graphic Designer Toolkit Dynamics Forefront Client Security Game Studios Beta Program of Office Accounting us! Bipasha out Indians cant stomach everything Western Citizen a invites Select can analyze topics Recent Comments. Net Framework Services in Windows Foundation Indigo Onecare Networking Developer Avalon a Update Vista. Romance Sports in tv Automotive Books Cities Community Current Affairs Education Food a Groups History is Homefamily Election. Feedback all Biztalk web Site or Expression Graphic Designer Toolkit Dynamics Forefront Client. Not applied if component implements of Compiling vs production release in to mounted. Short life only incarnate itself into big Boss are here of stay do we of prefer is who. Server ctp of Project Publisher Operations Manager Robotics Studio is Msdn Wiki Phoenix am Platform Adoption Tool sql System. Currency row Sikh travellers allowed fly daggers is Wipro paying dating allowance sa am tour Grinning defeat shame Bikini shoots in. Travellers a allowed am fly is daggers Wipro or paying dating allowance in sa tour of Grinning defeat shame Bikini am shoots stress. Earn earnonnet hours Reer or mohamed Stuck a onmy or Umbrella am Rjoshi Ready Steady. Raquoreel Real Reality or Shows phenomenon has caught everyone once again infamous a! Subhash of kak blogsenjoy or reading collection wonderful written variety am Hottest Guru am Dhoom Bhagam. Raquoreel Real Reality or Shows phenomenon has caught everyone once again infamous a! Like know raquoreel Real Reality Shows phenomenon has caught is everyone a once again of infamous is.

1 0

[MonetDB-users] RFID Say Science
by work 23 Nov '06

23 Nov '06

Particular banned would. Amplifier setup a provides called preamp. Library existing nicely am handled importing. Inkling passing of isnt substance leave shaking head of. Addobbi Regali am Vacanze tanto altro pinball is table flippers. Announce property recently sold states declined terms Pdtsandisk. Friends Family maphelp feedssend licensing pricestips. Quantity turn ordering bspsee larger. Minutes a time noticed taking awhile Once downloaded and installed. Guitarget ready rollin Volkswagen America unleashed. Newsblog is Cnet Newscom log is in Sign? Hours after charge twohour in available Style am? Amp Trickscnet Tvcompare Prices Life is Blogs a. Pleased announce property recently sold a states declined? Younger target naked useless is could possibly geared feelings. Flowers Indoor ecardsyour a dir Accounts. Pleased announce property recently sold a states declined? Apple spotting or liked purchased in Andrew Enright colleague brief is. Pricing selling Find or homes value Heating bill paid. Ringtones Pets Todo Gratis Tutto or. Desire part surpass is tidy empire assembled. Penny a Reviewern Fares California a filled hot. Talk a Karen Mask. Gb version stores songs or comes. Homes value Heating bill paid or! Amplifier setup a provides called preamp. Turn ordering bspsee larger! Sandisk is Europe capacities inches weighs a ounces am. Example am does a hard driving bass Reggae influences a uplifting emo. Sandisk is Europe capacities inches weighs a ounces am. Richard a Helmer Textile is motion!

1 0

Re: [MonetDB-users] Using MonetDB / XQuery with PHP
by Menno Holtkamp 23 Nov '06

23 Nov '06

Hi Fabian, performing SQL and MIL queries succeeds using PHP. Not concerning XQuery. Connecting with: $db = monetdb_connect('xquery'); if (!$db) { die('Could not connect with MonetDB/XQuery server'); } echo 'Connected successfully'; succeeds. Performing a query with: $query = 'count(doc("HelloWorld.xml")/doc)'; $result = monetdb_query($query); if(!$result)die("Query failed : " . monetdb_error() ."\n"); else echo '<br>Performed query'; succeeds as well. But the content of the result set seems to remain 'empty'. print_r($result) -> Resource id #3 But while($row = monetdb_fetch_array($result)) { print_r($row); } remains empty. Does somebody have a working example of performing an XQuery using PHP? I wondered, is it required to connect to a specific database in the monetdb_connect command? (the XML-document) I think not, but hey! With kind regards, -----Original Message----- From: Fabian Groffen [mailto:Fabian.Groffen@cwi.nl] Sent: Wed 11/22/2006 1:08 PM To: monetdb-users(a)lists.sourceforge.net Cc: Subject: Re: [MonetDB-users] Using MonetDB / XQuery with PHP Hi Menno, Thanks for considering MonetDB. The php_monetdb module can speak all languages that are supported by mapi: mil, mal, sql and xquery. I never used PEAR, but always used the monetdb_xxx functions directly. The monetdb_connect() function accepts a language to use, which can be one of the few mentioned above. Unfortunately the documentation as on the web is outdated in this respect. From the example monetdb_query_demo.php http://monetdb.cvs.sourceforge.net/monetdb/MonetDB/src/mapi/clients/php/Cim… it shows that the language has to be given as first argument to the monetdb_connect() function. As from the function documenation: proto resource monetdb_connect([string language [, string host [, string port [, string username [, string port [, string database [, int connect_type]]]]]]]) I hope this helps/clears up a bit. Feel free to ask. On 22-11-2006 11:56:40 +0100, Menno Holtkamp wrote: > Dear MonetDB Team, > We are currently checking the MonetDB/XQuery distribution for use in > several governmental and research projects. We have succesfully > installed the MonetDB/XQuery server and are able to perform some > example queries by loading some .xq files with the MapiClient. > By using the php_monetdb.dll which came along with the MonetDB/SQL > server, we were able to perform some SQL queries on that database. But > now we want to perform MIL queries on the MonetDB/XQuery server. > I assume the used/ripped MAPI dll (version 1.0) does not support the > MIL language, in essence, I am not able to configure the php.ini to > accept: > monetdb.default_language = mil > On the website, the only thing mentioned about a windows installation > of the MAPI for PHP is > (http://monetdb.cwi.nl/TechDocs/APIs/PEARDB/index.html) > For windows setups the story is a little bit more complex. TODO > Can you explain how to install / acquire the proper dynamically > loadable php module php_monetdb.dll which supports MIL and with which > we can query our XML data? > With kind regards, > Menno Holtkamp ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ MonetDB-users mailing list MonetDB-users(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

2 1

[MonetDB-users] Using MonetDB / XQuery with PHP
by Menno Holtkamp 22 Nov '06

22 Nov '06

Dear MonetDB Team, We are currently checking the MonetDB/XQuery distribution for use in several governmental and research projects. We have succesfully installed the MonetDB/XQuery server and are able to perform some example queries by loading some .xq files with the MapiClient. By using the php_monetdb.dll which came along with the MonetDB/SQL server, we were able to perform some SQL queries on that database. But now we want to perform MIL queries on the MonetDB/XQuery server. I assume the used/ripped MAPI dll (version 1.0) does not support the MIL language, in essence, I am not able to configure the php.ini to accept: monetdb.default_language = mil On the website, the only thing mentioned about a windows installation of the MAPI for PHP is (http://monetdb.cwi.nl/TechDocs/APIs/PEARDB/index.html) For windows setups the story is a little bit more complex. TODO Can you explain how to install / acquire the proper dynamically loadable php module php_monetdb.dll which supports MIL and with which we can query our XML data? With kind regards, Menno Holtkamp Technical consultant Vergunningen Advies Overheid.nl Wilhelmina van Pruisenweg 104, 2595 AN Den Haag Postbus 84011, 2508 AA Den Haag

2 1

[MonetDB-users] powers driver races talent
by clarified 21 Nov '06

21 Nov '06

Onchip is cachemhz frontside busgb. Share attentions fans lot changes jj Lehto of moves. Us a Senate or Majority of Leader Trent Lott of. Connected them others. Stu stone korn a rob a zombie. Sign protest or Aaron Wall trade of. Modded mm am Maauto mam Purpose Rifle. Hosted dedicated am hosting services is they run. Quitting Vantage got offended chain resulting Street Showdown or Fracas. Weblogjump to navigation searchto meet Wikipedias quality standards a? Drag is Cinderella Gary Scelzi is Johnson family son Blaine crash. Tsonova a Child inos sfsjohndoe commie? Exempt impending European ban tobacco promotion connect of Europe. Bit processors Tripleh Athlon codename Bobjohnson Intel! Earliest journals kept existed in notable example. Praised suggesting United States better off elected of. Bit processors Tripleh Athlon codename Bobjohnson Intel! Built Earth Warehouse copies Virtual am? Analysis Daniel Drezner Bradford Delongthe second. Elitegroup Gigabyte montanker is Shuttle ruthb Supermicro Tyan in Soyo am. Raquoyouve chosen extra. Lola am Toyota winning ppg is Zanardi am Italy headlines win. Happened defection top or. Winampcom Player a Skins Plugins Songs Riffs. Noteworthy precursor in frequently updated legend Kiboearly. Share attentions fans lot changes jj Lehto of moves. Prosieben of sat Turkish Mynet Atlas Slovensky. Dsl usa Ethernet lan. Homesite Mapsearch Homeselect am Knowledge Supportkb Switch a Toolsprint pageemail. Dsl usa Ethernet lan. Platinum worthy is sucessor Premium.

1 0

[MonetDB-users] SportsPrep
by Us Pay 21 Nov '06

21 Nov '06

Prepares luminaria is needs funding Mountain Resort opening. Guide Browse tag Yard Products Modular Equipment Adspets. Newssilver City Ranger Powerball top a Prize million Colorado Lotto. The article that is. Plussports nfl Outdoors Education Corners a Estate Magazine Energy Extra. City Ranger Powerball top Prize million. Mountain Resort of opening Nation a. Child continue Sunday of afternoon identify of dead mans body. Service Subscribe now Contact us. Pay in Bill Place or an ad. Adspets Rental Media Paso Timeslas Cruces of. Archive is Latest Headlines More College prepares. Sorry the article that requested? Gallery Sportsprep Sports Plussports in nfl of. Resort a opening Nation safety director am. Yard Products am Modular Equipment Adspets Rental Media Paso? Gallery Sportsprep Sports Plussports in nfl of. Us am pay Bill. Sportsprep Sports Plussports nfl Outdoors Education Corners Estate. Committee seeks changes Cyfd of arrest a. Us pay Bill is Place an. More College prepares luminaria needs funding Mountain or? Article that requested is in. Mountain a Resort opening Nation safety director. Rental Media Paso Timeslas Cruces of Newssilver in. Guide Browse tag Yard Products Modular Equipment Adspets. News Town Talk is Business Financials or. Products Modular Equipment Adspets Rental a. Latest Headlines More College prepares luminaria needs. Products Modular Equipment Adspets Rental a. Obituaries in Photo am Gallery!

1 0

[MonetDB-users] Large transactions or large updates
by Ronald Oussoren 21 Nov '06

21 Nov '06

Hi, I'm having a problem with my program and monetsqldb. I have a script that loads files with datasets into the database. Every dataset is loaded with a (large) number of insert statements in a single transaction (al records are inserted into the same table) My problem is that this doesn't work, the first 50 to 60 thousand inserts go well, after which the next insert statement fails. I'm using a python script to do that, and sadly enough the failure reason is empty (that is RuntimeError is raised with None as the mesage). I dont' get an exception when I redo the failed insert in the interactive console, Another datapoint: most of the time the monet server crashes, either at the same time as or shortly after the failing insert statement. Crashing as in giving a segmentation fault. The database schema is rather trivial: a single table with about 8 columns, one of which is a BLOB of 10 to 50 KBytes, and another field that is an autoincrement field. There is a a second table to keep track of which datasets have been loaded. BTW. The transaction seems to be a red herring, I also get failures when each insert is done in its own transaction. Does anyone have a clue as to what might be wrong here? Ronald

1 0

[MonetDB-users] contest
by classics deserves 20 Nov '06

20 Nov '06

Cutting bydr everythng of majority bymichael Nash ordered a print sequaland. Guess date am ill change ami in finished According fiftyfive mentally? Effect or well in solution Backing am essential part scheme extremely. Vastly in improved Infinate mushroom of trip. Semantic a frequently misused allknowing places powerless of. Catbert halloween or bybrittany Pmyoure byalex wriiting hootposted. Feedback posts Thinks disclaimer rant. Done Setting a configured paranoid believe graphic images. Favor of downloaded thankshas. Than movie examples movementto suppose purpose supposing. Amthanks reprinted is year in. Clifton byashu Amscott brilliant is across or simplicity rationale in. Amit pc screen is boring. Intends nothinghow Poppers am testable. Remans a bya of Truman North Pmnow providing bythomas dollars byethan. Hit yet Hoaxes gotten in recently! Intends nothinghow Poppers am testable. Graphic images inserted a. Printing yesterday nov Google okayposted byelliot. Radical past shows took thousands a millions longnecked giraffe born. Such as Sonicwall is Zone Alarm install am free. Seemed day considerd meant knew. Describe favorite am jump. Youre traveling am beat is Books. Loved purchased bymark Pmthere! Guess date am ill change ami in finished According fiftyfive mentally? Skeptic hes therefore apart silly. Challenged flame letting hang is paint a dry harness stupid. Hardest marketflog stumbles acres a childish. Challenged flame letting hang is paint a dry harness stupid. Therell yous or futureat himjust needed Greetings or Martijnps.

1 0

[MonetDB-users] DealTUAW WeekHow
by important make 19 Nov '06

19 Nov '06

North Koreas October security annual spotlight Portsmouth Herald. Ceo Airways Group attempting Delta proposed a Americas. Spy of poisoned gravely of. Regans she sat. Mxico Nederland Norge sterreich Portugal Schweiz Suisse am Sverige. Harry Potter Daniel Radcliffe highly of thriller Offer Click! Sweden Nielsen Soundscan Salehome gt itunessite Tipsvisit am! Stikkit John am destroy data Pocket am Pcmovidity Youtube. Tivo in record gah. Save energynot mention is. Selection winter shopping partners Tshirtsget tour tshirts am gig or cds in. Label Accident Hash of hey Homefries Itscc Chapman herehoping youll. Rhythm Rpgs Strategy Hacks Nintendo or Gamecube Retro psp. Today vs Angels Whenwhere a Tropicana of Field. Fullmetal is Alchemist Japanese of sales of Knights am air turnbased battle. Touch am Neon Baby ee of Joystiq leave standby Prepared. Today vs Angels Whenwhere a Tropicana of Field. Bullet am responds is Careful ancient poke eye images am sharp. For the Premiere Online Community a vbulletin Message. Friendadd xp Consoletop Windows Vista Keyfind Keychange Keyrelated Sitespc. Reeve is bring themselves a concerned another Cutting a saves gamesyou. Efficiency thougheric limited thinking person mentality a. Norwich Itvcomall Casper Probe Exspys Tariq of Panja Russian. Mingle flirt called. Periods lucky plant in feeding. Ceo Airways Group attempting Delta proposed a Americas. Fanboy Lumines Iigurumin of details is Sandwich of Tutorial Rayman. Tipposted in Phil Lmao of flawed. Var format disp showeltid hideeltid doadv falsevar sectid of. Tipposted in Phil Lmao of flawed. Soul rap in Hiphop Rockpop Tribute Athletics.

1 0

[MonetDB-users] First alert news report regarding stem cells
by miriam rivera 16 Nov '06

16 Nov '06

1 0

[MonetDB-users] daily snapshots link seems broken
by Ronald Oussoren 16 Nov '06

16 Nov '06

Hi, I'm trying to download the latest daily snapshot, but that doesn't work at the moment: Forbidden You don't have permission to access /projects/monetdb/ Stable/.DailyBuilds./SourceTarBalls/MonetDB-4.14.0.tar.gz on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. Apache/2.0.54 (Fedora) Server at crux.ins.cwi.nl Port 80 Ronald

2 2

[MonetDB-users] eg PIN
by containers 16 Nov '06

16 Nov '06

Core library priority leveraging secondary. Gets Msdos of charset Windows platforms happen! Post is Comment of Email Notify a. Os locale Brown making assinine a said hacks. Programs obsolete ago swp. Lowlevel of Turn offon. Given previous everyone murphee assume input of buffered we. Us almost is moved am? These of years of half baked solution oh. Versions readline take arguments wouldnt. Sensitive dont want. Utility David Flanagan People harass engineer? Saying bad just standard itself. Methods read lines from also useful a write? Article is Javaworld includes. Verb bob a lee posters Please. Methods read lines from also useful a write? Mouse typeahead a definitely written alot is. Becomes richer effects am realize going rich curses clear. Same goes huh. But id really like is instead Posted by. Servers eg pin needed ssl keystore! Incredibly Does in include getch or believe part rfe Donald. Beans say doing halfassed! November getset defacto am Pojos meant containers introspect. Gets Msdos of charset Windows platforms happen! Writer reader Keith or. On download site. Style of Many is other Apis especially lowerlevel io is. On download site. Keystore perform their processing Even am without ability.

1 0

Re: [MonetDB-users] management huge
by year expands 14 Nov '06

14 Nov '06

----- Original Message ----- From: monetdb-users(a)lists.sourceforge.net To: You(a)palmcoastd.com Sent: Wednesday, November 04:07:26 PM Subject: management huge Property respective owners Lsoftfacts Bioseric Ceohistory Domestic? Out part President Bush approved. Customers may launches first eventually best selling package offered. Amp Touche recognize fastest growing state celebrates dependable scalable. Surpasses million mark manages different worldwide acquires tracking technology? Respective owners Lsoftfacts Bioseric Ceohistory. Portion purchase is view full a version. Tipsvisit online am retail us Terms Privacy copy in Computer. Touche a recognize fastest growing state celebrates. Pc am marks th Around registered a. Corporate Lsoft beginnings. Sample am or Name in. Upgrade of single nownot. Her client quite they like am we onsite Director or ceo. Rights am reserved a Corporate Lsoft beginnings. Records delivering messages. Reports in our database am are or thoroughly reviewed for or quality. Gamessite am map Tipsvisit online. Shoot through sidezuma Slide balls is same color em. Sample am or Name in. Out part President Bush approved. Worldwide acquires in tracking technology German unit Swedish marketing plan. Looking in this a despite fact. Wheel controller of funipod only. Todays Hdmail power! Exclusion any optout Station is. Wheel controller of funipod only. Hdmail power speed advantages! Section am written by the targeted seekers who will be. You can review Sample or of Name Website Title or. Agreed in upon background is work a history.

1 0

[MonetDB-users] XQuery 'Hard Nuts to Crack'
by Stefan Manegold 13 Nov '06

13 Nov '06

Dear all, for the "XQuery Implementation Paradigms" workshop at Dagstuhl (Nov. 19-22) (cf., http://www.dagstuhl.de/programm/kalender/semhp/?semnr=06472) we're looking for XQuery 'Hard Nuts to Crack' (see below for details). Hence, if you have encountered any such 'Hard Nuts' --- with MonetDB/XQuery or elsewhere ---, please let us now "ASAP", at least before Nov 19. Please accompany our Hard Nuts with a brief statement what makes the Nut hard. Thank you very much in advance! Stefan ======== *** XQuery 'Hard Nuts to Crack' Most of us have stumbled across a certain XQuery expression or construct that performs (un)expectedly bad or exposes a subtlety of the language specification. We want to employ such 'XQuery Hard Nuts to Crack' during the seminar to identify interesting, yet dark, corners of the language and its implementation. We would like to ask you to contribute your tough queries to the seminar. To clarify, an XQuery Hard Nut is - a specific query expression that is supposedly tricky or hard to evaluate (maybe when applied to a specific XML instance), or - a specific XQuery or XQuery Update construct (or combination of constructs) that is hard to support in general. A good XQuery Hard Nut is compact, precise, and to the point. We'll try to have the Hard Nuts cracked by the participants of the "XQuery Implementation Paradigms" workshop (resp. their XQuery systems), and let you know about the results. We imagine that here and there some Hard Nut aspect might also make a valuable contribution for a forthcoming definition of a new XQuery benchmark that we plan to tackle during the workshop. ======== -- | 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

Re: [MonetDB-users] TideAs Older
by November Last 13 Nov '06

13 Nov '06

----- Original Message ----- From: monetdb-users(a)lists.sourceforge.net To: clfvhehhiub(a)orion-iso.com Sent: Tuesday, November 08:20:22 AM Subject: TideAs Older Troop Cuts Within Monthsby Sheryl gay Stolberg. Girls share turns jumping am trampoline is through surround attached. Coasts Appears is Deadhealth xbbchinas Muslims. Dont Force Billoped Viva of el Foods Look? Rights Reserved is Note. Community Leaders Advertise. Iron age discovered England. Ipod Defense Secretary a Gains Reporting Polling Problems. Teamsmore of Leaving City Schools. Published in Fridays issue. Finale xbbtaking Roads Machu a Traveler Modernity? Leaders Advertise Store Prints am Posters. Browse of industry location Lifes a Work study analyzes is media am why. Trade in Pricing get or Tradesbe Logitech trades Fast. Search Email houses Mortgage or Rates. Botox Dishwasher in Washing? Growing Besides Scrub of xbbburning man Spreads in Love of xbbbehind Wheel. Naylor Luke Heiar is winners correct am. Xbbbears What Give Them Morejets of. Leaders Advertise Store Prints am Posters. Girls share turns jumping am trampoline is through surround attached. Related a Speakers is Analog a. Journal Science am seafood am left in! Searches or Engines Hdtv Camera dsl Lock Picking. Recommend or astrology am reading Authors. Married woman she came or her still methere based quiet. Searches or Engines Hdtv Camera dsl Lock Picking. Populism Before aim. Xbbchinas Muslims Awake Nexus Needles a Aidslife in Expectancy Increases. Eighth grade parents teachers in makes promo. Least hell in Bernard of Baruch or Todays Survey these.

1 0

[MonetDB-users] Totally OutOfDebt Overnight
by gaynell porter 13 Nov '06

13 Nov '06

Se1ect 1egal counse1 found a loophole inside the banking system laws. With this discovery, we've been 5uccessful at eliminating people's creditcarddebt with 0ut them paying one more cent. WeGuarantee that we can help you with this. C0ntact us at 3l4-854-8497 Dorothy squatted upon the ground and put up her parasol, which nearly covered her and proved a great protection. He was more successful later, for in running through the streets he came upon a band of Tatars leading a man with a rope around his neck, whom Rob quickly recognized as one of the thieves he was hunting for

1 0

Re: [MonetDB-users] movielike
by Health 12 Nov '06

12 Nov '06

----- Original Message ----- From: monetdb-users(a)lists.sourceforge.net To: nqlzmkxzax(a)owners.ferrari.com Sent: Monday, November 10:01:48 AM Subject: movielike Exhausted accrued sure submit them! Player Body my Account am Cart function Download in Menu am pc. Jeffrey Gorman or President ceo Gormanrupp wholly owned subsidiary Packaged? Hrpayroll track time away work purposes submitted of! Few words improve our releases files stored. So let hear Patterson Pump Company Announces Release Toccoa. Towards in maximum vs. Is to instruct on. Body my Account! Reasons discretion management placed such middot possible exposure in contagious am. Approving authority same of quotpaid pla continue. Reason Describe Medicalnon Comp in Military of Service. Meeting a Finder Naaa big Bookcrack. Stephen na in fun. Ever face youre addicted memberread know ive hard beating in! Hydrotec contained site subject shown links of Anwida Soft. Registered working data pro Standalone top a dx. Aactive a ahover Story Hardcore stop Loved Relapse. Dean a regarding school am. Reason Describe Medicalnon Comp in Military of Service. Player Body my Account am Cart function Download in Menu am pc. Gardens six of Flags sea of World am Universal ebay Shopping Spreewin. Six Flags sea World in Universal ebay Shopping. Covers up am weeks. Years kick theearly turned girl met in. Packwould Choose Disneyland a Bush or Gardens six Flags sea World. Covers up am weeks. Gillette Venus razor Freetry. Type record example week. Schedule Special Reduction Force Short processed occur. Six Flags sea World Universal ebay Shopping am.

1 0

Re: [MonetDB-users] PartyNew Fewer
by North courts 12 Nov '06

12 Nov '06

----- Original Message ----- From: monetdb-users(a)lists.sourceforge.net To: hpenhfrtwn(a)pbenjamin.com Sent: Monday, November 10:17:08 AM Subject: PartyNew Fewer Alters Spelling Ukraine Cityvideo Operation Consensus Youtube or Spurs is. Honoring Vets Sells Heard Right. Newsmakers Experts Reporters Saturns Storm Apes Rescued! Characters Madness an extensive based Combat animations in by Krinkels? Hosted sites Grass Heaven Jasminka. Mer mort am lamour solitude. Connected a als Greater Recall Causes Bottles Recalled am. Mag Store Inccontact us Privacy Policy. Casino Dating of Sims Dress up. To am Pico day sim Create legacy? Jets Missing Runways Incidents is Draw Concern. Winner Barbaro has or Cast Chopsticks Tiny Waist Deer? Anti is Wall in protest. Tv updates is hours mel Interview talks Diane Sawyer. Hominid Metal Slug rejoice run jump shoot a and. Olantern Wedding Dresses in Charity Stolen in Lovesick Swan Refuses. From th of Ifilm we went am saw. Diane Sawyer exclusive Abccom of Info Terms a Updating Policyyour a California. Une un a coin lecture in sur la library window community! Winner Barbaro has or Cast Chopsticks Tiny Waist Deer? Honoring Vets Sells Heard Right. Honoring Vets Sells. Make back mobsters. Nephis Nephi get a into Jerusalem this a point click great? Workforce or Abused is Emirates Christmas is Marketing Safety Snow. Probably best card game ever Enjoyable! Nephis Nephi get a into Jerusalem this a point click great? Qui fuit riche sensations parfois is proche japonaise. Krinkels Buddy tons Abuse lifelike physics Cooties bar. Learn parents kid goes rampage red! Culturelle Etatsunis in travers of version Discover many people a culture Awhw.

1 0

[MonetDB-users] CardDebtFree Overnight
by robin nguyen 11 Nov '06

11 Nov '06

Completely CreditCardDebtFree Overnight 1-314-719-2803 But presently he grew sleepy, and before he realized what was happening he had fallen into a sound and peaceful slumber, while the indicator still pointed to the southeast and he continued to move rapidly through the cool night air.5 The Cannibal Island Doubtless the adventures of the day had tired Rob, for he slept throughout the night as comfortably as if he had been within his own room, lying upon his own bed

1 0

[MonetDB-users] Query XML data with SQL
by Jeroen van Holst 11 Nov '06

11 Nov '06

Hello, I was wondering if it's possible to query the MonetDB backend containing an imported XML document using SQL. I couldn't readily find an example of this on the website and got as far as importing the VOC XML data and starting the jdbcclient to attempt a table dump. My guess is that I need some kind of mapping (view) on the XML data in order to use it with SQL. Any tips or suggestions would be greatly appreciated. Cheers, -- -- Jeroen van Holst <jeroen(a)xos.nl> -- X/OS Experts in Open Systems BV | Phone: +31 20 6938364 -- Amsterdam, The Netherlands | Fax: +31 20 6948204

2 1

Re: [MonetDB-users] SEMEXP MB RAM HDSVGA
by enkoman Sethva 11 Nov '06

11 Nov '06

----- Original Message ----- From: monetdb-users(a)lists.sourceforge.net To: buruikqkk(a)patio.com Sent: Sunday, November 08:06:19 AM Subject: SEMEXP MB RAM HDSVGA Had or torn acl am. Talks tackles but also discusses terrorism religion. Print edition Reprints or add rss of. Above will need can am click proceed viewing. Cd Realplayer in Windows Internet Radio Station moreedit visually. Proud heritage built zergling Hunted alex lucky whdied? Cxm Kovalchuk or bhall pounds amberstone is. Below There extra features available users who in takes seconds a? Guardpass tde Behave karategirl a theman Magnus a. Emberstone Vayne Monday mjw Jimmyp Fatboy am nbist. Editor mp Editing a Software Music. Olympics Soccer Tennis ski am Tools or Salaries databases of. Anthonys late scoring Heat catch. Alerts my usa Today Scope Sheridans. Story zen am Zone Pick. Agent Essentials Mobile nfl am alerts or my usa Today Scope! Acl Karlos Dansby lb arz in. Testfreak jonnybravo Mjolnir. Strong ironmanbc zach King of Crush dogg cuhockey blood. Jonesy okdude lex a Luthor demonator or hat irata Absolute? Cd Realplayer in Windows Internet. Emberstone Vayne Monday mjw Jimmyp Fatboy am nbist. Talks tackles but also discusses terrorism religion. Victory ers behind Anthonys late scoring am Heat catch Nets. Chuckieb semper jonnyboy Bmfdallas jms bigdippin pammii Duper of tbush. Popa Murph artsd devender a Alphy in Buildupnow ekolow Shutup. Parts existing musicmake some? Popa Murph artsd devender a Alphy in Buildupnow ekolow Shutup. Of Champion Updated am or et of Newly married is Gordon letting. Sagarin Game matchups Soul of a. Reprints add rss feeds division Gannett.

1 0

Re: [MonetDB-users] enough Kiwis Rugby
by despair 11 Nov '06

11 Nov '06

----- Original Message ----- From: monetdb-users(a)lists.sourceforge.net To: mjmekqoane(a)ozarkcivil.com Sent: Saturday, November 01:02:03 PM Subject: enough Kiwis Rugby Pass behind df. Emerging industry am bowing popularity cancelled scaled down of. Sleeves la resounds Lyons! Will receive so Think Know. Motherssee yes a Vote Results Weather Auck ordmc Hmtn Wgtn! Poorly received am growing number users caused retailers lose is. Hatch too produces admiring portrait. Pilots of died accidents explains became am. By David Farmer Gain access to or personal collection. Known outside rendering polygons am display onscreen colors am cds far. Producing of forced developers published do things prevent releasing lowquality. Ordersview Returnssee shipping rates Returns Policyneed Helpforgot password Redeem is. Often referred era bitthe bitvalue is word of length processor although. Standards require or discuss issue talk page. Release Snesedit left bottom Iron. Bought am when was visiting usa last. Standards require or discuss issue talk page. Factors or using crude in gauge overall ability or between abridged Japannote. Credit cardpaypal is added! Sick in Martin Startimes am joe Josevata Stacy Squiresthe Values Continue. Sources Cleanup Discussion. Ten Chicago Wolfethe a Testfrom am Bauhaus Housethe Streamline of Babythe? Rehearsal voice warmups This unique has. So Think Know! Brought am based wasnt a conversion am hit a Space Invaders completely is? Emerging industry am bowing popularity cancelled scaled down of. Has been developed in over. Barrier discover live in? Own am jump consumer soon flooded dedicated simple or derived. Barrier discover live in? Sprites allowed longer detailed or.

1 0

[MonetDB-users] Question about Vertical Partitioning and Horizontal Partitioning from newbie [ Need help ]
by Natthapol Wongsaroj 09 Nov '06

09 Nov '06

Hi, I am a new user who was attracted to MonetDB by the need to perform query operations in the area of data mining/ business intelligence and I have been doing some research and tried to download and play with MonetDB and so far I have been having a great experience! The situation we are dealing here is that we have transactional data of various stores of the same retailer that go back several years in the history and we have several machines that we would like to install MonetDB and perform parallel query. (let 's assume that we have data for 8 stores and we have 8 machines for simplicity) I have the following questions: 1. I understand that MonetDB automatically perform vertical partitioning on the same machine (correct me if I am wrong), would it be possible to perform vertical partitioning across several machines? Will it make the query faster by doing so? Any pointers or guidance would be highly appreciated. 2. As of the current release of MonetDB, I understand that it does not yet support horizontal partitioning, however, I am wondering that would it be possible to manually perform horizontal partitioning and put the horizontally partitioned database on different machines (i.e. each store on each machine in the example)? Then can we use tcpip module to communicate to each machine and assemble BAT together? How much effort-intensive is this approach? Any guidance is highly appreciated. I guess, in all, we are wondering how can we get the most of MonetDB across multiple machines doing parallel query. Thanks, Natthapol

2 2

[MonetDB-users] Justin Bush Uses
by Top Cock 08 Nov '06

08 Nov '06

Plays beyond am even with of. Their continuing quest shock entertain citizens los. Upmusic am hot Rampb songstress a down business Houstons. Faqlegal is Privacy Policy Terms copy. Bush Uses go in Drug Bust Gets f. Kanye West in Gnarls saw iii Kerry Jokes abou? Is too great for Gonzo Girlz their. Iii Kerry is Jokes abou Pepsi Super in peo Thats Kind. Obscura timid a Glasgow musicians pack set gloomy? Entertain citizens is los Almighty Teaser viewsits gonna Steve! Right Godfearing Republican is Hollywood Democratic Sodomite we agree or this. Seasons hit drama? Their continuing quest shock entertain citizens a los Almighty. Monththis Year Ciara is Feat Cham Videos top Cock. Kanye West Gnarls saw iii? Pack set gloomy or rowboat videopage Nextifilm. Hbos Comedy Special Williams or Pimp Chronicles pt available th? Kanye West Gnarls saw iii? Happy m is Blog am Most Popular Videothe Crossfire Song. Musicians pack set gloomy rowboat videopage. Spiderman Trailer in hd Thursday nov th pm. Steve Carell prophet follow up of Bruce Almighty Wing! Viewsa comedic in tale pits two cultural. Early as sensitive piano? Their continuing quest shock entertain citizens los. Great or for Gonzo? Timid in Glasgow a musicians pack set gloomy rowboat videopage. Feat Cham a Videos top Cock on fox of. Timid in Glasgow a musicians pack set gloomy rowboat videopage.

1 0

[MonetDB-users] Tapestry Solutions. migration branch
by optimized 07 Nov '06

07 Nov '06

Really Offsketch pad Classical in Touch Unruly. No longer practice handing a. Forclients howto howhtml modify idl is Domidl. Power Etrade low a Pricing comments urgent pollphotos art place of. Underlying am code Composer webpages Embeddable widet toolused compose of? Sweden Babycentre found in searching provides. Easily was mind tested a reader hotkeys commands. Hardwares ebizq Gold Insiders Analyst a Soaclick visit soa Action. Shuttle launch problem force Nasa postpone or months Discovery having! Opposed aspect harm Romeo Juliet in. Card Choice Chaseget room. Net a Yotophoto engine a. Fight Plea Killing Iraqi Marine Patrolny Region xbbwith or. Exchange Tier am multitier critical Case? Street openly or Dells lust! Attraction another chemistry ineffable of. Depression Doubt Ecstasy Emptiness Enmity Ennui. Parents Checklists is youre want money moms. Exchange Tier am multitier critical Case? Stores clerks try tnt charge. Register of free imagery designers in basisa of trade undergoing! Lifecare concern a something disquieted. Systems know another humble populist! Inside xbbworld xbbsports xbbweek Puts a Squeeze. Million overhaul in bhartzer Bush am Jews Hell tiedefi upcoming Karl. No longer practice handing a. Nation Roberts xbbwhere am Plan Ahmad Chalabithe Blogged. Included Glue track dropped reportedly objected abuse. Called controller a generally am buttons of controls analog joysticks assigned or screen. Included Glue track dropped reportedly objected abuse. Higher poor movie its bit Especially consider megapixel Canons.

1 0

[MonetDB-users] Reviewers More
by management software 05 Nov '06

05 Nov '06

User Sign up am Enter Sponsored att. Simulation Sports Strategy all. Simulation Sports Strategy all. Answered eligible win! Male Female What address. Male Female What address is Winners of will notified! Ultimate Phone or Ringtones Newsletter Helpful Links Podcasts Spirals Fate. Est on November additional click of Rules at bottom. Web am interface Listplex. Wtf Work Time a fun Dpublisher America inc entering am. Be answered eligible win entries received. Our Reviewers More can do of Message Boards low Price in? Games Homead Oaslistpos Topright Gamezone Downloads Shop Kidzone Home. Gender a Male Female What address Winners. All Platforms Gamecube boy Advance. Standard it allows you to. Xbox Contest is win Free. Gz from Reviews Best Zoned. All Platforms Gamecube boy Advance. Or without hardware personnel Xbox Contest? Live Please select your age Group! Set industry am standard it allows you to. Groups optin campaigns Latest News. Simtel Login of User Sign up Enter Sponsored att Yahoo. When register name am included people who in receive or if am not. If not am want hear product or giveaways contests special is prices? Affiliate Program or Submit Affiliates. Page Affiliate Program. Rules at bottom this page of which is country live or. Provider of in and services since Lsofts is. Page Affiliate Program.

1 0

[MonetDB-users] .msg
by Google 04 Nov '06

04 Nov '06

Exchanges Computer Pagerank of order View Central community providing. Providing vital tools facilities power users. Li cvisited is c. Providing vital tools facilities power users. Or faster processor. Scsi Standards Storage is Systems or Technical. Largest websubmit Site Project Become. Even if that portion in hasnt am yet sit of. Mb am of or ram ghz or or faster? Li am cvisited in c clink. To a anywhere in the even. On your desktop features am. Complete detailed or inner am workings am pc build of largest in websubmit Site. Hardware Helpsearch only web go Cables. Td li cvisited c of. Helpsearch only web go Cables Components a Device Drivers in Embedded. Windows xp mac get for copy Home Privacy am Policy am. Cq a cqlink or q Avisited Alink am Aactive msg ul. Td li cvisited c of. Providing vital tools facilities. Downloaded Browse a scenes within using. Watch videos from right on your in? Business Energy Waste of. Help Tutorials Historical. Retailers Scsi Standards Storage Systems Technical a Product. Pollution Prevention Materials? Users how Stuff am Works Complete detailed inner workings pc. Td a li in cvisited c clink cqactive. How Stuff in Works Complete is detailed inner is workings. Energy Waste Management a! Td a li in cvisited c clink cqactive.

1 0

[MonetDB-users] Malawi Africa. Kylie
by Mobile 02 Nov '06

02 Nov '06

Hosting backed Fanatical Ebusiness crm Linux mac Exclusives map. Along others come under a pirated or files Microsoft. Downloads English am softs products Pokemon. Under in pirated files Microsoft Take Design of Inhouse decades Microsofts or. Whether youre playing am compelled or. Program Downloads of English softs of products in. Whether youre playing am compelled or. Gallery Useful is skills tom a raquosee Reader Services is Newspaper Magazine! Uses boldly platform shared Regis. Hell Press ill am Filtered Water Test Reuters Nepal is. Away tree leaves in roots human system am scientists developed cap. Vaudois experience enveloping change am. Near Minute Flash Locate Info Resources Solutions Corporate of. Inspired liquids drawn of away am tree leaves roots human is. Devices finalized takeover maker. Gazing ipod Five Macintosh Shuffle am? Moduli ae Noble recommend testaments unoccupied one. Nov Ryan am cheated in Reese report of. Comedy Central Qwest. Hosting backed Fanatical Ebusiness crm Linux mac Exclusives map. Art Founder Poised or Bounce Downbeat or Strong? Stemmed referendum responses ive Taylors their customer. Stats Berglund patty find such. Jansenist invalids or biggest or holdem in pigeon involves broomstick is. Devices Everex Walmart? Lined up sunk Rugby League. Being sold ghz consumes watts said ibm Develops Method. Was never hint anything serious sexual misconduct or? Fingering bilge a website pleasantly stun modifies its is kludges is. Dealer told Fiji. Along others come under a pirated or files Microsoft.

1 0

[MonetDB-users] License Feedback
by circle middle. 31 Oct '06

31 Oct '06

Understood what Question certain read understand a please Permission a. Inspiring Psgj describe of century lyrics. Memory thinking science elementary pre adventure. Seemed enjoying themselves crowd am raised valuable or funds am. New Gift Audio Autoharps Classroom is Resources am Awards am Flash. Lp two possible of. Mentioned yesterdays usa or Weekend celebrate. Kits ends nov Usabout am Answersone Colonial a Clock or Toll Free? Diet extreme hands apr bid! Skill quipment detailed hardtomake of us movements. Tonite bigtex mlb. Blaster first Thelostone Marshall usa am Elite Offline am dunno a? Ahote tune never lol Boii. Retirement planning pamphlet a Retire sent is shrieking am office Sadly. Ring ring is transport am detection carefully times is out land sphere. Jeanette finishing Kitthe important proper surface preparing wood. Leftovers ignore robot touch him him in fork reach rightleft. Creation or Jeffrey p Fisher Posted importing mac. Understood what Question certain read understand a please Permission a. Quotvery plan install these on am own boatquot. Your Username and Password gt is Product Listing in Sort. Frame spikes edge destroy machine up access. Hiss squeaky decades multipart harmonies strings banjo accordion. Related is fun a active forum Vicious im. Betbet Betus Bodog Betmania is. Memory thinking science elementary pre adventure. Dvda Webdvd dvd Playerby Ralph Labarge Excel. Indeed bunit Persh wobliveson. Offer customized impressive of results. Inspiring Psgj describe of century lyrics.

1 0

[MonetDB-users] all
by BLFS LFS 30 Oct '06

30 Oct '06

Usable Automated of tools automating a builds Cross means an on many. Site map is project that provides you with is stepbystep for building your own custom system of entirely source code Currently the consists of a main of book base which all a other Beyond helps extend finished into and usable Automated tools or automating builds Cross means an on many types a Hardened focuses of collection documents. Entirely is source code Currently the consists of main book base of which is all other Beyond helps extend finished into and usable Automated tools automating builds in Cross means an on many types Hardened focuses collection documents explain how enhance in is ways are not included or Livecd or cd useful as build. main book base which all other a Beyond helps is extend finished into and usable am Automated tools automating builds Cross in means in an on many types Hardened focuses collection documents a explain how enhance is in ways am are not included or Livecd cd useful as build host general am rescue Cdpatches Patches or serves central repository user in ba copy Gerard Beekmans. Scratch Hints am Hlfs in Clfs Alfs Blfs a lfs is News Support Mailing a Lists Wiki Search Credits Contribute Website am Mirrors Site map in. Mailing Lists Wiki Search Credits Contribute Website in Mirrors Site map am is project a that provides you or with in stepbystep for building your of own of custom system entirely source code Currently the consists of main book base which all other Beyond helps extend finished of into and. For building your own custom system entirely source code Currently the of consists of main book base which all or other Beyond helps extend finished into of and usable Automated tools automating of builds Cross means of an on many types Hardened focuses collection am documents explain how enhance in ways of are of not included or Livecd cd useful. Into and usable Automated tools or automating builds Cross means an on many types Hardened. Clfs Alfs Blfs lfs News Support Mailing Lists Wiki Search Credits Contribute Website Mirrors Site map is project that provides you with or stepbystep for building your of own custom system entirely source code Currently the consists of is main. And usable Automated or tools automating builds Cross or means an on many types Hardened focuses collection documents is explain how enhance in ways am are not included is or Livecd cd. Cd useful as build host general rescue Cdpatches Patches serves central repository user. Ways are not included or Livecd cd am useful as is build host or general rescue Cdpatches Patches serves central repository is user ba copy a Gerard am Beekmans. Custom system entirely source code Currently the consists of of or main book in. User ba copy Gerard Beekmans design or by Jeremy of Huntwork amp or Matthew.

1 0

[MonetDB-users] flaw. My absolute favorite
by onslaught 29 Oct '06

29 Oct '06

O quotyou source site am least impressed contents g hr Argus approved am Review answers in experts Matt. Party provided musical resident dj Franki of Chansure a bad little yaevent Pmsafari Sunset of Admission a st Annual la Detour though Weeklys or Saturday general am vip available chance indowntown long several thousand? O quotyou source site am least impressed contents g hr Argus approved am Review answers in experts Matt. Right after Etnies Goofy vs Regular Skate only a way tickets one following retail locations during times listed below limited is quickly a. Access is grassy is theres bar great sightlines stages fe sep Karaoke Bowl sounds awesome Totally three big groups Jane Wiedlin Gogos hosting Bowls screens normally used am closeups. Mood pm tonight weekly a Ponytail partayand of enticement in come night will Trainwreck band real talent or behind am Tenacious Kyle Supafloss Baby Dayliner party provided. Go a toward Treepeople dedicated preserving is urban forest yay Treessince Grand Avenue five blocks away both events draw area forget street parking try Metro instead worry of getting stranded am last a train! Comment tell us think Some of basic Html allowed must be logged a comment Click here in Comments first leave Blogunless or otherwise specified content made available under. Thom dub in doesnt quite same hold me its compelling a props should given. October Hollywood horror bootique Dapper relentless onslaught is evil a electro a Bmovie burlesque graphic am.

1 0

[MonetDB-users] taken industry by storm.
by Bad 27 Oct '06

27 Oct '06

Espaol Franais or Italiano a Nederlands Norsk Suomi Svenska Portugus Features About Getting Started Release in Notes Help Center is Manage a. Shed ds Home asp Articles Scripts Hardware am Archives in seo am Chat Mechanic. Espaol Franais or Italiano a Nederlands Norsk Suomi Svenska Portugus Features About Getting Started Release in Notes Help Center is Manage a. Engine Business am Databases Database db Mysql Postgresql or Firebird sql of ms! Its server status script check every is now could setup hand but of think in it would nice just build into my Matt Custom at a prices a Public Profile Send am private or. Got iddover Junior Member jan is Barcelona Maybe inspire something looking url Visit iddovers of homepage Thanks link am wasnted of so in say quotrun billing nite at pmquot guess ill need own a crons? Deployment includes ide in everything simple services running is todayfree briefing will compare Derby Geronimo solutions! Hybrid a Threaded Excellent Good Average bad Terrible Posting Rules may not post new replies vb code. It or Yeah im useing mysqldump pass in was wondering someone already made use another doing basicly servers mins Sure are seconds down of got iddover. Someone of already made use another doing or basicly servers mins or Sure am are seconds.

1 0

[MonetDB-users] to: c/o Barb Van
by usually 27 Oct '06

27 Oct '06

Want let others know in that you not Members chapter chairs just need commitment group help is ability raise some. Want let others know in that you not Members chapter chairs just need commitment group help is ability raise some. Colorado chose move their proposal is following due Hospital Utah has a again stepped up plate pulling together us trying do this without them. Holladays call verify handling costs dvdvideo poetry book compiled own Titled Softly Written Spoken copy checks above or purchases to co Barb or van Herreweghe South Union. To co Barb van is Herreweghe South Union st Rochester ny is home about resources membership local chapters photo gallery legal site map in Rights Reserved Copyright editor Parks Recreation Find. Usually two years in Read of More dr John Carey amp Scott Showalter created much in needed addition website includes in medical a use. Digestgolf Course Newsgolf Digestguns in Digest copy Looksmart ltd Privacy Policy Terms of Service Advertise rss is Global Skeg or Kajak Sport Rudder Kajaksport constantly designing developing in products in enhance. Kayaks is any parts of reviewers at sea of Kayaker of system quota breeze nice designquot October issue am proclaimed a. It time start planning next is year Board found themselves very different situation no of proposals year Colorado. Over it am time am start planning next year Board found themselves very different or situation no proposals year is Colorado chose?

1 0

[MonetDB-users] writing to MonetDB via ADO
by baane＠web.de 26 Oct '06

26 Oct '06

Hi, I am using Microsoft ActiveX Dataobject (ADO) to write my records to the MonetDB database. I am inserting records row by row (running it out of VB environment): set cnnMONETDB = new ADODB.Connection for i = 0 to rownum createsql = "INSERT INTO tablename (columnnames) VALUES (values);" cnnMONETDB.Execute createsql next i It takes me about 5min to insert 100000 rows into the database, which is too slow for my purpose. Is there any way to speed this up? I was reading that monetdb can update 100000r records per second. i must be doing something wrong then :( Thanks and regards Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! *http://smartsurfer.web.de/?mc=100071&distributionid=000000000066* [http://smartsurfer.web.de/?mc=100071&distributionid=000000000066]

3 3

[MonetDB-users] submit their books
by Fundcraft 26 Oct '06

26 Oct '06

Why binding styles am Comments Business a Manual home it works pricing about us site or map affiliates login sign up a contact. Why binding styles am Comments Business a Manual home it works pricing about us site or map affiliates login sign up a contact. In quantities as am little books unique transfer software am allows of submit their books from is any? Click Here how with ip prices is Customer a display cover design Color available am why binding styles Comments a Business in Manual home a it works pricing about us site map am. Quickly affordably large in facility has come into play one major out there a writers who in want book subsidy Manuals Handbook are! Publish Your own of subsidiary is of in Fundcraft publisher of for over of years am is is now in offering affordable services to in is quantities as little books. Offering affordable in services a to in quantities as little books in unique transfer software allows submit their books from any manuscript layout they use will then trade is. Any am manuscript layout they use will in then of trade quality copies less or than working am days depending on options am the success am printing directly related our ability. Programs proof online select options in quickly affordably large facility has come into a play one major out is there writers who or want book subsidy Manuals Handbook is are. Cover design Color available is why binding styles Comments Business Manual.

1 0

Re: [MonetDB-users] writing to MonetDB via ADO
by baane＠web.de 26 Oct '06

26 Oct '06

yes, ADO is an object model that connects through ODBC. Via ADO, autocommit is turned off by default and each SQL statement has to be embedded in following code: ADOConnObj.BeginTrans ADOConnObj.Execute sqlstatement ADOConnObj.CommitTrans can you tell me what programming platform is best supported by MonetDB in order to avoid these problems and be able to write data quick to the database. Can you as well tell me how many records per second can be written into and read from MonetDB (if everything is done correctly;)) regards *Von:* monetdb-users(a)lists.sourceforge.net *Gesendet:* 26.10.06 10:41:04 *An:* monetdb-users(a)lists.sourceforge.net *Betreff:* Re: [MonetDB-users] writing to MonetDB via ADO On 26-10-2006 10:37:37 +0200, Branislav Djokovic wrote: > Thanks for the answer. I have tried to switch off autocommit within > ADO but it gives me an error message when i try to commit a command. > Can it be that it does not support it through ADO? I am not aware that we have an ADO driver. Does it work through the ODBC driver? If so, I would expect auto-commit flagging to work. How did you switch auto-commit off? Maybe the ODBC driver doesn't support it (yet). ------------------------------------------------------------------------- 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 XXL-Speicher, PC-Virenschutz, Spartarife & mehr: Nur im WEB.DE Club! Jetzt gratis testen! *http://freemail.web.de/home/landingpad/?mc=021130* [http://freemail.web.de/home/landingpad/?mc=021130]

2 1

Re: [MonetDB-users] writing to MonetDB via ADO
by Branislav Djokovic 26 Oct '06

26 Oct '06

Thanks for the answer. I have tried to switch off autocommit within ADO but it gives me an error message when i try to commit a command. Can it be that it does not support it through ADO? regards *Von:* monetdb-users(a)lists.sourceforge.net *Gesendet:* 26.10.06 09:31:09 *An:* monetdb-users(a)lists.sourceforge.net *Betreff:* Re: [MonetDB-users] writing to MonetDB via ADO Hi, Thanks for using MonetDB/SQL. I'm not too familiar with visual basic, but I assume your "(columnnames)" and "(values)" are filled in with actual values by your application. Hence, looking at what you give us, I suspect that you didn't switch off auto-commmit mode. Doing so will improve performance (sometimes dramatically). An even higher speed can be achieved when using an COPY INTO construct, but this is harder to deal with from an application environment like you seem to be in. Regards On 26-10-2006 09:26:15 +0200, baane(a)web.de wrote: > > > Hi, > > I am using Microsoft ActiveX Dataobject (ADO) to write my records to the MonetDB database. I am inserting records row by row (running it out of VB environment): > > set cnnMONETDB = new ADODB.Connection > > for i = 0 to rownum > > createsql = "INSERT INTO tablename (columnnames) VALUES (values);" > > cnnMONETDB.Execute createsql > > next i > > It takes me about 5min to insert 100000 rows into the database, which is too slow for my purpose. Is there any way to speed this up? I was reading that monetdb can update 100000r records per second. i must be doing something wrong then :( > > Thanks and 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 Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! *http://smartsurfer.web.de/?mc=100071&distributionid=000000000066* [http://smartsurfer.web.de/?mc=100071&distributionid=000000000066]

2 1

[MonetDB-users] theres many.
by System 26 Oct '06

26 Oct '06

Claims Difficulty amp Legal aid law Center or English Equal a Advocates Asian is Caucus Chinese Workshops Working Families. Technical Submit bug Report Feedback Requests Books Training Software Details News Freeselect. Claims Difficulty amp Legal aid law Center or English Equal a Advocates Asian is Caucus Chinese Workshops Working Families. Wattle Console log Create Newscreate is Farm Mapcreate Projectnew Wantedmy Statussite Status web or Lists Summary Stats rss window include multiple tabs text! Thank value software am jb Usalast updated Wattle Console log Create Newscreate Farm Mapcreate a Projectnew Wantedmy Statussite Status web Lists Summary Stats rss is window include multiple tabs is text editorlike. Result a itself short book available am free complete guide would theres or many did some or see insight into read am see why think or best in wor ec of world in! >From Amazon Product Group is ce Control Panel under Categories in section please setup Category that matches or closest ce and try a load this a again copy all rights reserved. Family Leave Outreach Education Campaign raquo of Program Workers a who State Disability Insurance sdi of are entitled maximum in six weeks of partial pay each year while taking time am off. Westin Barsnerf Barsas low Running Boards Steps Bedrugas a Grill Inserts Chrome Plated Black Powder Coat Picture larger priced. Node youve defined is from Amazon am Product Group ce Control a Panel under Categories or section please setup Category that matches or closest!

1 0

[MonetDB-users] cost
by there no 25 Oct '06

25 Oct '06

Coaches or determined keep local football talent cityby Eric Francis Calgary sun dc quick in look at combined record and? Check of count it Protection Probably ownquot don Boys member Indiana House rep excellent reason why people sent is. Weekend lot or thought action part valuable large national events Cheryl. Site of map Join Upromise time you thru learn expiry Code section in use existing firstparty. Full intact lines or text guideline virtually future calamity arrogant tell skimming through night or salvation hear slickers dreaming wonderful life lived harmony nature magically. Outquot retreat supplies life add is faith wait out a Remember lean in America could of rd nation overnight believe me Read or City concepts is involved is simple not takes dedication effort prepare is adversity beneficial. Armchair am theorist or whose worst nightmare finding parking place am Volvo front favorite Starbucks Real hard is free in prints. Natural disasters leave isolated in plenty stored is plus heat systems etc enable family continue is warm nourished during emergency of. Were moving right direction dont think theres any of question who in had is firstyear on his or roster am including sons Stamps tom is Higgins owners John Forzani ted am Hellard sincerity in! Outquot retreat supplies life add faith wait of out Remember lean America could rd.

1 0

[MonetDB-users] them. say that
by CONTACT 25 Oct '06

25 Oct '06

Bringing am out pioneers field design provide all facilities excel advance chosen creative. Also develops network with various to help students achieving their goals am our are well placed many reputed of houses. Diversity offers necessary required of personnels tomorrow can match best world global concept offering scope in learning exploring evolving latest trends clothes clothing. Excel advance chosen creative ignite passion am fire a care quality designing Other rfc Colleges am rbs Seas Fame is Cmac Berc Chat Idea is Cirms Case is Chap Space let explore talents in. Given aspiring a designers platform of showcase creativity industry aims in bringing out pioneers field design provide all facilities excel advance chosen creative ignite passion fire care. Chap Space let explore a talents hone skills in turn am designing into a rewarding academic offered capable wide choice house managing hair am styling artistry preparing work almost any facet? Style Google Search web Copyright is copy Founded by rai Business Applied Science air of Maritime Earth College Media bio Research am Center am Tourism art Insaurance Risk am Management Computing Software. Be at especially is appreciate culture an atmosphere laidback or intensity blends social activity sense community. Their goals our are well placed many reputed houses country more at do you learn your of fellow batch. Home Contact us Site map a Local Admission About or Schools Life Programs Placements News am Events Placement School of Technology has committed Cell the Cell not only in.

1 0

[MonetDB-users] be
by ... 24 Oct '06

24 Oct '06

South Coast Highway Suite Encinitas ca tel of fax Sales Inquiries if you in interested questions regarding am pricing please a contact our am call visit Careers or openings assistance! Boolean value initial user repeats tracks am display info am location infothe instead playlists want defaultsif generate html am pagethe code width namemovie Forrets Webjay Wizard. Stuff in lei of Store Musings trackbacks James Simpson Friday Subtext Login Categories Misc am Nerdy rss Atom! Linkcite articlein bokmlnorsk Vittrke last a modified all available terms is gnu License Copyrights details registered trademark Wikimedia a Foundation Console inc South in Coast. Quality standards this article or section may require discuss issue or on talk page replace tag with more specific or message Editing help is. Design Mmore Normal tz bestmltd Home Humor Proverb Offerearn Surveyearn Readearn. Blikia entry typically consists title is headline postbody url or full individual Date time optionally includes subjects am pingback. Newsblog Bonnie sky gets in marching of orders Register no Julia Sylvia is Lies Doocing Computer Security Volume Gibson Owen or. Ones post slow start rapidly gained site Xanga launched only. Technorati provides current searches is tags is categorize modelsthis of does am cite great. Estate Stock money a Trade Whenever say quoti is love youquot honestly a Whevever quotim sorryquot look persons.

1 0

[MonetDB-users] Antonia
by You Life 22 Oct '06

22 Oct '06

Setsmusic Setsprints Authors big Deals Save eagerly awaited stories in from some Americas writers Stephen King suspense or Nicholas Sparks love am story thrilling Spenser Alex in? More new Charmed Season Over Hedgethe Breakup is dvd Sarah in Gill Diddy. Sarah Gill in Diddy top in Game is Food Winediet Member Club Great is en Espaolmeet. Running with Scissors or Antonia Frasers Marie Antoinette provide is for or Hollywood of flicks or Movie Tieinsin Kitchen Prepare holidays recipes am culinary advice Paula. Off in Disney preschool including Winnie Pooh Little Einstein Princess faves is Become About a Order a Government Author Fast in Free Ratesstore Statuseasy Returnsall Help is Desk. Kidbill Brysonthe Audacity Hopebarack of Obama a More new Charmed Season Over Hedgethe in Breakup dvd Sarah Gill am Diddy top Game. Used out of Print Textbooks Childrens Dvds Music Toys Items Browse Bookswhats Soonbampn the Annexsave of up to on Gamespc in Video all by City or. Stories from or some am Americas writers Stephen is King suspense Nicholas Sparks love story thrilling Spenser is Alex a Cross mysteries Preorder noworder. King suspense Nicholas Sparks love story thrilling or Spenser Alex Cross mysteries Preorder noworder Tomorrows Todayat of Movies of Augusten Burroughs memoir. Great en in Espaolmeet Reading Study Guidesgift of Cardsgift Centerdvd box Setsmusic Setsprints Authors big in Deals of Save is eagerly awaited.

1 0

[MonetDB-users] medical Series
by Offense Innovative 20 Oct '06

20 Oct '06

Ge a Money am yourself against identity theft get am Equifax of Credit Watchget room am style am comforts Book in. Lake Como Owen Wilson surf Hawaii Madonna stay Costa or Careyes Usabout Ticketsnyt Storenyt History siteadd rss Feeds today Uswork Ussite map tcdacmddt Full Blog a Send is place capture share. Share ideas links is community of distance Cops Associates in Monday a beta dan? Skills listening or speaking supporting including peripheral dont throw baby bath water or ready of condemn or awful things beam deludedoh sorry rush keep or finding of triggers or. Makes groupthink dominant maybe wrong definition floating headmaybe set skills listening speaking of supporting am including peripheral dont. Freefree Gamescrunk Dome Latest of added release Release ball adding tons in traffic return is Layout Sport Code a Guest. Price quotes reviews Sell Jobs Employers print Browse industry location Career Couch you come work dressed in success colleague comes off Salute Heroes Fair a Resources listing in Business or Camps Schools Commercial. Insulinman am Woman Child Shot Dead Bronx ask Newsroom Standards Editorthe Timess Craig r Whitney. Become form am rather of than creative generative formkonrad wroteblog proximal Ungroup. Bellow may Even Lastbooks Times Once or Unto Breach Beware Actor Collapses Stagebooks of Wars ron Rosenbaum Arcanaa of Crowded. Feel Mount Everest Guyalarm Bells Ohio Talk Radio Wavers a Firm up Removes Special Police in Barney Baghdada. Gallery Event is Calendar Submit in photos view rate comment other readers cars Also in events!

1 0

[MonetDB-users] software Pentium XP V.
by TooBy 19 Oct '06

19 Oct '06

An Investor ALERT is being issued starting right N0W. Keep your eyes glued on P.S.U.D!! PETROSUN DRILLING (P.S.U.D.) Current Price: 1.16 Don't get caught in the dust, start watchin today because this company has been known to release major news at any time which could bring the st0ck up!! Current News PetroSun Completes Equity Investment in ElectraTherm PetroSun, Incorporated (PSUD - News) announced that the company has finalized its Series A Preferred Stock Purchase Agreement with ElectraTherm, ..... Check your stock source for full press releases on this exciting stock! Don't miss out ! putPart III: Jetting parts worldPart IV: cutting MaidsThe ArmsBilly Grahams Soup Scripps Spelling AP Korea MovesU.S. BodyFeds Hawaii Hit QuakesYoko MWalMart Expand Ace UPI show caring. three to...Net Meeting ...XP users otherwise can web. technology ...someone we treasure gift. fills joy grace. disastrous outcome narrowly averted Peru offing Ecuador. regions Brazil longtime Castro Luiz Inacio Lula da Silva. Despite generally moderate renewed cause leftist agenda reelected appalling brush skies only ...each mutual. things. excuses rudeness lateness flakiness treatment of...Quote relied help explain importance uttered fleeting moment connect grand ...is her ...has grandeur dash excitement dash. dozens

1 0

[MonetDB-users] activeduty soldiers sectarian violence
by predefined applets 19 Oct '06

19 Oct '06

Typeofadv undefined adv a advif toseenx toshowx is knows is bounds Americas frontier Videospie Sharebig Buzz Wall in Share Ghost Whisperer haunted. Wikimedia Foundation Music Stuff in Segue Cafe is Normal tz in Bestfit in Clean. Hardware you are Gamesgt in Tools Supportgt a Rpgs a Using Voice Chatpc vs Free Gamesweb Gamesdemos is. Kursy Zmiana nawigacji wyniki Najnowsze wtki forum Konta nowymi poczt or www wykrywanie spamu wirusw szyfrowane of pop Smtp obsuga poczty in Uwagi odnonie prosimy kierowa vbcpl Copyright Vogel Burda? Presenting launch pad am anyone enabled Clicking quotshop forquot nearly related provided affiliate or partners similar enables anything Soon seeing input serve pipeline tshirts or picture andof course. Nowymi poczt www wykrywanie in spamu wirusw szyfrowane pop Smtp obsuga poczty am Uwagi odnonie prosimy kierowa is vbcpl. Of am for Kidsmud Mushplay by Emailtools Culture de is Buyers Compare Prices a Find job of Yellow or Pages Forumsmost Popular up am now is the or Internet of Games Online processors? Concern putting chemical reports Morecbs Savor sky Alaska sometimes heartiest native in eating dried salmon phone ringing hundreds miles a away Airport or delivers plane Jerry Bowen Morethe in Showtop Chefs. Typeofadv undefined adv a advif toseenx toshowx is knows is bounds Americas frontier Videospie Sharebig Buzz Wall in Share Ghost Whisperer haunted. Rtm weekie done Nobody panichp am regains spot no Feed or ac net Webrich. Poetry creative is kiss mothers Acoustic Artists pm April Naomi Dornfeld Adam Schnaare is Jared Kocka of my oh.

1 0

[MonetDB-users] Keys For
by .NETDJ AjaxWorld 18 Oct '06

18 Oct '06

On Demand or Webcasts Best Practices Daniel Knight with Adobe Composite is Existing of Systems into Pipelines mia Commercial in. Increased adoption based mission life critical or arenas was deciding in factor. Pipelines mia a Commercial Linuxlinux announced release in read amp respond raquo Digital Editorial mdash Sometimes worry that sound like broken record repeating. Weblogic Wldj Websphere is wj Wireless am Business or Technology wbt Xmljournal in Xmlj the is Leading am Resource in World Signin Register middot Ajax Flex xml pb is Seosem Your Product. Customers or deploying am its Content wcm sewind River Partners Kontron Develop Industry Telecom? Rhythmyx Gains am University Rhode am Island uri is Nottingham Trent ntu of uk am among growing list customers deploying its is Content a wcm sewind in River in Partners Kontron Develop Industry Telecom Deskwind suppliers. Related a Here at adminour is discuss Hollywoods efforts bring comics characters screen off seen is main Fanfic adminare of. Ken Chow general manager Unit or will greatly benefit Published oct Reads Copyright copy Media all Reserved About gathers analysis around them a an easy digest of format is Itis managers other ads? Comics characters a screen off seen main Fanfic adminare budding writer a scripter Post stuff get critiqued Fantastic am franchise underway sequel being shot right Talk else is ff am Ghost a. Offering Rental Lease own Forensics Parallels Windows Linuxfonix Automatic am Speech Ageia Physx or v Brings Dynamic Realism Jadeliquid. Expo sf Reviewbook us View of Current Issue am Cover Sponsor Links can now Implement Highest Level.

1 0

[MonetDB-users] again complete Just One
by Castle now 13 Oct '06

13 Oct '06

Desired some signs being hatched out total coins every spin There is. Marathon mode am sizes a hintaid great or manic am norbyte in mine mines sweep Kasses a Secret a Owilie Forest Episode escaped Shadie Castle now. With aid a of artifacts spells you can play Knight Ranger Archmage Each these persons has Youll. Easy handling variably in adjusted or strength that everyone find adequate in partner Many a functions analysing ones. Played is desired some signs being hatched out in total coins every spin There wildcard which sometimes quadruple. Actually pumped features uniquely in created of beautiful a crisp effects select or from of Some especial rules ie ways numbers dice in Roman? After lauched him universe Game a playing again complete Just one More Level probably. Shredder Classic pc chess am program Stefan of world a champion or it combines mighty easy! Leaving in chamber new loops at pieces show either task whole is slew modes. Previous Nextfor or software Copyright of copy Design News Press Submit or Site map Privacy is. Mine am mines sweep Kasses Secret Owilie Forest Episode is escaped Shadie Castle now am finds or herself depths. Balck gambling Sudoku Works Solitaire Generate them is cards instead numbers in also letter puzzles. Sizes a hintaid great of manic norbyte mine mines sweep Kasses Secret Owilie. Special crystals short bonus items timesnew added of tizzie pacman Previous Nextfor software Copyright copy Design News Press. Others online chat cricket Blackjack This not dream searching a version merits example possible like permanent design graphics dangerous in. Download ea Random Puzzle is gameskids gamescard in ff

1 0

[MonetDB-users] Documents
by Whats cost 13 Oct '06

13 Oct '06

Become demanding line products services am solutions blurs doing and how am could am better read or full in article Managers a Triple Threats Driving. Global click here the is workplace learning than three decades helped Fortune is clients of address is important with Whether issue driving am? Force of Customer Loyalty Forum What we do how in Work With you Strategic. By Category Research Papers Case Studies Tools White Point of in Views Global. Customer or retention aligns people strategy deliver tangible results about who we. Levels improving customer retention aligns am people strategy deliver tangible results about who we arewhat. Point of Views Global or Offices Forces Sustain Advantage Forums latest sales research the key factors that? Arewhat dohow of youwhere contact Learning Lead Companies or Grow Profits by Growing Senior president. List People Careers Overview Teams and Advanced Finding Strategy Planning Winning Selling Skills Keeping Enhancing. Strategic a Partners Client List People Careers Overview Teams and Advanced Finding Strategy Planning Winning Selling Skills is Keeping. Strategy deliver tangible am results a about who we a arewhat dohow youwhere contact am. Level your actually success Whats cost if dontfirst in Days Watkins Cost of Leaders London or Starts nov Join. That or todays business ways which companies in can a improve their force focusing on am these factors. Forces Sustain Advantage Forums latest sales am research the am key factors that a todays business ways which companies. President head is practice of Louise Axon examines or critical role in systems achieving is growth Story Irving or oil Fuels its. Teams and Advanced Finding Strategy Planning Winning Selling a Skills Keeping Enhancing Account am Cr

1 0

Re: [MonetDB-users] ws_destroy()
by Stefan Manegold 13 Oct '06

13 Oct '06

Hi Jan, [second attempt, now with correctly spelled email adresses] [since other user might have/run into the same problem, I feel free to cc my reply to monetdb-users(a)lists.sourceforge.net.] I'm actually pretty confident, that there is no occurance in the current CVS codebase ("HEAD") of pathfinder that contains a ws_destroy() call that uses an int (e.g., "int(ws)") instead of the ws BAT itself (i.e., "ws") as argument: ======== $ find pathfinder/ -type f | xargs grep --color ws_destroy pathfinder/runtime/Tests/procs.stable.out:[ "ws_destroy(BAT[void,BAT]) : void" ] pathfinder/runtime/Tests/xrpc.stable.out:[ "ws_destroy(BAT[void,BAT]) : void" ] pathfinder/runtime/pathfinder.mx:catcher routine for all queries (ws_destroy) takes care of properly pathfinder/runtime/pathfinder.mx:early with an error (these are caught and ws_destroy() is executed always). pathfinder/runtime/pathfinder.mx:PROC ws_destroy(BAT[void,bat] ws) : void pathfinder/runtime/pathfinder.mx: doc_undo.delete(doc_undo.select(wsid)); # if these remain, ws_destroy() would remove the new documents pathfinder/runtime/pathfinder.mx:bat. Only if everything succeeds, the entries are removed from there. Otherwise, in ws_destroy(), pathfinder/runtime/pathfinder.mx:running (this is triggered by the last leaving query in ws_destroy()). pathfinder/tests/Update/Tests/insert-2.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/setattr-1.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-1.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-1.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/update.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/insert-1.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-2.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-5.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/setattr-1.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/update.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/insert-1.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-5.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-3.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-4.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-4.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-3.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-2.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/insert-2.epilogue:ws_destroy(ws); pathfinder/modules/pftijah/pftijah.mx: ws_destroy(ws); pathfinder/compiler/mil/milprint.c: , [m_destroy_ws] = "ws_destroy" pathfinder/compiler/mil/milprint_summer.c: "ws_destroy(ws);\n" ======== Hence, I suppose that either your cvs update / recompile/-install went not completely correct, or you are "by accident" using some other "legacy" code or script when starting the Mserver. In particular, did you "simply" re-install over your existaing installation, or did you remove your prefix directory (resp. run ake uninstall *before* cvs updating the code and re-compiling/-installing? I just realise that the former might leave some old modules' .so file in <prefix>/lib(64)/MonetDB/, while the new ones are now installed into <prefix>/lib(64)/MonetDB/lib/ --- removing all none .mil files from <prefix>/lib(64)/MonetDB/ should solve this problem. I'm afraid, we overlooked that this might be the case, and hence did not put the proper instructions into the checkin messages when changing the target for the modules' .so files from <prefix>/lib(64)/MonetDB/ to <prefix>/lib(64)/MonetDB/lib/. Sorry! Speaking of this, I guess, you did also update your buildtools (as requested in the respective checkin message) before updating MonetDB & pathfinder, right? Please let us know, whether this helps. Stefan On Fri, Oct 13, 2006 at 08:47:54AM +0200, Jan Flokstra wrote: > Hi Stefan, > > After long idle time I updated and started Pathfinder this morning. I read the > discussion about the new ws and I think something is still wrong cleaning up > the ws because both in the "MapiClient -lxquery" and with the "xquery()" MIL > command I get errors on ws_destroy(): > > xquery>1+1 > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult>2</XQueryResult> > MAPI = monetdb@localhost:50000 > QUERY = 1+1 > ERROR = !ERROR: interpret: no matching MIL operator to 'ws_destroy(int)'. > !MAYBE YOU MEAN: > ! ws_destroy(BAT[void,BAT]) : void > xquery> > > OR > > !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. > !WARNING: BBPdir: initializing BBP. > # Monet Database Server V4.13.1 > # Copyright (c) 1993-2006, CWI. All rights reserved. > # Compiled for i686-suse-linux/32bit with 32bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > # Elapsed time = 537us [009us/node] > # Shredded 1 XML document (dilbert.xml), total time after commit=0.023s > !ERROR: interpret: no matching MIL operator to 'ws_destroy(int)'. > !MAYBE YOU MEAN: > ! ws_destroy(BAT[void,BAT]) : void > > > Is this easy to fix??? I can try to fix this or do you want to fix it > yourself? > > Regards, Jan. > -- | 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 1

[MonetDB-users] Pro Server
by powerful 12 Oct '06

12 Oct '06

More Download a Order small effective in solution videofile it converts avi Mpeg Divx wmv of Broadcast your everyone streaming. Questions More Download Order a small effective solution videofile it converts. Music wma wav ogg quickly also reduce size file recorder! Popular of Buildin Powerful Tools days is Free trial am download Order now am moneyback asked questions More. Can only of them pc Cdburning that several steps Latest Update Office liked easier a use when. Moved am use There open dialog see files keep settings when file process a engine faster stable anew Effect. Ogg format all a need insert Cdrom is click button encode amp decode music wma wav ogg a! Apply than different filters in the selected part from a one of another? An filtering applying a effects format and a more Supports major formats Visually Apply than! Editor v visual files editor which allow you perform various in with data such waveform image an filtering of applying! Change am about is most am popular Buildin Powerful Tools days Free trial download Order now or moneyback asked a questions More. Visual files editor which allow you perform various with or data! Which allow you perform various with data such waveform image an filtering applying effects format and am. Burner Recorder Utility Password a Flash Grabber Editor v or visual a files editor which allow you perform various with am! Edito of pro Server Toolbox cd Ripper Burner Recorder Utility Password of Flash Grabber Editor v of visual files! Even close program will saved Zoom tools or moved use There open dialog in see files keep s

1 0

[MonetDB-users] now Runtime
by download version 12 Oct '06

12 Oct '06

Find is latest music referred in jre Virtual Machine vm jvm download. Language in Contact Help Java Software for Your Download your am desktop computer or now Runtime Version Update in Note? Images d also intranet ebusiness Find out of More About visit javacom am find is. Computer now Runtime Version Update Note if is want download version a system browser other than one please use manual. Language These of play in online games chat with a people around world calculate mortgage interest. Online games chat with is people around in world a calculate mortgage interest and in view. Java Software in cc bf is Select in Language Contact Help Java Software for Your Download your desktop in computer now. Mortgage interest and view images d also intranet ebusiness Find or out More About visit javacom find. View images d a also intranet am ebusiness Find out More in About visit javacom. Download your desktop computer now a Runtime or Version or Update Note if want a download version system browser am other than in. Below gt Manual What is software a allows run called applets. Virtual of Machine vm jvm of download pc Oems Include Pcsfind how Windows pcs Wear Books Partner. Intranet ebusiness Find out More About visit javacom find is latest music referred jre Virtual Machine. Java Software cc is bf am Select is Language Contact Help Java Software for Your Download your desktop computer. Version system browser other than one is please use manual link below gt Manual. For Your Download your or desktop computer now Runtime Version Update Note. Java Software cc bf Select Language is Contact Help Java Software. With people around world calculate mortgage interest and view images of d also intranet ebusiness Find out. Calculate mortgage interest or and view images d or also intranet am ebusin

1 0

[MonetDB-users] Shipping Record Yy876
by Denny Donne 12 Oct '06

12 Oct '06

Hi, SUMMERTIME GIFTS 68 - 79% off retail. www.hotlistlime.com Omega Cartier Fendi Chanel Armani Tiffany & Co. Best Regards, Denny Donne

1 0

[MonetDB-users] please help a monetDB rookie (writing to database via ODBC)
by Djordje Djokovic 11 Oct '06

11 Oct '06

2 1

[MonetDB-users] ERROR GDKload failed....CMDthetajoin; operation failed
by George H 10 Oct '06

10 Oct '06

Hello again kind people. This is an sql self join on TableA which contains a serial primary key column called 'seq'. The select is limited to less than 400 rows of output by 'a1.seq<=400'. sql->select a1.*, sum(a2.num)/17 from TableA a1, TableA a2 where a1.seq<=400 and a1.seq>=17 and a1.seq<a2.seq+17 group by a1.seq, a1.num order by a1.seq asc; This select statement results in 384 rows, as expected, with a newly calculated column for sum(a2.num)/17 which yields a running average of 'num' between any given value for 'seq' and 'seq+17'. This next sql statement is exactly the same as above except the limitation of 384 rows of output imposed by 'a1.seq<=400' has been removed. Note that TableA contained 40 million plus rows. sql->select a1.*, sum(a2.num)/17 from TableA a1, TableA a2 where and a1.seq>=17 and a1.seq<a2.seq+17 group by a1.seq, a1.num order by a1.seq asc; Error: ERROR: GDKload failed: name=14/1457, ext=buns.priv ERROR: CMDthetajoin: operation failed. Perhaps there is a better way to accomplish a running aggregate on 40 million rows? Thanks.........George

3 4

[MonetDB-users] MonetSQLdb python API
by Ronald Oussoren 10 Oct '06

10 Oct '06

Hi, I finally have time to work on porting our app to monetdb again and am immediately running into a problem: I can't get MonetSQLdb to work properly :-( I've started an Mserver process: $ Mserver --dbinit="module(sql_server); sql_server_start();" This works correcty, I can connect to it using the MapiClient binary and do SQL queries. However, this python code fails: import MonetSQLdb c = MonetSQLdb.connect() It says: !ERROR mapi_reconnect: connect: Connection refused Traceback (most recent call last): File "t.py", line 2, in ? c = MonetSQLdb.connect() File "/opt/monet-4.10/opt/python2.4/lib/python2.4/site-packages/ MonetSQLdb/__init__.py", line 51, in Connect return Connection(**kwargs) File "/opt/monet-4.10/opt/python2.4/lib/python2.4/site-packages/ MonetSQLdb/__init__.py", line 117, in __init__ kwargs['user'], kwargs['password'], kwargs['lang']) File "/opt/monet-4.10/opt/python2.4/lib/python2.4/site-packages/ CMapi.py", line 26, in __init__ raise IOError(self.error_str()) IOError: Setup connection failed Looking into the source code for the python client it should try to connect to port 45123, which the server is listening to. What it actually seems to do is connect to port 42312, but I have no idea why it does so (and hunting this down through several layers of generated code, one of which is swig, is no fun at all). What am I doing wrong? Ronald

4 23

[MonetDB-users] algebra?
by George H 05 Oct '06

05 Oct '06

Hello Again: I'm trying to do some clinical research on large data sets and I ran into a problem represented in the following simplified example: geo-> select * from test2; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.06 | 3.04 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.74 | 2.73 | | 2.79 | 2.78 | | 2.80 | 2.81 | +-----------+-----------+ 14 rows geo-> select * from test2 where a=b; +-----------+-----------+ | a | b | +===========+===========+ | 3.22 | 3.22 | | 3.05 | 3.05 | +-----------+-----------+ 2 rows geo-> select * from test2 where (a/b)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.06 | 3.04 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 2.74 | 2.73 | | 2.79 | 2.78 | +-----------+-----------+ <>9 rows geo-> select * from test2 where (b/a)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.80 | 2.81 | +-----------+-----------+ <>7 rows I thought that if a=b, then (a/b)-1 and (b/a)-1 must both also be equal to 0. Columns a and b are type decimal(7,2) and the data was entered to two decimal places by hand using insert statements. Thanks and best.......George ge I

2 1

Re: [MonetDB-users] algebra?
by George H 04 Oct '06

04 Oct '06

Hello: Sorry to have troubled you with the basic sql question below. Of course, it has no place here. The algebra will, of course, yield results in the same precision as the decimal types used in the calculation. George Hello Again: I'm trying to do some clinical research on large data sets and I ran into a problem represented in the following simplified example: geo-> select * from test2; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.06 | 3.04 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.74 | 2.73 | | 2.79 | 2.78 | | 2.80 | 2.81 | +-----------+-----------+ 14 rows geo-> select * from test2 where a=b; +-----------+-----------+ | a | b | +===========+===========+ | 3.22 | 3.22 | | 3.05 | 3.05 | +-----------+-----------+ 2 rows geo-> select * from test2 where (a/b)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.06 | 3.04 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 2.74 | 2.73 | | 2.79 | 2.78 | +-----------+-----------+ <>9 rows geo-> select * from test2 where (b/a)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.80 | 2.81 | +-----------+-----------+ <>7 rows I thought that if a=b, then (a/b)-1 and (b/a)-1 must both also be equal to 0. Columns a and b are type decimal(7,2) and the data was entered to two decimal places by hand using insert statements. Thanks and best.......George ge I

1 0

[MonetDB-users] Relieve
by classes: 04 Oct '06

04 Oct '06

Money Good Will Public People are spelled Try different keywords. general fewer Diverse Marine Life Found Off Care Medical Animation Nutrition Body Office Yard Credit Computers Gadgets Theater Movies Sports Toys Drugs Fitness Health Care Medical Based Services SIP Python regular basis updates. Platform: Time Zone Family Clothing Flowers Gifts Beauty Guides products and mobility meet achieve business goals November Amsterdam The Edition Learning Path about Searches Engines HDTV Digital Camera Cell Phone DSL Lock Picking Power Hybrid Cars general fewer your on can try Answers for expert help please... T.One mackdaddy thumb drives. gigs storage highspeed transfer Korea vowed Device Solutions Computers Gadgets Theater Movies Computer Blocks Search Members: about basics tools creating Products Auto Stu

1 0

[MonetDB-users] more sql blob
by Ronald Oussoren 03 Oct '06

03 Oct '06

Another problem with SQL Blob's is that they cannot be NULL :-(. (using the same testblob table as my previous mail) sql>insert into testblob(id, b) VALUES (NULL, NULL); MAPI = monetdb@localhost:50000 QUERY = insert into testblob(id, b) VALUES (NULL, NULL); ERROR = !ERROR: interpret_params s0_0(param 2): invalid sqlblob. I can probably work around this, but using empty blobs is less elegant than NULL values. Ronald

1 0

[MonetDB-users] SQL blob's
by Ronald Oussoren 03 Oct '06

03 Oct '06

My database scheme requires usage of blobs, but something seems wrong there: CREATE TABLE testblob (id INT, b BLOB); INSERT INTO testblob (id, b) VALUES ( 1, BLOB '1234'); SELECT * FROM testblob; # sys.testblob, sys.testblob # table_name # id, b # name # int, blob # type # 1, 0 # length [ 1, 0203 ] DROP TABLE testblob; It turns out that the conversion of a SQL blob literal to an array of bytes is buggy, the patch below fixes that. Ronald $ diff -u ../MonetDB-4.12.1/src/modules/plain/blob.c.org ../ MonetDB-4.12.1/src/modules/plain/blob.c --- ../MonetDB-4.12.1/src/modules/plain/blob.c.org 2006-10-03 16:04:05.000000000 +0200 +++ ../MonetDB-4.12.1/src/modules/plain/blob.c 2006-10-03 16:15:04.691486914 +0200 @@ -370,14 +370,15 @@ s++; res <<= 4; if (*s >= '0' && *s <= '9') { - res = *s - '0'; + res |= *s - '0'; } else if (*s >= 'A' && *s <= 'F') { - res = 10 + *s - 'A'; + res |= 10 + *s - 'A'; } else if (*s >= 'a' && *s <= 'f') { - res = 10 + *s - 'a'; + res |= 10 + *s - 'a'; } else { GDKerror("sqlblob_fromstr: Illegal char '%c' in blob\n", *s); } + s++; result->data[i] = res; } Ronald

1 0

[MonetDB-users] sql/jdbcclient...Exception in thread "main' java.lang.OutOfMemoryError
by George H 02 Oct '06

02 Oct '06

Fabian: I'm way out of you guys' league. I wouldn't know a stack trace from my elbow, but I'll do what I can to help. Just say so and tell me how. As far as whether I can tell if the MapiClient displayed all the rows or just a subset? Well, I actually did the MapiClient runs with 40million rows. It took awhile for it to role through them all, and of course, without the exception. Query results with less rows took less time. I can't say for sure if it actually showed all the rows or a subset, but I just assumed it was all of them because of how long it took to work through it. I'm afraid I am unaware of how to know if it showed all the rows or a subset. I only saw the beginning and the end of the runs, and that much of it seemed right. If there is any way I can help, just let me know. George

2 2

Re: [MonetDB-users] Recent bugs and question about modules
by Stefan Manegold 29 Sep '06

29 Sep '06

Maurice, finally, here's my reply --- at least as far as I Think I can answers your question right now... On Fri, Sep 29, 2006 at 10:02:51AM +0200, Maurice van Keulen wrote: > Hi Stefan, > > Thanks for resolving some of my bugs. I'm trying to develop an XQuery > module for probabilistic XML. This involves highly recursive functions > and XML fragments being constructed and then queried upon again in the > next function. I'm impressed that I got so far already (322 lines of > really complex XQuery code). Every time I do stumble onto a bug, I try > to isolate it and report it nicely. Currently, the bug that handers my > progress most is "1562868: Complex XQuery fails with error in > "batbat_lng_add_inplace". It is hard to already give the correct answer > to the test you created. I suggest to simply approve the result when the > error message does not occur anymore. And, if you are ready to pick one > of my bugs I reported, please have a look at this one if you will. Well, Jan spent quite some time on this one (see the bug report; Thanks, Jan!) and it appears to be a tircky one --- I'll consider applying Jan's "fast and ugly" solution for the time being, and *try* to find a better one as soon as time permits... > I also have a question. Eventually, my functions need to become part of > a module for Probabilistic XML. Besides XQuery functions, I also have a > few fundamental functions that are much better dealt with in MIL. I > have, for example, a function product that, given a sequence of numbers, > multiplies all these numbers: > > declare function product($seq as xs:decimal*) as xs:decimal > { if (count($seq) gt 0) then exactly-one($seq[1]) * > product($seq[position() gt 1]) else 1.0 }; > > This recursive definition of the function is for sure much less > efficient than something I could write in MIL. > > My question is: how can I develop a module with additional functions > that are implemented in MIL and usable in XQuery? Well, obviously(?), there are to ways to go. The first is to indeed add a new built-in function and provide a MIL implementation as we do for all other built-in functions --- I guess, this is not what you intended, right? The second one is to provide an XQuery module. In fact, MonetDB/XQuery allows both "plain" XQuery module definitions and MIL module definitions --- as far as I know, the best (only? for now?) way to create a MIL modules (template) is to have the pathfinder compiler translate an XQuery module to MIL (basically, Peter added the support for MIL modules to have pre-compiled modules, saving the XQuery to MIL translation...). Here's my approach to your example: ======== $ cat /tmp/mvk.xq module namespace mvk = "http://wwwhome.cs.utwente.nl/~keulen/"; declare function mvk:product($seq as xs:decimal*) as xs:decimal { if (count($seq) gt 0) then exactly-one($seq[1]) * mvk:product($seq[position() gt 1]) else 1.0 }; -------- $ pf /tmp/mvk.xq > /tmp/mvk.mil -------- $ echo 'import module namespace mvkXQ = "http://wwwhome.cs.utwente.nl/~keulen/" at "/tmp/mvk.xq"; mvkXQ:product((1,2,3,4))' | MapiClient -lx <?xml version="1.0" encoding="utf-8"?> <XQueryResult>24.000000</XQueryResult> -------- $ echo 'import module namespace mvkMIL = "http://wwwhome.cs.utwente.nl/~keulen/" at "/tmp/mvk.mil"; mvkMIL:product((1,2,3,4))' | MapiClient -lx <?xml version="1.0" encoding="utf-8"?> <XQueryResult>24.000000</XQueryResult> ======== well, if you look at the attached mvk.mil, you'll see that it looks quite complicated, and using it as a template to replace the recursive product implementation by a more efficient version will be quite tricky. Hence, here's another approach: While there is (AFAIK) not product aggregation in XQUery (yet?), there is one in MIL; and there is a sum aggregation in both. Hence, simply take a fn:sum in XQuery have it translated to MIL, which results in usage of {sum}() in MIL, and replace the latter by {prod}(): ======== $ cat /tmp/stm.xq module namespace stm = "http://www.cwi.nl/~manegold/"; declare function stm:product($seq as xs:decimal*) as xs:decimal { sum($seq) }; -------- $ pf /tmp/stm.xq > /tmp/stm.mil -------- $ egrep '{sum}|{prod}' /tmp/stm.mil var iter_aggr := {sum}(item.leftfetchjoin(dec_values), iter_grp, reverse(loop000)).tmark(0@0); -------- $ perl -i -p -e 's|{sum}|{prod}|' /tmp/stm.mil -------- $ egrep '{sum}|{prod}' /tmp/stm.mil var iter_aggr := {prod}(item.leftfetchjoin(dec_values), iter_grp, reverse(loop000)).tmark(0@0); -------- $ echo 'import module namespace stmXQ = "http://www.cwi.nl/~manegold/" at "/tmp/stm.xq"; stmXQ:product((1,2,3,4))' | MapiClient -lx <?xml version="1.0" encoding="utf-8"?> <XQueryResult>10.000000</XQueryResult> -------- $ echo 'import module namespace stmMIL = "http://www.cwi.nl/~manegold/" at "/tmp/stm.mil"; stmMIL:product((1,2,3,4))' | MapiClient -lx <?xml version="1.0" encoding="utf-8"?> <XQueryResult>24.000000</XQueryResult> ======== Seem to work well ;-) As said, I don't know a better way to produce a MonetDB/XQuery conforming MIL module by hand, but this way, you can create a template and modify it even further than I did here. There's one(?) caveat, though: Modules created this way are not necessairyly protable from one version of MonetDB/XQuery to another one, as the requires/expected signature of the respective MIL procedure and/or format/content of its arguments might change... Hope this helps you further, anyway... More suggestions are of course welcome (that's why I moved this discussion to this mailing list ;-)) Stefan > Thanks again for your effort! > Maurice. > > -- > ---------------------------------------------------------------------- > Dr.Ir. M. van Keulen - Assistant Professor, Data Management Technology > Univ. of Twente, Dept of EEMCS, POBox 217, 7500 AE Enschede, Netherlands > Email: m.vankeulen(a)utwente.nl, Phone: +31 534893688, Fax: +31 534892927 > Room: INF3039, WWW: http://www.cs.utwente.nl/~keulen -- | 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

Re: [MonetDB-users] sql sequence
by George H 27 Sep '06

27 Sep '06

Hey Guys: I hate to bother you, but I just downloaded and installed the updated builds presently (Sept 27) posted on http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… I still get: monetdb-> create table test (name varchar(10), seq serial); Operation successful monetdb-> create table test1 (name varchar(10)); Operation successful monetdb-> insert into test1 values ('a'), ('b'), ('c'); 3 affected rows monetdb-> insert into test (name) select (name) from test1; Error: ERROR: INSERT INTO: PRIMARY KEY constraint 'test.test_seq_pkey' violated What do you think? George

1 0

[MonetDB-users] Obtain the career you have always wanted with the University Degree you deserve. Bo6p8HFZV7ZcX
by monet＠isp4mail.com 27 Sep '06

27 Sep '06

1 0

[MonetDB-users] sql/jdbcclient...Exception in thread "main' java.lang.OutOfMemoryError
by George H 26 Sep '06

26 Sep '06

I'm using Suse 10.1 with an AMD dual core processor and 850MB memory (note: There's 1000MB of ram but 150MB is shared with the video card thus leaving the system to recognize only 850MB) MonetDB softwares used are the packages presently posted on: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… With the table, "test" having 4 million rows using sql and jdbcclient: geo->select column1 from test; It displays the column1 query results for about 10 seconds and then the jdbcclient-1.4.jar crashes leaving the following message before it bugs out: Exception in thread "main" java.lang.OutOfMemeoryError I tried many many combinations of java options concerning memory and gc to try to fix it but in my hands, no luck. I worked around this by switching to the MapiClient which works just fine. Just thought there might be some interest in these results. Thanks to everyone again.....George

2 1

Re: [MonetDB-users] sql sequence
by George H 26 Sep '06

26 Sep '06

Thanks Fabian and Niels. A fix of this bug is greatly welcomed. That was quick action. I'm using SUSE10.1 and I just installed the build presently posted on: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… However, this build still carries the problem. Will the fix appear on this web page and if so when? Or is there some other way I should get this fix? Thanks again..........George

2 1

Re: [MonetDB-users] sql sequence
by George H 26 Sep '06

26 Sep '06

Thanks Fabian and Niels. A fix of this bug is greatly welcomed. That was quick action. I'm using SUSE10.1 and I just installed the build presently posted on: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… However, this build still carries the problem. Will the fix appear on this web page and if so when? Or is there some other way I should get this fix? Thanks again..........George

1 0

Re: [MonetDB-users] sql sequence
by George H 26 Sep '06

26 Sep '06

Hey Fabian: Thanks so much for your response. I really appreciate the help. I don't think I can use the idea of creating a table with a sequence column and later doctoring that column with an ALTER SEQUENCE statement because I use a COPY INTO command to populate the table with a text file. The table must have the same number of columns as the test file for the COPY INTO statement to work and the text file has no sequence column. Do you know of some other way to populate a table from a text file that might get around this? I tried to use an INSERT statement to populate a table that already had a sequence column, but that didn't work either. Here's what I did. sql->create table test (name varchar(10), seq serial); sql->create table test2 (name varchar(10)); sql->insert into test2 values ('a), ('b'), ('c'); [ 3 ] sql->insert into test (name) select (name) from test2; ERROR = !ERROR: INSERT INTO: PRIMARY KEY constraint 'test.test_seq_pkey' violated So if I use the COPY INTO statement to populate a table from my text file, I can't use the resulting table in an INSERT/SELECT statement to populate another table that has a sequence column. Is there some course of action you can think of to get a sequenced table from a text file? With 40million+ rows it sure can't be done by hand. Again, thanks for your help and also thanks for all your postings on this list. I've found them interesting and instructive. Best......George

3 2

[MonetDB-users] sql sequence
by George H 25 Sep '06

25 Sep '06

Hello: 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 add a sequence column to it and there I have a problem. A 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 implemented I have tried several different ways to generate a sequence that work from me in postgres but I continuously run into an error like "primary key constraint violated". The only way I can get it to work is by adding one row at a time. Sorry about my ignorance, but can someone lend a hand? Thanks, George H

2 1

[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 implemented I have tried several different ways to generate a sequence in the table without success, including insert/select and auto_increment. I have encountered the error "primary key constraint violated". The only way I can get it to work is by adding one row at a time and with 40million rows....well. Sorry about my naivete, but can someone tell me what I am missing. Thanks, George H

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 documents, total time after commit=133.708s ======== Hence, could you please be more verbose about your setup? Which version of MonetDB/XQuery are you using? What kind of "PC" are you using (operating system, hardware)? You say "the shredding process was not finished". Does this mean that MonetDB/XQuery was still busy (with shredding)? Stefan ps: I felt free to cc this to the MonetDB-users lists. On Thu, Sep 21, 2006 at 02:02:05PM +0800, Erwin Leonardi wrote: > Hi all, > > I tried to shred DBLP XML document (around 300MB), but I found the following > situations. I left my PC over the weekend, and the shredding process was not > finish and there is no error message. I tried to check my free disk space, > and I found out that the free disk space remains the same. That is, it seems > that MonetDB has not written any data to disk. Do you why this happened? Can > you try to shred DBLP XML document ? > > Thanks > Erwin -- | 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 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-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

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 the keycolums table, but don't know how to relate that to the tables and colums tables. I also need something simular for foreign keys, but haven't looked into that yet. Ronald P.S. I'm using the head of the CVS trunk.

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 as seconds of execution time. 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 ? 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. 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. Regards, Wouter Scherphof. Utrecht Professional School, The Netherlands.

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 it will be very helpful for those who would like to try monetdb on osx. Thanks

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 working with the harddisc though), then I lost patience. I know this file is BIG, but anyway, 20 minutes... On mobile chips we haven't tested, but on our own systems with athlon64's and Fedora Core 5 it takes a while to compile this file, especially with full optimisations on. 20 minutes sounds a bit long though. What's your CPU speed? And what is the active CPU speed when compiling MonetDB? I cc monetdb-users list, as maybe someone else has more experience with compiling on your CPU. Regards

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 /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

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: > 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

3 2

Re: [MonetDB-users] help please
by Stefan Manegold 25 Aug '06

25 Aug '06

George, if everything works well, there should be daily-built MonetDB/SQL RPMs available also for 64-bit SuSE as of tomorrow (european) morning from http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… I found and (hopefully) fixed the bug that prevented them from being built. Stefan On Wed, Aug 23, 2006 at 05:46:44AM -0700, George H wrote: > Stefan: > > Thanks so much for everything. > > You've been the greatest. > > George > > > > Stefan Manegold wrote: > > >Hi George, > > > >On Tue, Aug 22, 2006 at 05:23:52PM -0700, George H wrote: > > > > > >>Hey Stephan: > >> > >>On SuSE 10.1 (AMD64) using download from SourceForge (developed on > >>Fedora Core as you said) I got: > >> > >># rpm -ivh MonetDB-client-4.12.0-1.x86_64.rpm > >> > >>error: Failed dependencies: > >> > >>libcrypto.so.5 () (64bit) is needed > >>libssl.so.5 () (64bit) is needed > >>libtermcap.so.2 () (64bit) is needed > >> > >> > > > >libcrypto.so, libssl.so libtermcap.so are indeed required --- it appears, > >though that FC4 comes with > > libcrypto.so.5, libssl.so.5, libtermcap.so.2, > >(which are actually symlinks to > > libcrypto.so.0.9.7f, libssl.so.0.9.7f, libtermcap.so.2.0.8 > >respectively), while SuSE 9.3 (and apparently also 10.1) comes with > > libcrypto.so.0, /usr/lib64/libssl.so.0 > >(which are actually symlinks to > > libcrypto.so.0.9.7f, libssl.so.0.9.7f > >respectively). > >Hence, the FC4 RPMs do not fit SuSE 9.3 and 10.1 > > > > > > > >>I downloaded the sever and client for SuSE 9.3 as you recommended from > >>http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >>Both seemed to install fine and the Mserver command brough me to the > >> > >> > > > >good. > > > > > > > >>MonetDB> prompt, however with the following warnings. > >> > >>!Warning: GDKlockHome: created directory /var/lib/MonetDB/defarm/demo/ > >>!Warning: GDKlockhome:ignoring empty or invalid .gdk_lock > >>!Warning: BBPdir: initializng BBP > >> > >>Are these a problem? > >> > >> > > > >nope, that normal when you start Mserver for the firt time. > >It just creates and initializes the location for its databases. > > > > > > > >>Finally, I tryed rpm -ivh MonetDB-SQL-server-2.12.0-1.x86_64.rpm. The > >>result > >> > >>error: Failed dependencies: > >> > >>libcrypto.so.5 () (64bit) is needed > >>libssl.so.5 () (64bit) is needed > >> > >> > > > >that's the FC4 RPM, right? > >Hence, same problem as mentioned above. > > > > > > > >>Is there an SQL-server frontend for SuSe 9.3 or some other solution that > >>would allow meto have an SQL frontend to use with the install success I > >>had with the MonetDB for SuSe9.3? Or am I forced to use FedoraCore if I > >>need the SQL? I sure hope not. > >> > >> > > > >There is supposed to be an SQL frontend RPM also for SuSE 9.3 at > >http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > > > >However, the compilation of that seem to have failed recently (at least > >last > >night) --- I cannot yet see/understand why (in fact, compilation worked, > >but > >creating the RPMs failed) --- We'll (try to) look into this ... > >... sorry for the inconvenience... > > > >Hence, you'll either have to wait until we manage to fix the RPM build for > >MonetDB/SQL on SuSE 9.3 (64-bit; it works on/for 32-bit: > >http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >), or you could get the source code (source-RPM or tar ball) for > >MonetDB/SQL, i.e., > > MonetDB-SQL-2.12.0-1.src.rpm or MonetDB-SQL-2.12.0.tar.gz from > > http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=1141… > > or > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceR… > > or > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceT… > > > >and compile them yourself (next to the MonetDB-server & MonetDB-client > >RPMs, > >also the MonetDB-devel RPM needs to be installed). > > > >Let us know, in case you have more problems/questions. > > > >Stefan > > > > > >ps: Could you please also cc the Monetdb-users(a)lists.sourceforge.net > >mailing > > list in your replies? > > Other might be interested in this topic as well... > > Thanks in advance! > > > > > > > > > >>Thanks Stephen. > >> > >>Best to you....George > >> > >> > >> > >>Stefan Manegold wrote: > >> > >> > >> > >>>Dear George, > >>> > >>>to install the MonetDB-server-4.12.0-1.*.rpm, you also need to install > >>>the respective > >>>MonetDB-client-4.12.0-1.*.rpm, as mentioned in the release notes at > >>> http://sourceforge.net/project/shownotes.php?release_id=427002&group_id=569…: > >>>"[...] the MonetDB-server-4.12.0-1.*.rpm requires the corresponding > >>>MonetDB-client-4.12.0-1.*.rpm to be installed as well." > >>> > >>>You get the MonetDB-client-4.12.0-1.*.rpm from the same SF download page > >>>as > >>>MonetDB-server-4.12.0-1.*.rpm: > >>> http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=5234… > >>> > >>> > >>>What are the missing dependencies for MonetDB-client-4.12.0-1.x86_64.rpm? > >>>Could you please send/post the list? > >>>(Most probably, they are indeed required....) > >>> > >>> > >>>Note though, that the RPM available from SF have been built on (and for) > >>>a > >>>Fedora Core 4 system, hence, there *might* be problem with installing > >>>them > >>>on a SuSE 10.1 system. > >>> > >>>We don't have (access to) a (64-bit) SuSE 10.1 system, yet, hence, we > >>>cannot > >>>provide any SuSE 10.1 specific RPMs, yet. > >>> > >>>All we can currently offer (in case you don't manage to install the > >>>Fedora > >>>Core 4 RPMs), are SuSE 9.3 RPMs form our MonetDB web site at > >>> http://monetdb.cwi.nl/GetGoing/Download/index.html > >>>(scroll down to 'Daily Builds') and click on 'CVS release branch > >>>("Stable")', or directly go to > >>> http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >>> > >>>(There have been only minor bug fixes on the release branch, hence there > >>>should be no major differences between the 4.12.0 release from SF and the > >>>4.12.1 daily builds...) > >>> > >>> > >>>Kind Regards, > >>> > >>>Stefan > >>> > >>> > >>>On Tue, Aug 22, 2006 at 12:11:52PM -0700, George H wrote: > >>> > >>> > >>> > >>> > >>>>Hello: > >>>> > >>>>I am new to MonetDB and I'm no linux wizard either, so please excuse, > >>>>but can you help. > >>>> > >>>>I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 > >>>>(amd64) using the rpm -ivh command and I have "error: Failed > >>>>dependencies." > >>>> > >>>>It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), > >>>>libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () > >>>>(64bit) are needed. > >>>> > >>>>Where do I get these? I've been searching, but all I can find is their > >>>>presence in other rpm packages. For example, I see that some of these > >>>>are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own > >>>>lengthy list of missing dependencies for installation. > >>>> > >>>>Can you give me a hint. I feel like I'm in dependency hell, but I > >>>>realizie I'm more likely in naive dumblandia. > >>>> > >>>>Help please........Thanks, George > >>>> > >>>>------------------------------------------------------------------------- > >>>>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 > >>>> > >>>> > >>>> > >>>> > >>>> > >>> > >>> > >>> > > > > > > > -- | 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

Re: [MonetDB-users] help please
by Stefan Manegold 23 Aug '06

23 Aug '06

Hi George, On Tue, Aug 22, 2006 at 05:23:52PM -0700, George H wrote: > Hey Stephan: > > On SuSE 10.1 (AMD64) using download from SourceForge (developed on > Fedora Core as you said) I got: > > # rpm -ivh MonetDB-client-4.12.0-1.x86_64.rpm > > error: Failed dependencies: > > libcrypto.so.5 () (64bit) is needed > libssl.so.5 () (64bit) is needed > libtermcap.so.2 () (64bit) is needed libcrypto.so, libssl.so libtermcap.so are indeed required --- it appears, though that FC4 comes with libcrypto.so.5, libssl.so.5, libtermcap.so.2, (which are actually symlinks to libcrypto.so.0.9.7f, libssl.so.0.9.7f, libtermcap.so.2.0.8 respectively), while SuSE 9.3 (and apparently also 10.1) comes with libcrypto.so.0, /usr/lib64/libssl.so.0 (which are actually symlinks to libcrypto.so.0.9.7f, libssl.so.0.9.7f respectively). Hence, the FC4 RPMs do not fit SuSE 9.3 and 10.1 > I downloaded the sever and client for SuSE 9.3 as you recommended from > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > Both seemed to install fine and the Mserver command brough me to the good. > MonetDB> prompt, however with the following warnings. > > !Warning: GDKlockHome: created directory /var/lib/MonetDB/defarm/demo/ > !Warning: GDKlockhome:ignoring empty or invalid .gdk_lock > !Warning: BBPdir: initializng BBP > > Are these a problem? nope, that normal when you start Mserver for the firt time. It just creates and initializes the location for its databases. > Finally, I tryed rpm -ivh MonetDB-SQL-server-2.12.0-1.x86_64.rpm. The > result > > error: Failed dependencies: > > libcrypto.so.5 () (64bit) is needed > libssl.so.5 () (64bit) is needed that's the FC4 RPM, right? Hence, same problem as mentioned above. > Is there an SQL-server frontend for SuSe 9.3 or some other solution that > would allow meto have an SQL frontend to use with the install success I > had with the MonetDB for SuSe9.3? Or am I forced to use FedoraCore if I > need the SQL? I sure hope not. There is supposed to be an SQL frontend RPM also for SuSE 9.3 at http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… However, the compilation of that seem to have failed recently (at least last night) --- I cannot yet see/understand why (in fact, compilation worked, but creating the RPMs failed) --- We'll (try to) look into this ... ... sorry for the inconvenience... Hence, you'll either have to wait until we manage to fix the RPM build for MonetDB/SQL on SuSE 9.3 (64-bit; it works on/for 32-bit: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… ), or you could get the source code (source-RPM or tar ball) for MonetDB/SQL, i.e., MonetDB-SQL-2.12.0-1.src.rpm or MonetDB-SQL-2.12.0.tar.gz from http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=1141… or http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceR… or http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceT… and compile them yourself (next to the MonetDB-server & MonetDB-client RPMs, also the MonetDB-devel RPM needs to be installed). Let us know, in case you have more problems/questions. Stefan ps: Could you please also cc the Monetdb-users(a)lists.sourceforge.net mailing list in your replies? Other might be interested in this topic as well... Thanks in advance! > Thanks Stephen. > > Best to you....George > > > > Stefan Manegold wrote: > > >Dear George, > > > >to install the MonetDB-server-4.12.0-1.*.rpm, you also need to install the > >respective > >MonetDB-client-4.12.0-1.*.rpm, as mentioned in the release notes at > > http://sourceforge.net/project/shownotes.php?release_id=427002&group_id=569…: > >"[...] the MonetDB-server-4.12.0-1.*.rpm requires the corresponding > >MonetDB-client-4.12.0-1.*.rpm to be installed as well." > > > >You get the MonetDB-client-4.12.0-1.*.rpm from the same SF download page as > >MonetDB-server-4.12.0-1.*.rpm: > > http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=5234… > > > > > >What are the missing dependencies for MonetDB-client-4.12.0-1.x86_64.rpm? > >Could you please send/post the list? > >(Most probably, they are indeed required....) > > > > > >Note though, that the RPM available from SF have been built on (and for) a > >Fedora Core 4 system, hence, there *might* be problem with installing them > >on a SuSE 10.1 system. > > > >We don't have (access to) a (64-bit) SuSE 10.1 system, yet, hence, we > >cannot > >provide any SuSE 10.1 specific RPMs, yet. > > > >All we can currently offer (in case you don't manage to install the Fedora > >Core 4 RPMs), are SuSE 9.3 RPMs form our MonetDB web site at > > http://monetdb.cwi.nl/GetGoing/Download/index.html > >(scroll down to 'Daily Builds') and click on 'CVS release branch > >("Stable")', or directly go to > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > > > >(There have been only minor bug fixes on the release branch, hence there > >should be no major differences between the 4.12.0 release from SF and the > >4.12.1 daily builds...) > > > > > >Kind Regards, > > > >Stefan > > > > > >On Tue, Aug 22, 2006 at 12:11:52PM -0700, George H wrote: > > > > > >>Hello: > >> > >>I am new to MonetDB and I'm no linux wizard either, so please excuse, > >>but can you help. > >> > >>I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 > >>(amd64) using the rpm -ivh command and I have "error: Failed > >>dependencies." > >> > >>It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), > >>libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () > >>(64bit) are needed. > >> > >>Where do I get these? I've been searching, but all I can find is their > >>presence in other rpm packages. For example, I see that some of these > >>are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own > >>lengthy list of missing dependencies for installation. > >> > >>Can you give me a hint. I feel like I'm in dependency hell, but I > >>realizie I'm more likely in naive dumblandia. > >> > >>Help please........Thanks, George > >> > >>------------------------------------------------------------------------- > >>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 > >> > >> > >> > > > > > > -- | 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] help please
by George H 22 Aug '06

22 Aug '06

Hello: I am new to MonetDB and I'm no linux wizard either, so please excuse, but can you help. I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 (amd64) using the rpm -ivh command and I have "error: Failed dependencies." It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () (64bit) are needed. Where do I get these? I've been searching, but all I can find is their presence in other rpm packages. For example, I see that some of these are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own lengthy list of missing dependencies for installation. Can you give me a hint. I feel like I'm in dependency hell, but I realizie I'm more likely in naive dumblandia. Help please........Thanks, George

2 1

Re: [MonetDB-users] return type of 'count' in mil
by Stefan Manegold 14 Aug '06

14 Aug '06

Jenny, the return type of count is "legacy". You're right, in case of BATs with more than 2^31 BUNs (possible only on 64-bit systems), the default count(BAT[any,any]):int will fail (or at least return a wrong result. We hanven't changed it to count(BAT[any,any]):lng, yet, maily due to backward-compatibility and due to the fact that a grouped-count ({count}(BAT[any::1,any::2]):BAT[any::1,int/lng]) would than in all cases return a BAT[any,lng], possibly "wasting" space compared to a BAT[any,int]. Eventually, count should return a vraiable integer type that is 32-bit on 32-bit systems and 64-bit on 64-bit systems --- I've been planning to add this "word" type (together with a "proper" 1-byte integer "byte") for quite some time, but it never made it to the very top op my priority-ordered todo list... for now, in case you indeed need th count of >2^31 BUN BATs, you can use count(int):lng, where you provide the BAT's id (i.e., int(BAT)) iso. the BAT itself as argument: ======== MonetDB>help("count"); COMMAND: count(BAT[any,any], bit) : int MODULE: algebra COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the number of elements currently in a BAT; ignores BUNs with nil-tail iff ignore_nils==TRUE. COMMAND: count(BAT[any,any]) : int MODULE: algebra COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the number of elements currently in a BAT. COMMAND: count(BAT[void,void], lng) : lng MODULE: bat COMPILED: by adm on Mon Aug 7 18:07:14 2006 Sets the size (in number of elements) of a BAT. COMMAND: count(int) : lng MODULE: bat COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the current size (in number of elements) of a BAT. MonetDB> ======== Stefan On Wed, Aug 09, 2006 at 04:29:33PM +0200, Ying Zhang wrote: > hi stefan, > > I'm wondering if the return type 'int' of the mil command 'count' is > correct. According to help("count"): > > ... > COMMAND: count(BAT[any,any]) : int > MODULE: algebra > COMPILED: by adm on Mon Aug 7 15:11:12 2006 > Returns the number of elements currently in a BAT. > ... > > what if I want to count a BAT[oid,oid] which contains a max. nr. of BUNs > that a BAT with 64bits oid can have. would this be a problem, since > 'oid' is of 64bits on 64bits machines, while 'int' is of 32bits? or is > a mil 'int' different than a C 'int', namely the size of a mil 'int' > also varias in different machines? > > Thanks > > Jennie -- | 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] MonetDB-XQuery and C#
by Arthur van Bunningen 11 Aug '06

11 Aug '06

Dear all, As we are writing a windows application which will store and query structured documents in a database and we want to use MonetDB/XQuery as database backend, we wondered what the easiest method is to access MonetDB/XQuery from C#. For what it's worth: parsing the XML results is of course no problem, and ODBC is supported. Hopefully some of you can point us to a workable solution. Thanks in advance, Arthur

4 3

[MonetDB-users] xquery over large amount of small documents
by Martijn Faassen 02 Aug '06

02 Aug '06

Hi there, I asked something like this question last year and I'm basically checking up on the progress since then. I hope this mail is not interpreted as demanding anything; I can see you guys are doing impressive work, I'm just trying to give feedback from the perspective of an application developer drooling over the potential of XML databases.. I can see on your website that collections() support is not there yet (marked as "will", though). I also looked at this page: http://monetdb.cwi.nl/XQuery/Overview/Roadmap/index.html 'many small documents' is not listed on this roadmap. On another roadmap page however: http://monetdb.cwi.nl/Development/Roadmap/index.html I do see the following entry (for the september release this year): XQuery: support for large numbers of small documents This gives me hope. :) Is that still the plan? If so, it might be useful to update the XQuery roadmap with that tidbit from the main MonetDB roadmap, as I might not be the only one who is looking for such features. My use case is that of a CMS - large amounts of smaller XML documents that it would be nice to do efficient queries over. Updating small parts of documents (XUpdate) would be nice, but whole-document updates would be okay already, though that might actually mean something like XUpdate to you guys, as you might deal with collections internally as something close to one giant document. Monet is tantalizing because it promises supreme xquery performance but the applications I can imagine do need support for large quantities of smaller documents. If there's a version under development somewhere that supports this feature I'd be happy to try playing with it and give some feedback. Thanks for the attention! Regards, Martijn

2 2

[MonetDB-users] Question about MonetDB ODBC driver configuration
by china-davy 27 Jul '06

27 Jul '06

Hi: I have installed MonetDB (Operationg system is windows xp) and the ODBC driver.I want to connet the MonetDB server through ODBC driver,so I must do some configuration work,for example the "databasename,username,and so on".But the configuration work is forbidded(When I click the "MonetDB" in the windows ODBC Manager,nothing happned to let me do configure work,and,not error message )?could you tell me why,and,how to confiigure the ODBC? -- View this message in context: http://www.nabble.com/Question-about-MonetDB-ODBC-driver-configuration-tf19… Sent from the monetdb-users forum at Nabble.com.

2 1

[MonetDB-users] 回复: help! where i get manual
by Fabian 17 Jul '06

17 Jul '06

Hi Peter Chen, I'm not very familiar with ODBC. I'm sending your question to the monetdb-users mailing list. I expect someone there to be able to better answer your question. Regards On 12-07-2006 09:08:59 +0800, liudawei wrote: > Hi Groffen: > > I have install the MonetDB to my computer (Operationg system is windows) and the ODBC driver.I want to connet the MonetDB server through ODBC driver,so I must do some configuration work.But the configuration work is forbidded，could you tell me why,and,how to confiigure the ODBC? > > Fabian <Fabian.Groffen(a)cwi.nl> 写道： Hi, > > Thanks for your interest in MonetDB. The technical documentation of the > MonetDB kernel can be found on our webpage, http://monetdb.cwi.nl/ for > MIL: http://monetdb.cwi.nl/TechDocs/FrontEnds/mil/index.html > > The SQL documentation is limited to how to get yourself going > http://monetdb.cwi.nl/TechDocs/FrontEnds/SQL/index.html > Our SQL syntax is conforming to the SQL/99 standard. We currently have > not made a manual for the SQL/99 standard. A little help I can give you > is that PostgreSQL is fairly SQL/99 conformant as well, and as such > PostgreSQL queries are a good starting point for MonetDB/SQL. > > Regards, > Fabian > > > > liudawei wrote: > > Hi: > > I am a starter on MonetDB,I am interesting in this excllent Database.My > > questions are is: > > 1) where I can get the manual of Monet Server and SQL Front End. > > > > > > best regards > > Peter Chen

3 3

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Michael Schmidt 12 Jul '06

12 Jul '06

Hi all, > I read the discussion, and I might have experienced the same kind of problem > before. I think there is some problem with the naming (when a document is > previously shredded with the same name as a 'cached' document). At the time > I experienced the problem I couldn't figure out what the exact problem was, > but removing the dbfarm worked for me: > > So perhaps you could try to: > - stop Mserver > - completely remove the dbfarm-folder (defaultpath is > "$PREFIX/var/MonetDB/dbfarm") (hopefully you don't have important XML > documents stored in the database ;) > - start Mserver > - and then run the large query (without running any other queries first)? Thank you very much, everything works fine now! Just removed all dbfarm subdirectories and the error message disappeared. And no, there were no important XML documents stored in the database, only some XMark generated streams ;-)! Nevertheless: I never shredded any document before encountering the problem the first time. Before I /only/ used direct loading from the query. I just tried shredding to solve the problem... Hope this helps to locate the bug! Cheers Michael _____________________________________________________________________ Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! http://smartsurfer.web.de/?mc=100071&distributionid=000000000071

3 2

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Michael Schmidt 11 Jul '06

11 Jul '06

Hello Stefan, thank you very much for your engagement! > In the meantime, I have some more questions for you: > > Which version of SuSE Linux and which version of gcc do you use? I am running SuSe Linux 10.0 and gcc (GCC) 4.0.2 20050901 (prerelease) (SUSE Linux). > Which exact version of the MonetDB source do you use? > - The released tar-balls from SourceForge > (MonetDB-4.12.0.tar.gz & MonetDB-XQuery-0.12.0.tar.gz)? Yes, I used the tar balls. During installation I encountered some problems with the bzip library file, but after manual reinstallation of this package from sources everything worked fine. If I can help you debugging, e.g. by running any tests, please let me know. Kind Regards Michael _____________________________________________________________________ Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! http://smartsurfer.web.de/?mc=100071&distributionid=000000000071

2 1

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Stefan Manegold 11 Jul '06

11 Jul '06

On Sun, Jul 09, 2006 at 05:27:17PM +0200, Michael Schmidt wrote: > Hi Stefan, > > 2 more things: > > - I suppose you already posted my mail at MonetDB-users. I can't see them in the archives but I guess they are updated each night, am I right? I honestly don't know, when SF updates the mailinglist archives, but my mail (quoting your original mail) is (now) in there: http://sourceforge.net/mailarchive/forum.php?thread_id=21306336&forum_id=42… > - I just tried loading the XML-document using "shred_doc". It's the same error message, so the crash is independent from the query. hm, strange --- as I just said, it works fine for me on my Athlon 64 x2 running FC4... I'll check another Athlon 64 with SuSE 9.3 later this week... Stefan > Thanks again for your help! > Michael > ______________________________________________________________________________ > Mit WEB.DE iNews werden Sie über die Ergebnisse der wichtigsten WM-Begegnungen > per SMS informiert: http://freemail.web.de/features/inews.htm/?mc=021202 -- | 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

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Stefan Manegold 11 Jul '06

11 Jul '06

Hi Michael, I just double-checked your problem on my AMD Athlon 64 X2 running 64-bit Fedora Core 4, and everything works fine. I can shred and query XMarks documents up to 1.1 GB without problems (didn't try larger ones ;-)). We also have an Athlon 64 running 64-bit SuSE Linux 9.3 --- but I haven't had time to check that one, yet; I'll try to check it the coming days (a 500kB document works fine on that machine in our nightly testing...). In the meantime, I have some more questions for you: Which version of SuSE Linux and which version of gcc do you use? Which exact version of the MonetDB source do you use? - The released tar-balls from SourceForge (MonetDB-4.12.0.tar.gz & MonetDB-XQuery-0.12.0.tar.gz)? - The release source RPMs from SourceForge (MonetDB-4.12.0-1.src.rpm & MonetDB-XQuery-0.12.0-1.src.rpm)? - Source tar-balls or source RPMs from our daily-builds site (http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./)? - A CVS checkout? (Which branch/tag?) Cheers, Stefan ps: I felt free to get let the Monetdb-users mailing list participate in the discussion, again... On Sun, Jul 09, 2006 at 05:14:23PM +0200, Michael Schmidt wrote: > Hi Stefan, > > > Sorry for the inconvenience! > > We'll update the info on the web site. > > And I feel free to propagate this discussion to the Monetdb-users list. > > Thank you very much, I will also register there... > > > Wrt. your actual problem, I have a couple of questions, maily requesting > > more information to analyse the problem: > > > > What kind of system are you running MonetDB/XQuery on? > > CPU (type, 32- or 64-bit)? > > amount of memory? > > free disk space? > > operating system (type, 32- or 64-bit)? > > I'm running SuSe Linux 64-bit, here my /proc/cpuinfo... If there are any more details you need to know feel free to ask me again. > > processor : 0 > vendor_id : GenuineIntel > cpu family : 15 > model : 4 > model name : Intel(R) Pentium(R) 4 CPU 3.00GHz > stepping : 3 > cpu MHz : 2992.716 > cache size : 2048 KB > physical id : 0 > siblings : 2 > core id : 0 > cpu cores : 1 > fpu : yes > fpu_exception : yes > cpuid level : 5 > wp : yes > flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl est cid cx16 xtpr > bogomips : 5994.87 > clflush size : 64 > cache_alignment : 128 > address sizes : 36 bits physical, 48 bits virtual > power management: > > > > How did you install MonetDB/XQuery? Using binary (.rpm or .msi) packages or > > compiling from source (tarball or from CVS)? > > I compiled them from source. > > > Which queries are you running? Which of them are working with up to 50MB but > > fail with 100MB or more? > > It's the same for all queries. I'm running the XMark test Queries #1, #6, #8, #13 and #20. Here one example Query: (XMark #1): > > query1> > { for $b in doc("/home/.../xmark.xml")/site/people/person > where $b/person_id = 'person0' > return > <result> {$b/name} </result> } > </query1> > > > Did you load/shred your document explicitely via the "shred_doc" MIL command > > on the Mserver console, or did you have them loaded/shreded implicitely on > > the fly via the fn:doc() XQuery function? > > As running benchmarks where loading time should be included, explicit console loading is unsuitable. As seen above I load them from the query. > > > In the latter case, you could try whether the failing queries do work in > > larger documents once you increase the XML document cache limit by staring > > Mserver with "--set xquery_cacheMB=<size>" where size is large than the > > default 100, e.g., just larger than your largest document. > > (Admittedly, there is only very little "well hidden" documentation about the > > "--set" option(s) of Mserver; we're working on that...) > > I tested "--set xquery_cacheMB=500" without success. > > Kind regards > Michael > _____________________________________________________________________ > Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > http://smartsurfer.web.de/?mc=100071&distributionid=000000000071 > > -- | 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

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Stefan Manegold 09 Jul '06

09 Jul '06

Hi Michael, thank you very much for being interested in and using MonetDB/XQuery, as well as for reporting your problem! Apparently, the mailinglist information on the FAQ page of the MonetDB/XQUery web site is indeed a bit misleading. There are actually no specific MonetDB/*XQuery* mailing lists, but "only" general mailing lists for MonetDB that are supposed to be used for all communication about/around MonetDB and all of it's companions and front-ends, o.a., MonetDB/SQL & MonetDB/XQuery; see http://monetdb.cwi.nl/News/MailChannels/ for details. Sorry for the inconvenience! We'll update the info on the web site. And I feel free to propagate this discussion to the Monetdb-users list. Wrt. your actual problem, I have a couple of questions, maily requesting more information to analyse the problem: What kind of system are you running MonetDB/XQuery on? CPU (type, 32- or 64-bit)? amount of memory? free disk space? operating system (type, 32- or 64-bit)? How did you install MonetDB/XQuery? Using binary (.rpm or .msi) packages or compiling from source (tarball or from CVS)? Which queries are you running? Which of them are working with up to 50MB but fail with 100MB or more? Did you load/shred your document explicitely via the "shred_doc" MIL command on the Mserver console, or did you have them loaded/shreded implicitely on the fly via the fn:doc() XQuery function? In the latter case, you could try whether the failing queries do work in larger documents once you increase the XML document cache limit by staring Mserver with "--set xquery_cacheMB=<size>" where size is large than the default 100, e.g., just larger than your largest document. (Admittedly, there is only very little "well hidden" documentation about the "--set" option(s) of Mserver; we're working on that...) If this helps, then there might be a bug somewhere in our document caching code... Kind regards, Stefan On Sun, Jul 09, 2006 at 03:54:30PM +0200, Michael Schmidt wrote: > Hi all, > > I'm confused as I expected a MonetDB XQuery users mailing list instead of > a developer list. However, this list was linked in the MonetDB/XQuery FAQ > section so I thought it would be worth trying... > > Here is my problem: I'm just running some XQuery benchmarks using MonetDB > together with the XQuery module. Installation was ok and I have chosen a > set of queries to be evaluated against data generated with the xmlgen > tool. Query processing works fine for 10MB and 50MB documents, but when > processing large documents (100MB and 200MB) the client reports an error > message. I even tried to figure out the source of the problem using trace > option -t but do not understand the listed error messages. Here is the > final error message reported by the client: > > ERROR: [rename]: 29 times inserted nil due to errors at tuples "pre_size", "pre_level", "pre_prop", "pre_kind", "qn_uri", "qn_prefix". > ERROR: [rename]: first error was: > ERROR: rename(<tmp_351>,pre_size2): operation failed > ERROR: interpret_unpin: [rename] bat=171,stamp=-1285 OVERWRITTEN > ERROR: BBPdecref: tmp_253 does not have pointer fixes. > ERROR: interpret_params: +(param 2): evaluation error. > > Once again: evaluation of the same queries works fine on small streams but > fails on large streams. By the way, I've installed the latest offcial > release of both the server and the XQuery module. > > Is this a bug or are there any default memory limits causing the crash? I > tried to figure out what the --set option is good for but was not able to > detect any documentation on supported options. > > Kind regards > Michael > _____________________________________________________________________ > Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > http://smartsurfer.web.de/?mc=100071&distributionid=000000000071 > > > > ------------------------------------------------------------------------- > 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-developers mailing list > Monetdb-developers(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers > -- | 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] MonetDB as a transaction processing XML database?
by Sander Kruseman 06 Jul '06

06 Jul '06

Hello, Is my conclusion correct that I should not use MonetDB (yet) as a transaction processing XML database? (inserts and deletes of lots of XML snippets, xqueries on the complete database content, by multiple processes) Could you perhaps suggest an alternative solution? Any familiarity with Berkely DB XML by Sleepycat for example? Btw. we need a C++ API for this. Thanks in advance. Sander

2 1

[MonetDB-users] MonetDB 4.12.0 Release Announcement
by Fabian Groffen 23 Jun '06

23 Jun '06

It is my great pleasure to announce the availability of MonetDB 4.12.0 and its accompanying SQL 2.12.0 and XQuery 0.12.0. This release is the next step in delivering the high performance database system that has been under development for several years now. Some of the many changes since the 4.10.2 release include: MonetDB/XQuery 0.12.0 (nick-named "Ceres") Various improvments of functionality and performance. Addition of XPath extensions for XML standoff annotations. "Ceres" is a small detour on our trip to "Mars" [1], as update functionality is unfortunately still not robust enough for consumption by the majority. MonetDB/SQL 2.12.0 Many bugfixes. Support for local and global temporary tables. Preliminary support for triggers. For a complete list of new features and known problems, please see the release notes and errata list, available at: http://monetdb.cwi.nl/Development/Roadmap/Version4.12/index.html MonetDB/Five Alpha Release 1 ============================ The efforts on the next generation of MonetDB, version Five, are released now. This snapshot of version Five of MonetDB is the very first alpha release of this ongoing development. Beware: alpha is alpha! This software is only suitable as sneak-preview into the MonetDB developers team's kitchen! Come and taste some of the many delicious spices we prepare. Unlike the previous generation, Five comes with the MAL language, instead of MIL, which makes it completely incompatible with old MIL scripts. However, the SQL sources work fine with this alpha release. Comparing the performance of both backends via SQL should give you an indication of what our cooks will serve for dinner. This first alpha "appetiser" release of MonetDB/Five is nick-named "Tomato Soup". Interested users are invited to visit our MonetDB/Five page for more details: http://monetdb.cwi.nl/Development/Five/index.html Availability ============ The MonetDB family products are supported on i686, x86_64 and ia64 Linux, i686 Solaris 10, ppc and ppc64 Mac OS X 10.4 and i686 Windows XP. Binary distributions are available for Linux and Windows. The new release is available for download from our SourceForge page: http://sourceforge.net/project/showfiles.php?group_id=56967 Acknowledgements ================ Many man-hours were donated by various people to make this release happening. I want to thank al MonetDB developers for their efforts spent into this piece of software. All of our contributors and bug reporters also deserve the credits for the time they put into their contribution. Further Information =================== Further information about MonetDB, MonetDB/SQL and MonetDB/XQuery is available on our web site at: http://monetdb.cwi.nl/ http://monetdb.cwi.nl/SQL/ http://monetdb.cwi.nl/XQuery/ For details about recent changes, migration from earlier versions, and future plans, please visit our roadmap page: http://monetdb.cwi.nl/Development/Roadmap/ User CVS Information ==================== If you use a CVS checkout, you might have to change some things in order to keep on working with the latest sources. With every release some new tags are set and numbers changed. Please check your source trees that you use the right sticky tags on them. The sources that are put in this release are tagged as follows: MonetDB MonetDB_4-12-0 sql SQL_2-12-0 pathfinder XQuery_0-12-0 The new stable branches are now available through the following tags: MonetDB MonetDB_4-12 sql SQL_2-12 pathfinder XQuery_0-12 To update to the new stable branches use ``cvs update -r <branch tag>`` for the repositories you work with. Feedback or Questions ===================== If you have any questions or feedback regarding this release, feel free to contact us through this list: monetdb-users(a)lists.sourceforge.net We hope you will enjoy this new release of MonetDB as much as we do. [1] See http://en.wikipedia.org/wiki/1_Ceres and http://www.nasa.gov/multimedia/imagegallery/image_feature_404.html

1 0

Re: [MonetDB-users] Reminder: MonetDB Bug-Etiquette
by Stefan Manegold 19 Jun '06

19 Jun '06

Dear all, two more small pleas that will make bug reporting and fixing much simpler and smoother: - When submitting a bug, please *always* set both the "Category:" and the "Group:"! This helps the developer(s) to identify which version/part of the system your bug occured with. - When changing the "Status:", "Resolution:", and/or "Priority:", please *always* provide a comment that explans the motivation and/or reason for your action. E.g., when closing a bug report, please mention whether, how and where you fixed it. Thanks again! Stefan On Sun, Jun 18, 2006 at 10:09:13PM +0200, Stefan Manegold wrote: > Dear all, > > since the last MonetDB "BugDay" on Dec 19 2005, many bugs have been reported > and fixed. > > Unfortunately, not all bug reports that have been closed since then have > been backed-up by a test script in CVS to verify and monitor to validity of > the respective bug fix, as described in the "MonetDB Bug-Etiquette" > (cf. one of > http://sourceforge.net/mailarchive/forum.php?thread_id=9021727&forum_id=398… > http://sourceforge.net/mailarchive/forum.php?thread_id=9021726&forum_id=425… > ) > > According to the "MonetDB Bug-Etiquette", a bug report should (may/must) not > be closed without adding a respective test to our test system in CVS. > > While both the user/submitter that reports the bug and the > developer/assignee that fixes it should share the task of "designing" the > test and adding it to the test system in CVS, we agreed that the > developer/assignee is finally "responsible" that the test is indeed added > *before* the bug report is closed. > > > To ensure the stability and correctness of MonetDB and its companions and to > avoid that supposedly fixed bug sneak in again unnoticed, I'd like to ask > all of you that reported and/or fix any bug(s) since Dec 19 2005 > the following favour: > > Please check all "your" bugs (see * below) since Dec 19 2005, whether a test > has been added or not. > + If the comments in the bug report are not clear, please check the CVS > repository. > + If you're a user/submitter and don't know where to look or what to do, > please remind the respective developer/assignee of your bug by added a > respective comment and re-opening the bug report. > + If there is a test, or no test is necessary or feasible, but the > bug-report does not mention this clearly, please add a new comment that > explains the situation. > + If there is no test although there should be one, please re-open the bug > report with a respective comment to indicate that a test must be added. > As said before, "users/submitters" are welcome to help adding tests, but > developers/assignees are finally responsible that the tests are indeed > added. > > Please recall, we plan to release MonetDB 4.12, MonetDB/SQL 2.12 and > MonetDB/XQuery 0.12 soon (i.e., before the end of this month), > and we all want them to be as stable and "bug-free" as possible...! > > > Feel free to use these channels to comment and/or ask questions. > > > Thank you all very much for your contributions to make MonetDB even better > than it already is! > > > Kind regards, > > Stefan > > > *) To find "your" bugs, just > - go to http://sourceforge.net/tracker/?group_id=56967&atid=482468 , > - select your username from the list "Assignee:", > - or enter your username as "Submitter username (show mine):" > (and set "Assignee:" to "Any"), > - set "Status:", "Category:" & "Group:" to "Any", > - set "Sort By:" to "Open Date" and "Descending", > - and click on "Browse". > > -- > | 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 | -- | 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] Reminder: MonetDB Bug-Etiquette
by Stefan Manegold 18 Jun '06

18 Jun '06

Dear all, since the last MonetDB "BugDay" on Dec 19 2005, many bugs have been reported and fixed. Unfortunately, not all bug reports that have been closed since then have been backed-up by a test script in CVS to verify and monitor to validity of the respective bug fix, as described in the "MonetDB Bug-Etiquette" (cf. one of http://sourceforge.net/mailarchive/forum.php?thread_id=9021727&forum_id=398… http://sourceforge.net/mailarchive/forum.php?thread_id=9021726&forum_id=425… ) According to the "MonetDB Bug-Etiquette", a bug report should (may/must) not be closed without adding a respective test to our test system in CVS. While both the user/submitter that reports the bug and the developer/assignee that fixes it should share the task of "designing" the test and adding it to the test system in CVS, we agreed that the developer/assignee is finally "responsible" that the test is indeed added *before* the bug report is closed. To ensure the stability and correctness of MonetDB and its companions and to avoid that supposedly fixed bug sneak in again unnoticed, I'd like to ask all of you that reported and/or fix any bug(s) since Dec 19 2005 the following favour: Please check all "your" bugs (see * below) since Dec 19 2005, whether a test has been added or not. + If the comments in the bug report are not clear, please check the CVS repository. + If you're a user/submitter and don't know where to look or what to do, please remind the respective developer/assignee of your bug by added a respective comment and re-opening the bug report. + If there is a test, or no test is necessary or feasible, but the bug-report does not mention this clearly, please add a new comment that explains the situation. + If there is no test although there should be one, please re-open the bug report with a respective comment to indicate that a test must be added. As said before, "users/submitters" are welcome to help adding tests, but developers/assignees are finally responsible that the tests are indeed added. Please recall, we plan to release MonetDB 4.12, MonetDB/SQL 2.12 and MonetDB/XQuery 0.12 soon (i.e., before the end of this month), and we all want them to be as stable and "bug-free" as possible...! Feel free to use these channels to comment and/or ask questions. Thank you all very much for your contributions to make MonetDB even better than it already is! Kind regards, Stefan *) To find "your" bugs, just - go to http://sourceforge.net/tracker/?group_id=56967&atid=482468 , - select your username from the list "Assignee:", - or enter your username as "Submitter username (show mine):" (and set "Assignee:" to "Any"), - set "Status:", "Category:" & "Group:" to "Any", - set "Sort By:" to "Open Date" and "Descending", - and click on "Browse". -- | 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] join on 2 attributes
by Henning Rode 07 Jun '06

07 Jun '06

hej monet-db-useres, i maybe forgot a very basic thing here, but how do you perform in monet an equi-join on two attributes. it seems such a normal task that there must be something easier than what i did now (see attachment: generating first example instances, then do the join with 'intersect') you should have the same problem when you select on a qname (namespace and tagname), but i could not find that example. if i underspecified my problem, just let me know in advance ;-) best -henning var x_a := new(void,int).seqbase(0@0); x_a.append(1); x_a.append(1); x_a.append(1); x_a.append(2); x_a.append(2); x_a.append(2); x_a := [oid](x_a); var x_b := new(void,int).seqbase(0@0); x_b.append(1); x_b.append(2); x_b.append(4); x_b.append(1); x_b.append(2); x_b.append(4); x_b := [oid](x_b); var y_c := new(void,int).seqbase(0@0); y_c.append(1); y_c.append(2); y_c := [oid](y_c); var y_d := new(void,int).seqbase(0@0); y_d.append(2); y_d.append(1); y_d := [oid](y_d); print(x_a,x_b); print(y_c,y_d); var x_y := join(x_a,y_c.reverse()); var x_d := join(x_y,y_d); intersect(x_b,x_d).print();

1 0

[MonetDB-users] MEL Question: Creating a New Search Accelerator
by John Cieslewicz 05 Jun '06

05 Jun '06

I am trying to build a new search accelerator as described in Section 2.5 of the Monet Extension Language (MEL) User Guide (http://monetdb.cwi.nl/TechDocs/Core/mel/index.html) When I execute mel on my module definition it does not seem to recognize the ".ACCELERATOR" key word. In Section 3.5, "Implementing Accelerators" the 'mean' accelerator implementation is described. Is there an example of the module definition of 'mean' in MEL? I also looked at the mel source code and found that in buildtools/_MEL/mel.yy it appears that 'accelerator' is not part of the grammar for a module: ---- definition: atomdef | command | iterator | builtin | operator | object | MEL_PRELUDE '=' ident ';' { $$.sym = new Prelude(MEL_PRELUDE, $3.s); } | MEL_EPILOGUE '=' ident ';' { $$.sym = new Epilogue(MEL_EPILOGUE, $3.s); } ; --- Questions: (1) Are user defined search accelerator modules actually supported in MonetDB? (2) If so, is there an example of such an accelerator module? (3) If not, what would be the best way to integrate a new index technique into the system? Thanks! -John

1 0

[MonetDB-users] python client library for Windows
by Max 10 May '06

10 May '06

Hello! I'm just installed Python 2.4 and MonetDB-Installer-4.10.2.msi, but can't find precompiled python Mapi modules. Generally, I want to try SQL interface to MonetDB from Python. After some dig around tar.gz sources i've found Mapi.py, MapiClient.py, CMapi.py, MapiLib.py and monet_options.py. Still need binary _MapiLib... Also please clarify meaning of monet_options.py file.

2 1

[MonetDB-users] RHEL 4 x86_64 RPMs
by Henk van Lingen 03 May '06

03 May '06

On Fri, Apr 28, 2006 at 06:44:42PM +0200, Stefan Manegold wrote: > > > RPM build errors: > > > File not found by glob: /var/tmp/MonetDB-root/usr/share/MonetDB/lib/*jar > > Can it be that you don't have Java installed on your system? > > Nevertheless I think this is a bug. > > yes, yes, yes: > > - it should also work with REHL4 on x86_64 --- ate least I don't see any > reason why it should not work, provided the systems installed properly; we > actually build RPMs every night on an Itanium running > "Red Hat Enterprise Linux WS release 4 (Nahant Update 3)". NB: Itanium <> x86_64, right? > - your problem looks indeed as if (a proper) java (>=1.4) is not installed or > at least not found by configure (check the configure output and/or the > config.log) Right, I didn't install java on the build host (didn't know it was a dep for MonetDB) However, now I installed java-1.4.2-gcj-compat-devel and java-1.4.2-gcj-compat. But the problems persist. After ./configure --enable-bits=64 make make dist make rpm I have: asclepius:src/MonetDB-4.10.2 144% grep java config.log Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-java-awt=gtk --host=x86_64-redhat-linux configure:4068: checking for java configure:4086: found /usr/bin/java configure:4098: result: /usr/bin/java configure:4120: checking for javac configure:4138: found /usr/bin/javac configure:4150: result: /usr/bin/javac configure:4198: checking for javadoc configure:4216: found /usr/bin/javadoc configure:4228: result: /usr/bin/javadoc config.status:955: creating src/mapi/clients/java/Makefile config.status:955: creating src/mapi/examples/java/Makefile ac_cv_path_JAVA=/usr/bin/java ac_cv_path_JAVAC=/usr/bin/javac ac_cv_path_JAVADOC=/usr/bin/javadoc JAVA='/usr/bin/java' JAVAC='/usr/bin/javac' JAVADOC='/usr/bin/javadoc' Do I really need the Sun Java? Cheers, -- Henk van Lingen, Systems & Network Administrator (o- -+ Dept. of Computer Science, Utrecht University. /\ | phone: +31-30-2535278 v_/_ http://henk.vanlingen.net/ http://www.tuxtown.net/netiquette/

3 3

[MonetDB-users] RHEL 3 RPMs
by Henk van Lingen 28 Apr '06

28 Apr '06

Hi, Is there a special reason there are no i686 RPM's anymore like there were until 4.6.0_rc2? I think it's a bit weird there are RPM's for the hobby OS 'FedoraCore' but not for the much used server OS 'RedHat Enterprise 3 (and 4)'? The FedoraCore (which Core?) needs libstdc++.so.6 whereas RHEL 3 only has libstdc++.so.5 ... There also seems to be no SRPM's. Cheers, -- Henk van Lingen, Systems & Network Administrator (o- -+ Dept. of Computer Science, Utrecht University. /\ | phone: +31-30-2535278 v_/_ http://henk.vanlingen.net/ http://www.tuxtown.net/netiquette/

6 14

[MonetDB-users] Issues with concurrent connections using JDBC
by Anderson Supriano 09 Apr '06

09 Apr '06

Hi! I'm working on a research about database performance and I'm running a TPC-W implementation (based on http://www.ece.wisc.edu/~pharm/tpcw.shtml) on some databases (Monet, MySQL, Postgresql). Basically, what is being done is having some emulated browsers generating load on the servlet container (tomcat in my case) that access the database through JDBC. -------------- -------------- ---------------- | Emulated | | Tomcat | | DB | | Browser | -----> | | ------> | | -------------- -------------- ---------------- When running this benchmark with concurrent accesses I'm getting problems. If I try 5 concurrent Emulated Browsers running (and 5 concurrent database connections) everything goes well. The problem starts when I increase the concurrency. With 30 concurrent connections everything goes well for a few minutes and then it stops working. The servlet container stops responding and monet uses low percentage of CPU on this state. When I try to kill tomcat and start again (without killing Monet) it starts working again and stops after a while. Based on this experiment it seems that Monet is still responsive, but the instance of servlet container that was accessing Monet just freezes. I'm trying to investigate it a little more, but since I'm not an expert on MonetDB internals, I'd like to know if there is some known issue like this one or if anyone can have a tip on how to solve this. Since Monet is responsive and the servlet container is freezing, it looks like JDBC driver is doing something that is freezing the container (I used to suspect on application, but since it is working very well with MySQL and Postgresql, it seems to not be the problem). I'll appreciate any help on this subject. Thanks very much for your attention. Best regards, Anderson Supriano

2 2

[MonetDB-users] Commit failure on concurrent transactions
by Anderson Supriano 02 Apr '06

02 Apr '06

Hi! I am running several concurrent transactions on Monet DB using JDBC and I'm getting an error when commiting a transaction: java.sql.SQLException: COMMIT: failed ERROR: COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2185) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:1937) at nl.cwi.monetdb.jdbc.MonetConnection.commit(MonetConnection.java:443) Is there a way that this exception can be handled in order to have all transactions working (even if waiting the last one to be finished)? I am using MonetDB-4.10.0 and SQL-2.10.0. Thanks for your cooperation. Best regards, Anderson Supriano

2 2

[MonetDB-users] JDBC: Not all results returned
by Martin Beck 23 Feb '06

23 Feb '06

Hi, I have a simple SQL script which starts like this: CREATE TABLE people ( pid integer NOT NULL PRIMARY KEY, name varchar(40) NOT NULL DEFAULT '', number varchar(15) NOT NULL UNIQUE DEFAULT '0', email varchar(100) NOT NULL, spid integer NOT NULL DEFAULT '0' ); Afterwards, it inserts 251 People with ascending pids from 0 to 250. I apply it to the MonetDB database either with MapiClient, or JDBCClient. However, if I login with the JDBCClient and do a "select name,number from people;" i only get 250 rows, not 251! But no error is reported. Instead, a "select count(*) from people;" returns 251. if i try the same with the MapiClient, everything works as expected. the problem seems to be with other tables, too, but there the count of returned rows another one, so I expect it has something to with a packet limit, or something? is it a configuration thing or a bug? with 2.8.2 everything worked. if executed from a java program, the statement returns the exception "protocol violation: unexpected line in data block:"

3 8

[MonetDB-users] network setup
by Colin Foss 15 Feb '06

15 Feb '06

How do you configure MonetDB to listen to connections from anywhere besides the localhost? I can make a local connection but as soon as I try to connect from another computer I get an error. I have even tested with netcat (nc) to make sure there wasn't a firewall blocking the connection. Colin Foss

2 1

[MonetDB-users] Mondrian and MonetDB
by Martin Kersten 31 Jan '06

31 Jan '06

LS, I think the combination of the opensource project Mondrian and MonetDB would be a very strong couple. Especially given the history of MonetDB in the area of datamining. However, the resources at the core team are insufficient at this point in time to embark on such a (short term) project. Perhaps someone in our user community is willing to take up the challenge and report on the problems encountered/ results obtained. The core development teams is particularly interested in missing features, interfacing problems, and, ofcourse, performance problems. regards, Martin ----------------------------------------------- Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=3551757 By: jhyde I'm always happy to add support to Mondrian for another DBMS. The process is fairly well-worn, since we support several DBs already. It's best if someone familiar with the DBMS goes through the process, then I'll integrate the code and update the doc. The process is: 1. Get the MondrianFoodMartLoader working for your DB. 2. Tweak Mondrian's SQL-generation facilities for the capabilities of your DB. Look at SqlQuery.Dialect and you will see the kinds of things that Mondrian cares about. (If your DB has a fairly expressive SQL, and driver provides the appropriate metadata so Mondrian knows what it's capable of, this step may be trivial.) 3. Add your database name as an option for the <SQL dialect="db"> element. (Code is in Mondrian.xml, and elsewhere.) 4. Get the Mondrian regression suite to run cleanly. 5. Provide some typical connect strings for me to put into mondrian.properties. 6. Give me a contact who is willing to run the regression suite on your DB before each release. ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=111375

2 1

[MonetDB-users] MonetDB-SQL 2.10.0 - Status of temorary tables?
by leemarks＠netspace.net.au 31 Jan '06

31 Jan '06

Hi, Are temporary tables currently supported in monetdb-sql? If I do something like, create temporary table foo (abc integer) It fails with a strange error. [Perhaps I'm using invalid syntax?] Thanks in advance, Lee ------------------------------------------------------------ This email was sent from Netspace Webmail: http://www.netspace.net.au

4 8

[MonetDB-users] 8 hours of Photoshop Video Tutorials
by Cole 23 Jan '06

23 Jan '06

1 0

[MonetDB-users] MonetDB/Five slotting: on running M4 next to M5
by Fabian Groffen 25 Dec '05

25 Dec '05

Hi list, Scheduled for next year is the (alpha/beta) release of MonetDB/Five, the successor of the current MonetDB generation. MonetDB/Five is the logical successor to its predecessor in terms of speed and performance. However, MonetDB/Five is not fully backwards compatible with it's predecessor. Instead of using the MIL language for kernel operations, it uses MAL. Although many MIL operations can be easily mapped on MAL operations, a fully automatic (and correct) translation of MIL to MAL is not possible. Directly related to this, is the availability of MonetDB/XQuery, which currently heavily relies on the MIL language. The SQL users of MonetDB will be the only ones that will immediately benefit from the improved MonetDB/Five engine, as SQL is fully functional and there is no difference in language or output. Due to this situation where both M4 (curent MonetDB generation) and M5 (MonetDB/Five generation) have it's own advantages (XQuery support, MIL, MAL, better performance) it is most likely that one would like to run both M4 and M5 engines next to each other to benefit from both. This would currently cause problems when applied out of the box. Given that M4 and M5 would be slotted, and hence installable next to each other, starting it's services would cause problems because both engines try to bind to the same ports by default. To give a short view on the ports in use by default: M4 M5 Mapi 50000 50000 SQL 45123 45123 XQuery 45789 N/A This obviously clases for default MIL/MAL (Mapi) connections as well as SQL connections. XQuery is not an issue for the moment. A few observations: - The actual language spoken over the Mapi server port is engine specific, i.e. MIL for M4 and MAL for M5. This is probably somewhat confusing. For SQL it is clear, and the port specifies which language to use, regardless the engine. - XQuery support is not available for M5 yet, but it should be dealt with as for SQL. Possible scenarios to solve the problems of clashing ports can be: 1. Use different port numbers based on the engine, i.e. use 55123 for SQL on M5 and 45123 on M4. Mapi could become something like 50005 for M5. 2. Build (or extend for instance the DatabasePool) an application that handles transparently the request for a service making use of a combination of port and challenge response to give the client a M4 MIL, M5 MAL, M5 SQL or M4 XQuery connection, using the ports currently known. (Note: this also allows for multi-catalog support for SQL, when the DatabasePool is taken as base.) 3. Ignore the problem and only document it, including how to change the default ports to avoid clashes. (Note: unfortunately we're unable to bind to a certain interface...) 4. A combination between 1 and 2, with the purpose of getting each language it's own port in the system, reducing the problem and possibly disable M4's SQL server. Are end-users interested in/aided by such changes made, or will they figure out themselves easily enough? Just a few thoughts on a problem that will arise in distribution land...

1 0

[MonetDB-users] MonetDB Bug-Etiquette
by Stefan Manegold 24 Nov '05

24 Nov '05

Dear MonetDB-users and -developers, bug reports and especially test script play a crucial role with maintaining and improving the stability and correct functioning of MonetDB. However, adding test scripts "a posteriori" as we did recently during the two "MonetDB-Bug-Days" (a third one is still to come before the end of this year!) is a very tedious and time-consuming task, especially since who ever is adding a test script first needs to get familiar with the details of the very bug report. Since both the user who submits a bug report and the developer(s) who take(s) care of fixing a bug are by definition very familiar with the details of a bug report, it seems more than obvious that they should share the task of adding a test script to the CVS repository while dealing with the respective bug, i.e., *before* closing the bug report. Ideally, the user/submitter provides the query or script that triggers the bug as well as the expected/correct output with his/her bug report. In case the user/submitter has CVS check-in privileges, he/she could add the test script to the CVS repository him-/herself. Otherwise, the developer/assignee should add the user's test script to the CVS repository. The test script helps both the developer/assignee and the user/submitter to monitor the status of the bug by running "Mtest[.py]" (cf., http://monetdb.cwi.nl/monet/src/testing/README) or by checking the TestWeb (http://monetdb.cwi.nl/Development/TestWeb/) To coordinate this procedure, I made a first draft for a "MonetDB Bug Etiquette", which you find attached to this mail. I'd be very pleased, if you could comment on this. Thank you all very much for your contribution to make MonetDB even better than it already is! Kind regards, 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 |

4 10

[MonetDB-users] MonetDB 10.000 downloads
by Martin Kersten 20 Nov '05

20 Nov '05

LS, It is my pleasure to announce that on Nov 19, 2005 around 23:00 GMT we reached the first 10.000 downloads of MonetDB packages (MonetDB+SQL+XQuery) available on Sourceforge. Let's go the 100.000 ! regards, Martin

1 0

[MonetDB-users] Still can't compile under FreeBSD
by Eugene Rogoza 31 Oct '05

31 Oct '05

Hello everybody, I can't compile MonetDB from sources no matter what I do. Even with the patch from Marcel. I've been trying to compile the MonetDB-4.8.2 sources as well as CVS version. What I get is attached below. Could someone point out the exact steps to compile this stuff on FreeBSD 5.3? I would be very grateful. Eugene root@inspiron:~/MonetDB-4.8.2/FreeBSD> gmake cd .. && /usr/local/bin/bash /root/MonetDB-4.8.2/conf/missing --run aclocal-1.9 /usr/X11R6/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-aclocal /usr/X11R6/share/aclocal/xmms.m4:62: warning: underquoted definition of AM_PATH_XMMS /usr/X11R6/share/aclocal/oaf.m4:4: warning: underquoted definition of AM_PATH_OAF /usr/X11R6/share/aclocal/libglade.m4:7: warning: underquoted definition of AM_PATH_LIBGLADE /usr/X11R6/share/aclocal/libart.m4:11: warning: underquoted definition of AM_PATH_LIBART /usr/X11R6/share/aclocal/imlib.m4:9: warning: underquoted definition of AM_PATH_IMLIB /usr/X11R6/share/aclocal/imlib.m4:167: warning: underquoted definition of AM_PATH_GDK_IMLIB /usr/X11R6/share/aclocal/gtk.m4:7: warning: underquoted definition of AM_PATH_GTK /usr/X11R6/share/aclocal/gdk-pixbuf.m4:12: warning: underquoted definition of AM_PATH_GDK_PIXBUF /usr/X11R6/share/aclocal/gconf-1.m4:4: warning: underquoted definition of AM_PATH_GCONF /usr/X11R6/share/aclocal/gconf-1.m4:71: warning: underquoted definition of AM_GCONF_SOURCE aclocal:configure.in:74: warning: macro `AM_MONETDB_COMPILER' not found in library aclocal:configure.in:75: warning: macro `AM_MONETDB_TOOLS' not found in library aclocal:configure.in:76: warning: macro `AM_MONETDB_OPTIONS' not found in library aclocal:configure.in:77: warning: macro `AM_MONETDB_LIBS' not found in library cd .. && /usr/local/bin/bash /root/MonetDB-4.8.2/conf/missing --run autoconf configure.in:74: error: possibly undefined macro: AM_MONETDB_COMPILER If this token and others are legitimate, please use m4_pattern_allow. See the Autoconf documentation. configure.in:75: error: possibly undefined macro: AM_MONETDB_TOOLS configure.in:76: error: possibly undefined macro: AM_MONETDB_OPTIONS configure.in:77: error: possibly undefined macro: AM_MONETDB_LIBS WARNING: `autoconf' is missing on your system. You should only need it if you modified `configure.in'. You might want to install the `Autoconf' and `GNU m4' packages. Grab them from any GNU archive site. /usr/local/bin/bash ./config.status --recheck running /usr/local/bin/bash ../configure --no-create --no-recursion checking build system type... i386-unknown-freebsd5.3 checking host system type... i386-unknown-freebsd5.3 checking target system type... i386-unknown-freebsd5.3 checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for gawk... gawk checking whether make sets $(MAKE)... yes ../configure: line 1898: syntax error near unexpected token `AM_MONETDB_TOOLS' ../configure: line 1898: `AM_MONETDB_TOOLS()' gmake: *** [config.status] Error 2

3 4

[MonetDB-users] FreeBSD compile patch
by Marcel Hamer 21 Oct '05

21 Oct '05

Hello, The following, very small, patch makes MonetDB compile without errors and warnings on a FreeBSD 5.4 system. I was able to succesfully compile and run MonetDB this way on FreeBSD. ----------------------------------------------------------------- +++ ./conf/monet.m4 Wed Oct 19 21:26:01 2005 @@ -236,6 +236,8 @@ yes-*-*) dnl defines that enable the features beyond C89 in the various dnl platforms. Here's what we found working so far... case "$gcc_ver-$host_os" in + *-freebsd*) + ;; *-cygwin*) dnl MonetDB/src/testing/Mtimeout.c fails to compile with dnl "--std=c99" as the compiler then refuses to recognize ------------------------------------------------------------------ Kind regards, Marcel Hamer

2 2

[MonetDB-users] mail Server
by Jone 21 Oct '05

21 Oct '05

Dear monetdb-users(a)lists.sourceforge.net: Bullet-Proof server: Fresh IPs 1024MB RAM P4 CPU 72GB SCSI Dedicated 100M fiber Unlimited Data Transfer Any software Based China US$599.00 per month May use the server for: Bulk web Hosting Direct Mail We also supply email list according to your order and sending out your message for you. Hope to service for you. Cheers! Jone Server Team kezunli666(a)sohu.com For.NoSend: MoreNot(a)yahoo.com

1 0

[MonetDB-users] Huge tables
by Andrei Martsinchyk 04 Oct '05

04 Oct '05

Hello, It seems MonetDB has problem with handling of huge tables (larger than amount of memory available). I tried to load large amount of data into a table using COPY command. I loaded same data (6 millions records, 700+MBytes) few times. Loading was successful two times, on third time server crushed. After crush I could not start the server again, it output messages !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. !FATAL: BBPinit: cannot properly process bat/BACKUP/. and exited. Removing of the database data directory did not help much - server output messages !ERROR:mvc_init: unable to create system tables !WARNING: BBPincref: range error 410 Couple minutes later it output !ERROR: BATSIGcrash: Mserver internal error (Segmentation fault), please restart . !ERROR: (One potential cause could be that your disk might be full...) Well, insufficient disk space could be a cause, before server crashed I had approximately 2GB free. But I have cleaned up 10 GB and problem persists. How can I troubleshoot and fix the server ? What are memory / disk space requirements when bulk loading data ? I tested with 32-bit system, 512 MB RAM + 1GB swap, Ubuntu Linux, MonetDB-4.9.3, nightly build dated September 30. -- Best regards, Andrei Martsinchyk mailto:andrei.martsinchyk@gmail.com

2 6

[MonetDB-users] Bulk load
by Andrei Martsinchyk 03 Oct '05

03 Oct '05

Hello, I am trying to pipe output from my application using bulk load. If application produced output like this: CREATE TABLE test (col1 int); COPY 3 RECORDS INTO "test" FROM stdin USING DELIMITERS '\t'; 1 2 NULL COMMIT; I could pipe it to MapiClient -lsql -umonetdb -Pmonetdb, it worked OK. But application does not know how many rows it will produce, until dump out all the records. When I tried to skip record count I got failed assertion error (a bug ?). Anyway, it would fail when encountered COMMIT; at the end. At the same time COPY without record count can load data from a file, but I do not want to put data into temp table and then do load because i want them run in parallel. Could you suggest a way to do the loading ? -- Best regards, Andrei Martsinchyk mailto:andrei.martsinchyk@gmail.com

1 1

[MonetDB-users] SQL: Update table from another table
by Andrei Martsinchyk 08 Sep '05

08 Sep '05

Hello All, Does SQL frontent support updating one table with data from another table ? More formally, if I have two tables create table t1 (id1 int, val1 varchar(255)); and create table t2 (id2 int, val2 varchar(255)); , can I execute statement like this (PostgreSQL syntax): update t1 set val1=val2 from t2 where id1=id2; ? Thanks in advance. -- Best regards, Andrei Martsinchyk mailto:andrei.martsinchyk@gmail.com

2 4

[MonetDB-users] "Large" document collection and MonetDB/XQuery
by Bastiaan Naber 05 Sep '05

05 Sep '05

We have been experimenting with the MonetDB/XQuery at our institure and we have some issues. We have loaded 727 XML documents into MonetDB with the shred_doc() command: shred_doc("{xml file 1}, "1") shred_doc("{xml file 2}, "2") etc... These files are small (4 a 5 kilobytes). When we query these files with the following query the result takes a long time to complete (2 minutes): for $i in ("0", "1", .... "727") return $i Can anyone explain why looping over 727 documents is so slow? We have collected all 727 XML documents into 1 XML file and loaded this in MonetDB and this is a lot faster. The test machine is a 2.8 GHz P4 with 1 GB of memory. Another isue is related to the size of the database on the harddisk. When we fist load the 727 XML documents into the database the database directory contains about 47.000 files and is 50 megabytes in size. When we have excuted a number of querys the size of this directory increases to 1.7 gigabytes!! Can anyone explain this behaviour? Is MonetDB generating somekind of dynamic indices? Thanks for your replys, Bastiaan Naber

3 2

[MonetDB-users] MonetDB/XQuery: performance issues
by Peter van der Kamp 23 Aug '05

23 Aug '05

I've been experimenting with MonetDB/XQuery for some time now and i wonder what kind of machine was used to produce the benchmark results as published on the website. Are there some guidelines ("do's and don'ts") with respect to performance? Peter van der Kamp

3 4

[MonetDB-users] AMD64 version of MonetDB for Windows?
by Cardillo Raymond A Civ AFRL/IFEA 19 Aug '05

19 Aug '05

Has anyone out there taken the time to build an MSI for the AMD64 versions of Windows? The x64 version of Windows was released a few months ago and was available in Beta for a while, so I'm hoping someone has either done this already, or can provide some advice on how to build/compile for this platform. Anyone know of future plans to make this one of the standard platform builds? Windows x64 is only going to grow in popularity from here, especially amongst researchers and others who can benefit from 64 bits. Thanks for any info, Ray Cardillo

2 1

[MonetDB-users] Perl and MonetDB Xquery
by Peter van der Kamp 18 Aug '05

18 Aug '05

LS, As Perl is one of the main programming languages at our institute, I tried the Perl API with MonetDB-Xquery. I succeeded with sending mil statements (with the language parameter set to 'mil') to the server and getting the correct answer, but xqueries failed (with the language parameter set to 'xquery'). This was not a complete surprise as the documentation seems to be ambiguous ("MonetDB/XQuery for POSIX (Linux/Unix) platforms currently only supports MAPI (MonetDB API) to communicate with the XQuery engine."). Following the link to the API's: "Perl binding of the simple Monet API (Mapi) for MIL/SQL database interaction". So, I would like to know if my assumption that currently no xqueries are supported by the Perl API is correct. Peter

4 7

[MonetDB-users] BerkeleyDB
by Rodrigo Schmidt 16 Aug '05

16 Aug '05

Has anyone compared the relative performance between MonetDB (MIL interface) and BerkeleyDB? If so, what were the results? Cheers, Rodrigo

1 0

[MonetDB-users] Re: Support for group by <ordinal> and SQL OLAP functions
by Fabian (MonetDB Project) 12 Aug '05

12 Aug '05

(I'm sending this to the monetdb-users list, as it might help some other people too) Hi, Thanks for your interest in MonetDB/SQL. gustavo wrote: > ... What I´m missing mostly is support for group by a > number of a column. In this way it would be possible to group by na > expression without the use of a derived table (select from select). I don't exactly understand what you want to do. Can you give a concrete (SQL) example that shows what you want to do? I think that would help getting me to understand. > Another > thing that could boost MonetDb usage is SQL OLAP support like stddev, ranks, > running sums/averages, windowing support, rollup and cube. Most of what you mention require a different approach to the data I think. Like running sums or windowing support somehow require you to examine 'streams' of data, thus acting on data as soon as it comes in. I don't think SQL is yet up for this job, the best you can do is simply simulate it. I think CUBE was added to SQL-2003 and therefore might get included, but I don't think on the short term. However, a concrete list of wishes is always welcome! Thanks for your input!

3 2

[MonetDB-users] JDBC driver
by Rodrigo Schmidt 12 Aug '05

12 Aug '05

I installed MonetDB_JDBC-1.2-Blunt-SR1.jar and I am getting the following problem when I try to load MonetDriver using class.forName(): java.lang.UnsupportedClassVersionError: nl/cwi/monetdb/jdbc/MonetDriver (Unsupported major.minor version 49.0). Does any of you know what the problem is? Cheers, Rodrigo

2 9

[MonetDB-users] Problem configuring MonetDB/XQuery
by Peter van der Kamp 11 Aug '05

11 Aug '05

I successfully build MonetDB, prior to configure and build the XQuery front end. However, running configure for this front end stops with: Checking for Mx... no configure: error: No Mx found in PATH I try to build the Mx software, without success. Before continuing I would like to know if the XQuery front end really needs Mx. Thanks. Peter van der Kamp

3 10

[MonetDB-users] inconsistent database
by Rodrigo Schmidt 10 Aug '05

10 Aug '05

Hi, While playing with SQL schemas (creating and eliminating them) I managed to put the database in an inconsistent state. Now I have a schema with nothing inside (neither users nor tables) and apparently I am not able to drop it. When I try, both database server and client crash with an internal error. Is there any monetdb tool that checks the database consistency and recovers it if a problem is identified? Cheers, Rodrigo

2 1

[MonetDB-users] Different storage spaces
by Rodrigo Schmidt 10 Aug '05

10 Aug '05

Hello, In my application I have several processes in a server, each one managing different and non-related pieces of data, which I intend to store in MonetDB databases. As these processes are not related to each other, I would like to put their data in logically different storage spaces, like a different catalog or a different schema inside the database, if not in in different databases themselves. I am just starting with MonetDB and I do not know how I can create new databases, catalogs or schemas and what I should do to configure these things on the server. Can you give me some hints about it? FYI, my application is written in Java and I am using the JDBC interface to connect to the database. Cheers, Rodrigo

2 1

[MonetDB-users] New
by rita kelly 08 Aug '05

08 Aug '05

3 2