Transcript CRUD Matrix

CRUD Matrix
Presented by
Trisha Cummings
Background to a CRUD Matrix
• CRUD stands for :Create, Read, Update and Delete.
• A CRUD Matrix is very useful for identifying
the
Data Items which are involved in the Data
Access for each Application.
• In the early stages it is not necessary to
produce a complete CRUD Matrix.
A CRUD Matrix
• A CRUD matrix is a table showing the
Functions in an application containing SQL
statement affecting parts of a database.
• SQL consists of only 4 statements, sometimes
referred to as CRUD :– Create - INSERT - to store new data
– Read - SELECT - to retrieve data
– Update - UPDATE - to change or modify data.
– Delete - DELETE - delete or remove data
CRUD Matrix And Web Sites
• The CRUD Matrix is an excellent technique to identify the Tables in
a Database which are used in any User interaction with a Web Site.
• CRUD means ‘Create, Read, Update or Delete’, and the CRUD Matrix
identifies the Tables involved in any CRUD operation.
• It is very valuable to combine a CRUD Matrix with the analysis of
possible User Scenarios for the Web Site.
• The analysis helps to identify any Tables which are not used, and
any Tables which are used heavily, and may therefore be a
performance bottleneck.
• The application of this technique to a Portal Web Site is shown on
the next slides.
It identifies the different kinds of Users who can access the Web
Site.
• For each kind of User, the User Scenario is defined as a series of
User Actions, and the corresponding Tables are identified.
Here is a simple CRUD Matrix for a CRM Data Architecture :-
Here is a typical CRUD Matrix for a Business Intellignece Data Architecture :-
Resources
• http://www.databaseanswers.org/data_arch/
crm/crud_matrix.htm