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 [...]
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.
-
John Owens Hi Julian Assets in the contexts that you outline
-
-
Julian Schwarzenbach John, For many asset intensive organisations (p
-
-
Joe Interesting article. I would just be curious on ho
BAFFE Silver Package
BAFFE Gold Package
BAFFE Platinum Package
Information Flow Modelling eBook
Business Process Modelling eBook
