Sybase, Inc., an SAP company, has announced that Sybase IQ v.15.2, its column-oriented analytics server, working with the IBM POWER 780 Model 9179-MHB server and running the Red Hat Enterprise Linux 6 Operating System (OS), achieved the best overall performance results among non-clustered systems for the TPC-H benchmark at 1 TB scale factor.
The benchmark simulates decision support systems that analyze enterprise-scale data volumes, execute queries with a high degree of complexity, and give answers to critical business questions. According to Sybase, the test results provide another example of how the Sybase IQ 15.2 architecture and query parallelism provides maximum performance while requiring less overall IT resources by fully utilizing available assets, ownership costs.
The TPC-H benchmark results for the joint Sybase and IBM solution include the best performance at the 1 TB scale-factor among non-clustered systems with 164,747 QphH. This record performance was achieved using half the number of processor cores over the previous leader at the 1 TB scale-factor among non-clustered systems. It also included a greater than 40% reduction in price-performance over the previous performance record holder at the 1 TB scale-factor among non-clustered systems. In addition, with Sybase IQ 15.2,the results showed the highest QphH ever published for Sybase IQ in the TPC-H.
"A point we wanted to highlight is that for customers who are looking to get started on a data warehousing or BI project, they can look to the POWER series with Sybase IQ and Linux as a good way to get started, and they can expect tremendous performance," Joydeep Das, director of analytics product management at Sybase, tells 5 Minute Briefing. It is significant that the benchmark is at the 1 terabyte category, Das adds, noting that this is typically where most data warehouses fall into, at least when they begin. "What we are telling the market is that if you are looking for a good reference architecture to get started on a data warehousing project and are looking for good performance and want to use the latest generation of technologies, this is a good way to start."
To learn more about Sybase IQ and the additional features and benefits of version 15.2, go here. To read the Sybase IQ blog, go here.