Real Time Data Analytics on Active Data Guard

Abstract

Oracle Database (ODB) offers significant acceleration for analytic queries with its highly compressed, transactionally consistent, memory-optimized Column Store. Customers may utilize Oracle ODB to make real-time judgments by evaluating extensive data sets at remarkable rates. Active Data Guard (ADG) is Oracle's all-encompassing solution for high availability and disaster recovery of the Oracle Database. Oracle ADG mitigates the substantial expense of idle redundancy by enabling reporting applications, ad-hoc queries, and data extracts to be delegated to the synchronized, physical Standby database duplicated via Oracle ADG. In Oracle 12.2, we expanded the ODB benefit to the Oracle ADG architecture. ODB-on-ADG markedly enhances the performance of analytic, read-only workloads executed on the physical Standby database, while the Primary database persists in managing high-velocity OLTP workloads. Customers may distribute their data across the In-Memory Column Stores on both the Primary and Standby databases according to access patterns, so achieving fault tolerance and workload segregation without sacrificing essential performance SLAs. This study examines the principal issues associated with constructing the ODB-on-ADG architecture, particularly the synchronized maintenance of the In-Memory Column Store on the Standby database, amid ongoing high-speed OLTP activity that continually alters data on the Primary database.