Strategy Integration with Oracle MySQL
MySQL is a relational database management system. The Strategy Secure Enterprise Platform supports integration with Oracle MySQL as a data warehouse with Strategy Intelligence Server running on Windows and Linux operating systems.
Strategy integration with MySQL includes the following features which improve database performance
- The Multi-Pass SQL Engine translates analytical questions into optimized queries using multiple passes of SQL. This method is faster and more agile than traditional single-pass SQL.
- Push-down analytics leverages excess database processing power by using database specific syntax to process calculations at the database level.
- Precision tuning of queries via an extensive set of VLBD settings can be applied at the report, application, or project level.
- The multi-source engine enables connectivity to data stored across multiple enterprise data assets.
- The transaction engine pushes new or updated data back to underlying databases.
