1 / 6

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.

gerard
Download Presentation

CRUD Matrix

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CRUD Matrix Presented by Trisha Cummings

  2. 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.

  3. 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

  4. 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.

  5. Here is a typical CRUD Matrix for a Business Intellignece Data Architecture :- Here is a simple CRUD Matrix for a CRM Data Architecture :-

  6. Resources • http://www.databaseanswers.org/data_arch/crm/crud_matrix.htm

More Related