[Mondrian] Lots of Dimensions & Lots of Rows
mkambol at gmail.com
Thu Feb 8 17:18:27 EST 2007
It's very expensive. We've tested on a development license, but I found the
following snippet in an article: "a standard, two-server data warehouse
able to store 300 billion bytes starts at $486,000. "
On 2/7/07, Paul Ramsey <pramsey at refractions.net> wrote:
> Matt, how much does Teradata cost? Ballpark?
> Matt Campbell wrote:
> > We were running Mondrian on a dual core Win2003 server with 3Gig of
> > memory. The RDBMs for the tests with 100s of millions of fact rows was
> > Teradata, which gives very good performance for the sorts of queries
> > that Mondrian fires.
> > On 2/7/07, *Paul Ramsey* <pramsey at refractions.net
> > <mailto:pramsey at refractions.net>> wrote:
> > Matt, thanks for the anecdote, that is amazing (and great news)!
> > kind of hardware do you have backing your system?
> > Julian, thanks for the detailed response, it will be interesting
> > to fit our problem neatly into the OLAP space, but I see lots of
> > advantages to doing so in terms of pre-existing functionality. On
> > spatial side, by the time stuff hits the fact table, it is
> > non-spatial. All the spatial relationships (cell->region,
> > cell->watershed) are expressed in the dimensions at that point.
> > Yours,
> > Paul
> > Matt Campbell wrote:
> > > To add some anecdotal info-- we've successfully run Mondrian with
> > nearly
> > > 700 dimensions using fact tables with 100s of millions of
> > rows. We've
> > > noticed no performance degradation or instability from the number
> > > dimensions.
> > >
> Paul Ramsey
> Refractions Research
> pramsey at refractions.net
> Phone: 250-383-3022
> Cell: 250-885-0632
> Mondrian mailing list
> Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian