Analytic Database Enables Fast Reporting and Analytics for the Masses with Breakthrough Performance and Price/Performance on Standard Hardware
Las Vegas, NV, TDWI BI SUMMIT – February 15, 2011 - Ingres Corporation, pioneers of the breakthrough analytic database, Vectorwise, today announced it has set a new record for the Transaction Processing Performance Council’s TPC-H benchmark at scale factor 100 running on a single HP ProLiant DL380, delivering 340% of the previous best record while improving price/performance by 25%. The result of this breakthrough opens a new range of business intelligence and interactive reporting possibilities previously not possible without expensive software and hardware.
“Intel congratulates Ingres on achieving a world record result for the TPC-H decision support benchmark at 100GB,” said Pauline Nist, General Manager of Mission Critical Segment, Intel Corporation. “The Vectorwise database does an amazing job taking advantage of the multi-core scalable performance and energy efficient capabilities of Intel Xeon processor-based systems, enabling IT to provide knowledge workers powerful business intelligence tools they need to make real-time decisions.”
Based on the newly published TPC-H results, the Vectorwise database delivered 251,561 QphH@100GB (Query–per-hour performance metric) for 100 GB of data on a single HP ProLiant DL380 G7 system (availability date March 31, 2011 at a total system cost of $94,667 USD) compared to the previous best of 73,975 QphH@100GB on an HP ProLiant DL380 G7 system (availability date July 2, 2010 at a total system cost of $42,680 USD). Vectorwise also posted a price performance figure of USD $0.38 QphH@100GB compared with the previous best of USD $0.51 QphH@100GB on an HP ProLiant DL385 G7 system (availability date July 14, 2010 at a total system cost of $36,271 USD).
“It was no surprise to see this stunning result from Vectorwise as it is in line with what we saw in our testing prior to purchasing the product earlier this year,” commented Kevin Struckhoff, Senior IT Manager for GSI Commerce. “Vectorwise now underpins our reporting platform so our clients benefit not just from blazing fast performance but access to five years of transactional history – something we were unable to do adequately before with our original RDBMS.”
Vectorwise accomplished this record breaking performance on an HP Proliant DL380, equipped with two Intel® Xeon® processor 5600 Series, running Red Hat Enterprise Linux 6.0, and at a total three year system and software cost of less than USD $100,000. Companies of all sizes can now experience the value of fast interactive reporting and business intelligence that was historically only available to companies with large IT budgets.
Marty Bowes, a member of the UK Ingres User Association said, “I’m not at all surprised about the Benchmark results because I’ve experienced the speed and ease of use for myself. I downloaded Vectorwise and ran a report which usually takes me over 2 days to complete and with Vectorwise it took just 30 minutes.”
“We are naturally delighted to claim pole position in this industry-recognized benchmark for decision support”, said Terry Garnett, CEO of Ingres Corporation. “The sheer scale of the record means that companies of all sizes, across any vertical market, now have the ability to run queries in minutes instead of hours, delivering fast interactive reporting for decision making across the enterprise. The 240% performance gain together with the 25% improvement in price performance could make Vectorwise a very disruptive technology in many industries.”
About the TPC-H Benchmark
The TPC Benchmark™H (TPC-H) is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.
The performance metric reported by TPC-H is called the TPC-H Composite Query-per-Hour Performance Metric (QphH@Size), and reflects multiple aspects of the capability of the system to process queries. These aspects include the selected database size against which the queries are executed, the query processing power when queries are submitted by a single stream, and the query throughput when queries are submitted by multiple concurrent users. The TPC-H Price/Performance metric is expressed as $/QphH@Size.
This benchmark was run on a HP Proliant DL380, equipped with two Intel® Xeon® processor 5600 Series, running Vectorwise V1.5
About Ingres Corporation
Ingres develops and markets the leading open source enterprise-grade relational database and a breakthrough analytic database, Vectorwise, designed to support the growing need for analytics and business intelligence. Vectorwise customers claim performance improvements of up to 70X that of comparable databases, without the traditional overhead. The product is suitable for SMBs and enterprises and as an embedded database for ISVs and SaaS providers. Vectorwise is quickly becoming a leader in interactive reporting and analysis for data-driven companies. More information is available at www.ingres.com
Ingres and Vectorwise are trademarks of Ingres Corporation. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.