Offload Operational Reporting and Analytics to Improve Database Performance

This technical brief examines a difficult issue facing businesses today: how to get the most relevant data for making business-critical decisions from the production database, without affecting performance or productivity. Expensive hardware upgrades or maintaining several databases exclusively for reporting and analytics will increase the cost of doing business and therefore are not ideal solutions.

A more affordable solution is to split online transaction processing (OLTP) and report generation to separate systems. This allows users to run reports and data scientists to run analytics against a separate data warehouse instance that is constantly maintained to reflect the activity on the production system. This brief explains how to execute a proven solution using SharePlex.