Master Data Management

Posted on 2007-10-19
Medium Priority
Last Modified: 2008-01-09
what is mdm (master database management) ? how to create it?
what is the differences compare to traditional Data warehosue ?
Question by:jung1975
LVL 37

Accepted Solution

momi_sabag earned 2000 total points
ID: 20114295
you can read an overview about mdm here

setting it up is not a 1 fit all procedure,
every enterprise needs to set it up differently according to it's needs and current applications

the difference between mdm and a traditional data warhouse as i see it focus on 2 levels :
1) a data warhouse is a centeral database to hold data from many systems. One should maintain processes that update the data warhouse with data from the production systems. On the other hand, mdm contains a central repository of data, and the direction of data replication is opposite. you update the mdm and from there you replicate the data to the production systems
2) mdm is an entire infrastructure and not just a database, that is it enables you to perform buisness logic in one central location (kind of like SOA), and by this eliminate the need to repeat the same buisness logic in different production applications

i hope i was clear
anyways, read the article in the above link and it will make things clearer

Author Comment

ID: 20115890
thanks.. do you see the future of MDM? it seems like it's a very cool idea for many business situation?
and SOA seems  to be the the new techniolgoy to handle the complex business logic and enterprize data intergration...

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month16 days, 1 hour left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question