Master Data Management Model Effectiveness in Information ...

Master Data Management Model Effectiveness in Information ...

A R C H I T E C T U R A L E VA LU AT I O N O F M A S T E R D ATA M A N A G E M E N T ( M D M ) : L I T E R AT U R E R E V I E W Gholam Ali Shaykhian, Ph. D. Jinan Ziade, Ph.D. Mohamed Khairi, Ph. D. June 2016 INTRODUCTION What is MDM? What is data model? What is CDM? What is FDM? Why we should consider MDM models? 2 PROBLEM STATEMENT General problem: The problem is that the companys sales and marketing are losing business with growing data that is not controlled and organized by IT department Inappropriate uses of tools and processes have led to master data

inconsistency and have resulted in multiple versions of master data. Specific problem: Many IT organizations such as Microsoft have many databases spread across several divisions with no apparent consensus about specific data model architecture or shared MDM principles. Some divisions use Federated data Model (FDM) model and other divisions use Centralized Data Model (CDM) whereas the other divisions dont use MDM. 3 PURPOSE STATEMENT The purpose of this study is to identify and to further understand the MDM users and experiences on the suitable MDM model for an organization against certain factors (cost, schedule, performance, efficiency, limitations, risk, training, operations, compliances, deployment, security, accessibility, dependability, data quality, stability, maintainability, reliability, availability, flexibility, scalability, and predictability) 4 LITERATURE REVIEW

The IBM Press, The MK/OMG Press, Business Intelligence Journal, Communications of AIS, Proceedings of World Academy of Science: Engineering & Technology, Information Management, Natural Gas & Electricity, Insurance Networking News, IDC, Gartner RAS Core Research, Portuguese Journal of Management Studies, DM Review, Business Performance Management, and Information Management were the sources for collecting expert testimonies (ETs) data for this research. 5 RECOMMENDATIONS Literature review and surveys provide guidelines and recommendation for IT managers to follow to choose the suitable data management model for their organizations: Small Organization (10-99): The recommendation for such organizations is to use an FDM data model from one source or two. The cost of MDM software, operations, and maintenance is considerably high. FDM operations and maintenance are relatively low compared to CDM. IT managers must analyze the cost of technologies (specifically MDM software), operation, and human resources.

6 RECOMMENDATIONS Medium Organization (100-499): The recommendation for such organizations is to begin by analyzing the data volume, the demand of master data, and business needs in the organization. If many departments are using the same master data such as customer and product data extensively, then the urgent need for managing the master data is high and hence the business need will drive the support needed for implementing the MDM. More departments need the data to implement the CDM approach adequately. The CDM will allow fast access, better performance, and one center place to update master data. 7 RECOMMENDATIONS Large Organization (More than 500): Big organizations with more than 500 employees that have urgent need for MDM system to handle complex business process keep track of continual changes, and increasingly

merger and acquisition activities. Scalable MDM system is able to transform systems to SaaS (software as a Service) by cultivating it to deal with multitenant environment as well as assuring scalability and configuration capability. The recommendation for such needs is to implement CDM style. 8 SUGGESTIONS FOR FURTHER RESEARCH The cloud computing is taking the momentum and it is use increases. To study the factors influence on model selection in cloud computing will be useful for future research. 9 THANK YOU 10 REFERENCES

