Paper Info
Title
On Repairing Referential Integrity Constraints in Relational Databases.
Abstract
Integrity constraints (ICs) are semantic conditions that a database should satisfy in order to be in a consistent state. Typically, ICs are declared with the database schema and enforced by the database management system (DBMS). However, in practice, ICs may not be specified to the DBMS along with the schema, this is considered a bad database design and may lead to many problems such as inconsistency and anomalies. In this paper, we present a method to identify and repair missing referential integrity constraints (foreign keys). Our method comprises three steps of verification of candidate foreign keys: data-based, model-based, and brute-force.
Year
DOI
Venue
2019
10.1007/978-3-030-19093-4_7
Communications in Computer and Information Science
Keywords
Field
DocType
Relational databases,Integrity constraints,SQL,Validation,Verification
SQL,Relational database,Information retrieval,Computer science,Database design,Database schema,Foreign key,Data integrity,Schema (psychology),Referential integrity
Conference
Volume
ISSN
Citations 
1018
1865-0929
0
PageRank 
References 
Authors
0.34
0
1
Name
Order
Citations
PageRank
Raji Ghawi1193.64