How to implement referential integrity control programmatically?

Question

Java

good morning.
Maybe someone came across - the customer's TOR specifies the requirement to implement referential integrity control by software (implementation not by means of a DBMS!). Clearly the customer can not answer what it is.
Can anyone have experience, how can you implement referential integrity control software?

Answer 1

Referential integrity is the state of the system when following each link does not return a missing target error (database row by primary key for databases). If the task is to implement referential integrity not by means of a DBMS, then you will have to create your own abstraction layer that implements this task somewhere in the process of writing data, which is a time-consuming and technically difficult task. From this, generally speaking, the conclusion is that it is more efficient to rely on ready-made database functionality to obtain this functionality.

Answer 2

It depends a lot on what kind of "software" you have.
Delete from TK.
In general, if the customer cannot answer what it is - perhaps he is not a real customer and he just threw the project over to you? :) Especially if you don't want to cross out.