Agosta, L. (2005). Hub-and- Spoke Architecture Favored. DM Review. 15(3) 14-63. Retrieved from EBSCOhost Database. Alt, R., Fleisch, E., sterle, H.(2000). Electronic Commerce and Supply Chain Management at ETA Fabriques dEbauches SA. Journal of Electronic Commerce Research. 1(2). Beyer, M. A. (2009). Overview of Data Warehouse Project Delivery in 2009. Advance online publication. Retrieved from Bijesse, J., Higgs, L., McCluskey, M.(2002). Service Lifecycle Management (Part 1): The Approaches and Technologies to Build Sustainable Competitive Advantage, Atlanta: AMR Research. BIPM Institute (2008). Master Data Management definition- What is MDM-CDI?. Retrieved from Brennan, Z. (2007). Federated benefits: Transformative IT: What It Means for Employers, Providers, Government. Advance online publication. Retrieved from Cheng, L. (2005). Changing language teaching through language testing: awashback study. Cambridge University Press. p. 72. Chisholm, M. (2009). All Data is Not Equal; Reference data, master data and event data have distinctions and must be managed differently. Information Management. Advance online publication. Committee on National Security Systems (CSNSS) (2006). National Information Assurance (IA) glossary. Retrieved from Creswell, J. W. (2004). Educational research planning, conducting, and evaluating quantitative and qualitative research (2 nd ed.). Columbus, Ohio: Merrill Prentice Hall. D&B (n.d.). D&Bs Purisma Data Hub 4.0 provides in-depth and actionable customer data. Retrieved From Dagan, B. (2008). Master data management systems to be useful for ccs, other functions. Natural Gas, 24(10), 25-29. Retrieved from

Dagan, B. (2008). Master Data Management Systems To Be Useful for CCS, Other Functions. Natural Gas & Electricity, 24(10), p25-29, 5p. Danielewicz, J. (n.d.). SIX SIGMA AND MDM. Data Strategy Journal. Retrieved from Data Foundations (n.d.). OneData MDR. Retrieved from DataFlux (n.d.). Master Data Management. Retrieved from Dreibelbis, A., Hechler, E., Milman, I., Oberhofer, M. (2008). Enterprise Master Data Management: An SOA Approach to Managing Core Information. IBM Press Dreibelbis, A., Hechler, E., Milman, I., Oberhofer, M., van Run, P., & Wolfson, D. (2008). Introduction to enterprise master data management. Retrieved from,295582,sid91_gci1320762,00.html Dych, J., & Levy, E. (2006). Serving many masters: a closer look at MDM; as important to business strategy as the EDW was, the processing of the item master was ultimately much more critical to business operations. Advance online publication. Retrieved from index=0&did=1454942261&SrchMode=2&sid=1&Fmt=3&VInst=PROD&VType=PQD&RQT=309&VName=PQD&TS=1258783964&clientId=13118 Eckerson, W. (2003). Four ways to build a data warehouse. Advance online publication. Retrieved from Freidman, T. (2006). Key Issues for Data Management and Integration, 2006, GartnerGroup Research, March 30, ID# G00138812. Friedman, T. (2007). Data federation adoption increases as part of complete data integration strategy. Advance online publication. Retrieved from Fryer, A. (2007). One version of the truth. Andrew Fryer's Blog, Retrieved January 2, 2010, from

Gall, M.D., Borg, W.R., & Gall, J.P. (1996). Educational research: An introduction (6thed.). NY: Longman. Yang, J. S. (2005). Master Data Management. Baseline. Advance online publication. Retrieved from 11 REFERENCES Garbellotto, G. (2007). The data warehousing disconnect. Strategic Finance. 89(4) 59-61. Retrieved from EBSCOHOST Database. Gartner (n.d.). Gartners case for federated data. Advance online publication. Retrieved from Gay, L.R. (1976) Educational research: Competencies for analysis and application, Merrill., Columbus, OH Godinez, M. ; Hechler, E., Koenig, K., Lockwood, S., Oberhofer, M., Schroeck, M. (2010). The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight. Indianapolis, Indiana: IBM Press. Retrieved From Goul, M. (2007). Whats your strategy for master data management? Advance online publication. Retrieved from Graham, T. (2008). Defining the role of MDM in the organization: A Technical perspective. Microsoft Press. Advance online publication. Retrieved from http://infoweb2007/sqlserver/content/find/solutions/Pages/MasterDataServices.aspx Greene, J.C., Caracelli, V.J., & Graham, W.F. (1989). Toward a conceptual framework for mixed-method evaluation designs. Educational Evaluation and Policy Analysis, 11, 255274. Gruman, G. (2006). Rolling out the real time data mart. Infoworld. Advance online publication.

