IBM DB2 for i

Tab navigation

Take advantage of investments made in your most critical asset – your data! IBM® DB2® Web Query for i offers more than just a graphical reporting solution; its low cost extensible Business Intelligence framework can improve productivity of both end users and report authors, delivering data for analysis purposes immediately in a self service model, or through automated distribution processes. Deliver data to end users in the manner in which they will use the data most effectively, including dashboards, spreadsheets, PDFs, multi-dimensional drill downs or to mobile devices such as the Apple iPad.

Modernize your Query/400 reports and improve performance, reduce report maintenance, and eliminate complex export and import steps. Leverage DB2 Web Query’s meta data layer to simplify the complexities of the database to the report author while also opening up the ability to author reports to a broader community beyond just I/T.

IBM i for Business Intelligence is a packaged solution that is easy to order and easy to implement, a perfect choice for improving your capability to analyze data –turning it into information that can help transform your business.

This solution combines the strengths of Power Systems, DB2 Web Query for i, data transportation software and installation services to deliver a ready to go operational reporting solution optimized for BI.

DB2 for i contains many enablers for BI applications, including:

DB2's sophisticated cost-based optimizer, based on over twenty years of IBM research and development efforts. Recent enhancements include the built-in SQL Query Engine and new Statistics Engine, resulting in 2-5 times performance improvements in large, complex queries.
IBM's patented Encoded Vector Indexing supplements its traditional Binary Radix Tree indexing implementation to significantly improve performance when querying large star-schema, or other database designs commonly used in data warehousing applications.