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.
OBIEE Plus
- Limited End-to-End 64-Bit In-Memory ROLAP: OBIEE Plus does not provide an in-memory ROLAP engine that could leverage 64-bit operating systems natively.
- Lack of Dynamic Sourcing: Even though Oracle recently acquired Essbase, which provides in-memory capabilities, Essbase is a standalone multidimensional database and cannot be leveraged in conjunction with the Oracle BI Server ROLAP engine to provide dynamic sourcing capabilities.
- Limited Caching: Oracle BI Server 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
- 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 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.
OBIEE Plus
- No Push-Down Architecture: The Oracle BI Server does not provide push-down technology; instead it brings back all intermediate result sets to the middle tier.
- Limited High-Performance Multi-Pass SQL: The Oracle BI Server has a limited multi-pass SQL engine that does not support temporary table creation. Without temporary table creation, the Oracle BI Server brings back each result set to the middle tier for further processing, straining network bandwidth and server CPUs. The Oracle BI Publisher server is not aggregate-aware and does not support multi-pass SQL.
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.
OBIEE Plus
- Limited 64-Bit BI Processing: OBIEE Plus has limited enterprise-wide production references at scale and even fewer references of successful 64-bit processing BI environments. OBIEE Plus is not compiled in 64-bit for Linux, Windows or HP-UX.
- Limited Server Clustering: Oracle BI Server clustered servers do not share query cache, so the same request is sent multiple times to the database. Metadata changes do not take effect immediately and cluster nodes must be restarted to propagate changes. Oracle BI Publisher has limited support for clustered environments.
The Expanded Memory Available in 64-Bit JVMs Allows MicroStrategy 9 to
Support More Concurrent Users with Larger Reports
