is MDS suitable for my scenario?

Question

Hi,

I have  a DB XYZ in my PROD server which acts as a master DB to all the 150+ user app DBs in my server. Right now its working in a cross DB connection . We have  unique service accounts mapped to each app DBs which also has access to the master DB XYZ. That master database gets data from different sources both in realtime and in batch mode. Will MDS implementation suit our model?

I have gone through some MDS documents. I have some questions

1) With MDS ,  are we configuring  master data as centralized hub and exposing it as a webservice on top of WCF?

2)can we avoid cross DB dependency,if MDS implemented?

3)How the 150+ app will get the data which it needs from my XYZ master DB

Also some links to understand what is MDS and its features would be helpful

Thanks in advance

Answer 1

Are my questions technically valid?

Answer 2

1) With MDS ,  are we configuring  master data as centralized hub and exposing it as a webservice on top of WCF?

2)can we avoid cross DB dependency,if MDS implemented?

3)How the 150+ app will get the data which it needs from my XYZ master DB

Also some links to understand what is MDS and its features would be helpful

1. yes, MDS architecture is one where the master data is centralized and exposed to "subscribers" which can be users, or applications.  Typically in DW environments, the master data is exposed via views where master data is referenced during the ETL process.  There is a WCF-based web-service which is geared more towards master-data management-related tasks as opposed to consumption, but its likely that this can be used for consumption as well if the "view-based" expose doesn't suffice.
2. no, I don't believe you can avoid cross DB dependency...for typical usage where master data is exposed via views to subscribers (users/applications) the data remains in the separate MDS database.
3. subscription views...as mentioned in points 1 & 2 above

Here's a good place to get started: http://msdn.microsoft.com/en-us/sqlserver/ff943581.aspx