Solutions: MicroStrategy and Teradata

Overview | Unique Optimizations | Certifications & Memberships

Unique Optimizations

MicroStrategy offers multi-platform support for Teradata to allow customers greater operating environment flexibility.

MicroStrategy’s SQL engine automatically generates highly optimized SQL specific to Teradata. In fact, these Teradata-specific optimizations can be further tuned to make queries run 10 to 100 times faster. These tunable properties are referred to as Very Large Database (VLDB) settings that adjust the SQL for Teradata at every level in the MicroStrategy application, including at the metric, report, or BI application level.

In addition, MicroStrategy provides the ability to execute SQL commands concurrently against Teradata in order to optimize the workload on the database and maximize its capability to achieve high levels of performance. MicroStrategy’s Multi-pass SQL engine not only leverages parallel SQL execution, but also delivers greater analytical depth to address and resolve the hardest questions. As a result, our joint customers are able to derive maximum value from our joint technology integration and optimization.

• Ordered Analytic functions (OLAP functions)
• Use of CASE expressions
• Full Outer joins
• Set operators
• Sub queries

• Use of volatile tables
• Use of derived tables
• Control over primary indexes on intermediate results
• Statistics collection on intermediate results
• Bulk insertion of intermediate results for speed

• Partitioned primary indexes
• Aggregate join indexes
• Teradata function library
• User-defined functions
• UNICODE character sets

• Aggregate awareness with physical summary tables
• Middle-tier computation of calculations not available in Teradata
• Middle-tier caching via Intelligent Cubes
• Report caching
• Application-level partitioning

• Priority Scheduler
• Query Director