MicroStrategy Business Intelligence Software
RDBMS BI Tuning Specialists
The Technical Advisory Services team is assembled with key consulting specialists with extensive RDBMS knowledge
and specific BI experience with your DBMS environment.
MicroStrategy Technical Advisory Services Team |
|
|
|
|
|
|
|
|
|
RDBMS BI Tuning
Specialist Capabilities |
Sybase |
Informix |
SQL Server |
Tandem |
Oracle |
DB2 UDB |
Teradata |
General |
-
Creation of most advantageous Oracle Hints to ensure the optimizer is
tuned appropriately for the MicroStrategy application
- Strategies to leverage Oracle 9i Real Application Clusters (RAC) to
increase fault tolerance of complete clusters
- Materialized view optimizations
- Query plan analysis
|
- AST (Automatic summary Table) creation for optimal functionality with
Engine’s aggregate table navigation
- Common table vs. temporary table analysis
- Reduce physical page requests, locks and commits
- Query optimization on AS/400 using encoded vector indices
- Partition key analysis for optimal join processing
|
- Optimal primary index selection and
creation to ensure best data distribution and join performance for the
Teradata MPP architecture
- Join index analysis
- Derived table vs. temporary table analysis
- Reduce physical page requests, locks and commits
- Leveraging CLI-API to take advantage innate Teradata capabilities
|
- Database indexing
- Explain plan analysis for optimal SQL tuning
- Aggregate table creation based on query and usage pattern analysis
- Join analysis
- Concurrency and locking control
- Database analytics vs. MicroStrategy analytics
|
|
|
