A Design Specification and a Server Implementation of the Inverse Referential Integrity Constraints

Slavica Aleksić1, Sonja Ristić2, Ivan Luković1 and Milan Čeliković1

  1. University of Novi Sad, Faculty of Technical Sciences, Department of Computing and Control
    Trg Dositeja Obradovica 6, 21000 Novi Sad, Serbia
    {slavica, ivan, milancel}@uns.ac.rs
  2. University of Novi Sad, Faculty of Technical Sciences, Department for Industrial Engineering and Management
    Trg Dositeja Obradovica 6, 21000 Novi Sad, Serbia
    sdristic@uns.ac.rs

Abstract

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.

Key words

Inclusion Dependencies, Inverse Referential Integrity Constraint, Declarative Constraint Specification

Digital Object Identifier (DOI)

https://doi.org/10.2298/CSIS111102003A

Publication information

Volume 10, Issue 1 (Januar 2013)
Year of Publication: 2013
ISSN: 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable in PDF
Portable Document Format

How to cite

Aleksić, S., Ristić, S., Luković, I., Čeliković, M.: A Design Specification and a Server Implementation of the Inverse Referential Integrity Constraints. Computer Science and Information Systems, Vol. 10, No. 1, 283-320. (2013), https://doi.org/10.2298/CSIS111102003A