Answer the question
In order to leave comments, you need to log in
How to implement referential integrity control programmatically?
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 the question
In order to leave comments, you need to log in
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.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question