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.
CITATION STYLE
Ghawi, R. (2019). On repairing referential integrity constraints in relational databases. In Communications in Computer and Information Science (Vol. 1018, pp. 82–96). Springer Verlag. https://doi.org/10.1007/978-3-030-19093-4_7
Mendeley helps you to discover research relevant for your work.