Sun Microsystems and Sybase's Enterprise Data Reference Architecture has enabled the creation and high performance of the largest data warehouse in the world. This is according to an independent audit performed by InfoSizing, a consulting firm specialising in accurate sizing of information systems through the design, management and analysis of performance benchmarks.
By implementing the architecture-driven solution, customers can save $1 million per terabyte (TB) of input data. As demonstrated by this verified audit, total savings would result in nearly $50 million. Beyond increasing efficiencies as a result of deploying this solution, other important benefits include investment protection, scalability and decreased complexity, leading to a reduction in storage requirements by as much as 75%.
"Sun and Sybase's reference architecture provides very large data warehouse (VLDW) solutions for the new economy," says Julie Tomlinson, Sybase SA marketing manager. "Faced with the dynamic environment of mergers, consolidations and global competition, successful companies must collect, manage and analyse mountains of data from multiple resources.
"The VLDW from Sun and Sybase addresses previously unmanageable data warehouse and data analysis needs, helping companies make better informed, business-critical decisions, while keeping costs down."
Says Francois Raab, president of InfoSizing: "The Enterprise Data Warehouse Reference Architecture, running on Sun midrange servers with Sun StorEdge 9960 systems and Sybase Adaptive Server IQ Multiplex, has demonstrated several significant achievements - the most notable of these includes storing 48.2TB of raw input data (179 billion rows) in a realistic data warehouse schema using only 22TB of total storage (data compression of 0.46).
"This is the largest database demonstrated and verified to date. Furthermore, query performance scaled to more than 94% with multiple server nodes, and data loading slowed down minimally (less than 7%) when concurrent queries were being run."
Conventional implementations with the same input data would consume more than 300TB of storage. With lower maintenance costs, smaller data centre footprint, less power consumption and more efficient resource utilisation, the Sun/Sybase Enterprise Data Warehouse Reference Architecture creates a significantly more manageable and cost-effective environment than competitive offerings.
Tomlinson says the Reference Architecture substantially reduces total cost of ownership (TCO) of enterprise analytics by reducing data storage requirements and improving performance - delivering query speeds of 10 to 1 000 times faster.
"As an iForce solution, the Enterprise Data Warehouse Reference Architecture is jointly designed, integrated and tuned to substantially reduce installation and set-up time for customers by as much as 80%," she notes. "All of these factors contribute to increased capabilities, greater productivity and increased competitiveness in today's challenging global markets."
Reference Architectures are an integral part of Sun's iForce Initiative - the company's effort to bring together Sun, its customers and partners to build solutions that help customers leverage IT quickly, safely and at a lower cost.
By deploying the Sun and Sybase Reference Architecture in Sun iForce Centers, Sun provides customers with a collaborative environment to build proof-of-concept demonstrations that tailor the Reference Architectures to meet their individual environments.
The Reference Architecture has been designed and demonstrated with the optimal integration of Sun and Sybase elements, including: Sybase's highly scalable analytical database, Adaptive Server IQ Multiplex, on a mix of Sun's UltraSPARC II and UltraSPARC III processor-based servers running the Solaris 8 Operating environment, specifically the Sun Fire 4810 and 6800 servers and the Sun Enterprise 4500 and 6000 servers, as well as Sun StorEdge 9960 systems and Sun StorEdge T3 arrays.
To learn more about the InfoSizing audit, please visit http://sun.com/architectures-platforms/refarch/edw/report.html.
Share
Editorial contacts