Java Solaris Communities About Sun How to Buy United States Worldwide

World's Largest Data Warehouse

The worlds Biggest Data Warehouse
Sun's Data Warehouse Reference Architecture for Structured and Unstructured Data

Businesses today face the challenge of evaluating and building energy efficient, complex, multi-tiered environments that can house multiple vendor products. Sun has embarked on an effort to simplify those decisions by offering an array of Reference Architectures that combine Sun's scalable hardware and software platforms with leading third-party technologies. Our goal is simple - to provide the scalability and flexibility needed in data warehousing today by simplifying decision making with a set of architecture, implementation and sizing guides, and to support deployment with integration and testing services: all the features needed to grow and adapt to change.

 
 

A Green Solution for Business Intelligence

The Sun Data Warehouse Reference Architecture for Structured and Unstructured data is a brand new Data Warehouse Reference Architecture that brings together innovative Sun server and storage products with sophisticated database technology from Sybase and BMMsoft to create an industry-leading energy efficient data warehouse. The solution supports over 1 PB of source data - over 34 times larger than the largest industry standard benchmark1 and twice the size of the largest commercial data warehouse known to date2. This Reference Architecture is unique in that it delivers incredible performance, power and scalability while simultaneously providing dramatic reductions in footprint, electricity costs and CO2 emissions.

 
 

Eco Innovation and Energy Efficiency

This Reference Architecture is part of Sun's Eco Innovation portfolio of products and services, which represent the industry's most innovative and open energy-efficient solution for the challenges facing datacenters today including rising power consumption and cooling costs. The Eco Innovation portfolio is designed to

  • Increase system utilization and Return on Investment (ROI)
  • Improve energy efficiency
  • Lower operating costs
  • Reduce harmful materials in manufacture and eWaste
Now, going green is the smart and safe way to drive higher profits. For more information on Sun's Eco Innovation and resources go to Eco Innovation.

 
 

Cost $avings

Using the latest eco-friendly Sun servers, and storage arrays in combination with Sybase IQ analytics server and BMMsoft DataFusion, Sun's new data warehouse solution delivers a high volume, high-performance, scalable architecture that uses 90 percent less storage, consumes 91 percent less energy and generates less heat and carbon dioxide than conventional solutions. During one year of operation the Sun's Data Warehouse Reference Architecture for Structured and Unstructured data can deliver:

  • More than 10x the savings annually on electricity bill
  • 10x reduction in annual CO2 emissions
  • Shrink storage footprint by a factor of 6x

(A) As of August, 2007, the electric rate of $0.11 per KWh is used based on the Energy Information Administration
(B) Typical pollutant factor of 1.34 lb. of CO2 per KWh.
(C) Based on the average weight of the storage and server equipment that would be needed.


The Details

The Reference Architecture consists of a Sun SPARC Enterprise M9000 Server, Sun StorageTek 6540 Array and Solaris 10 OS working together with compression techniques from Sybase IQ analytics and BMMsoft DataFusion. This winning combination enables more data to be stored in less space and searched and analyzed in less time. As configured and tested the data warehouse solution is certified to scale over 1 PB of source data, containing approximately six trillion SQL records and one billion email messages, documents and images.

Storage: The architects selected the Sun StorageTek 6540 array for its fast performance, robust scalability, redundant design and non-disruptive upgrades as well as its support for high-density, low-cost SATA drives. The complementary Sun StorageTek Data Snapshot software allows the administrators to restore directly from disk if required, saving time and effort.
Servers: The SPARC Enterprise M9000 server delivers the best of SPARC/Solaris OS computing and is the ideal virtualization and consolidation platform with up to 24 dynamic domains and thousands of Solaris containers per system. The SPARC Enterprise M9000 server is optimized for 24/7 mission critical computing and features 64 high performance dual core SPARC64 VI processors, up to 2 TB memory and up to 288 PCIe or PCI-X slots with the external I/O expansion unit.
Software:
The Solaris 10 OS includes industry-first utilization features such as Solaris Containers, that let you consolidate, isolate, and protect thousands of applications on a single server. Solaris is free, open source, secure and massively scalable with over 8 million distributed licenses.
Partners:
BMMsoft is the leading software company in unifying emails, documents and transactions into one database that provides cross-analytic capabilities. BMMsoft's DataFusion provides the data infrastructure platform, email archive and analytics to enhance a company’s CRM, fraud detection, eDiscovery or other very complex queries. DataFusion has solutions for organization of all sizes.


Sybase has been a valued partner of Sun's for many years and, together, the two companies have delivered industry leading database solutions. For the WLDW project Sybase's highly optimized business analytics server, Sybase IQ, was utilized on Sun's industry leading APL servers to create a 1 PB data warehouse that is capable of handling both structured and unstructured data at an attractive price/performance point.

*1 See the Ten Most Recently Published TPC-H Results as of July 9, 2007.
*2 See "At Wal-Mart, World’s Largest Retail Data Warehouse Gets Even Larger" at eWeek.com

Future Proof the Datacenter

Watch how Sun increased storage capacity by 244%, increased computer power by 456%, cut energy costs by 60% and were awarded $1.2 million in rebates...

Contact About Sun News & Events Employment Site Map Privacy Terms of Use Trademarks Copyright 1994-2008 Sun Microsystems, Inc.