D
D
Dmitry Krapivin2019-07-01 08:45:59
Java
Dmitry Krapivin, 2019-07-01 08:45:59

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

2 answer(s)
A
Artemy, 2019-07-01
@MetaAbstract

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.

R
Robur, 2019-07-01
@Robur

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.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question