Let’s understand master data services terminologies using an analogy. We’ll use the world of RDBMS for our analogy:
| Terminology in MDS | Analogy w/ RDBMS |
| Models | SQL server Schema which is used to group logical entities together. |
| Entities | Table |
| Attributes | Columns |
And here’s a picture that captures the thought: Models contains entities; entities contains Attributes:
And Here’s the official reference: http://msdn.microsoft.com/en-us/library/ee633763.aspx
Conclusion:
Thinking about the master data services terminologies by drawing an analogy helps me remember them – I hope it helps someone out there too.
Pingback: How to standardize data using Data Quality Services? | Paras Doshi – Blog
Pingback: Resource: Learn to build an Enterprise Information Management system using Data Quality Services, Master Data Services and SQL Server Integration Services | Paras Doshi – Blog
Pingback: Matching activity in Data Quality Services in action! | Paras Doshi – Blog
Pingback: How to view error(s) that occur during Master data Service’s Staging Process? | Paras Doshi – Blog
Pingback: How to create a MDS entity via Excel add-in? | Paras Doshi – Blog