A stored procedure is more efficient than an ad hoc query
since the query optimization overhead is amortized over the many executions of the query.
These applications include a repair of re pairables database, market pricing of material, online case reconciliation reviews, online metrics, a customer requisition management system, and an online ad hoc query
system, as well as other customer and employee productivity enhancing applications.
The three products available are the Mortgage Application Acceleration Program, the Parcel Attribute Query, and the Mini Ad Hoc Query
Stonefield has partnered with over 800 OEM and ISV partners to deliver ad hoc query
and Business Intelligence (BI) reporting solutions to more than 225,000 users in over 65 countries globally to date.
"Self-service BI enables end users to access and analyze data through interactive and personalized BI interfaces without being dependent on IT resources for each iterative ad hoc query
and customized report." It's not that there are great technological barriers to self-service business intelligence.