dbta

The Importance of Referential Constraints for Data Integrity

Referential integrity (RI)is a method for ensuring the “correctness” of data within a DBMS. People tend to oversimplify RI, stating that it is merely the identification of relationships between ...
Ars Technica

MySQL and Referential Integrity

I'm giving myself a crash course on database design before I take on a quite enormous project. I'm starting by reading through my semi-introductory book, MySQL by Michael Kofler (2001). As I go, I'm ...
Ars Technica

Oracle/SQL -- self referential tables

Hi,<BR><BR>I'm in the process of building a SQL clean-up script that will be removing lots of now redundant data from our Oracle DB.<BR><BR>It seems that for tables which contain a FK pointing back to ...
dbta

The Importance of Database-Enforced Integrity

Ensuring the integrity of the organization’s databases is a key component of the DBA’s job. A database is of little use if the data it contains is inaccurate or if it cannot be accessed due to ...