Warning: Creating default object from empty value in /home/johnnz/public_html/wp-content/themes/simplicity/functions/admin-hooks.php on line 160
Tag Archives: UID

Data Modelling: The Power of QUACKs and UIDs

Codes are Not Identifiers In my previous post on how unique keys cause duplication in databases I demonstrated that codes are not identifiers for data entities and, by extension, they cannot be unique identifiers (UIDs). Why Do People Use Codes? If codes are not identifiers how come they are used so extensively?  Because, when used […]

Leave a comment Continue Reading →

Unique Keys are the Primary Cause of Duplication in Databases

It is perhaps the greatest paradox of data quality that the PRIMARY cause of duplication of entries in any database is the mistaken use of unique keys as the Unique Identifiers UIDs) of records.
Click on “Read More” to learn how to avoid this error.

8 Comments Continue Reading →