Using CRUD Matrix in EA process.
We try CRUD matrix the other day to check out duplication
of data usage in the enterprise. After mapping and
classification of the Information worlds (Data) and
extract enterprise functions we use CRUD matrix to find
out what’s going on. The discipline is pretty simple. One
axis filled with Information worlds while the other axis
holds enterprise functionality. For every cell you enter
any CRUD letter for the action that given enterprise
function operate on given information worlds. The matrix
should look like that;
|
Function/Information |
World 1 |
World 2 |
World 3 |
World 4 |
|
Func 1 |
|
U |
R |
D |
|
Func 2 |
C |
U |
R |
R |
|
Func 3 |
C |
R |
R |
D |
What you need to look for:
-
If two functions create, update or delete world it
means duplication of ambiguity of the data.
-
If no function creates, updates or deletes world it
means that the world might belong to historic user and
should be store in archive.
-
You can see which function is major in term of
enterprise activities.
Try it and you’ll be surprise from the results.