MicroStrategy Business Intelligence Software
|
MicroStrategy Database
Optimizations
|
 MicroStrategy
Optimizations for IBM
The MicroStrategy Business Intelligence Platform has been
optimized for IBM
DB2 throughout its development history. We have invested
in dozens of IBM-specific features to ensure you get maximum
leverage from your investment. As a result, business users
get the full range of reporting, analysis and information
delivery features they desire, and data warehouse profes-sionals
get the performance and maintainability they demand.
|
| Unique
MicroStrategy Optimizations for IBM DB2 |
| DB2-specific Syntax
for Common Tables |
Partitioning Keys |
DB2-specific SQL |
| Derived Tables |
Customized Index
Creation |
Middle Tier Caching |
| Global Temporary
Tables |
Primary Indexing
with Partitioning |
Intelligent Cube
Technology |
|
 MicroStrategy
Optimizations for Oracle
Oracle
tests the MicroStrategy platform at its Enterprise Technology
Center in order to optimize performance and stability for
our joint customers. Through rigorous pre-release testing,
MicroStrategy has consistently supported each new Oracle release
before it reached the market.
|
| Unique
MicroStrategy Optimizations for Oracle |
| Multi-column IN Statements |
Oracle-specific SQL |
Table Selection Options |
| Customized Index
Creation |
Star-Query
Optimization |
Intelligent Cube
Technology |
| Object-specific Hints |
Middle Tier Caching |
Materialized Views |
|
 MicroStrategy
Optimizations for Teradata
MicroStrategy
and Teradata
have a long history of working together to optimize the performance
and capabilities of our joint business intelligence solutions.
Both MicroStrategy and Teradata maintain dedicated research
and devel-opment groups to continue the enhancemnt of their
BI collaborations.
|
| Unique
MicroStrategy Optimizations for Teradata |
| Volatile Tables |
Delayed Dropping
of Temp Tables |
Middle Tier Caching |
| Derived Tables |
Insert/Select Optimizations
for Intermediate Tables |
Intelligent Cube
Technology |
| Primary Indexing |
Teradata-specific
SQL |
Statistic Collection
on Temporary Tables |
|
