Data repair based on parity determined using join operation

A system for intelligently repairing data, the system comprising:

• one or more processors of a data quality management (DQM) system;
• at least one memory coupled to the one or more processors and storing instructions that, when executed by the one or more processors, cause the system to perform operations comprising:
• receiving a transmission over a communications network from a computing device associated with the DQM system, the transmission including an indication that source data stored in one or more source databases, which are append only, was ingested and stored as target data in one or more target databases in a materialized view at a current time of ingestion;
• generating parity data for the target data in the one or more target databases with the source data in the one or more source databases, comprising:
• generating a target data change dataset for the target data in the one or more target databases based on changes to target data that occurred from a previous time of ingestion to the current time of ingestion, wherein changes comprise updates, inserts, and deletes;
• generating a source data change dataset for the source data from the one or more source databases based on changes to the source data that occurred from the previous time of ingestion to the current time of ingestion;
• generating first differential data for updates and inserts based on a comparison of the updates and the inserts in the target data change dataset and the source data change dataset;
• generating second differential data for deletes based on a join operation for deletes using the one or more target databases and the source data change dataset;
• and
• selectively repairing the target data in the one or more target databases based on the first differential data and the second differential data.