System News
Sun's Data Warehouse Reference Architecture for Structured and Unstructured Data
Access Data from ERP, CRM and More for Better Decision Making
August 27, 2007,
Volume 114, Issue 5

The Sun colution for 1 Petabyte consist of 1 server, 3 cabinets of disk, $87k/year for power, 470 tons per year of CO2 vs competitive solutions with 3 servers, 30 cabinets of disk, $922k/year for power and 5,095 tons per year of CO2
 

To simplify the problem of accessing valuable information from many applications across a large organization, Sun has made a new reference architecture, the Sun Data Warehouse Reference Architecture for Structured and Unstructured Data.

This solution enables people to analyze information from sources such as enterprise resource planning (ERP), supply chain management (SCM), customer relationship management (CRM), online transaction processing (OLTP) systems, email, documents, blogs and more. Having all this data available as needed to employees, partners, customers and suppliers can foster better decision making.

This solution can scale to petabytes of input data by using the Solaris Operating System (Solaris OS), Sybase IQ and BMMsoft DataFusion. As configured and tested, the data warehouse solution consists of one Sun SPARC Enterprise M9000 server and three Sun StorageTek 6540 arrays with a total of 250 TB of disk storage capacity. It can handle over 1 PB of source data containing approximately six trillion SQL records and one billion e-mail messages, documents and images.

The Sun, Sybase and BMMsoft DataFusion products combine to provide text and media analysis for structured and unstructured data by consolidating transactions, email, documents, call center, voice, video and multimedia data in a single database. Sybase IQ is designed for high-performance analytics. Multiple Sybase IQ readers can run across several servers and system domains using Dynamic Reconfiguration technology to enable the availability of compute resources as needed, increasing asset utilization and processing power.

Learn more and see an example of cost savings online.

Read More ... [...read more...]

Keywords:

fullsource
 




Other articles in the Service section of Volume 114, Issue 5:

See all archived articles in the Service section.





Popular Articles in Vol 184, Issue 2


News and Solutions for Users of Solaris, Java and Oracle's Sun hardware products
Just the news you need, none of what you don't – 42,000+ Members – 24,000+ Articles Published since 1998