Geodesic
A Design Specification and a Server Implementation of the Inverse Referential Integrity Constraints
Computer Science and Information Systems, Tome 10 (2013) no. 1.

Voir la notice de l'article provenant de la source Computer Science and Information Systems website

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*Studio development environment. In the paper the algorithms for insertion, modification and deletion control are presented, alongside with parameterized patterns for their implementation for DBMSs MS SQL Server 2008 and Oracle 10g. It is also given an example of generated procedures/triggers.
Keywords: Inclusion Dependencies, Inverse Referential Integrity Constraint, Declarative Constraint Specification 
@article{CSIS_2013_10_1_a15,
     author = {Slavica Aleksi\'c and Sonja Risti\'c and Ivan Lukovi\'c and Milan \v{C}elikovi\'c},
     title = {A {Design} {Specification} and a {Server} {Implementation} of the {Inverse} {Referential} {Integrity} {Constraints}},
     journal = {Computer Science and Information Systems},
     publisher = {mathdoc},
     volume = {10},
     number = {1},
     year = {2013},
     url = {http://geodesic.mathdoc.fr/item/CSIS_2013_10_1_a15/}
}
TY  - JOUR
AU  - Slavica Aleksić
AU  - Sonja Ristić
AU  - Ivan Luković
AU  - Milan Čeliković
TI  - A Design Specification and a Server Implementation of the Inverse Referential Integrity Constraints
JO  - Computer Science and Information Systems
PY  - 2013
VL  - 10
IS  - 1
PB  - mathdoc
UR  - http://geodesic.mathdoc.fr/item/CSIS_2013_10_1_a15/
ID  - CSIS_2013_10_1_a15
ER  - 
%0 Journal Article
%A Slavica Aleksić
%A Sonja Ristić
%A Ivan Luković
%A Milan Čeliković
%T A Design Specification and a Server Implementation of the Inverse Referential Integrity Constraints
%J Computer Science and Information Systems
%D 2013
%V 10
%N 1
%I mathdoc
%U http://geodesic.mathdoc.fr/item/CSIS_2013_10_1_a15/
%F CSIS_2013_10_1_a15
Slavica Aleksić; Sonja Ristić; Ivan Luković; Milan Čeliković. A Design Specification and a Server Implementation of the Inverse Referential Integrity Constraints. Computer Science and Information Systems, Tome 10 (2013) no. 1. http://geodesic.mathdoc.fr/item/CSIS_2013_10_1_a15/