CRUD Matrix (BPM)

A CRUD matrix is a table that allows you to observe, at a global level, the actions (Create, Read, Update, or Delete) your processes perform on data or resources, and modify or add any missing actions on them.

A CRUD matrix can be created in a choreography diagram with any of the following target languages:


Data CRUD Matrix

In the following example, the Process Order process reads and updates the Client data, and reads the Credit Card data, and the Confirm Order Shipment process reads the Credit Card data:



Resource CRUD Matrix

In the following example, the Check Stock process reads data stored in the Inventory resource and the Ship FedEx Overnight process reads and updates data stored in the Work Team resource:



The CRUD matrix is made up of:


  • Headers – which contain the name of resources or data along the top and the name of processes down the left side.

  • Cells – which contain the CRUD values (Create, Read, Update, Delete). CRUD values are derived from the access modes specified in the Data tab of the process or resource flow property sheet. Cells are empty when there is no relationship between objects.


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com