Can some queries be offloaded to alternative databases for improved performance and enhanced capacity?
Yes. Companies can use MicroStrategy MultiSource Option to get more capacity from expensive database engines by offloading simple queries from high-end, high-cost database servers onto much less expensive, general purpose databases. MicroStrategys ROLAP engine will automatically use the most efficient source whenever possible, reserving the high-end database capacity for more complex and higher volume queries.
Related Questions
- What if the user employs several Enhanced Operator Stations as the primary operator interface? Will he still have multiple databases to maintain after migrating to Experion?
- What if the user employs several Enhanced Operator Stations as the primary operator interface? Will he still have multiple databases to maintain after migrating to Experion?
- Is it possible now to export data from Oracle tables and queries selected from different databases to RTF files?
- Can some queries be offloaded to alternative databases for improved performance and enhanced capacity?
- How Does Titan Work?
- How Does Titan Work?