- Master data management
-
In computing, master data management (MDM) comprises a set of processes and tools that consistently defines and manages the non-transactional data entities of an organization (which may include reference data). MDM has the objective of providing processes for collecting, aggregating, matching, consolidating, quality-assuring, persisting and distributing such data throughout an organization to ensure consistency and control in the ongoing maintenance and application use of this information.
The term recalls the concept of a master file from an earlier computing era. MDM is similar to, and some would say the same as, virtual or federated database management.
Contents
Issues
At a basic level, MDM seeks to ensure that an organization does not use multiple (potentially inconsistent) versions of the same master data in different parts of its operations, which can occur in large organizations. A common example of poor MDM is the scenario of a bank at which a customer has taken out a mortgage and the bank begins to send mortgage solicitations to that customer, ignoring the fact that the person already has a mortgage account relationship with the bank. This happens because the customer information used by the marketing section within the bank lacks integration with the customer information used by the customer services section of the bank. Thus the two groups remain unaware that an existing customer is also considered a sales lead.
Other problems include (for example) issues with the quality of data, consistent classification and identification of data, and data-reconciliation issues.
One of the most common reasons some large corporations experience massive issues with MDM is growth through mergers or acquisitions. Two organizations which merge will typically create an entity with duplicate master data (since each likely had at least one master database of its own prior to the merger). Ideally, database administrators resolve this problem through deduplication of the master data as part of the merger. In practice, however, reconciling several master data systems can present difficulties because of the dependencies that existing applications have on the master databases. As a result, more often than not the two systems do not fully merge, but remain separate, with a special reconciliation process defined that ensures consistency between the data stored in the two systems. Over time, however, as further mergers and acquisitions occur, the problem multiplies, more and more master databases appear, and data-reconciliation processes become extremely complex, and consequently unmanageable and unreliable. Because of this trend, one can find organizations with 10, 15, or even as many as 100 separate, poorly-integrated master databases, which can cause serious operational problems in the areas of customer satisfaction, operational efficiency, decision-support, and regulatory compliance.
Solutions
Processes commonly seen in MDM solutions include source identification, data collection, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage, data distribution, data classification, taxonomy services, item master creation, schema mapping,product codification, data enrichment and data governance.
The tools include data networks, file systems, a data warehouse, data marts, an operational data store, data mining, data analysis, data virtualization, data federation and data visualization. One of the newest tools, virtual master data management (also called virtual mdm) utilizes data virtualization and a persistent metadata server to implement a multi-level automated mdm hierarchy.
The selection of entities considered for MDM depends somewhat on the nature of an organization. In the common case of commercial enterprises, MDM may apply to such entities as customer (Customer Data Integration), product (Product Information Management), employee, and vendor. MDM processes identify the sources from which to collect descriptions of these entities. In the course of transformation and normalization, administrators adapt descriptions to conform to standard formats and data domains, making it possible to remove duplicate instances of any entity. Such processes generally result in an organizational MDM repository, from which all requests for a certain entity instance produce the same description, irrespective of the originating sources and the requesting destinations.
Criticism of MDM solutions
The value and current approaches to MDM have come under criticism due to some parties claiming large costs and low return on investment from major MDM solution providers.[1]
See also
- Reference data
- Master data
- Data steward
- Data visualization
- Customer data integration
- Data Integration
- Information as a service
- Product information management
- Identity resolution
- Enterprise Information Integration
- Linked data
- Semantic Web
- Data governance
- Operational data store
- Form, fit and function
References
- ^ Margulius, David L. (2005-10-14). "Mastering data comes at a price | Platforms". InfoWorld. http://www.infoworld.com/t/platforms/mastering-data-comes-price-604. Retrieved 2010-08-27.
2. Pooja Hegde, A study pertaining to the master data management strategies of Unilog Content Solutions.
External links
- Master data management at the Open Directory Project
- Microsoft: The What, Why, and How of Master Data Management
- Microsoft: Master Data Management (MDM) Hub Architecture
- PolarLake: Reference Data Management (RDM) and Governance
- Open Methodology for Master Data Management
- Semarchy: Why do I Need MDM? (Video)
Data warehouse Creating the data warehouseConcepts- Database
- Dimension
- Dimensional modeling
- Fact
- OLAP
- Star schema
- Aggregate
Variants- Anchor Modeling
- Column-oriented DBMS
- Data Vault Modeling
- HOLAP
- MOLAP
- ROLAP
- Operational data store
Elements- Data dictionary/Metadata
- Data mart
- Sixth normal form
- Surrogate key
FactDimensionFillingUsing the data warehouseConceptsLanguagesTools- Business intelligence tools
- Reporting software
- Spreadsheet
RelatedPeopleProducts- Comparison of OLAP Servers
- Data warehousing products and their producers
Database management systems Concepts Objects - Relation (Table)
- View
- Transaction
- Log
- Trigger
- Index
- Stored procedure
- Cursor
- Partition
Components Database products:
Categories:- Database management systems
- Business intelligence
- Data management
- Data warehousing
- Information technology management
Wikimedia Foundation. 2010.