SOL took part in creating of The World’s Largest Certified 1-Petabyte Data Warehouse.

Our partner, BMMsoft, announced the publishing of an independent study by InfoSizing (www.sizing.com) certifying the BMMsoft Server^SM application, Sybase IQ analytics server, Sun SPARC Enterprise M9000 server running the Solaris 10 Operating System (OS) and Sun StorageTekTM 6540 arrays, as the World’s Largest Data Warehouse at Sun’s Enterprise Technology Center (ETC) in Menlo Park

The certification involved loading fully-indexed transactions, full-text searchable emails and documents in a Data Warehouse solution at the rate of 250 Billion transactions, 150 Million documents and 50 Million emails per day. The daily total was an impressive 30 TB of data.

Due to the combined storage efficiency of the BMMSoft Server platform and the Sybase IQ analytics server, the test required only ~250TB of high-density disk storage or an 85% reduction in storage size, cost and power. Compare this result to conventional solutions that require over 1.5 PB of fast storage for similar performance. A 90% reduction in power usage represents an equal reduction in CO2 pollution and equates to over 30 Million pounds of CO2 saved over a 3-year life span of the system.

The BMMsoft Server application and the Sybase IQ analytics server, with a combination of 6 trillion trading transactions, emails and documents show real-time performance with sub-second responses to standard queries (“pin-point” crosssearch of emails and transactions) and sub-5-second responses for complicated realtime analysis. Even very sophisticated trend-detection queries took only 45 seconds to finish. New emails and documents are ready for analysis in less than 3 seconds after arrival. The combination of real-time updates and instant query responses are critical for high transaction volume businesses of all types.

How much more effective would your company be if you could access all the data within your organization? BMMsoft Server unlocks the 80% of corporate information that is hidden in unstructured data. With BMMsoft Server, you are able to cross correlate the information stored in the emails and documents with your transaction data. The BMMsoft Server software provides the ability to manage both structured and unstructured data within one database, enabling incremental business intelligence in the areas of CRM, eDiscovery, fraud or compliance never before possible.

“BMMsoft platform, together with Sybase IQ’s column-oriented analytics server architecture, Sun servers with the Solaris 10 OS, and Sun storage, offer a flexible and highly-scalable environment for enterprise analysis and use of both structured and unstructured data,” said Anne MacFarland, Director of Data Strategies and Information Solutions at The Clipper Group, Inc. “The synergies between the components, and the comprehensive capabilities of the BMMsoft Server front end, provide a solution targeted at business intelligence that is more than the sum of its parts.”

SOL took an active part in this certification by giving support and monitoring throughout the process. We are proud to be a part of this achievement, because this is the breakthrough in the area of data warehousing. It took immense efforts of our team, but being a part of such an important event has the inestimable significance.

You can read more about this event at BMMsoft’s website (www.BMMsoft.com) and get a more complex insight into this fantastic result.