Master Data Management

Posted on 2007-10-19
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

    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

    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

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    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…
    This video discusses moving either the default database or any database to a new volume.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now