- users-list - monetdb.org

[MonetDB-users] Yeah recommends
by Chaim Lonsberry 03 Apr '07

03 Apr '07

Byte PC World curtain shows http://img444.imageshack.us/my.php?image=bkqu5.gif tabs shown he

1 0

[MonetDB-users] [PF/Tijah] How to do a full text search?
by Sander Bockting 02 Apr '07

02 Apr '07

Dear all, We are trying to do a full text search in a database, but we can use some help to get started. A small excerpt from our database is stated below: //=== xquery>doc("ep") <?xml version="1.0" encoding="utf-8"?> <eprintsdata xmlns="http://eprints.org/ep2/data"> <record> <field name="eprintid">629</field> <field name="keywords">Model-based on-the-fly Testing, Timed Automata, Real-Time Testing, TorX, Tools.</field> <field name="research_projects">STRESS: Systematic Testing of Real-time Software Systems</field> </record> <record> <field name="eprintid">642</field> <field name="keywords">Compositional modelling, supervisory control</field> <field name="research_projects">HYBRIDGE: Distributed Control and Stochastic Analysis of Hybrid Systems Supporting Safety Critical Real-Time Systems Design</field> </record> </eprintsdata> //=== The PF/Tijah Getting Started page (http://dbappl.cs.utwente.nl/pftijah/Documentation/GettingStarted) mentions we can do a full text query as follows: let $c := collection("MyCollection") for $res in tijah:query($c, "//html[about(., ir db)]") return $res/head/title I believe this way is probably outdated, as tijah:query does not work. To suit our needs, I changed the query to the following form: //=== let $c := collection("ep") for $res in pf:tijah-query($c,"//field[@name='research_projects'][about(., Distributed)]") return $res //=== But this results in the following error: "ERROR = !ERROR: interpret: unknown variable 'collName'" That is why I incorporated the collection name in the query, like this: //=== for $res in pf:tijah-query(ep,"//field[@name='research_projects'][about(., Distributed)]") return $res //=== However, this also does not work, as I get the following error: "ERROR = !illegal reference to context node: at (1,29-1,30): ``.'' is unbound" I have tried numerous of other variations, but neither of them work. Can somebody please help us with an explanation about how we can do a full text search within a certain node or point us at a more recent getting started page (if it already exists)? Kind regards, Sander Bockting

2 2

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

31 Mar '07

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

1 0

[MonetDB-users] UNION with ORDER BY crash
by Colin Foss 30 Mar '07

30 Mar '07

I am running latest 4.x line on Windows 64bit. If I run the following SQL Mserver will die every time. ---------------------------------- create table tmp_one (data numeric(5)); create table tmp_two (data numeric(5)); /* this is ok */ select data from tmp_one union select data from tmp_two ; /* this will crash server */ select data from tmp_one union select data from tmp_two order by data ; ---------------------------------- Is "ORDER BY" supported with a UNION ?

2 2

[MonetDB-users] mjclient missing
by Shahbaz 27 Mar '07

27 Mar '07

I just installed MonetDB on my linux (Fedora Core 6) system with --enable-sql but mjclient doesn't seem to be in my MonetDB/bin directory (it was there when I installed it on my osx machine). I installed using --cvs=current. I have java installed and can confirm java and javac from the same command line where I issued the monetdb-install command. My install script's version is 1.9. Any ideas?

3 3

Re: [MonetDB-users] ERROR = !ERROR: add-doc((null)): document name must end in .xml
by Djoerd Hiemstra 26 Mar '07

26 Mar '07

