Outstanding TPC-H results: Sun & Paraccel
Wednesday Oct 31, 2007
Yesterday I posted several Sun Fire X4100 world record performance & $/performance results on the TPC-H benchmarks. Sun leads the pack with Paraccel's innovative software and even the software pricing model. I wanted to try to give even more insights.
ParAccel has a very efficient data compression techniques so using the storage associated with Sun's hardware design, the Sun TPC-H cluster submissions did not need ANY external storage. The data could be entirely contained on the internal drives of each node. Once again, Sun is the ONLY vendor that has been able to do so. Other vendors, using traditional RDBMS, are forced to submit results with a disproportionate number of spindles, in order to achieve competitive performance, even at small scale factors. As a consequence, the Sun ParAccel cluster solution greatly reduces costs and requirements for space, power/cooling, maintenance and complex hardware administration.
Sun and ParAccel are in the remarkably unique position of having simultaneously the best performance and price/performance by far at multiple TPC-H scale factors. As I said yesterday, innovators seek out and find innovators.
The ParAccel Analytic Database is an innovative RDBMS designed from the ground up as Decision Support and Business Intelligence database.
ParAccel has a parallel cluster architecture, "shared-nothing", with node redundancy, which relies on a column-based table structure and heavy data compression. Compression provides for a significantly smaller data footprint, higher speed in data processing and transmission. The significant reduction in the size of the data allows for even large databases to be fully contained in the memory of a cluster of multiple systems. The database can also operate by accessing data on permanent storage, although with a tradeoff in performance.
ParAccel doesn't make use of complex index structures, further reducing database size, administration complexity and simplifying data updates.
Data partitioning and load balancing is provided automatically by the ParAccel product and doesn't require manual DB admin intervention, either to optimize the data layout or to create additional indexes and structures, traditionally needed to speedup query performance.
Results detailed at:
http://blogs.sun.com/bmseer/entry/innovation_setting_world_records_in
http://blogs.sun.com/bmseer/entry/tpc_h_100gb_sun_fire
http://blogs.sun.com/bmseer/entry/sun_paraccel_in_tpc_h
Disclosure Statement:
TPC-H @1000GB Sun Fire X4100 cluster 315,842.9 QphH@1000GB, $4.57/QphH@1000GB, avail 10/29/07; TPC-H @300GB Sun Fire X4100 cluster 198,578.1 QphH@300GB, $3.15/QphH@300GB, avail 10/29/07; TPC-H @100GB Sun Fire X4100 cluster 98,857.0 QphH@100GB, $2.65/QphH@100GB, avail 10/29/07; TPC-H, QphH, $/QphH tm of Transaction Processing Performance Council (TPC). More info http://www.tpc.org.
|
|
|
|
