Sybase, Inc. a provider of enterprise infrastructure and mobile software, announced in conjunction with Sun Microsystems and BMMSoft, that Sybase IQ powers the world's largest data warehouse implemented in history.

The data warehouse depends on Sybase IQ's unique compression capability to store one petabyte of raw data including unstructured data (emails, documents and multimedia) using only 160 terabytes of storage. This huge savings in storage achieves a 90 percent reduction in CO2 emissions. Organizations using this architecture will be able to scale their data warehouses well beyond today's requirements at substantially lower storage costs, lower cooling requirements and lower energy costs than alternatives. Smaller data warehouses can also expect similar results.

Nearly 1,000 organizations use Sybase IQ analytics server to meet their demand for business intelligence, advanced analytics, predictive modeling, stringent regulation compliance and rapid reporting. The Sybase IQ analytics server allows users to aggregate data stores and accelerates analytics processing faster than traditional solutions.

Sun provided the Sun SPARC Enterprise M9000 server, which features dual-core SPARC64 VI processors and up to 2 TB memory, and the Sun StorageTek 6540 system that gave Alvion the needed storage capacity and snapshot capabilities.

It was benchmarked on the following -

It loaded 1 Petabyte of raw transactional data (6 Trillion stock quote records) in a fully indexed star schema; creating a new, independently verified record for the world's largest data warehouse.

It reached a load speed of 285 billion rows per day (3 Million rows per second) and sustained that database population pace for a period of over 3 weeks.

It showed an 85% data compression ratio by storing a Petabyte of raw transactional data in less than 260 Terabytes of actual disk space.

It reached loading rates of 2 million e-mails per hour and 6 million documents per hour while consuming less than 7% of the available CPU power, leaving the other 93% of the SPARC Enterprise M9000 server CPUs available for Sybase IQ to respond to reporting and analytic queries.

"The results of this benchmark show that Sybase IQ demonstrated its capability to handle real-world scenarios comparable to the transactions processed across the worldwide financial trading networks over multiple years," said Francois Raab, president, InfoSizing.