Dear Peter, I do not understand your "consistency" argument. Surely, you can find some way to serve files with any name through http? Best, Djoerd. > On Sat, Mar 24, 2007 at 04:02:22PM +0100, Torsten Grust wrote: >> Hi all, >> >> while I appreciate the http access functionality for database >> documents, I do feel that this (rather strict) naming convention >> is unfortunate. There are a lot of XML files out there that use >> non-'.xml' endings ('.xhtml' and '.xsl' come to mind, immediately). >> >> >> Cheers, --Torsten >> >> On 3/24/07, p.a.boncz(a)chello.nl <p.a.boncz(a)chello.nl> wrote: >>> Hi, >>> >>> MonetDB/XQuery has an integrated HTTP server that treats GET (and >>> PUT,DELETE) requests for URLs that end in .xml or .XML in a >>> special way. >>> >>> Such files are not served from the http file directory >>> (datadir/xrpc/) but are taken to be requests for XML documents >>> stored in MonetDB/XQuery. >>> >>> Since the moment this feature was added, indeed the restriction >>> has been imposed that all documents in the database should have a >>> name ending in .xml This was done for consistency: now all >>> documents X in the database can be retrieved through HTTP (i.e. >>> http://yourserver:50001/X) >>> >>> If the restriction is not imposed, the HTTP access method will >>> not work anymore for all documents. >>> >>> Peter >>> >>> >>> ---- Stefan Manegold <Stefan.Manegold(a)cwi.nl> schreef: >>>> Peter, >>>> >>>> could you please have a look at this and comment? >>>> >>>> Thank you very much in advance! Stefan >>>> >>>> >>>> On Sat, Mar 24, 2007 at 02:02:27PM +0100, Stefan Manegold >>>> wrote: >>>>> Two tests fail (apparently unnoticed for some time) due to >>>>> the same problem; cf. >>>>> >>>>> http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… >>>>> >>>>> http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… >>>>> >>>>> >>>>> Stefan >>>>> >>>>> >>>>> On Fri, Mar 23, 2007 at 09:17:59AM +0100, Djoerd Hiemstra >>>>> wrote: >>>>>> Dear Martin, >>>>>> >>>>>> You are right, sorry, here is the English translation: >>>>>> Recently it is no longer possible to add logical names for >>>>>> XML documents that do not end with .xml, for instance >>>>>> >>>>>> let $site := "http://www.sigir2007.org/" let $pages := >>>>>> ("index.html", "cfp.html", "cfw.html") for $page in $pages >>>>>> return pf:add-doc(concat($site, $page), $page, "MySIGIR") >>>>>> >>>>>> gives: ERROR = !ERROR: add-doc((null)): document name must >>>>>> end in .xml (3 such errors)! >>>>>> >>>>>> In the previous version this was possible, and I use it for >>>>>> instance in a demo for one of our industrial partners in >>>>>> the MultimediaN project. Can this error please be removed? >>>>>> XML documents can have many extensions, for instance.rss, >>>>>> .xhtml, .svg, etc. I might want to add to the database: >>>>>> sigir.html (web page in xhtml) sigir.xml (source of the >>>>>> page) sigir.xsd (schema of the page) sigir.rss (RSS feed >>>>>> of the page) sigir.svg (page as a nice graphic) sigir.mml >>>>>> (mathematical formula of the page) etc, etc., >>>>>> >>>>>> I think the error is too restrictive. >>>>>> >>>>>> Best regards, Djoerd. >>>>>> >>>>>> Martin Kersten wrote: >>>>>>> Djoerd, >>>>>>> >>>>>>> Please, realize that this list is read worldwide. English >>>>>>> is the preferred language. It is also readable for 100 >>>>>>> people in Beijing looking at this mailing list. >>>>>>> >>>>>>> regards, Martin >>>>>>> >>>>>>> Djoerd Hiemstra wrote: >>>>>>>> Ha die MonetDBs, >>>>>>>> >>>>>>>> Ik zie dat het niet meer langer toegestaan is om >>>>>>>> logische namen van documenten in de database te hebben >>>>>>>> die niet op .xml eindigen, bijvoorbeeld: >>>>>>>> >>>>>>>> let $site := "http://www.sigir2007.org/" let $pages := >>>>>>>> ("index.html", "cfp.html", "cfw.html") for $page in >>>>>>>> $pages return pf:add-doc(concat($site, $page), $page, >>>>>>>> "MySIGIR") >>>>>>>> >>>>>>>> geeft: >>>>>>>> >>>>>>>> ERROR = !ERROR: add-doc((null)): document name must end >>>>>>>> in .xml (3 such errors)! >>>>>>>> >>>>>>>> Dit mocht eerder wel. Kan dit teruggedraaid worden? XML >>>>>>>> documenten kunnen veel extensies hebben, bijvoorbeeld >>>>>>>> .rss, .xhtml, .svg, etc. Ik wil misschien wel >>>>>>>> toevoegen: sigir.html (webpagina in xhtml) sigir.xml >>>>>>>> (source van webpagina) sigir.rss (RSS feed voor >>>>>>>> pagina) sigir.svg (pagina als mooi plaatje) sigir.mml >>>>>>>> (wiskundige formulering voor pagina) enz., enz. >>>>>>>> >>>>>>>> Ik vind deze foutmelding te restrictief. >>>>>>>> >>>>>>>> Groetjes, Djoerd. >>>>>>>> >>>>>>>> ------------------------------------------------------------------------- >>>>>>>> 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 >>>>>>>> >>>>>> ------------------------------------------------------------------------- >>>>>> 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 >>>>> -- | 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 | >>>>> >>>>> ------------------------------------------------------------------------- >>>>> 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 >>>>> >>>> -- | 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 | >>> >>> ------------------------------------------------------------------------- >>> 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 >>> >> >> -- | Torsten "Teggy" Grust | Torsten.Grust(a)gmail.com >> >> ------------------------------------------------------------------------- >> 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 > -- Djoerd Hiemstra University of Twente Department of Computer Science PO Box 217, 7500 AE Enschede, The Netherlands URL: www.cs.utwente.nl/~hiemstra Tel: +31 53 4892335

2 1

Re: [MonetDB-users] ERROR = !ERROR: add-doc((null)): document name must end in .xml
by p.a.boncz＠chello.nl 25 Mar '07

25 Mar '07

Hi, MonetDB/XQuery has an integrated HTTP server that treats GET (and PUT,DELETE) requests for URLs that end in .xml or .XML in a special way. Such files are not served from the http file directory (datadir/xrpc/) but are taken to be requests for XML documents stored in MonetDB/XQuery. Since the moment this feature was added, indeed the restriction has been imposed that all documents in the database should have a name ending in .xml This was done for consistency: now all documents X in the database can be retrieved through HTTP (i.e. http://yourserver:50001/X) If the restriction is not imposed, the HTTP access method will not work anymore for all documents. Peter ---- Stefan Manegold <Stefan.Manegold(a)cwi.nl> schreef: > Peter, > > could you please have a look at this and comment? > > Thank you very much in advance! > > Stefan > > > On Sat, Mar 24, 2007 at 02:02:27PM +0100, Stefan Manegold wrote: > > Two tests fail (apparently unnoticed for some time) due to the same problem; > > cf. > > > > http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… > > http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… > > > > Stefan > > > > > > On Fri, Mar 23, 2007 at 09:17:59AM +0100, Djoerd Hiemstra wrote: > > > Dear Martin, > > > > > > You are right, sorry, here is the English translation: > > > Recently it is no longer possible to add logical names for XML > > > documents that do not end with .xml, for instance > > > > > > let $site := "http://www.sigir2007.org/" > > > let $pages := ("index.html", "cfp.html", "cfw.html") > > > for $page in $pages > > > return pf:add-doc(concat($site, $page), $page, "MySIGIR") > > > > > > gives: > > > ERROR = !ERROR: add-doc((null)): document name must end in .xml > > > (3 such errors)! > > > > > > In the previous version this was possible, and I use it for instance in > > > a demo for one of our industrial partners in the MultimediaN project. > > > Can this error please be removed? XML documents can have many > > > extensions, for instance.rss, .xhtml, .svg, etc. I might want to add to > > > the database: > > > sigir.html (web page in xhtml) > > > sigir.xml (source of the page) > > > sigir.xsd (schema of the page) > > > sigir.rss (RSS feed of the page) > > > sigir.svg (page as a nice graphic) > > > sigir.mml (mathematical formula of the page) > > > etc, etc., > > > > > > I think the error is too restrictive. > > > > > > Best regards, > > > Djoerd. > > > > > > Martin Kersten wrote: > > > > Djoerd, > > > > > > > > Please, realize that this list is read worldwide. English is > > > > the preferred language. It is also readable for 100 people in > > > > Beijing looking at this mailing list. > > > > > > > > regards, Martin > > > > > > > > Djoerd Hiemstra wrote: > > > >> Ha die MonetDBs, > > > >> > > > >> Ik zie dat het niet meer langer toegestaan is om logische namen van > > > >> documenten in de database te hebben die niet op .xml eindigen, > > > >> bijvoorbeeld: > > > >> > > > >> let $site := "http://www.sigir2007.org/" > > > >> let $pages := ("index.html", "cfp.html", "cfw.html") > > > >> for $page in $pages > > > >> return pf:add-doc(concat($site, $page), $page, "MySIGIR") > > > >> > > > >> geeft: > > > >> > > > >> ERROR = !ERROR: add-doc((null)): document name must end in .xml (3 > > > >> such errors)! > > > >> > > > >> Dit mocht eerder wel. Kan dit teruggedraaid worden? XML documenten > > > >> kunnen veel extensies hebben, bijvoorbeeld .rss, .xhtml, .svg, etc. Ik > > > >> wil misschien wel toevoegen: > > > >> sigir.html (webpagina in xhtml) > > > >> sigir.xml (source van webpagina) > > > >> sigir.rss (RSS feed voor pagina) > > > >> sigir.svg (pagina als mooi plaatje) > > > >> sigir.mml (wiskundige formulering voor pagina) > > > >> enz., enz. > > > >> > > > >> Ik vind deze foutmelding te restrictief. > > > >> > > > >> Groetjes, Djoerd. > > > >> > > > >> ------------------------------------------------------------------------- > > > >> 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 > > > > > > ------------------------------------------------------------------------- > > > 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 > > > > -- > > | 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 | > > > > ------------------------------------------------------------------------- > > 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 > > > > -- > | 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] ERROR = !ERROR: add-doc((null)): document name must end in .xml
by Djoerd Hiemstra 24 Mar '07

24 Mar '07

Ha die MonetDBs, Ik zie dat het niet meer langer toegestaan is om logische namen van documenten in de database te hebben die niet op .xml eindigen, bijvoorbeeld: let $site := "http://www.sigir2007.org/" let $pages := ("index.html", "cfp.html", "cfw.html") for $page in $pages return pf:add-doc(concat($site, $page), $page, "MySIGIR") geeft: ERROR = !ERROR: add-doc((null)): document name must end in .xml (3 such errors)! Dit mocht eerder wel. Kan dit teruggedraaid worden? XML documenten kunnen veel extensies hebben, bijvoorbeeld .rss, .xhtml, .svg, etc. Ik wil misschien wel toevoegen: sigir.html (webpagina in xhtml) sigir.xml (source van webpagina) sigir.rss (RSS feed voor pagina) sigir.svg (pagina als mooi plaatje) sigir.mml (wiskundige formulering voor pagina) enz., enz. Ik vind deze foutmelding te restrictief. Groetjes, Djoerd.

3 4

[MonetDB-users] allow children lessen
by Viktoras Pool 24 Mar '07

24 Mar '07

Because dozens, sane would tell teams probably? Ready microsoft, will see. Services unique provide richer. Help take whole level. Et excs de, zle siliconfr album. Any drive tool, automated which removes, complexity setting. Director bill, hilf says, research! Forpowered by xpearlier for, pcsshared, computer. Clients exchange my, we around customers? Rest competency biggest areas doesnt captured elements, model spend. Coffee, coffeegeek, consoles, copinage. Eyebrows last executive, speak! Whether network, internetor even within emailwith. Salons sante, scifi sdk seventies sf sg. Lessen risk malicious harmful changes pcprovide, critical. Competency biggest areas doesnt captured elements model. Advisor determine minimum supported mhz super vga genuine. Amount rest competency biggest areas doesnt. Next tvs throughout just room? Team, build do type labhilf. Fifties fightclub firefox font fonts, freeware funstuff galeries gamedod. Mahjong titans, chess titansyou capture edit publish format. Held united states started friends.

1 0

[MonetDB-users] SQL database recovery
by Colin Foss 23 Mar '07

23 Mar '07

Somehow I've managed to get MonetDB into a state that the sql_server does not startup sucessfully. Steps leading up to the failure were: 1. delete 49M rows from a table 2. reload 49M rows into table using COPY INTO 3. did select count(*) on table. 4. looked at sql_logs and noticed one of the files was approximately 5G. 5. killed monet process 6. restarted monet. I waited for about 30 minutes and the SQL frontend never responded. Normally steps 5 and 6 take about 8 minutes. Questions. 1. Is there a cleaner way to shutdown monet besides killing the process? I tried "commit();" before the shutdown but that never seems to decrease the initialization time. 2. what debug settings should I turn on to determine what is failing during --dbinit="module(sql_server)" ? 3. I noticed that there are several (700M) .buns files associated with a table that I had deleted all rows from before the restart. ls() reports a zero count but why are the files still that large?

1 0