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. "<br><br><div><span class="gmail_quote">On 2/7/07, <b class="gmail_sendername">Paul Ramsey</b> <<a href="mailto:pramsey@refractions.net">pramsey@refractions.net
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Matt, how much does Teradata cost? Ballpark?<br><br>Matt Campbell wrote:
<br>><br>> We were running Mondrian on a dual core Win2003 server with 3Gig of<br>> memory. The RDBMs for the tests with 100s of millions of fact rows was<br>> Teradata, which gives very good performance for the sorts of queries
<br>> that Mondrian fires.<br>><br>><br>> On 2/7/07, *Paul Ramsey* <<a href="mailto:pramsey@refractions.net">pramsey@refractions.net</a><br>> <mailto:<a href="mailto:pramsey@refractions.net">pramsey@refractions.net
</a>>> wrote:<br>><br>> Matt, thanks for the anecdote, that is amazing (and great news)! What<br>> kind of hardware do you have backing your system?<br>><br>> Julian, thanks for the detailed response, it will be interesting trying
<br>> to fit our problem neatly into the OLAP space, but I see lots of<br>> advantages to doing so in terms of pre-existing functionality. On the<br>> spatial side, by the time stuff hits the fact table, it is essentially
<br>> non-spatial. All the spatial relationships (cell->region,<br>> cell->watershed) are expressed in the dimensions at that point.<br>><br>> Yours,<br>><br>> Paul<br>><br>> Matt Campbell wrote:
<br>> > To add some anecdotal info-- we've successfully run Mondrian with<br>> nearly<br>> > 700 dimensions using fact tables with 100s of millions of<br>> rows. We've<br>> > noticed no performance degradation or instability from the number of
<br>> > dimensions.<br>> ><br><br><br>--<br><br> Paul Ramsey<br> Refractions Research<br> <a href="http://www.refractions.net">http://www.refractions.net</a><br> <a href="mailto:pramsey@refractions.net">
pramsey@refractions.net</a><br> Phone: 250-383-3022<br> Cell: 250-885-0632<br>_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br></blockquote></div><br>