Legal Notice
MicroStrategy does not guarantee the accuracy of any information presented in this document, and there is no commitment, express or implied, on the part of MicroStrategy to update or otherwise amend this document. The furnishing of this document does not provide any license to patents, trademarks, copyrights or other intellectual property rights owned or held by MicroStrategy.
Copyright Information
All Contents Copyright © 2010 MicroStrategy Incorporated.
All Rights Reserved.
Please click the link to agree to the above terms and continue with the QuickTour. AGREE »
High Performance at Any Scale
Quick Response Time
MicroStrategy 9
- In-memory ROLAP: In-memory ROLAP cubes improve the performance of the most time-consuming and frequently-used queries, while still allowing users to seamlessly navigate the entire data warehouse.
- Dynamic Sourcing: MicroStrategy Intelligence Server dynamically selects the best source of data for a report. Dynamic sourcing capabilities automatically direct queries to In-memory ROLAP cubes whenever possible.
- Dynamic Multi-Level Caching: MicroStrategy provides automatic caching at multiple levels, including element list, metadata object, report dataset, XML definition, document output, and database connection caching.
Microsoft
- Limited End-to-End 64-bit In-memory ROLAP: Microsoft does not provide an In-memory ROLAP engine to leverage 64-bit operating systems natively.
- Lack of Dynamic Sourcing: Microsoft developers must manually select a data source for each report. Microsoft offers limited support for non-Microsoft data sources.
- Limited Caching: Microsoft provides very limited support for inter-user report caching, inter-report dataset caching, and element list caching. Limited shared caching abilities results in more hardware processing and slower applications response time for end users.
In-memory BI Fills a Void in the Performance Curve of a BI System
High Performance ROLAP Engine
MicroStrategy 9
- Push-Down Architecture: MicroStrategy leverages the database to its fullest extent by pushing data joins and analytic calculations to the database whenever possible.
- High Performance Multi-Pass SQL: MicroStrategy ensures high performance Multi-Pass SQL queries by making full use of the database’s processing and analytical capabilities and avoid pulling intermediate result sets to the mid-tier.
- Automatic Aggregate Awareness: Maximized database usage and enhanced performance for every analysis by making use of common data warehouse optimization techniques like aggregate tables and table partitioning.
Microsoft
- Limited Multi-Pass SQL: The Microsoft ROLAP engine does not provide the ability to run multi-pass SQL and therefore forces many calculations to be performed in the middle-tier server. Microsoft cannot leverage the database to its fullest extent possible, resulting in unnecessary network and hardware resources utilization.
- No Automatic Aggregate Awareness: Microsoft requires IT developers to pre-configure dimensions to use either ROLAP or Analysis Services cubes. The Microsoft ROLAP engine does not support automatic aggregate awareness and so cannot select the most efficient data source during run-time.
Market Proven Enterprise Scalability and Performance
MicroStrategy 9
- Native 64-bit BI processing: MicroStrategy provides native support for 64-bit processing for all major operating systems, and across the entire BI platform.
- Full Support for 64-bit Java Virtual Machines: The expanded memory available in 64-bit JVMs allows for optimal Web performance across the enterprise.
- Robust Server Clustering: Cluster-capable servers provide load balancing and automatic failover capabilities. The MicroStrategy Intelligence Server supports asymmetric clustering, shared caching and in-memory cubes, immediate metadata objects, and security settings synchronization.
Microsoft
- Cannot leverage all 64-bit assets: Since Microsoft does not offer native support for LINUX or UNIX operating systems, organizations cannot leverage their existing investments. Microsoft customers need to spend more money on hardware boxes to support the equivalent number of users and data volumes as MicroStrategy.
- History of small deployments: Microsoft has traditionally served smaller organizations and departmental applications. Microsoft BI remains unproven in the ability to cost effectively support large data and user scales while providing adequate performance.
The Expanded Memory Available in 64-bit JVMs Allows MicroStrategy 9 to
Support More Concurrent Users with Larger Reports