Han, J., Ju, H., & Chun, J.(2010). RFID-ready Master Data Management for Reverse Logistics. Proceedings of World Academy of Science: Engineering & Technology, Jun2010, Vol. 66, p826-829, 4p Heimbigner, D., & McLoed, D. (1985). A Federated architecture for information management. ACM Transactions on Information Systems (TOIS), 3(3), 253-278. Retrieved from id=4233&coll=GUIDE&dl=GUIDE&CFID=24352949&CFTOKEN=82196277&ret=1#Fulltext Hyperian (2010). Heperion System. IBM (n.d.). InfoSphere Master Data Management. Retrieved from IBM (n.d.). InfoSphere Master Data Management. Retrieved from INFORMATICA (n.d.). Siperian Multidomain MDM Hub. Retrieved From Intellegent(2009). Microsoft SQL Server 2008 R2: A Closer Look. Intelligent Enterprise-Online. Advance online publication. Ishida, T. (in press). High density phase-change type optical disk having a data efficiency of more than 80 percent. US Patent for Matsushita Electric Industrial Co. Ltd. Retrieved from Joshi, M., Subrahmanya, V. (2003). Global Data Synchronization, Bangalore: Wipro Technologies. Juran, J. M. (1988). Juran on Planning for Quality. New York, NY: Macmillan. KALIDO (nd.). Master Data Management Software. Retrived From Karel, B. (2010). Introducing The MDM Markets Newest 800lb Gorilla: Informatica Acquires Siperian! . Retrieved from

Kelly, R., Fritsch, M.(2002). Improved effectiveness with information consolidation. Retrieved from Kimball, R. (2008). Essential Steps for the Integrated Enterprise Data Warehouse, Part 1. Advance online publication. Retrieved from http:// &VName=PQD&TS=1258783964&clientId=13118 12 REFERENCES Kirby, P., Gile, C., & Fossner, L. (2006). Data warehouse architectures must reflect business consensus. Forrester. Retrieved from Microsoft Library Kobielus, J. (n.d.). Mastering customer records: How services-oriented architecture will shape the future of CRM. Advance online publication. Retrieved from T=P&P=AN&K=27747993&EbscoContent=dGJyMMTo50SeqK44zOX0OLCmrlGeqLFSs6%2b4S7aWxWXSAAAA&ContentCust Kobielus, J. (2006). Master data management is key to compliance. Network World, 23(22), 35. Retrieved from Kobielus, J. (2007). Master data management: Bringing SOA to the datacenter. Bussiness Communications Review, 37(2), 50-53. Retrieved from Lee, Y., L. Pipino, J. Funk, and R. Wang. (2006). Journey to Data Quality, Cambridge, Mass, The MIT Press. Longman, C. (2008). Why Master Data Management is Such a Challenge. DM Review, 18(11), 18-20

Loser, C., Legner, C., & Gizanis, D. (2004). Master data management for collaborative service processes. Swittzerland: Institute of Information Management, University of St. Gallen. Loshin, D. (2008). Master Data Management. Morgan Kaufmann, CA: San Francisco Loshin, D. (2008). Master data management. San Francisco, CA: Morgan Kaufmann. Lucas, A. (2010). TOWARDS CORPORATE DATA QUALITY MANAGEMENT. Portuguese Journal of Management Studies, 15 (2), 173-195 Madhukar, N. (2009, June 24). Federated MDM data domains - A Perspective. Retrieved from Madhukar, N. (2009b). Implementing federated data domains. Advance online publication. Retrieved from McKnight, W. (2009). Four more sources of poor data quality: How to develop a strategy to identify and understand the issues. ProQuest. Advance online publication. McLeod, D. & Heimbigner,D. (1985). A federated architecture for information management. ACM Transactions on Information Systems, 3(3) pp. 253278. Retrieved from MDM Community (n.d.). Master data management - community of practitioners. Retrieved from Microsoft MDS(n.d.). SQL Server 2008 R2 Master Data Services. Retrieved From Morris, H. D., & Vesset, D. (2005). Managing Master Data for Business Performance Management: The Issues and Hyperion' s Solution. White Paper. IDC Analyze the future. IDC. Retrieved from Moseley, M. (2009). Choosing the optimal multidomain MDM Architecture. Advance online publication. Retrieved from

