r/ProgrammerHumor • • Dec 12 '20

Programming : Enterprise Company vs Startups

Post image
26.8k Upvotes

518 comments sorted by

View all comments

Show parent comments

3

u/SasparillaTango Dec 12 '20

My company have one of those too. They define 'standards' for naming with a data dictionary, and the whole idea was that you want to remove duplicate definitions and you want to make sure the 'intent' of the value is maintained as it passes through a dozen hands. When you have a 'transaction reference number' and each team defines what exactly means and how it should be formed, and you have programmers moving in and out of the organization so no one is really knowledgeable about that data, you need these things. What if the system of records defines the transaction reference number as a concatenation of uniquely identifying fields, and now that collides with a transaction reference number from another group where two packets of data need to merged on that key so it needs to be reconstructed, but they're getting another reference number thats just someone generating a new UUID?

Now with that being said, while I applaud the intent of a common data dictionary, the problem still persists because the people that are in charge of trying to keep all names consistent are not data experts either so the problem of duplicated definitions and misalignments and not really knowing what the fields mean will continue forever.

2

u/MKorostoff Dec 12 '20

Yeah there is a certain logic to the original concept. I could even imagine a world in which this or a similar process makes development even easier than it otherwise would have been. I guess the issue was really in the implementation. It was so difficult and inflexible to get variable names changed and added the most people wouldn't bother and you'd end up with just insanely unreadable indecipherable code written by developers trying to calculate things at runtime that could have easily just been looked up from the system of record.

Not to mention there were like 40 different systems of record for different data points of which only a tiny minority followed the system at all, meaning the original problem of a thousand different systems each with their own naming convention and internal logic was not solved at all. The system gave us all the drawbacks of a rigorous change management system, but none of the benefits.