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 allowing users to seamlessly navigate the entire data warehouse.
- Dynamic Sourcing: 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.
IBM Cognos 8.4
- Limited End-to-End 64-Bit In-Memory ROLAP: Cognos does not provide an in-memory ROLAP engine that could leverage 64-bit operating systems natively.
- Lack of Dynamic Sourcing: Even though IBM Cognos recently acquired Applix TM1®, which provides In-memory capabilities, TM1 is a standalone multidimensional database and cannot be leveraged in conjunction with the Cognos ROLAP engine to provide dynamic sourcing capabilities.
- Limited Caching: Cognos provides very limited support for inter-user report caching, inter-report dataset caching and element list caching.
In-Memory BI Completes 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 avoids pulling intermediate result sets to the middle tier.
- Automatic Aggregate Awareness: MicroStrategy optimizes data warehouse usage and performance for every analysis by using 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.
IBM Cognos 8.4
- No Automatic Aggregate Awareness: The Cognos ROLAP engine is unable to map a single attribute to many fact tables and select the most efficient table to obtain the data during runtime.
Market-Proven Enterprise Scalability and Performance
MicroStrategy 9
- Native 64-Bit BI Processing: Native support for 64-bit processing for all major operating systems, and across the entire BI platform.
- 64-bit Java Virtual Machines: Full support for 64-bit Java Virtual Machines. The expanded memory available in 64-bit JVMs provides stunning web performance across the enterprise.
- Robust Server Clustering: Cluster-capable servers provide load balancing and automatic failover capabilities. Intelligence Server supports asymmetric clustering, shared caching, in-memory cubes, immediate metadata objects, and security settings synchronization.
IBM Cognos 8.4
- Incomplete 64-Bit BI Processing: Cognos does not offer native end-to-end support for 64-bit operating systems. More money needs to be spent on more hardware to support the same users and data volumes as MicroStrategy.
- Assemblage of Different Architectures: Cognos’ BI offering represents an assemblage of multiple different architectures that have been joined together through a service-oriented backbone. This requires the use of multiple inefficient layers of web services for internal processing tasks, harming 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
