Data change tracking and event notification

摘要

The described implementations relate to updating views in a database system. One implementation can identify an active view that retrieves records from a database and determine one or more physical tables in the database that are referenced by the active view. The implementation can track one or more columns in the physical tables that are used by the active view and identify a change to the physical tables in a transaction log of the database. If the change does not affect the one or more columns, the change can be treated as an ignorable change for the active view.

主权项

1. A method performed by at least one computing device, the method comprising:
creating a materialized view table based on one or more physical tables of a database storing a plurality of records; obtaining first temporal metadata associated with a first network message that was received over a network at a first time; obtaining second temporal metadata associated with a second network message that was received over the network at a second time that is later than the first time; identifying an interval during which a subset of the records of the database were altered, the interval being identified by the first temporal metadata and the second temporal metadata; and performing an update on the materialized view table while limiting the update to the subset of the records that were altered during the interval identified by the first temporal metadata and the second temporal metadata, wherein limiting the update to the subset of the records comprises using the first temporal metadata and the second temporal metadata to obtain a constrained set of primary keys that are used to extract the subset of the records.