Friday, November 19, 2004

diff transactional data & master data

is there any difference?

Master Data (MD) is long lived, so is much Transactional Data (TD).
MD may only be valid for certain subscribing applications, same for TD.
It can make sense to publish MD even when it is not fully populated, same for TD.
MD has both global entities and local entities, that can be the case for TD.
MD often goes through workflow for updates/creation, so does TD.
MD entities are heavily references, TD not as much.
MD needs to be flexible to accommodate significant change, TD less so, since TD is normally consumed by fewer applications.

So if there is a difference that influences design it is probably MDs need to support a higher rate of change than TD and a higher number of external, incoming references.