Relational databases do this using keys and going at the data level is very encouraging . Document DBs must enforce it at the application level.
RDBs do provide referential integrity. If the relationship between two people, if one person is deleted, the relationship will automatically cease to exist (I mention ON DELETE CASCADE). If the parent category has been deleted, its subcategories will also cease to exist.
The closest repository for NoSQL can be referential integrity - these are graphical DBs such as Neo4j. Here the edges exist directly between two nodes. So, if a node were removed, the edges will also be.
I read in graphical and document repositories, and I think NoSQL databases will work towards referential integrity (and the graph databases are closer).
Question: Which NoSQL databases have referential integrity at the data level ?
source share