Oracle has announced the first TPC-H 30 Terabyte (TB) benchmark, the largest TPC-H benchmark conducted to date.(1) This accomplishment builds on Oracle's history of world record performance leadership for data warehousing, adding to its long list of TPC-H 300GB,(2) clustered TPC-H One TB,(3) TPC-H Three TB(4) and non-clustered TPC-H 10 TB(5) world records.
Running on a single HP Integrity Superdome Server with 64 Dual-Core Intel Itanium 2 1.6 GHz processors, HP-UX 11i v3 operating system and HP StorageWorks arrays, Oracle Database 10g Release 2 achieved a milestone result of 150,960.5QphH@30000GB with a price-performance ratio of $46.49/QphH@30000GB. As the first 30 TB result, this benchmark signifies Oracle's commitment to continued leadership by raising the industry standard bar for large-scale data warehousing performance.
"Oracle's consistent leadership and innovation in data warehousing performance is highlighted by this first 30TB TPC-H benchmark result," said Juan Loaiza, Oracle senior vice president, Systems Technology. "Today, many of the largest data warehouses in the world run on Oracle databases, including production data warehouses over 100TB in size. This 30TB TPC-H result demonstrates that Oracle data warehousing technology excels at running complex workloads on extremely large volumes of data."
(1) HP Integrity Superdome Server, 64 processors/128 cores/128 threads, 150,960.5 QphH@30000GB, Oracle Database 10g Release 2 Enterprise Edition, $46.49/QphH@30000GB, available 6/18/07 (TPC-H 30TB World Record Result).
(2) HP BladeSystem ProLiant BL480c, 16 processors/32 cores/32 threads, 40,411 QphH@300GB, Oracle Database 10g Release 2 Enterprise Edition, $18.67/QphH@300GB, available 12/18/06 (TPC-H 300GB World Record Performance Result).
(3) 8-node PANTA Systems PANTAmatrix, Oracle Database 10g Release 2 and Oracle Real Application Clusters, 59,353.9 QphH@1000GB, $24.94/QpH@1000GB, available 4/15/07 (TPC-H 1000GB Clustered World Record Performance Result).
(4) Sun Fire E25K Server, 72 processors/144 cores/144 threads, Oracle Database 10g Release 2 Enterprise Edition, 114,713 QphH@3000GB, $36.68/QphH@3000GB, available 4/9/07 (TPC-H 3000GB World Record Performance Result).
(5) HP Integrity Superdome Server, 64 processors/128 cores/128 threads, Oracle Database 10g Release 2 Enterprise Edition, 171,380 QphH@10000GB, $32.91/QphH@10000GB, available 4/1/07 (TPC-H 10000GB Non-Clustered World Record Performance Result).