Moseley, M. (2009). Eliminating Data Warehouse Pressures with Master Data Services and SOA. Business Intelligence Journal, 14(2), 33-43 Moseley, M. (2009, October 15). Part 7: Centralized Models: Complete but Expensive. [Web log message]. Retrieved from Moustakas, C. (1994). Phenomenological research methods. Thousand Oaks, CA: Sage. OSullivan, T. (208). Multi-Domain and Federated MDM Hubs: Two Key Considerations. Advance online publication. Retrieved from O'Donoghue, T., Punch K. (2003). Qualitative Educational Research in Action: Doing and Reflecting. Routledge. p.78 13 REFERENCES Oracle (2010). Oracle Reference Architecture and Service Orientation. Retrieved from Oracle (n.d.). Oracle Customer Hub. Retrieved From Oracle (n.d.). Oracle Hyperion Data Relationship Management. Retrieved From Oracle. (2007). MDM as a Foundation for SOA. Advance online publication. Retrieved from Pedhazur, E. J. & Schmelkin, L. P. (1991). Measurement, design, and analysis: An integrated approach. Hillsdale, NJ: Lawrence Erlbaum.

Power, D. (in press). The Best Pitch for Customer Data Integration; Follow these 10 steps to deliver a business case within your companys project requirements. Information Management. Premisberger, C. (n.d., ). Change comes to MDM space. Information Management. Recovery Specialties. (2007). Data Consistency Explained. Retrieved from Rogers, A., Day, J, Randall, F. & Bentall, R. (2003). Patients understanding and participation in a trial designed to improve the management of anti-psychotic medication. Social Psychiatry and Psychiatric Epidemiology. 38(12) Rosenberg, J. M. (1987). Dictionary of Computers. Information Processing & Telecommunications, 2nd ed., New York: John Wiley & Sons. Sampson, H. (2004). Navigating the waves: the usefulness of a pilot in qualitative research . eafarers International Research Centre, Cardiff University. 4(3): 383-402. SAGE Publications Sandelowski, M. (1993). With child in mind: Studies of the personal encounter with infertility. University of Pennsylvania Press, Philadelphia. SAP (n.d.). Master data management solutions. Retrieved from,8,0,94346321,762418941,1269713642,SAP+%22DataFlux+MDM%22,21663190,5369893715 SAP (n.d.). Master data management solutions. Retrieved From,8,0,94347921,762418923,1269712092,%22SAP+NetWeaver+ MDM%22,21663190,5369893715 Sarsfield, S. (2009). The data governance imperative. It Governance Ltd Schindewolf, S., & Gupta, S.(2003). More than technology. SAP INFO. 107, 48-50. Schmitt, I., Saake, G. (2005). A Comprehensive database schema integration method based on the theory of formal concepts. Acta Informatica. 41(7/8) 475524. Retrieved August 29, 2008, from EBSCOHOST Database. (n.d.). Ask The Data Management Expert: Meet The Experts. Retrieved from,289621,sid91,00.html Shankar, R. (2008). Master Data Management Strategies to Start Small and Grow Big.Business Intelligence Journal, 13 (3), p37-47, 11p Shankar, R., & Menon, R. (2010). MDM Maturity Pragmatism Business Challenges and the Future of MDM. BUSINESS INTELLIGENCE Journal. 15(3) p19-25 Siperion (2004). Building a Foundation for Customer Data Integration. White Paper. Retrieved from Tapscott, D. (2008). Business Intelligence: Actionable Insights for Business Decision Makers. Retrieved from TIBCO (n.d.). TIBCO collaborative information manager. Retrieved From Todd, G. (2009). Master Data: Dont surrender; you can and must build master data management capabilities to achieve high performance. Information Management. Advance online publication. Toolbox for IT (n.d.). MDM Wiki Project. Retrieved from Tseng , F. (2005). Integrating heterogeneous data warehouses using XML technologies. Journal of Information Science, 31(3) 209-229. Retrieved from EBSCOHOST Database. 14 REFERENCES VisionWare (n.d.). MultiVue Identification Server. Retrieved from White, A. (2010). Magic Quadrant for Master Data Management of Product Data. Gartner. Gartner

