The Business Intelligence Blog

From Press Release -

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.”

One Petabyte of mixed relational and unstructure data. That’s neat.

More from the Sybase Press Release -

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.”