Record breaking one petabyte data warehouse

The Sybase IQ analytics server has set a Guinness World Record by powering the world’s largest data warehouse on a Sun SPARC Enterprise M9000 server. The data warehouse is certified to support one petabyte, or 1000 terabytes, of mixed relational and unstructured data, while consuming 91% less energy and generating less heat and carbon dioxide than competing systems. One petabyte is twice the size of the largest commercial data warehouse, and more than 34 times larger than the largest industry standard benchmark.

The environmentally friendly system uses a column-oriented data structure with patented indexing and a scalable grid to allow data to be compressed by up to 70% of its input size, and searched and analyzed in less time. The data warehouse contains six trillion rows of transactional data and over 185 million content-searchable documents. It was made using Sybase IQ, BMMsoft ServerSM and the Sun Microsystems Data Warehouse Reference Architecture.