[计算机]商业职能平台评测报告.pdf

Research Publication Date: 23 April 2007 ID Number: Business Intelligence Platform Capability Matrix Kurt Schlegel, Bhavish Sood The BI platform capability matrix outlines the technical details of the 12 BI platform capabilities, as defined by Gartner, and evaluates the leading BI platform products based on those technical capabilities. The matrix serves as a high-level guide to understanding the technical capabilities of each vendors shipping products. Beyond vendor selection, the capability matrix should primarily be used as an architectural guide to what should be included in a comprehensive and well-balanced BI platform. Organizations must decide which capabilities they need based on their requirements. Key Findings • While the core functionality of offerings in this market — such as reporting, ad hoc query and online analytical processing (OLAP) — is reaching parity, there are still some major differences in each vendor’s strategy in optimizing query performance. There are three dominant approaches: the traditional pre-calculated multidimensional OLAP (MOLAP) architecture; loading detailed data into memory; and optimizing relational queries with aggregate tables, caching and multipass Structured Query Language (SQL). • Vendors that have built their technology organically have better integrated infrastructure than those that have grown through acquisition. However, most vendors have done a reasonably good job of integrating disparate products by leveraging the same security and metadata infrastructure. • Scorecards are tough to differentiate. Most vendors with a scorecard product were able to meet all the requirements we requested — the technology is the easy part. The hard part of deploying a scorecard is defining the key performance indicat