S. Lott has written a short note regarding Cubulus. Quote: "It may be that this technique helps a lot with an RDBMS that doesn't support the star schema via bit-mapped indexes. It may be that this technique only helps a little with a more modern RDBMS."
Somewhat true, haven't measured GROUP BY versus range-queries with bitmap indexes (say, in Oracle), and neither in MonetDB. Time will tell if simpler and "embarrasingly parallel" SQL is better..
Sunday, May 27, 2007
Wednesday, May 16, 2007
compiling MonetDB python libraries on the Mac
MonetDB is a "think different" kind of database. Link: http://monetdb.cwi.nl
Here are some notes for the builtin python2.3 for Mac OS X 10.4.9 . It builds correctly, and it works after manually moving some libs .
-headers: /usr/include/python2.3/
-libs: /usr/lib (/usr/lib/libpython.dylib , /usr/lib/libpython2.dylib , /usr/lib/libpython2.3.dylib )
-site-packages: /usr/lib/python2.3/site-packages/
-dynamic libs: /usr/lib/python2.3/lib-dynload/
It is easy to get readline from www.darwinports.org (sudo port install readline):
-Headers: /opt/local/include/readline
-Libs: /opt/local/lib/libreadline.5.0.dylib /opt/local/lib/libreadline.a /opt/local/lib/libreadline.5.dylib /opt/local/lib/libreadline.dylib
Swig also from darwinports , installed as: /opt/local/bin/swig . (Get it with: sudo port install swig)
./configure --with-python=python2.3 --with-python-library=/usr/lib --with-python-incdir=/usr/include/python2.3/ --with-swig=/opt/local/bin/swig
make
sudo make install
This still DOES NOT copy MonetSQLdb under python2.3 site-packages, and places dynamic libs under /usr/local/lib/python2.3/site-packages/lib/ instead of usr/lib/python2.3/lib-dynload/
Fixed with:
cp /usr/local/lib/python2.3/site-packages/lib/_* ~/Desktop/clients/src/python/Cimpl/MonetSQLdb
cp /usr/local/lib/python2.3/site-packages/lib/_* ~/Desktop/clients/src/python/Cimpl
Here are some notes for the builtin python2.3 for Mac OS X 10.4.9 . It builds correctly, and it works after manually moving some libs .
-headers: /usr/include/python2.3/
-libs: /usr/lib (/usr/lib/libpython.dylib , /usr/lib/libpython2.dylib , /usr/lib/libpython2.3.dylib )
-site-packages: /usr/lib/python2.3/site-packages/
-dynamic libs: /usr/lib/python2.3/lib-dynload/
It is easy to get readline from www.darwinports.org (sudo port install readline):
-Headers: /opt/local/include/readline
-Libs: /opt/local/lib/libreadline.5.0.dylib /opt/local/lib/libreadline.a /opt/local/lib/libreadline.5.dylib /opt/local/lib/libreadline.dylib
Swig also from darwinports , installed as: /opt/local/bin/swig . (Get it with: sudo port install swig)
./configure --with-python=python2.3 --with-python-library=/usr/lib --with-python-incdir=/usr/include/python2.3/ --with-swig=/opt/local/bin/swig
make
sudo make install
This still DOES NOT copy MonetSQLdb under python2.3 site-packages, and places dynamic libs under /usr/local/lib/python2.3/site-packages/lib/ instead of usr/lib/python2.3/lib-dynload/
Fixed with:
cp /usr/local/lib/python2.3/site-packages/lib/_* ~/Desktop/clients/src/python/Cimpl/MonetSQLdb
cp /usr/local/lib/python2.3/site-packages/lib/_* ~/Desktop/clients/src/python/Cimpl
Subscribe to:
Posts (Atom)