What is CRUD Analysis?

CRUD analysis is a technique for mapping data change events across a set of requirements.  Typically,  data maintained within a software application needs to have at least one function for each that creates, reads, updates and deletes each type of data.  We call this the full set of CRUD operations.  To check for completeness (potential missing requirements) we need to examine all of the requirements within a set and ensure that there is at least one create function, one read function and so on for each object type.  CRUD analysis is the activity of cross -referencing requirements with the each of the four data maintenance types for object types involved in each requirement.  Hitherto this has been a manual task of drawing up the CRUD table.

CRUD Analysis, Automated

ScopeMaster analyses the text of your functional user stories (or software requirements).  It detects the most likely data movements for each object type within each requirement.

It finds all the objects mentioned in all the requirements (that have clear functional intent) and then maps them onto a single table so that the requirements author can instantly see any potential missing functional requirements.

This is how ScopeMaster speeds up completeness checking to find potential omitted functionality and potential duplicate checking too.  CRUD analysis is an important, but often overlooked step in ensuring that requirements are complete, consistent and not duplicated.   Using this feature of ScopeMaster you can find and fix omissions in about 2 minutes.  This represents a saving of 50x productivity increase on the manual work of establishing and maintaining a CRUD table, detecting and adding the missing requirements.

The Benefits

The three main benefits of compiling a CRUD table is to identify potential defects in your requirements.  The main types of defect you can expose are:

Omissions – missing CRUD events.

Duplications – excessive operations on an object type occurring in many requirements.

Consistency – detecting consistent naming of object types.

CRUD Analysis with ScopeMaster - screenshot

ScopeMaster detects data movements across all user stories and can propose the complete application CRUD analysis table.

Automatically tests a set of user stories to find potential defect totals
All Features