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.