· Oct 20, 2021

Rules in database

Why is it not common to handle inclusion, alteration and exclusion rules directly in the Caché database, using their controls on web pages, as is usually done in other databases such as Oracle, SQL Server?  

Product version: Caché 2018.1
Discussion (1)1
Log in or sign up to continue

Nothing prevents you to have such rules as part of your object definition.
And all the code to define this is definitely part of Caché or IRIS.
Caché and IRIS have excellent SQL support and projection of objects to simple tables.

But you should not try to compare an Object database to any relational database.
Just as a comparison, you won't ask:
  Why does a 747 not have red blinking warning lights at his back like a yellow school bus?

In reverse the 2 you mentioned try to mimic features of an Object database. With limited success.