Write behind cache with m-to-n referential integrity

A system, comprising:

• a cache memory;
• and
• a processor programmed to:
• cache a batch of data records generated by at least one application for persistent storage to the cache memory, where at least one of the batch of data records comprises at least one foreign key reference that each references one non-existent data record;
• determine that one of a plurality of batch database storage events has occurred;
• iteratively determine, in response to the one of the plurality of batch database storage events, which of the at least one of the batch of data records do not comprise the at least one foreign key reference that each references the one non-existent data record;
• and
• persist to a database, via a batch storage operation, each of the cached batch of data records that do not comprise the at least one foreign key reference that each references the one non-existent data record.

A computer program product comprising a computer readable storage medium including computer readable program code, where the computer readable program code when executed on a computer causes the computer to:

• cache a batch of data records generated by at least one application for persistent storage, where at least one of the batch of data records comprises at least one foreign key reference that each references one non-existent data record;
• determine that one of a plurality of batch database storage events has occurred;
• iteratively determine, in response to the one of the plurality of batch database storage events, which of the at least one of the batch of data records do not comprise the at least one foreign key reference that each references the one non-existent data record;
• and
• persist to a database, via a batch storage operation, each of the cached batch of data records that do not comprise the at least one foreign key reference that each references the one non-existent data record.