MicroStrategy Incorporated introduced MicroStrategy 9 at its annual user conference in Las Vegas. MicroStrategy 9, the company’s most significant release in nearly a decade, is expected to be generally available in the first quarter of 2009 and will include significant new products and enhancements to its BI software platform.

“Organizations have a mix of enterprise-grade and departmental BI applications. Enterprise BI applications continue to advance in data scale, user scale, and analytical requirements, and MicroStrategy 9 includes new, advanced features to improve the performance, scale, and efficiency of large-scale enterprise BI applications,” said Sanju Bansal, MicroStrategy’s COO. “In addition, MicroStrategy 9 also includes innovative features to enable the rapid development of departmental BI applications by business users rather than IT professionals. To support consolidation and standardization, MicroStrategy 9 eases the migration of departmental BI application data and metadata into a unified, enterprise BI environment.”

As BI systems grow to thousands of users and hundreds of terabytes of data, maintaining fast query performance can be a tremendous challenge. MicroStrategy 9 includes new adaptive caching technology called In-memory ROLAP and improvements in SQL generation to enhance query performance.

MicroStrategy 9 introduces a major new architectural component called “In-memory ROLAP” to dramatically improve query performance. In-memory ROLAP takes advantage of the large addressable memory now available on 64-bit Unix, Linux, and Windows computer servers, and provides a performance-optimized middle-tier database that can respond directly to data requests from reports, dashboards, and OLAP analyses. Since the new middle-tier database is stored in computer memory, it avoids disk access delays. In-memory ROLAP can serve the data needed for the most complex and time-consuming queries, dramatically improving the average query response times. In-memory ROLAP can also offload work from database servers, freeing up database capacity and allowing enterprises potentially to delay purchasing additional database capacity.

MicroStrategy 9 introduces SQL generation algorithm optimizations for handling sophisticated analyses involving complex metrics. The new optimization algorithm can reduce the number of SQL passes by 66% and reduce database query time by as much as 75%. This new capability works transparently with reports, dashboards, and analyses, providing an immediate performance improvement to many existing MicroStrategy applications.

Successful BI systems often experience dramatic growth in user populations. It is increasingly common for a single enterprise BI installation to support thousands and even tens of thousands of business users.

MicroStrategy 9 includes significant architectural components and features that allow it to efficiently support the specific needs of smaller-scale BI systems for departments and workgroups.

This BeyeNETWORK news item contains information from a recent press release by the company mentioned.