Re: Larry Ellison and million bucks!

I agree in principal with what you say. I do not know what the TPC D spec would say about use of this feature; and it would be good to disclose it's use.

But I think it is an important and valuable feature; one that users can use to their advantage in real world situations. It is true that often people will make queries against a data warehouse that the people managing the data warehouse do not know of in advance. (which this feature may not help one iota.) It is also true that there are often reports etc that get run periodically (accounting rollups etc.) month and these would benefit greatly from this feature.

One other point is that MS SQL server (6.5 or 7) is not designed to scale to large data warehouse queries regardless of this special Oracle feature.
Jim

On Tue, 24 Nov 1998 16:33:18 +0000, Snorri Bergmann <snorri_at_strengur.is> wrote:

>Here we go again.
>
>Remember when Oracle 7.1 was released? It set new TPC-C benchmark
>records all over the place. But when people started to read the full
>disclosure reports they saw a new 'feature' in Oracle 7.1 was being
>used: Discrete Transaction. DT was of no real value for customers and
>was basically a special feature that was coded in Oracle 7 specifically
>for the TPC-C benchmark.
>Oracle users: How many of you use the Discrete Transactions feature?
>
>Now Oracle has done it again!
>Have you heard about the features "Materialized views" and "Pre-computed
>aggregates" in Oracle 8i? These features allow Oracle to pre-compute the
>outcome of pre-defined queries during load!
>
>Now I read that "Oracle Corp. will pay $1 million to the first person --
>including anyone at Microsoft -- who can demonstrate that MS SQL Server
>7.0 is not 100 times slower than the Oracle database when running a
>standard business query against a large database".
>More specifically, Oracle is talking about Query no. 5 in the TPC-D
>benchmark.
>
>I suggest people should not waste their time doing this benchmark
>because, as expected, Oracle is bending benchmark rules again (at least
>the spirit of the benchmark).
>
>Oracle claims: "Currently Oracle holds every database performance record
>in the world including data warehousing (TPC-D)..". Now, let's look at
>this statement.
>
>At www.tpc.org executive summaries of benchmarks can be obtained. Oracle
>has published two 1 TB benchmarks, both on Sun. Here are vital stats
>from these (An Informix 1 TB benchmark is included for comparison)
>
>Hardware DBMS Load time Time for
>Query 5
>Sun Ultra Enterpr. 10000 Oracle 8.04 27:02:02 1315.5 sec.
>Sun Starf. Enterpr. 10000 Oracle 8i 44:35:00 71.5 sec.
>Sun Enterprise 6000 Informix 8.21 11:55:23 561.5
>sec.
>
>Your first impression is probably: Oracle 8i is almost 20 times faster
>than Oracle 8.0.4!! However, load times are 50% longer, (in fact almost
>400% longer than in Informix). This is because Oracle has pre-computed
>the outcome of all the TPC-D queries (filter, join, aggregate etc.)
>during load time and stored the results in internal tables. Great stuff
>for the TPC-D benchmark beacuse all queries are known in advance. So,
>Oracle 8i is probably reading 20 times less data in this particular case
>than 8.0.4.
>
>I can imagine that Data Warehouse administrators can't wait to get their
>hands on these new features because they know that
>
>1) Load times don't matter
>2) All queries in the DW are known in advance
>3) DW queries are NOT ad hoc in nature
>
>NOT!
>
>Take care,
>-Snorri

Jim Kennedy X7055 Received on Wed Nov 25 1998 - 00:00:00 CST