Adrian
Mar 20, 2024

--

It’s a good overview of what MDM is about. The architecture you describe makes sense and the tools available (at least those from Microsoft’s technology stack) make it possible to implement it. However, there are also points I don’t agree with. I was trying to formulate the ideas into an answer, though it became a post. I will resume to mention in here only the first paragraph:

“Master data can be managed within individual domains though the boundaries must be clearly defined, and some coordination is needed. Attempting to partition the entities based on domains doesn’t always work. The partition needs to be performed at attribute level, though even then might be some exceptions involved (e.g. some Products are only for Finance to use). One can identify then attributes inside of the system to create the boundaries.”

Feel free to check the other points:

https://sql-troubles.blogspot.com/2024/03/data-management-understanding-master.html

--

--

Adrian

IT professional/blogger with more than 24 years experience in IT - Software Engineering, BI & Analytics, Data, Project, Quality, Database & Knowledge Management