Calpont InfiniDB Shines in Data Warehouse Benchmark Against Row Based Database
Calpont InfiniDB Clearly Demonstrates its Advantages and Value Over Row-Oriented Database Technology
Frisco, TX – January 26, 2011 – Calpont Corporation, a leading provider of high-performance analytic databases, today announced the availability of a new benchmark in the whitepaper, “Data Warehouse Benchmark: Comparing Calpont InfiniDB®and a Row-based Database.” The testing was performed in the fall of 2010 by Bert Scalzo, a database expert and Oracle ACE who has published several books, articles and speaks on subject of data warehouse design and performance.
Sclazo used Calpont’s recently released InfiniDB 2.0 in comparison with one of the leading row-oriented databases in the market today. The environment simulated several different user types with a mix of data analysis, query and reporting needs. The dimension tables ranged in size from several thousand to several million rows, and the largest fact table had nearly 40 billion rows with a total raw data size being about 2 terabytes. The testing was performed across two different server environments and architectures to ensure the hardware did not play a significant role in the results.
“Nothing could have prepared me for the astounding performance of Calpont InfiniDB 2.0. InfiniDB is truly the top contender for consideration when size, speed, predictability and price matter,” said Mr. Scalzo, author of the whitepaper. “With InfiniDB 2.0, Calpont offers numerous new features, including improved query optimization, enhanced partitioning with partition elimination, user defined functions, and physical data compression. Simply put, one cannot find a database that scales well into the high terabytes, offering both excellent and predictable query performance, at a better price.”
Calpont’s goal for the benchmark was not just to best the row-based database in the test, but demonstrate that InfiniDB provides a significant advantage to traditional relational database platforms for data warehouse performance. Highlights of the testing include:
Reduced Space Consumption
InfiniDB offers a measurable reduction in disk space required to store star schema data and all of its supporting structures. The space savings was 22% over the row-oriented database.
Faster Total Data Load Time
Similar savings were achieved in the database object creation and load times. InfiniDB has the advantage of not requiring indexes or aggregates, allowing for load time savings.
Faster Total Run Time
Using real world samples captured from the retail system being implemented as the test bed, InfiniDB 2.0 achieved a decrease in total run time by an average of 85%, or 7 times faster, than the row-oriented database. This was a 41% improvement over prior versions of InfiniDB.
Tight Query Run Time Ranges
The InfiniDB’s optimizer has the largest year-over-year improvement of any database software Mr. Scalzo had reviewed in the past two decades. Query run time range looks at how much variance in run time there is across any and all queries that the data warehouse might see – which translates into how effective the database optimizer is at handling a wide range of ad-hoc or unknown queries.
“Calpont’s licensing for InfiniDB is designed with the understanding that customers are looking for cost-effective solutions that scale with data and user performance needs,” said John Weber, vice president of products and business development at Calpont. “As Mr. Scalzo points out, InfiniDB is very competitively priced against any traditional row-oriented database, as well as other new database solutions. Our licensing model fits well with need for scalable data, as we don’t “tax” data growth like per-terabyte subscription offerings. The result is high value performance, for any organization, at any data scale.”
To download your free copy of report and hear a recap of Mr. Scalzo's comments about the benchmark visit http://www.calpont.com/data-warehouse-benchmark. If you want to start using InfiniDB Enteprise, it’s available for download at www.calpont.com/products/tryinfinidb. Licensing information can be found at www.calpont.com/licensing .
Calpont Corporation is a provider of scalable, high-performance column-oriented analytic databases enabling ultra-fast, deep analysis of massive data sets. InfiniDB Enterprise is the emerging choice for demanding data warehouse, business intelligence, reporting, and analytic deployments. Known for its rapid implementation time, unmatched operational simplicity and extraordinary value, InfiniDB provides a proven solution for data-intensive businesses, including those in the software, online business, telecom, and social spheres. For more information, please visit www.calpont.com, join our open source community at www.infinidb.org, or follow us at twitter.com/calpont.
Peterson Communications for Calpont