[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference nsic00::eis_dw

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

171.0. "TPC-D results" by IJSAPL::OLTHOF (I answer MAIL!) Wed Dec 27 1995 15:14

T.RTitleUserPersonal
Name
DateLines
171.1IBM got it wrong, but will correct shortlyIJSAPL::OLTHOFI answer MAIL!Wed Dec 27 1995 15:3223
171.2TPC-D for Digital?OTOP89::"[email protected]"Tue Jan 02 1996 22:425
171.3let's ask OracleSTOWOA::HAGGERTYS.I. PM&D, Stow MA USAWed Jan 03 1996 04:056
171.4Informix as databaseIJSAPL::OLTHOFI answer MAIL!Wed Jan 03 1996 08:365
171.5Revised IBM TPC-D results IJSAPL::OLTHOFI answer MAIL!Wed Jan 03 1996 16:0458
171.6on a somewhat related note...57785::HAGGERTYS.I. PM&D, Stow MA USAFri Jan 26 1996 19:079
171.7NCR TPC-D resultIJSAPL::OLTHOFI answer MAIL!Mon Feb 19 1996 20:26168
171.8IBM SP2 300gbSTOWOA::HAGGERTYS.I. PM&D, Stow MA USAFri Apr 05 1996 21:5780
171.9impressiveSTOWOA::HAGGERTYS.I. S/W Business, Stow MA USATue Apr 30 1996 02:173
171.10no FDR yet; Sun p.r. from their WWW pagesSTOWOA::HAGGERTYS.I. S/W Business, Stow MA USAFri May 03 1996 03:29137
171.11When Digital TPC-D?SEAWLF::BOLLINGERAlan Bollinger, DTN 339-5217Fri May 24 1996 23:476
171.12new from NCRSTOWOA::HAGGERTYS.I. S/W Business, Stow MA USAFri Jun 07 1996 19:37121
171.13Digital's record numbers - more later!!!STOWOA::HAGGERTYSBU ASE, Stow MA USATue Sep 03 1996 17:2913
171.14The correct Digital TPC-D resultsIJSAPL::OLTHOFSpellchecked Henry AlthoughWed Sep 04 1996 09:5593
171.15Pyramid's 300gb test resultsSTOWOA::HAGGERTYSBU ASE, Stow MA USAThu Sep 19 1996 16:33112
171.16SP2 300gb 1360QppD $11969 price/perfEPS::HAGGERTYSBU ASEMon Nov 04 1996 20:5133
171.17the latest TPC-D submissionsEPS::HAGGERTYSBU ASE, Nashua NH USAThu Dec 05 1996 16:3612
171.18in case we never mentioned it...EPS::HAGGERTYSBU ASE, Nashua NH USAThu Dec 05 1996 16:466
171.18in case we never mentioned itEPS::HAGGERTYSBU ASE, Nashua NH USAThu Jan 02 1997 21:3210
171.19300gb test from SunEPS::HAGGERTYSBU ASE, Nashua NH USAThu Jan 23 1997 16:1434
171.20Compaq on NT with OracleEPS::HAGGERTYSBU ASE, Nashua NH USAWed Mar 05 1997 18:1527
This is a message from the TPC Alert Mailing List.

Test Sponsor:	Compaq Computer Corporation
Complete Name of System: ProLiant 5000 Model-1X
Spec. Revision: 1.2.1
Performance: 
  TPC-D Power: 232.6 QppD@100 GB
  TPC-D Throughput: 116.4 QthD@100 GB
  Price/Performance: 3678.97 $/QphD@100 GB
  Total System Cost: $605,190
Database Size: 100 GB
Database Software: Oracle 7.3.3
Operating System: Microsoft Windows NT 4.0 service pack 1
Cluster: NO
Total # CPUs: 4
# CPUs per Node/Server: 4
Processors/MHz of Server: PentiumPro 200MHz
availability date: June 30, 1997
Date Submitted to the TPC: March 3, 1997

A PDF copy of the executive summary and Full disclosure report have been 
uploaded to the TPC ftp drop site.

Bryon Georgson
Compaq Computer Corporation

 
171.21Sun Ultra 10000 Oracle 300gb (update of .19)EPS::HAGGERTYKevin, NSIS, Stow MA USASun Mar 23 1997 19:0932
Test Sponsor:  Sun Starfire Ultra Enterprise 10000 (Oracle) TPC-D SF300

Spec. Revision:  TPC-D 1.2.1

Performance
TPC-D Power:  2009.5 QppD
TPC-D Throughput:  1241.9 QthD

Price/performance: $3,312 QphD

Total System Cost:  $5,232,124

Database Size: 300 GB

Database Software:  Oracle7 v7.3.3

Operating System:  Solaris 2.5.1

TP Monitor:  None

Cluster?:  No

MP/UNI:  MP

Qty/Processors/MHz of Server:  64/UltraSPARC/250MHz

Availability Date:  8/1/97

Original Received:  3/21/97 (Electronic Submission)

-------------

171.22NCR re-prices 3 benchmarksEPS::HAGGERTYKevin, NSIS, Stow MA USAMon Mar 31 1997 18:14107
Subj:	NCR Repricing of TPC-D Benchmarks
    
This is a message from the TPC Alert Mailing List.

NCR is repricing its 3 TPC-D benchmarks on 5100M (20-node).

Alain Crolotte
NCR Corporation
(310)524-7271
[email protected]


________________________________________
1 Terabyte benchmark
----------------------------------------
Test Sponsor: NCR 
 
Spec. Revision:  TPC-D 1.1
 
Performance
TPC-D Power:  1879.4 QppD
TPC-D Throughput:  1151.9 QthD
Query Streams for Throughput test: 3
Price/performance: $9,039 per QphD @ 1TB
 
Total System Cost:  $13,299,725
 
Database Size: 1TB
 
Database Software:  Teradata V2R2.0
 
Operating System:  Unix SVR4 MP-RAS 3.00.00
 
TP Monitor:  None
 
Cluster?:  Yes (MPP) 20 5100M nodes with 8 133Mhz Pentium and 1GB of memory each
 
MP/UNI:  MP
 
Availability Date:  now
 
Original Received:  3/28/97 (Electronic Submission)


_________________________
300GB benchmark
-------------------------
Test Sponsor: NCR 
 
Spec. Revision:  TPC-D 1.1
 
Performance
TPC-D Power:  1501.1 QppD
TPC-D Throughput:  1028.3 QthD
Query Streams for Throughput test: 3
Price/performance: $9,374 per QphD @ 300GB
 
Total System Cost:  $11,645,965
 
Database Size: 300GB
 
Database Software:  Teradata V2R2.0
 
Operating System:  Unix SVR4 MP-RAS 3.00.00
 
TP Monitor:  None
 
Cluster?:  Yes (MPP) 20 5100M nodes with 8 133Mhz Pentium and 1GB of memory each
 
MP/UNI:  MP

Availability Date:  now
 
Original Received:  3/28/97 (Electronic Submission)


_________________________
100GB benchmark
-------------------------
Test Sponsor: NCR 
 
Spec. Revision:  TPC-D 1.1
 
Performance
TPC-D Power:  1441.9 QppD
TPC-D Throughput:  1150.4 QthD
Query Streams for Throughput test: 3
Price/performance: $9,043 per QphD @ 100GB
 
Total System Cost:  $11,645,965
 
Database Size: 100GB
 
Database Software:  Teradata V2R2.0
 
Operating System:  Unix SVR4 MP-RAS 3.00.00
 
TP Monitor:  None
 
Cluster?:  Yes (MPP) 20 5100M nodes with 8 133Mhz Pentium and 1GB of memory each
 
MP/UNI:  MP

Availability Date:  now
 
Original Received:  3/28/97 (Electronic Submission)

171.23new numbers from HP, InformixEPS::HAGGERTYKevin, NSIS, Stow MA USATue Apr 08 1997 17:38190
[First! for the Web]

HP and Informix revolutionize DSS performance with numbers that shatter
existing TPC-D results; HP and Informix deliver world's fastest
data-warehousing and decision-support solution

---------------------------------------------------------------------------
Date: Tuesday, April 8, 1997
Source: Business Wire
---------------------------------------------------------------------------

PALO ALTO, Calif.,--(BUSINESS WIRE) via Individual Inc. -- Hewlett-Packard
Company and Informix Software, Inc. today announced TPC-D results that
represent the fastest decision-support-system (DSS) numbers to date. The HP
9000 Enterprise Parallel Server (EPS) and INFORMIX-Extended Parallel Server
(XPS) system delivered 70 percent more performance than the next-closest
competitive offering, with 25 percent fewer central processing units (CPUs)
and better price performance. HP and Informix also loaded the information
and completed the entire query benchmark four hours before the next-closest
competitor had even completed the loading phase. These DDS numbers
represent an enormous time and cost savings for data-warehousing customers.

The HP 9000 EPS Model 22, powered by 48 PA-8000 CPUs, with INFORMIX-OnLine
Extended Parallel Server (XPS) achieved record-breaking performance of
3,416.4 QppD with the leading price/performance of $3,007 $/QphD at 300GB.
These results translate into real-world performance benefits for
data-warehousing customers who rely on the speed and scalability of their
data warehouses to maintain a competitive advantage in their industries.

According to the META Group 1997 Data Warehouse Survey, HP is the leader in
data warehousing for the second year in a row. The combination of HP's
leadership and the HP/Informix results will continue to define HP as the
data-warehouse solution platform.

"While it's true benchmarks are achieved in a controlled setting, they are
valuable for comparison shopping," said Doug Lynn, senior research analyst
at META Group, based in Stamford, Conn. "The benchmark HP achieved with its
EPS22 positions HP as one of the leading data-warehouse platforms."

According to Informix, the TPC-D benchmark also reinforces Informix's
performance and scalability leadership in data warehousing. Typically, TPC
benchmark results vary only 1 percent to 10 percent from vendor to vendor.
Informix's XPS high-end database not only beat its nearest competitor with
more than 70 percent better performance, but also demonstrated outstanding
load scalability by loading the data in half the time it took the
competitive offering.

TPC-D benchmarks are designed to provide customers with a method to
evaluate systems under typical processing loads for decision-support and
data-warehousing applications. The TPC-D benchmark is an industry-standard
benchmark used to represent relative performance for a suite of 17
real-world decision-support queries. The Transaction Processing Performance
Council is an independent organization formed by contributing member
companies across the computer industry.

The 300GB TPC-D benchmark on the HP/Informix system is equivalent to three
times HP's own enterprisewide sales and marketing data warehouse. This HP
warehouse maintains five years of sales records for more than $130 billion
in orders on 480,000 products.

HP AND INFORMIX MAKE CLEAN SWEEP WITH TPC-D BENCHMARK

HP's EPS22 and Informix's XPS 300GB TPC-D result delivers more than twice
the performance of NCR's 5100M and uses one-third of the CPUs while
providing a 3x improvement in price/performance. Compared to IBM's RS/6000,
the HP and Informix solution provides 2.5x the performance and uses less
than one-half the CPUs while providing more than a 3x improvement in
price/performance. The 3x price/performance improvement offered by the HP
and Informix solution may represent a total cost savings of up to several
millions of dollars.

Vendor/System       Total     Power     Throughput     Price/Perf
                    CPUs      (QppD @   (QthD @        ($/QphD @
                              300GB)    300GB)         300GB)

HP 9000 EPS22        48       3,416.4     1,673        $3,007
with Informix XPS

NCR 5100M           160       1,501.1   1,028.3         9,374
with Teradata

IBM RS/6000         128       1,360.5     916.3        11,969
with Oracle OPS

Sun Ultra            64       2,009.5   1,241.9         3,312
Enterprise 10000
with Oracle

Pyramid RM1000       96       1,169.2     749.3        10,225
with Oracle OPS

           Note:  These results are current as of 4/7/97.

"With this benchmark, HP and Informix have leapt past competitors'
2,000-level benchmarks to give customers superior performance for the most
demanding data-warehousing and decision-support applications," said Carol
G. Mills, general manager for HP's Enterprise Systems Division. "This
result illustrates the performance scalability inherent in our EPS
offering. Given our future EPS product roadmap, we could potentially
provide as much as a 20x DSS performance increase by the year 2000."

DELIVERING SUPERIOR DECISION-SUPPORT PLATFORMS

HP is a world-class solutions provider for implementing and managing
enterprisewide data warehouses. Its unmatched data-warehouse consulting
methodology and integration services ensure successful implementation of
the data warehouse. HP has unique partnerships with best-in-class DSS
systems running on HP 9000 Enterprise Servers. Informix is a recognized
data-warehouse leader in providing customers with complete data-warehouse
solutions that include industry-leading, high-performance database servers;
relational OLAP technology; prototyping centers called Information
Superstores; and best-of-breed partner solutions.

"The benchmark simply reinforces Informix's, and, specifically, OnLine
XPS's, performance leadership in running large, business-critical
applications," said Tim Shetler, vice president of product management at
Informix Software, Inc. "This benchmark was completed in record time with
members of our Oregon development lab to produce a result more than 70
percent faster than Sun announced last week (see chart on page 3).
Customers select Informix because we deliver the fastest, most scalable
database capability to give them the information they require to stay ahead
of their competitors."

The HP and Informix relationship was established in 1980 to exploit and
integrate the companies' complementary technologies -- HP's
industry-leading client/server-based architecture with Informix's
high-performance parallel-processing database -- to meet customers' needs.
HP and Informix have worked together to successfully implement data
warehouses at customer sites, including VISA International, United
Airlines, Home Depot, Kinkos, Bell South, Aames Financial, Associated
Grocers, Bournes & Bournes and Wells Fargo.

HP's EPS22 systems offer customers a platform that is production-ready for
implementing sophisticated data warehouses in the high-end data center --
enabling increased revenue sources, faster time-to-market and increased
market share. This allows for better-informed and more timely business
decisions regarding new products, services and programs.

HP is the leading supplier of enterprise solutions. HP has been recognized
by the Aberdeen Group as the leader in commercial UNIX(R) system solutions
for the last seven years. Based on HP's industry-leading HP-UX(1) operating
environment and PA-RISC(2) technology, HP 9000 Enterprise Servers provide
high-performance and systems-management capabilities required by
data-center environments, as well as the flexibility and performance
necessary for client/server implementation.

Informix Software, based in Menlo Park, California, provides innovative
database technology that enables the world's leading corporations to manage
and grow their businesses. Informix is widely recognized as the technology
leader for corporate computing environments, ranging from workgroups to
very large OLTP and data warehouse applications. Informix's database
servers, applications development tools, superior customer service and
strong partnerships enable the company to be at the forefront of many
leading-edge information technology solution areas.

More information about Informix is available via the World Wide Web at
http://www.informix.com .

Hewlett-Packard Company is a leading global manufacturer of computing,
communications and measurement products and services recognized for
excellence in quality and support. HP has 112,800 employees and had revenue
of $38.4 billion in its 1996 fiscal year.

Information about HP and its products can be found on the World Wide Web at
http://www.hp.com . Specific information regarding HP's UNIX system
products can be found at http://www.hp.com/go/9000servers .

Note to Editors: (1) HP-UX 9.X and 10.0 for HP 9000 Series 700 and 800
computers are X/Open(R) Company UNIX(R) 95 branded products. HP-UX 10.20 is
an X/Open UNIX 95 branded product.

(2) PA-RISC stands for Precision Architecture-reduced-instruction-set
computing.

X/Open is a registered trademark, and the X device is a trademark of X/Open
Company Ltd. in the UK and other countries.

UNIX is a registered trademark in the United States and other countries,
licensed exclusively through X/Open Company Limited.

CONTACT: HP | Terri Powell, 408/447-0958 | [email protected] | Candie
Watkins, 408/447-6285 | [email protected] | or | Informix Software, Inc. |
Jeff Lettes, 415/926-6326 | [email protected] | or | Cunningham
Communication, Inc. | (for Informix Software, Inc.) | Holly Hunter,
415/858-3791 | [email protected]
---------------------------------------------------------------------------
[Feedback] [Index] [Search] [Customize] [Individual, Inc.]
[Main] [Up] [< Prev Story] [Next Story >] [Calendar]
---------------------------------------------------------------------------
[Individual, Inc.]