Synopsis: Pseudo Key Neat-Freak
Explore the pseudokey neat-freak antipattern and its impact on data integrity in SQL databases. Understand why renumbering keys to remove gaps causes discrepancies and how to avoid this common mistake. Learn the importance of keeping stable identifiers to support accurate reporting and asset tracking.
We'll cover the following...
Imagine the following scenario. Your manager approaches you, holding two report printouts. “The bean counters are saying we have discrepancies between this quarter’s report and the last quarter’s report. I’m looking at them, and they’re absolutely right. Most of the later assets have disappeared. What happened?”
You look at the reports, and the pattern of discrepancies rings a bell. “No, everything is still there. You asked me to clean up the rows in the database, so there are no missing rows. You said the accountants kept asking you ...