Offloading reporting and business intelligence queries v7
In this use case, users take all or just a subset of data from a production OLTP system and replicate it to another database whose sole purpose is to support reporting queries. This approach can have multiple benefits:
- Reporting loads are removed from the OLTP system, improving transaction processing performance.
- Query performance improves without being subordinated to transactions on the system.
- In Oracle installations, the reporting server duties can be handled by a product like EDB Postgres Advanced Server, reducing licensing costs for a reporting server.