Master data – definition

Data is essential for mapping technical and business processes. If data changes only slowly, then it’s probably master data (operational systems). In the context of analytical systems (data warehouse, big data), the term “slowly changing dimensions” is explicit used, i.e. data that changes slowly.

Furthermore, the volume of the master data is significantly lower than that of the transaction data, such as order data. Examples for master data objects are:

  • Products and services
  • Suppliers
  • Customers
  • Employee
  • Locations
  • Accounts

Master data, rules and data models

For the correct use, data acquisition and assignment, we need rules similar to a grammar. Well-known representatives of these rules are e.g. existential dependency (referential integrity), absolutely necessary (mandatory) values ​​or area specifications.

A certain complexity is essential for modeling complex relationships. A large number of these relationships can already be mapped and monitored using appropriate data models.

We would be happy to support you with the automated testing of your data models on the basis of the data model scorecard and our own experience from a large number of projects and training courses.

Semantic checks, classifications or duplicate checks, on the other hand, cannot usually be mapped using data modeling methods.

Master data management

Master data management systems are used to ensure the high quality of the master data in more complex contexts. Appropriate expertise and intelligent MDM tools create the prerequisites for efficient processes, satisfied customers and reliable analyzes.

Master data software and consulting

Would you like to learn more about the possibilities of intelligent MDM tools? Call us on +49 2547 93998 0 or send us a message. We will advise you personally.