Oracle and Sun Announce World's Largest TPC-H Data Warehouse Benchmark

Obliterates One-Terabyte TPC-H Benchmark With First Three-Terabyte Result



Apr 17, 2001, 01:00 ET from Oracle Corp.

    REDWOOD SHORES, Calif. and PALO ALTO, Calif., April 17 /PRNewswire/ --
 (http://www.oracle.com/tellmemore/?667236) Oracle Corp., (Nasdaq: ORCL) the
 largest provider of software for e-business, and Sun Microsystems, Inc.,
 (Nasdaq: SUNW), one of the leaders in network computing products and services,
 announced today the world's first three-terabyte TPC-H result by achieving a
 stunning 10,764.7 QphH@3000GB with a price performance of $1,222/QphH@3000GB
 and an availability date of June 19, 2001.  For reference purposes, 3TB of
 data is approximately equal to the amount of information contained in
 18 miles of stacked books.  The size and scope of three-terabyte decision
 support benchmark result greatly surpasses the size and scope of the previous
 record TPC-H benchmark of only one terabyte held by IBM.  No other vendor has
 published results for a TPC-H benchmark of this magnitude.
     This result clearly illustrates Oracle's and Sun's leadership in
 delivering the most demanding applications for very large databases (VLDB) on
 the fastest database and high-end server in the industry.  This new standard
 was achieved running Oracle9i Database on two Sun Enterprise(TM)
 10000 servers, also known as Starfire(TM), with a total of 128 processors.
 This world-record setting benchmark result is proof that Oracle running on
 Sun's Starfire system today can scale the largest volumes of data and
 workloads.
     Data warehouse and business intelligence applications are characterized by
 very complex, ad-hoc queries running against very large amounts of data.  The
 Oracle(R) database offers a rich variety of query processing techniques that
 deliver the superior performance required when accessing enormous amounts of
 stored data.  The benchmark leveraged many key Oracle database features for
 scalable multi-node performance, including Internode Parallel Query, Automatic
 Parallel Tuning, and Partition-wise Joins.
     "Oracle can deliver scalability to handle databases supporting multiple
 terabytes while at the same time delivering rapid response to complex
 queries," said Chuck Rozwat, Oracle executive vice president of Server
 Technologies.  "Today, Oracle and Sun's Starfire together on a single node can
 support multiple terabytes.  This benchmark demonstrates how, using
 clustering, Oracle and Sun provide transparent scalability for any data
 warehouse as a company's data repository grows."
     The Sun Enterprise 10000 systems, combined with Sun(TM) Cluster software
 and Sun StorEdge(TM) solutions and running Oracle 9.0.1 software and
 Solaris(TM) 8 Operating Environment software, were configured for this
 benchmark with a total of 128 gigabytes of memory.  The Starfire servers,
 combined with Sun Cluster software, deliver high availability through
 automatic fault detection and recovery, and provide mainframe-class
 reliability and scalability for data warehousing in support of mixed workloads
 such as e-commerce, ERP, CRM, and other mission-critical applications and
 services.
     The system's 23.8 terabytes of storage was attained using Sun StorEdge
 solutions including the multi-platform Sun StorEdge T3 arrays, Sun StorEdge
 A5200 fibre-channel arrays and Sun StorEdge D1000 boot drive devices.  The
 comprehensive Sun StorEdge family of products helps enable customers to match
 storage to the application while providing scalable capacity and performance.
     "Sun and Oracle's performance on the TPC-H benchmark demonstrates our
 continued commitment to deliver real-world performance results that customers
 can use to measure systems," said Shahin Khan, vice president of Product
 Marketing and Planning, Sun Microsystems, Inc.  "Sun's Starfire server
 maintains its position as the fastest high-end server in the industry,
 delivering high availability, mainframe-class reliability and scalability
 unmatched by other vendor's high-end systems."
     The TPC-H result was obtained on a 3 TB data warehouse, the largest ever
 certified for a TPC-H benchmark.  The Transaction Processing Council notes
 that the size of the database is a primary determinant of results, and, as
 such, this benchmark provides an unparalleled demonstration of decision
 support power.  The total system cost was $13,155,003, including all hardware,
 software and maintenance.  Tests were conducted at Sun's Large Scale Computing
 Center in Beaverton, Oregon.
 
     About TPC-H
     Established by the Transaction Processing Council, the TPC-H benchmark is
 an industry-standard Decision Support test designed to measure systems'
 capability to examine large volumes of data, execute queries with a high
 degree of complexity, and give answers to critical business questions.  The
 TPC-H benchmark evaluates a composite performance metric (QphH@size) that
 measures the performance of various decision support systems by the execution
 of sets of queries against a standard database under controlled conditions.
 For additional information on the TPC-H benchmark, please visit the
 Transaction Processing Council's Web site at http://www.tpc.org .
 
     About Sun Enterprise 10000
     The Sun Enterprise 10000, or Starfire, server provides up to
 64 UltraSPARC(TM) processors and 16 Dynamic System Domains; Sun is the only
 UNIX(R) platform vendor to offer these features.  The Starfire server enables
 customers to run the most demanding, multi-terabyte applications for data
 warehousing, decision support, online transaction processing and data
 analytics on a single, scalable server.  The system hosts more than
 12,700 off-the-shelf applications for the Solaris Operating Environment and
 can be clustered with up to four nodes for even greater uptime.  The Sun
 Enterprise 10000 server contains up to 64 GB of shared memory and can support
 more than 60 TB of online storage to confidently handle extreme data
 warehousing situations.
 
     About Sun Microsystems, Inc.
     Since its inception in 1982, a singular vision -- "The Network Is The
 Computer(TM)" -- has propelled Sun Microsystems, Inc., to its position as a
 leading provider of industrial-strength hardware, software and services that
 power the Internet and allow companies worldwide to take their businesses to
 the nth.  With $19.2 billion in annual revenues, Sun can be found in more than
 170 countries and on the World Wide Web at http://sun.com .
 
     About Oracle
     Oracle Corporation provides the software that powers the Internet.  For
 more information about Oracle, please call 650-506-7000.
 
     Trademarks
     Oracle is a registered trademark and Oracle9i is a trademark or registered
 trademark of Oracle Corporation.
     Sun, Sun Microsystems, the Sun logo, Sun Enterprise, Sun StorEdge,
 Solaris, Starfire, and The Network is the Computer are trademarks or
 registered trademarks of Sun Microsystems, Inc. in the United States and other
 countries.
     The TPC Benchmark is a trademark of the Transaction Processing Council.
     All SPARC trademarks are used under license and are trademarks or
 registered trademarks of SPARC International, Inc. in the United States and
 other countries.  Products bearing SPARC trademarks are based upon
 architecture developed by Sun Microsystems, Inc.
     UNIX is a registered trademark in the United States and other countries,
 exclusively licensed through X/Open Company, Ltd.
 
 

SOURCE Oracle Corp.
    REDWOOD SHORES, Calif. and PALO ALTO, Calif., April 17 /PRNewswire/ --
 (http://www.oracle.com/tellmemore/?667236) Oracle Corp., (Nasdaq: ORCL) the
 largest provider of software for e-business, and Sun Microsystems, Inc.,
 (Nasdaq: SUNW), one of the leaders in network computing products and services,
 announced today the world's first three-terabyte TPC-H result by achieving a
 stunning 10,764.7 QphH@3000GB with a price performance of $1,222/QphH@3000GB
 and an availability date of June 19, 2001.  For reference purposes, 3TB of
 data is approximately equal to the amount of information contained in
 18 miles of stacked books.  The size and scope of three-terabyte decision
 support benchmark result greatly surpasses the size and scope of the previous
 record TPC-H benchmark of only one terabyte held by IBM.  No other vendor has
 published results for a TPC-H benchmark of this magnitude.
     This result clearly illustrates Oracle's and Sun's leadership in
 delivering the most demanding applications for very large databases (VLDB) on
 the fastest database and high-end server in the industry.  This new standard
 was achieved running Oracle9i Database on two Sun Enterprise(TM)
 10000 servers, also known as Starfire(TM), with a total of 128 processors.
 This world-record setting benchmark result is proof that Oracle running on
 Sun's Starfire system today can scale the largest volumes of data and
 workloads.
     Data warehouse and business intelligence applications are characterized by
 very complex, ad-hoc queries running against very large amounts of data.  The
 Oracle(R) database offers a rich variety of query processing techniques that
 deliver the superior performance required when accessing enormous amounts of
 stored data.  The benchmark leveraged many key Oracle database features for
 scalable multi-node performance, including Internode Parallel Query, Automatic
 Parallel Tuning, and Partition-wise Joins.
     "Oracle can deliver scalability to handle databases supporting multiple
 terabytes while at the same time delivering rapid response to complex
 queries," said Chuck Rozwat, Oracle executive vice president of Server
 Technologies.  "Today, Oracle and Sun's Starfire together on a single node can
 support multiple terabytes.  This benchmark demonstrates how, using
 clustering, Oracle and Sun provide transparent scalability for any data
 warehouse as a company's data repository grows."
     The Sun Enterprise 10000 systems, combined with Sun(TM) Cluster software
 and Sun StorEdge(TM) solutions and running Oracle 9.0.1 software and
 Solaris(TM) 8 Operating Environment software, were configured for this
 benchmark with a total of 128 gigabytes of memory.  The Starfire servers,
 combined with Sun Cluster software, deliver high availability through
 automatic fault detection and recovery, and provide mainframe-class
 reliability and scalability for data warehousing in support of mixed workloads
 such as e-commerce, ERP, CRM, and other mission-critical applications and
 services.
     The system's 23.8 terabytes of storage was attained using Sun StorEdge
 solutions including the multi-platform Sun StorEdge T3 arrays, Sun StorEdge
 A5200 fibre-channel arrays and Sun StorEdge D1000 boot drive devices.  The
 comprehensive Sun StorEdge family of products helps enable customers to match
 storage to the application while providing scalable capacity and performance.
     "Sun and Oracle's performance on the TPC-H benchmark demonstrates our
 continued commitment to deliver real-world performance results that customers
 can use to measure systems," said Shahin Khan, vice president of Product
 Marketing and Planning, Sun Microsystems, Inc.  "Sun's Starfire server
 maintains its position as the fastest high-end server in the industry,
 delivering high availability, mainframe-class reliability and scalability
 unmatched by other vendor's high-end systems."
     The TPC-H result was obtained on a 3 TB data warehouse, the largest ever
 certified for a TPC-H benchmark.  The Transaction Processing Council notes
 that the size of the database is a primary determinant of results, and, as
 such, this benchmark provides an unparalleled demonstration of decision
 support power.  The total system cost was $13,155,003, including all hardware,
 software and maintenance.  Tests were conducted at Sun's Large Scale Computing
 Center in Beaverton, Oregon.
 
     About TPC-H
     Established by the Transaction Processing Council, the TPC-H benchmark is
 an industry-standard Decision Support test designed to measure systems'
 capability to examine large volumes of data, execute queries with a high
 degree of complexity, and give answers to critical business questions.  The
 TPC-H benchmark evaluates a composite performance metric (QphH@size) that
 measures the performance of various decision support systems by the execution
 of sets of queries against a standard database under controlled conditions.
 For additional information on the TPC-H benchmark, please visit the
 Transaction Processing Council's Web site at http://www.tpc.org .
 
     About Sun Enterprise 10000
     The Sun Enterprise 10000, or Starfire, server provides up to
 64 UltraSPARC(TM) processors and 16 Dynamic System Domains; Sun is the only
 UNIX(R) platform vendor to offer these features.  The Starfire server enables
 customers to run the most demanding, multi-terabyte applications for data
 warehousing, decision support, online transaction processing and data
 analytics on a single, scalable server.  The system hosts more than
 12,700 off-the-shelf applications for the Solaris Operating Environment and
 can be clustered with up to four nodes for even greater uptime.  The Sun
 Enterprise 10000 server contains up to 64 GB of shared memory and can support
 more than 60 TB of online storage to confidently handle extreme data
 warehousing situations.
 
     About Sun Microsystems, Inc.
     Since its inception in 1982, a singular vision -- "The Network Is The
 Computer(TM)" -- has propelled Sun Microsystems, Inc., to its position as a
 leading provider of industrial-strength hardware, software and services that
 power the Internet and allow companies worldwide to take their businesses to
 the nth.  With $19.2 billion in annual revenues, Sun can be found in more than
 170 countries and on the World Wide Web at http://sun.com .
 
     About Oracle
     Oracle Corporation provides the software that powers the Internet.  For
 more information about Oracle, please call 650-506-7000.
 
     Trademarks
     Oracle is a registered trademark and Oracle9i is a trademark or registered
 trademark of Oracle Corporation.
     Sun, Sun Microsystems, the Sun logo, Sun Enterprise, Sun StorEdge,
 Solaris, Starfire, and The Network is the Computer are trademarks or
 registered trademarks of Sun Microsystems, Inc. in the United States and other
 countries.
     The TPC Benchmark is a trademark of the Transaction Processing Council.
     All SPARC trademarks are used under license and are trademarks or
 registered trademarks of SPARC International, Inc. in the United States and
 other countries.  Products bearing SPARC trademarks are based upon
 architecture developed by Sun Microsystems, Inc.
     UNIX is a registered trademark in the United States and other countries,
 exclusively licensed through X/Open Company, Ltd.
 
 SOURCE  Oracle Corp.

RELATED LINKS

http://www.oracle.com