1

Many DBMS implement views. However, do some of them implement change data capture on views (rather than actual tables), in a near real time fashion ?

1

I work mainly with Sql Server, but I'm not aware of any DBMS that can track changes on a 'view'.

I would suggest that a standard view is only a logical abstraction of physical tables and does not provide any actual data storage to change. Any changes done though the view would be applied to the actual physical tables. As I understand it, CDC uses the transaction log to process the changes, I think your answer is no. If you need to track the data changes, you would need to track the underlying tables.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.