Data change tracking and event notification

A system comprising:

• a rewrite module configured to:
• associate an active view with an entity that receives notifications reflecting the active view;
• identify one or more changed rows of a physical database table from a transaction log;
• extract, from the transaction log, one or more primary keys for the one or more changed rows of the physical database table;
• rewrite the active view using a filter condition identifying the one or more primary keys extracted from the transaction log;
• and
• execute the rewritten active view to retrieve the one or more changed rows from the physical database table;
• and
• one or more processors configured to execute the rewrite module,
• wherein the transaction log is separate from the physical database table and includes both:
• data that was included in the physical database before the change was made to the physical database table, and
• other data that was included in the physical database table after the change was made to the physical database table.

One or more hardware computer-readable storage devices comprising computer-readable instructions which, when executed by one or more computing devices, cause the one or more computing devices to perform:

• identifying an active view that retrieves records from a database, the active view being associated with an entity;
• determining one or more physical tables in the database that are referenced by the active view;
• tracking one or more columns in the one or more physical tables that are referenced by the active view;
• identifying a change to the one or more physical tables in a transaction log of the database;
• in a first instance when the change does not affect the one or more tracked columns that are referenced by the active view, treating the change as an ignorable change for the active view;
• in a second instance when the change does affect the one or more tracked columns:
• rewriting the active view using a condition that includes a primary key obtained from the transaction log;
• retrieving changed rows from the database using the condition;
• and
• providing an output of the rewritten active view to the entity, the output reflecting only the changed rows,
• wherein the transaction log is separate from the one or more physical tables.