crud matrix l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
CRUD Matrix PowerPoint Presentation
Download Presentation
CRUD Matrix

Loading in 2 Seconds...

play fullscreen
1 / 6

CRUD Matrix - PowerPoint PPT Presentation


  • 1095 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


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