Thanks for the link, i didnt know MonetDB had fts support. However i am looking for the full text search capability in the SQL. Something like
select * from table where column ='+include this text -but with out this' so that we can combine the boolean text query along with the normal joins. FastBit ( accorrding to the doc) has integrated this with MonetDB by overriding the = operator. Thanks Bharani Djoerd Hiemstra-2 wrote: > > > Dear Bharani, > > There is support for full text search in MonetDB/XQuery, see: > http://dbappl.cs.utwente.nl/pftijah/ > > Best, Djoerd. > > -- > 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 > > > On Mon, 23 Jul 2007, Bharani wrote: > >> >> Hi, >> >> Is there a plan to support full text search(FTS) in MonetDB as well? The >> pdf >> (http://crd.lbl.gov/~kewu/ps/LBNL-61768.pdf) talks about integrating FTS >> into monetdb sql using lucene as tokenizer. >> >> Postgresql has tsearch2 but lucene is a clear win when it comes to >> performance. It will be nice to have the power of MonetDB 'join' with the >> fts capability. >> >> Thanks >> Bharani >> >> >> >> Niels Nes wrote: >> > >> > On Fri, Jul 13, 2007 at 01:37:42PM +0200, Gabriel Welsche wrote: >> >> Hello, >> >> >> >> does anybody consider supporting bitmap indices? >> >> >> >> An indexing software called FastBit was integrated to MonetDB >> >> (http://crd.lbl.gov/~kewu/ps/LBNL-61768.pdf) >> >> and some benchmarks show that there were serious improvements >> concerning >> >> combined numerical and text queries (offers up to 10 times better >> >> performance then MonetDB without FastBit). >> > >> > We plan to look at the code from the FastBit group. They are working >> > hard to make their code available in open source. Than the MonetDB >> > team will have a look at their efforts integrating that into >> MonetDB/SQL. >> > We hopefully get a maintainable patch for MonetDB out of this. >> > >> > Niels >> >> >> >> Gabriel >> >> >> >> >> ------------------------------------------------------------------------- >> >> This SF.net email is sponsored by DB2 Express >> >> Download DB2 Express C - the FREE version of DB2 express and take >> >> control of your XML. No limits. Just data. Click to get it now. >> >> http://sourceforge.net/powerbar/db2/ >> >> _______________________________________________ >> >> Monetdb-developers mailing list >> >> [email protected] >> >> https://lists.sourceforge.net/lists/listinfo/monetdb-developers >> > >> > -- >> > >> > Niels Nes, Centre for Mathematics and Computer Science (CWI) >> > Kruislaan 413, 1098 SJ Amsterdam, The Netherlands >> > room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 >> > url: http://www.cwi.nl/~niels e-mail: [EMAIL PROTECTED] >> > >> > >> ------------------------------------------------------------------------- >> > This SF.net email is sponsored by DB2 Express >> > Download DB2 Express C - the FREE version of DB2 express and take >> > control of your XML. No limits. Just data. Click to get it now. >> > http://sourceforge.net/powerbar/db2/ >> > _______________________________________________ >> > Monetdb-developers mailing list >> > [email protected] >> > https://lists.sourceforge.net/lists/listinfo/monetdb-developers >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/Any-efforts-on-using-bitmap-indices--tf4073766.html#a11756856 >> Sent from the monetdb-developers mailing list archive at Nabble.com. >> >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by: Splunk Inc. >> Still grepping through log files to find problems? Stop. >> Now Search log events and configuration files using AJAX and a browser. >> Download your FREE copy of Splunk now >> http://get.splunk.com/ >> _______________________________________________ >> Monetdb-developers mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/monetdb-developers >> > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Monetdb-developers mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-developers > > -- View this message in context: http://www.nabble.com/Any-efforts-on-using-bitmap-indices--tf4073766.html#a11777027 Sent from the monetdb-developers mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
