Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Cubulus OLAP / News: Recent posts

hierarchical charts

New feature: hierarchical charts. The vertical boxes represent hierarchy "on rows", horizontal boxes represent datasets "on columns" scaled to the "on rows" measure. (See the online demo at http://alxtoth.webfactional.com ). Use a SVG-capable browser such as Firefox or Safari.

Posted by alxtoth 2007-10-21

looking for hardware donations to test scalability

Currently Cubulus scaling status is:
"scale up approach" = use multiple Python threads for running SQL queries. Works in theory: one single core CPU runs all the threads. Practical result: it does not crash under Apache Bench stress testing
-"scale out approach" = managed to set up a "cluster" of database processes running in same machine, but listening on different ports. It should be possible to run databases on different IP adresses, not just different ports. Fail-over and load balancing works when database processes are stopped & restarted. Again, it does not crash under load on single-core CPU
-"MySQL parallel query" - briefly tested on a friend's Intel Core Duo laptop. Setup : one Python thread, and MySQL 5.1 beta doing automatically parallel query on the partitioned table. The two cores were waiting for each other , most likely because partitions are not equal. ... read more

Posted by alxtoth 2007-05-22

initial support for MonetDB

MonetDB ( http://monetdb.cwi.nl/ ) database is cca 10 to 15 times faster than MySQL (partitioned, no indexes) in regards to Cubulus queries. This is due to Monet being a "column-oriented" database.

I don't mean to start a benchmarking "flamewar". In you have tuning / porting advices for your favourite DB, please share your thoughts.

Posted by alxtoth 2007-05-22

support for PostgreSQL

Since version 0.49 posgres is supported.

Posted by alxtoth 2007-04-26

out of the box

Version 0.48 includes all libraries except sqlite (comes with Python 2.5) and MySQLdb (platform dependent, must be installed separately).

Default database is now SQLite

Posted by alxtoth 2007-04-25

MDX

Cubulus understands a basic subset of MDX syntax starting with version 0.46

Posted by alxtoth 2007-04-17

presentation slides

Brief presentation material at http://cubulus.sourceforge.net/

Posted by alxtoth 2007-04-17