RAS Core Research Note G00205921 White, A. and Y. Genovese. (2006). Your Business Process Platform Needs and Enterprise Information Strategy, GartnerGroup Research, April 26, ID# G00139332. White, C. (March, 2009). Can enterprise data warehousing and master data management projects survive the recession? Retrieved from HTTP://WWW.B-EYE-NETWORK.COM/VIEW/10010 Wolter, R. (2007). Master Data Management (MDM) Hub Architecture. Retrieved from Wolter, R., & Haselden, K. (2008). The What, Why, and How of Master Data Management. Advance online publication. Retrieved from 15

Recently Viewed Presentations

  • Overview and Status of the ATLAS Pixel Detector

    Overview and Status of the ATLAS Pixel Detector

    Claudia Gemme, CERN/INFN-Genova on behalf of the ATLAS Pixel Community 10th ICATPP Conference, Como, Oct 8th 2007 * * * * * * * ATLAS: A Toroidal LHC ApparatuS The ATLAS Pixel Detector The Pixel Detector is the innermost part...
  • Chapter 7: Access Control Lists -

    Chapter 7: Access Control Lists -

    An ACL is a series of IOS commands that control whether a router forwards or drops packets based on information found in the packet header. ACLs are not configured by default on a router. ACL's can perform the following tasks:...
  • Daily Agenda 9/6/17

    Daily Agenda 9/6/17

    Remember to use specific details from the text to complete the chart and to record your observations in the spaces provided. Poetry Vocabulary A stanza is "a group of lines in a poem, separated by spaces from other stanzas, much...
  • ME-330 Introduction

    ME-330 Introduction

    Two types of welding principles. Principle I (fusion) Principle II (solid state) CP -6: welding. Physics. I want this couse to relate to you a practical understanding of various manufacturing processes
  • New Member Orientation - District 7 Toastmasters

    New Member Orientation - District 7 Toastmasters

    Why Toastmasters? Think about these questions for 30 seconds: Why did you join Toastmasters and decide on your club? What about Toastmasters/your club makes you want to stay and get involved? What benefit of Toastmasters could you talk about for...
  • The Board'S Role

    The Board'S Role

    Karl Nelson. Founder & CEO, KPN Consulting. ALCO STRUCTURE & OBJECTIVES. We see several variations on the theme of ALCO around the country. ... will lower risk profiles and sound ERM process will end up with a lesser need for...
  • Incremental, Systematic Acquiring of Knowledge (using closure ...

    Incremental, Systematic Acquiring of Knowledge (using closure ...

    A closure algorithmenables the incremental, systematic acquiring of knowledge. Closure algorithms are characterized by two components: An initialization, which is an assessment of what we know initially. An inference rule, which is a rule telling how knowledge from several places...
  • Reactions of Alkenes. Thermodynamics and Kinetics

    Reactions of Alkenes. Thermodynamics and Kinetics

    * * * * * * * * Chapter 4 * Rate-Determining Step Carbocation intermediates are consumed by bromide ions as fast as they are formed The rate of the overall reaction is determined by the slow first step Chapter...