...
The EDS Delta Cache relies on a set of configuration files to implement the delta cache updates. These files define what resources (tables) to monitor for updates and what datasets to refresh in the cache if the resource change.
The Delta Cache process uses two methods for monitoring the changes in the tables:
- Database Poll – it runs a query at a predefined interval to determine if there were any changes in the tables since the last cache update.
- Oracle Change Notification Subscription – it creates a subscription to Oracle to receive notifications when a table is being changed.
| Info |
|---|
The Oracle Change Notification Subscription is suitable for tables which do not have a lot of updates. This is a recommendation from Oracle. We have not validated the subscriptions on tables with large amounts of updates. |
...