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.
SAP BusinessObjects XI 3.1
- Limited End-to-End 64-bit In-memory ROLAP: BO does not provide an in-memory ROLAP engine that could leverage all 64-bit operating systems natively.
- Local Processing on a sub-optimal platform: BO performance is constrained by a number of factors; including its heavy dependence on workstation-based processing and its inefficient SQL engines.
- Limited Caching: BO provides very limited support for inter-user report caching, inter-report dataset caching and element list caching across the product set.
In-memory BI Fills a Void in the Performance Curve of a BI System
High Performance ROLAP Engine
MicroStrategy 9
- 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. Push-Down Architecture: MicroStrategy leverages the database to its fullest extent by pushing data joins and analytic calculations to the database whenever possible.
SAP BusinessObjects XI 3.1
- Limited Multi-Pass SQL: BO’s DOLAP SQL engines do not provide the ability to run multi-pass SQL and therefore forces many calculations to be performed in the middle tier server or on the desktop. BO’s SQL engines cannot leverage the database to its fullest extent possible, thus resulting in unnecessary usage of network and hardware resources.
- No Automatic Aggregate Awareness: BO's SQL engines do not support automatic aggregate awareness, and they are unable to map a single attribute to many fact tables or select the most efficient table to obtain the data during run-time.
Market Proven Enterprise Scalability and Performance
MicroStrategy 9
- Native 64-bit BI processing: MicroStrategy offers 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 Java Virtual Machines 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, and immediate metadata objects and security settings synchronization.
SAP BusinessObjects XI 3.1
- Incomplete 64-bit BI Processing: BO does not offer native end-to-end support for all 64-bit operating systems, supporting only HP-UX 64-bit but not Windows or Linux. More money needs to be spent on hardware boxes to support the equivalent number of users and data volumes as MicroStrategy.
- Assemblage of Different Architectures: The BO BI offering represents an assemblage from multiple origins with different architectures that have been joined together through a service-oriented backbone. This backbone requires the use of multiple inefficient layers of Web services for internal processing tasks that ultimately impact the performance and scalability of BI applications.
The Expanded Memory Available in 64-bit JVMs Allows MicroStrategy 9 to
Support More Concurrent Users with Larger Reports
