| Title: | Executive Information Solutions & Data Warehousing Conference |
| Notice: | Welcome to the Data Warehousing conference |
| Moderator: | 26002::HAGGERTY |
| Created: | Thu Sep 01 1994 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 499 |
| Total number of notes: | 2932 |
Hi,
our biggest telecom company is preparing to do a benchmark
with Digital, HP, Sun and IBM.
The benchmark will consist of running 3 of the 17 TPC-D queries
and a Load operation. He wants each company to suggest the
database (Oracle or Informix).
He is also asking for each company, what would be the 3 TPC-D queries
that would have the best price/performance results, in our case
for our AlphaServers.
I told him this is a hard work, we have to understand in details
what the query does. He gave one hint that the other companies
asked for Q3 query.
Does anyone have an idea on this using our equipments? Would
the results be the same if I use Oracle or Informix?
Thanks in advance,
Cristina
Sales Support/Brazil
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 491.1 | yikes | 26002::HAGGERTY | Kevin, NSIS, Stow MA USA | Fri May 09 1997 02:28 | 2 |
Cristina, you better talk to Bhagyam Moses (perfom::moses) about
this...
| |||||
| 491.2 | If queries only, try Red Brick | UTROP1::utoras-198-48-101.uto.dec.com::olthof_h | Spellchecked Henry Although | Fri May 09 1997 10:00 | 19 |
Christina, Agree that you should talk to Bagyam. If I recall well, TPC-D requires that the results of all 17 queries are disclosed (responsetimes etc). So in theory you could get these from the detailed reports from the TPC web site http://www.tpc.org. Comparing the result you could get an idea where we do best. Also on this site you find the specifications of the benchmark so you can see what Q3 realy is. But, TPC-D is setup in such a way that it gives a representative (for what its worth) workload on the system for data analysis. Selecting just 3 queries will give a wrong picture about real capabilities of platforms and or combinations. If it is just three queries they are running you could consider Red Brick as probably the fastest engine. Cheers, Henny | |||||