Re: Microsoft destroys TPC-C records!

On 23 Feb 2000 02:49:56 GMT, Norris <jcheong_at_cooper.com.hk> wrote:

> Still, the SQL Server team wanted some way to prove its product's performance, even if it couldn't use materialized views to answer the challenge Oracle posed. In mid-March, the team announced it had decided to use OLAP techniques rather than materialized views to run the specific TPC-D query cited in the Oracle challenge. As opposed to materialized views, which pre-compute summary tables based on advanced knowledge of the nature of the likely queries, OLAP is more of a post-load, on-the-fly technique to
 

>compute such values. Working with partner Hewlett-Packard, Microsoft constructed a 1TB OLAP cube based on the TPC-D query. According to Microsoft, the resulting system matched or exceeded the performance of the Oracle system, but cost only about one-twentieth as much.
>

"According to Microsoft" is the operative sentence here....

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Feb 23 2000 - 07:23:09 CST