Basic Guidelines for Data Integrity in Enterprise Software

The original Relational Model of Data for Large Shared Data Banks [] was a major milestone in the history of information technology that has undergone changes in understanding over the years. Despite the fact There is No Database Magic [], A Review of Relational Concepts [] is useful to avoid widespread Logical-Physical Confusion [].

That is not to say that the real world always maps well to the simplest logical structures, after all Starbucks Does Not Use Two-Phase Commit []. Also, aside from logical correctness, the problem of Basic Human Error Rates [] must be also managed into any data quality metric.