A design specification and a server implementation of the inverse referential integrity constraints
Author(s) -
Slavica Aleksić,
Sonja Ristić,
Ivan Luković,
Milan Čeliković
Publication year - 2013
Publication title -
computer science and information systems
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.244
H-Index - 24
eISSN - 2406-1018
pISSN - 1820-0214
DOI - 10.2298/csis111102003a
Subject(s) - computer science , data integrity , key (lock) , relational database management system , relational database , database , generator (circuit theory) , sql , sql server , programming language , data mining , theoretical computer science , computer security , power (physics) , physics , quantum mechanics
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
Accelerating Research
Robert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom
Address
John Eccles HouseRobert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom