The next wave in BI

Topic: Open Source Data Warehousing?

Date: 09/02/2009

By: D

Subject: Comparisons

Interesting post.

It looks like LucidDB has improved quite a bit from when I tried it out.

I also wanted to point out that things will change a lot once the data no longer fits into memory. In tests I ran with a tuned PostgreSQL database where the data was a lot more than memory, PostgreSQL outperformed MonetDB, which ran for hours.

It should do even better today with the 8.4 development HEAD of PostgreSQL, which significantly improves TPC-H performance for a couple of the really slow ones (I think one was NOT IN).