Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: skelesp on March 21, 2011, 09:40:27 pm

Title: CRUD matrix
Post by: skelesp on March 21, 2011, 09:40:27 pm

Hi,

Is there a way to make a CRUD-matrix in EA? I tried to do this in the relationship matrix by using classes (from datamodel) and actors. But I couldn't find the proper relationships (Creates or CreatedBy, Reads or ReadBy, Updates or UpdatedBy , Deletes or DeletedBy).

So, is there a way to shows which action is performed on the data by which actor?

Thanks in advance!

Title: Re: CRUD matrix
Post by: salayande on March 22, 2011, 12:20:32 am

I have requested for this feature for years but was informed that Ineed create an MDG Add-In for this.

Please, kindly raise a feature request for this.

kind regards

Segun

Title: Re: CRUD matrix
Post by: Sunshine on March 23, 2011, 11:25:05 am

As a workaround instead of creating one CRUD matrix you could create four matrices, one for each create, read, update and delete relationship type. You can achieve this by creating stereotypes of dependency (or association whatever you think is best) relationships for create, read, update and delete via the menu settings>UML... Then create four matrices of actors vs classes, one for each relationship stereotype, create, read, update and delete. Not all in one matrix but it should help.

I do a similar thing to map which applications are used by which business unit.

Hope that helps in some small way.

Title: Re: CRUD matrix
Post by: salayande on March 30, 2011, 03:10:53 am

Thank you for the suggestion, Sunshine.

regards

Segun