About the journal

• Home page
• Contact information
• Aims and scope
• Indexing information
• Editorial policies
• ComSIS consortium
• Journal boards
• Managing board

For authors

• Information for contributors
• Paper submission
• Article submission through OJS
• Copyright transfer form
• Download section

For readers

• Forthcoming articles
• Current issue
• Archive

For reviewers

• View and review submissions

News

• Journal's Facebook page
• Calls for special issues
• New issue notification

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

Slavica Aleksić¹, Sonja Ristić², Ivan Luković¹ and Milan Čeliković¹

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

Available 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