Advertisment

Open source data warehouse appliance

author-image
CIOL Bureau
Updated On
New Update

Features: Sun Microsystems, Inc. and Greenplum has unveiled a data

warehouse appliance built from open source software and general purpose systems.

Powered by the Solaris 10 Operating System (OS) and PostgreSQL, both the mature

product of open source development, this solution aims to deliver two orders of

magnitude better price-performance over the competition.






As one of the first data warehouse appliances from a major systems vendor, the
solution combines Sun's new "Thumper" Sun Fire X4500 data server

powered by Dual-Core AMD Opteron processors with Greenplum's massively parallel

distribution of PostgreSQL, Bizgres MPP, in a single turnkey appliance capable

of analyzing hundreds of terabytes of business data at a better

price-performance than virtually any product on the market.






The data warehouse appliance capitalizes on the incredibly high data throughput
and storage density of the Sun Fire X4500 x64 server with AMD Opteron processors

and Greenplum's Scale-Everything parallel database architecture to move

processing near the storage, dramatically boosting performance 10 to 50 times

over existing systems.






With its unique Query-In-Storage design, the solution is capable of scanning 1
terabyte of data in 60 seconds and can easily scale to hundreds of terabytes of

usable database capacity. The data warehouse system is also one of the most

energy efficient solutions in the industry, at only 90W per terabyte.






John Fowler, executive vice president of the Systems Group at Sun Microsystems,
said, "This data warehouse appliance demonstrates the power of open source

and general purpose computing, truly driving new economics for data analysis.

The lightning-fast performance of this solution also makes it a snap for

companies to manage ever-increasing amounts of data on their networks."






Scott Yara, president of Greenplum, said, "We are excited to be working
with Sun. As the leading systems company in the world, they are the perfect

company to revolutionize the data warehouse appliance market and finally deliver

on the promise of Business Intelligence in the enterprise."






The solution enables massive parallel processing, which is made possible by the
performance advantages of the AMD Opteron processor with Direct Connect

Architecture, leverages a high-performance interconnect and moves processing to

where the data resides. 10-50x the performance over traditional data warehouse

solutions in both query and data loading. Supports industry standards and

interfaces (SQL, ODBC, JDBC).











tech-news