A CRUD matrix maps the four database operations—Create, Read, Update, Delete—to your data types and tables. Rows show each data entity, columns show each operation. Fill it in and you see at a glance which functions exist or need building for each data type.
Chapters
What is the CRUD matrix? CRUD stands for Create, Read, Update, and Delete. It is a database operations matrix used to define the data manipulation operations that can be performed in an application. The CRUD matrix provides information on which functions are available for each type of operation, allowing developers to quickly understand how their application will interact with its underlying data sources. The CRUD matrix is particularly useful for mapping out the necessary operations within a single table. Each column represents one of the 4 basic database functions: Create , Read , Update , and Delete . The columns and rows are used to map out the relationship between the operations and the data types they affect. Finally, the CRUD matrix allows teams to quickly identify which functions need to be implemented and also helps them keep track of all operations taking place in their application.