[Mondrian] Lots of Dimensions & Lots of Rows

Matt Campbell 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)!
> What
> >     kind of hardware do you have backing your system?
> >
> >     Julian, thanks for the detailed response, it will be interesting
> trying
> >     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
> the
> >     spatial side, by the time stuff hits the fact table, it is
> essentially
> >     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
> of
> >      > dimensions.
> >      >
>
>
> --
>
>    Paul Ramsey
>    Refractions Research
>    http://www.refractions.net
>    pramsey at refractions.net
>    Phone: 250-383-3022
>    Cell: 250-885-0632
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070208/1f3095c3/attachment.html 


More information about the Mondrian mailing list