doiSerbia

A design specification and a server implementation of the inverse referential integrity constraints

Aleksić Slavica (Faculty of Technical Sciences, Department of Computing and Control, Novi Sad)
Ristić Sonja (Faculty of Technical Sciences, Department for Industrial Engineering and Management, Novi Sad,)
Luković Ivan (Faculty of Technical Sciences, Department of Computing and Control, Novi Sad)
Čeliković Milan (Faculty of Technical Sciences, Department of Computing and Control, Novi Sad)

The inverse referential integrity constraints (IRICs) are specialization of non-key-based inclusion dependencies (INDs). Keybased INDs (referential integrity constraints) may be fully enforced by most current relational database management systems (RDBMSs). On the contrary, non-key-based INDs are completely disregarded by actual RDBMSs, obliging the users to manage them via custom procedures and/or triggers. In this paper we present an approach to the automated implementation of IRICs integrated in the SQL Generator tool that we developed as a part of the IIS

Keywords: Inclusion Dependencies, Inverse Referential Integrity Constraint, Declarative Constraint Specification