IBM Sybase IQ for IBM Power Systems Solution

Highlights

• Accelerates query processing, reporting and analysis of business transaction information
• Designed to reduce overhead, storage costs and maintenance requirements for analytical and reporting applications
• Offers near-linear user and data scalability to support thousands of users and terabytes of data
• Complements existing enterprise data warehouses (EDWs) with ultra-high-speed analytics and reporting

The Sybase® IQ for IBM Power™ Systems Solution provides an enterprise-quality business analytics platform designed to complement existing data warehouse platforms to significantly improve the performance of analytical and reporting applications. It features Sybase IQ, a highly scalable analytical engine. This solution helps clients analyze increasing amounts of data by delivering ad hoc query performance up to 100 times faster than traditional RDBMSs while reducing overhead, storage costs and maintenance requirements.¹

Unprecedented growth in data—and the number of people demanding access to data—is placing significant strain on corporate operational systems. As competition becomes more intense, the need to improve data access and accelerate business analysis becomes more acute. The computing resources required to support query-intensive analytics are very different than those put in place to manage transaction-oriented business operations.

At a time when increased competition calls for quick answers—with an accuracy that requires larger amounts of data—Business Intelligence (BI) systems are challenged by:

• More data. The amount of data that organizations must manage is growing rapidly, with IDC forecasting a CAGR of almost 60% through 2011.² New regulations force companies to store more historical data and, more importantly, maintain online access to data for longer periods of time.
• More demand. Intelligence-driven decisions are becoming more prevalent, and decision support tools are becoming more broadly used. This results in more users asking for more reports and requiring better ad hoc query support.
• More complex queries. The natural outcome of more users, with a greater need-to-know and broader access to reporting tools is more sophisticated “what if” scenarios and more frequent reporting needs.

All of which can lead to over-burdened operational or data warehouse systems with slower performance and higher costs. Slow response times for processing the events and transactions that drive a business have a direct impact on revenues, productivity and customer satisfaction. Slow results for queries or reports are simply unacceptable.

The Sybase IQ for IBM Power Systems Solution is designed to optimize performance and reduce costs of analytics and reporting systems. IBM Power Systems servers offer a flexible, scalable and reliable platform for query-intensive workloads running on both the AIX®—the industrial strength UNIX® from IBM—and Linux® operating systems. In addition, Sybase and IBM get clients up to speed quickly, through services to integrate Sybase IQ on Power Systems servers into current data management and data warehouse environments.

Solution summary

• Sybase IQ is a highly scalable analytical engine, designed specifically from the ground up for unsurpassed query performance and the lowest total cost of ownership for analytics and reporting systems
• Business users including executives, analysts, managers, operations staff, customers, suppliers and distributors get the information they need when needed. Real-time information is available in seconds, empowering them to make the right decisions at the right times.
• IT executives can build and manage even the largest enterprise data warehouses and reporting systems efficiently and economically, delivering on their organizations’ strategic objectives to manage costs and transform data into economic and strategic value.
• Database managers can cut the total cost of ownership of the data warehouse or transactional systems while reducing overall complexity and maintenance cost.
• Analytics application developers can deliver higher performance, greater scalability and lower maintenance and ownership costs to their customers