Data Warehouse System scales to manage growth, complexity.
June 24, 2008 -
Built for complex decision support environments, SGI® Adaptive Data Warehouse solution helps enterprises readily adapt to changing business conditions and BI application demands. Scalable solution, capable of supporting data warehouses from 4 to over 300 TB, lets organizations conduct complex, ad-hoc queries and scale I/O bandwidth without adding unnecessary components. Architecture helps shorten time to insight and promotes productivity for those analyzing data.
(Archive News Story - Products mentioned in this Archive News Story may or may not be available from the manufacturer.)
|Original Press release |
1600 Amphitheatre Pkwy.
Mountain View, CA, 94043
As Enterprises Struggle with Data Growth and Complexity, SGI Unveils New Data Warehouse Solution for Oracle Users
Scalable Platform Optimized for Complex Decision Support Environments
SUNNYVALE, Calif., June 10 -- Today's enterprises face a constellation of challenges brought by soaring data volumes, increasingly complex analyses, multiple workflows, and ever larger populations of users. Those trends are bearing down on the data warehouses that organizations rely on to turn raw data into actionable insights.
Now, a new SGI(R) solution optimized for Oracle(R) data warehouses addresses the needs of this emerging class of enterprise customer. Built specifically for Complex Decision Support environments, the new data warehouse solution was launched today by SGI (NASDAQ:SGIC).
The new SGI(R) Adaptive Data Warehouse solution uses SGI technology first developed to deliver the performance, scalability and reliability needed for such data-intensive fields as battlefield intelligence, energy exploration, and weather modeling and forecasting.
With its ability to support bandwidth intensive applications, that same architecture shortens time to insight and boosts productivity for any customer analyzing data to solve highly complex, large-scale problems. Increasingly, those customers include online merchants who handle high-volume transactions, organizations running sophisticated pattern recognition software to catch identity thieves, and manufacturers whose complex decision support needs range from sales analysis to supply chain management.
The solution, launched as part of the Oracle Optimized Warehouse Initiative, combines industry-leading Oracle Database software with SGI(R) Altix(R) servers and SGI(R) InfiniteStorage systems in a platform that scales to meet the needs of customers whose requirements extend beyond the capabilities of traditional enterprise computers.
Capable of supporting data warehouses ranging from 4 Terabytes (TB) to more than 300TB, the SGI Adaptive Data Warehouse Solution allows organizations to conduct highly complex, ad-hoc queries up to five times faster(1) than competing platforms. By achieving insights sooner, enterprises can more readily adapt to changing business conditions and the demands of advanced business intelligence (BI) applications.
Furthermore, the SGI solution allows Oracle data warehouse customers to scale their I/O bandwidth without having to add unnecessary components. By leveraging the SGI Altix server architecture's unique ability to independently scale I/O, CPUs and memory, customers can create a data warehouse that expands efficiently and economically as their requirements demand.
"Data volumes are exploding, workloads are increasingly varied and user communities are multiplying - and all of these trends are putting unprecedented pressure on data warehouses," said Jean S. Bozman, research vice president, Enterprise Servers, IDC. "As data warehouses grow, and as more types of enterprise users need the data stored within them to make business- critical decisions, these large databases must cost-effectively scale to meet emerging needs. SGI has seen this mix of IT requirements evolving over time, spending decades developing systems that are optimized for large-scale decision support environments. SGI's Adaptive Data Warehouse Solution draws on that history in a way that speaks to the needs of enterprises maintaining complex, data-intensive Oracle warehouses, while giving them the headroom to scale up as their needs change."
By aggregating and organizing data from multiple sources, data warehouses help managers achieve an integrated view of critical business information. But, this in turn, creates increasingly large data repositories that can overwhelm the rigid architectures of competing data warehouses whose scalability limits lead to degraded performance that hinder timely decision- making.
"Enterprises are steadily increasing the workloads and content of their data warehouses, and this results in large increases in complexity," said Richard Winter, president of WinterCorp, a leading independent consulting firm specializing in large scale data management. "The SGI Adaptive Data Warehouse Solution has the bandwidth to excel in these intense environments. This is a solution that thrives in the chaos of today's data center."
Other platforms often require expensive "forklift" upgrades, but the SGI Adaptive Data Warehouse Solution makes it easy and affordable to scale a data warehouse.
Integrating SGI Altix, InfiniteStorage and Oracle Real Application Clusters
The SGI Adaptive Data Warehouse Solution combines acclaimed SGI(R) Altix(R) servers and SGI(R) InfiniteStorage hardware and software with Oracle(R) Real Application Clusters. Energy-efficient SGI Altix servers, powered by Intel(R) processors, deliver uncompromised performance and the flexibility to execute thousands of commercial off-the-shelf applications. By using industry-standard components, SGI helps protect technology investments, reduce costs and simplify integration.
"The ability to make informed decisions quickly can literally determine the success or failure of a company, but that ability is often hindered by the growth and complexity faced by many of today's enterprises," said Ken Won, director of enterprise data management, SGI. "That's why SGI collaborated with Oracle on a solution that addresses the escalating needs of customers with complex decision support environments -- a solution that helps keep those enterprises agile and successful."
The SGI Adaptive Data Warehouse Solution is available in multiple entry points and growth paths to accommodate a wide range of expansion and architecture strategies.
-- Mid-Range Data Warehouse: This option utilizes SGI(R) Altix(R) XE250 servers, SGI(R) InfiniteStorage 220 systems, and an InfiniBand node interconnect switch to support scalability to 20TB of user data.
-- Large Data Warehouse: SGI(R) Altix(R) 450 servers and SGI InfiniteStorage 220 systems scale to support as much as 100TB of user data.
-- Ultra Large Data Warehouse: For data repositories beyond 100TB, this option is based on SGI(R) Altix(R) 4700 servers and SGI(R) InfiniteStorage 4600 systems.
The SGI Adaptive Data Warehouse solution is available now. For more information, visit www.sgi.com/industries/data_warehouse/.
SGI | Innovation for Results(TM)
SGI (NASDAQ:SGIC) is a leader in high-performance computing. SGI delivers a broad range of high-performance server, storage and visualization solutions along with industry-leading professional services and support that enable its customers to overcome the challenges of complex data-intensive workflows and accelerate breakthrough discoveries, innovation and information transformation. SGI helps customers solve significant challenges whether it's enhancing the quality of life through drug research, designing and manufacturing safer and more efficient cars and airplanes, studying global climate change, providing technologies for homeland security and defense, or helping enterprises manage large data. With offices worldwide, the company is headquartered in Sunnyvale, Calif., and can be found on the Web at sgi.com.
(C) 2008 SGI. All rights reserved. SGI, the SGI cube, Altix and the SGI logo are registered trademarks, and NUMAlink is a trademark, of SGI in the United States and/or other countries worldwide. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. All other trademarks mentioned herein are the property of their respective owners.
(1) Real-world test involving airline customer measured query response time against a data warehouse of flight information pulled from multiple views. The test measured a load of 500 concurrent users on an eight-core SGI Altix 450 server and a similarly configured IBM P550 server. The Altix 450 delivered query response times of just 8 seconds, compared to the IBM system's response time of 40 seconds - a 5X improvement over the IBM.