Databases Reference
In-Depth Information
In order to make the most of these relationships, already
contained in the data model, the calculation of data
dependencies is a governance function which allows them to
be scanned automatically in order to carry out an impact
analysis and to put forward ways of querying the data. For
example, in a data model, an Article is linked to a Product
which is in turn linked to a Catalog, a Region, and a Factory.
It is possible to query the articles by product and catalog, or
by region and even by factory.
It is also possible to combine several of these
dependencies (or axes of dependencies).
Rather than build data dependencies from scratch, a
Model-driven MDM system has at its disposal a rich data
model which allows it to automatically take advantage of the
relationships between business objects. From the moment
that the model is available, the data dependencies are
automatically calculated and querying the data according to
different hierarchies of values is possible. More than this,
the user, if they have the rights, can extend the calculated
data dependencies
by adding other attributes present in the
business objects concerned, as, for example, the date of the
article; a query of articles by product, catalog, month,
quarter and year is thus obtained.
It is also possible to add
sort criteria, or filters on the attributes of the data objects
queried, etc.
In the end, the calculation of the data
dependencies and the consultation of the hierarchies allow a
complete and powerful querying of the reference and master
data.
6.10. Conclusion
Arriving at the end of this chapter, we can understand
that an MDM system offers governance functions that are
both rich and complete. Others exist and have not been
described here through lack of space: access to the audit
