subscribe: Daily Newsletter

 

Query performance still the leading BI problem

0 comments

Users are less happy with query performance than with any other aspect of their business intelligence (BI) platform. This is one of the findings to emerge from The BI Survey, now in its seventh iteration. Its findings are to be presented in Johannesburg, at VIBE 2008 tomorrow (17 April) by Nigel Pendse, creator of The BI Survey (formerly The OLAP Survey) at VIBE, a function being hosted by Harvey Jones.

21.1% of users surveyed complained that query performance was too slow, which impacted the overall user experience.
"This report is consistent with our research and findings down the years," says Pendse, who will head up a strong panel at VIBE. "Users tell us they have to wait for typically eight seconds for responses from their BI applications – this when Google delivers responses to Internet-wide queries in an average of two seconds.
"This 'Google' effect is causing users to ignore the BI systems that have been acquired at significant cost, with negative consequences," adds Pendse.
"The BI Survey will report on this and other BI realities," says Pendse.
The BI Survey will shed light on many perceived truths related to the BI market, among them:
* Data volumes are exploding.
* Customers are safer with a bigger vendor.
* Enterprise BI has arrived.
* Vendors and consultants understand customers' problems.
* Customers need a ROLAP (relational OLAP) architecture for near-realtime BI.
This year's survey is the biggest ever, attracting 2 746 responses, including more than 1 900 end-users and consultants. A minimum of 50 responses each was received from users of 16 BI products, making this the most statistically valid survey to date.
"The BI market is in a state of flux, caused in part by consolidation and commoditisation, and the steady rise of Microsoft," says Keith Jones, MD of Harvey Jones, which is working with Pendse for the second year in a row to make the results of the survey available in South Africa. "Releasing the results as we are doing underscores our commitment to the South African BI market."
The survey includes:
* An overview of the products and vendors.
* How and why customers buy BI products, and the resultant success rate.
* The overall BI ownership experience.
* Vendor effectiveness against a variety of criteria, including marketing, sales, deployment, product support and loyalty.
* Implementation, Web BI and data volumes.
"Unlike most other published surveys, The BI Survey 7 is entirely vendor-independent," Pendse adds. "We are therefore able to present our customers with research and analysis designed to suit their needs."