« Funny PicturesMagnitude 7.0 and Tsunami Warning »

Technique to Map Business Process to Data Model

06/16/05 | by Clarise | Categories: Techniques, Modeling

Getting input from the users increases the quality of a data model. Joint Application Development (JAD) sessions facilitate and accelerate the modeling process. During the JAD sessions, subject matter experts validate the model with respect to supported and identified functions and processes.

CRUD (Create Read Update Delete) Matrix is one technique to map the data model to the process model. The CRUD matrix helps identify:

  • Missing Process : A business process exists that is not supported by the model; The data model needs to be adjusted to include the missing process
  • Redundant Data Entity : A data entity exists that is not required to support a process

Think of CRUD in terms of how the data and process interact with each other. Using the simple example from the First 3 Rules of Data Normalization for Newbies, below is a simple example of a CRUD matrix:

Click to view original size

In this example, the process “Establish New Employee”, the entities (can be thought of as tables) of the model that are required to support the process are Employee, Employee Dependents, Warehouse (which warehouse will the new employee be assigned to).

Let us assume further that this model is only for employees and their training needs. Having an entity Product is a redundant entity. Of course, one can leave that entity in the model. However, it shows that for the scope of this particular model, it is not needed.

Send feedback »

No feedback yet

May 2020
Mon Tue Wed Thu Fri Sat Sun
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
 << <   > >>
This blog contains thoughts that range from non-technical to technical. Its name is derived from "Yakity Blah Blah" a column I once had that discussed a cornucopia of ideas. Who am I? I'm Clarise Z. Doval Santos, providing Project Management and Technical Leadership for data management and analytic, data science, IoT and sensor analytics ecosystems 37.652951177164 -122.490877706959


  XML Feeds

CMS software