Databases Reference
In-Depth Information
A unified table can be used to assemble all the data
enumerations that have low occurrence numbers, less than a
hundred or so values, in order to avoid a proliferation of
tables with low volume.
For instance, an information “Market type” is an
enumeration data at the semantic modeling level with the
values “USA | UK | International”. On the other hand, at
the logical modeling level, this information is transformed in
the form of:
− a dedicated table to benefit an autonomous governance
of this information, particularly its versions and rights
permissions; or
− an implementation in a unified table which absorbs
several data enumerations. This table has complementary
information at its disposal that enables the determination of
the classification of each code and value; in our example this
is the “Market type”. This solution avoids multiplying tables
with low volume that have a common structure and data
governance.
10.6.2.
User message
The operations can prompt information and error
messages.
These messages must be treated as enumerations data
managed by the MDM system. Therefore, they benefit from
an initialization and update by use context, in particular
multi-languages, and benefit from version management.
10.6.3.
User interface components
For certain ergonomic needs, the man-machine interface
offered by default by the Model-driven MDM system must be
extended. For example, a credit rate can be the object of an
