[Monetdb-developers] Any efforts on using bitmap indices?

Djoerd Hiemstra hiemstra at cs.utwente.nl
Tue Jul 24 12:29:29 CEST 2007


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
> >> Monetdb-developers at lists.sourceforge.net
> >> 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: Niels.Nes at cwi.nl
> > 
> > -------------------------------------------------------------------------
> > 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
> > Monetdb-developers at lists.sourceforge.net
> > 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
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers
> 




More information about the developers-list mailing list