Kathleen Schaub, Vice President of Product Marketing for Intelligent Enterprise for Sybase, Inc., recently participated in an exclusive interview with Ron Powell and the Business Intelligence Network (www.BeyeNETWORK.com). In this interview, Schaub explains how Sybase IQ handles the most challenging data warehousing requirements, meeting the demand for advanced analytics and fast reporting, and delivering unsurpassed query performance at the lowest price/performance available.
“Sybase IQ allows customers to achieve analytic feats they never dreamed possible with ordinary data bases,” Kathleen Schaub, Vice President of Product Marketing for Intelligent Enterprise for Sybase, Inc. “Sybase IQ is well suited for organizations with extreme analytics requirements such as analytics service providers, financial services and insurance companies.”
“Sybase is very focused on high performance and the ability to query large amounts of data,” says Ron Powell, Cofounder and Editorial Director of the Business Intelligence Network. “With Sybase IQ’s unique indexing and column-based processing, Sybase customers receive faster results for mission-critical business intelligence, data warehouse and reporting solutions on any standard hardware and operating systems.”
Sybase, Inc. (NYSE: SY), the largest enterprise software and services company exclusively focused on managing and mobilizing information, today announced that the Sybase® IQ analytics server has set a new Guinness World Record™ by powering the world’s largest data warehouse on a Sun™ SPARC® Enterprise M9000 server. This accomplishment was achieved using Sybase IQ, BMMsoft ServerSM and the Sun Microsystems® Data Warehouse Reference Architecture. This winning combination enables more data to be stored in less space, searched and analyzed in less time, while consuming 91 percent less energy and generating less heat and carbon dioxide than conventional solutions.
Powered by the category-leading column-oriented database Sybase IQ, the data warehouse is certified to support a record-breaking one petabyte of mixed relational and unstructured data—more than 34 times larger than the largest industry standard benchmark1 and twice the size of the largest commercial data warehouse known to date2. In total, the data warehouse contains six trillion rows of transactional data and more than 185 million content-searchable documents, such as emails, reports, spreadsheets and other multimedia objects.
Designed from the ground up as an analytics server, Sybase IQ produces its impressive results because of a unique architecture combining a column-oriented data structure with patented indexing and a scalable grid. Sybase IQ offers extraordinarily high performance at a lower cost than a traditional, row-oriented database. And, unlike traditional row-based data warehouses, the stored data in Sybase IQ is compressed by up to 70 percent of its input size, creating the most optimal and elegant analytics solutions.
“The results of this benchmark showcase Sybase IQ’s capabilities to handle real-world scenarios, querying vast amounts of data representing the transactions processed across the worldwide financial trading networks over multiple years.” said Francois Raab, president, InfoSizing, the consulting firm that oversaw the benchmarking of the record. “Sybase IQ has proven its production strength in handling the volume of multimedia documents representative of the electronic communication between half a million financial traders.”
“As an early adopter of RAP – The Trading Edition, our trading desk has been able to be more responsive to market opportunities through faster, more complete analysis of market data, both historical and real-time feeds,” said Jason Ross, director, Rates Trading Group at MUSI. “We were pleasantly surprised at the performance speed, and found we need only half the storage capacity to store the same amount of data.”
Other key beneficiaries of the solution include quantitative analysts, risk managers, and compliance officers. Analysts can run powerful quantitative models against years’ worth of time-series market data, trading histories, and reference data, with complex analysis running in minutes vs. hours; risk managers can monitor balance sheet exposure hourly to reduce firm-wide risk; and compliance officers can audit the trade flow to meet the latest market compliance requirements.
“RAP – The Trading Edition is the only integrated solution today with the ability to absorb streaming market data feeds and consolidate these with vast stores of historical data for common shared access and analysis. We offer an enterprise-class platform that can offer a single source of data to the entire trade life cycle, from quantitative analysis, through pre-trade pricing, to market risk analysis and compliance,” said Dr. Raj Nathan, Chief Marketing Officer at Sybase. “In today’s unforgiving market environment, financial services firms need best-in-class, bullet-proof solutions that afford instantaneous throughput with no down-time. Sybase® RAP – The Trading Edition is very robust, having a built-in administrative console and dependable business continuity/disaster recovery solutions to protect against system failures.”
Sybase, Inc, the largest enterprise software and services company exclusively focused on managing and mobilizing information, today announced the new Sybase® Analytic Appliance, configured and tuned to provide extreme analytics and alleviate overburdened enterprise data warehouses, data marts and reporting systems. Combining category-leading technologies including Sybase IQ, Sybase PowerDesigner®, IBM® POWER™ Systems and MicroStrategy 8™, Sybase Analytic Appliance has all the benefits of a custom-built enterprise data warehouse (EDW), but is easy, fast and affordable—up to one third of the price of other leading solutions.
Sybase Analytic Appliance on IBM POWER Systems provides fast time-to-value by providing a unified appliance console, pre-configured hardware, software and storage in one compact and power-efficient unit, with single vendor support. The appliance requires lower initial and ongoing investment because, unlike its traditional row-based and parallel-computing counterparts, stored data in column-oriented Sybase IQ is compressed by up to 70 percent of its input size, creating the most optimal and elegant appliance solution. In addition, Sybase Analytic Appliance does not require labor-intensive index tuning, reducing overall maintenance costs. Its point-and-click console simplifies appliance administration and monitoring.