Developer

Tracking Entity Data Changes with Change Pointer Tables

The Syclo Exchange Framework uses change pointer tables (exchange tables) in delta querying to track entity data updates.

A change pointer table has one record per relevant change of the delta-enabled entity set. Each record logs an entity creation, change, or deletion. The timestamp of the token and the information in the change pointer table determine whether an entity should be returned to the client in the response to a delta query.

Delta querying using a change pointer table can reduce response payload and provide better back-end performance. However, all changes of the relevant application table on which your entity set is based on (create, update and delete operations) must also be stored in the change pointer table.