Modeling Types

by Amol 23. February 2011 10:31

What is Modeling?

Modeling is an efficient way to represent, communicate organization needs. Modeling is an information provided to the members of an organization to understand business and its rules.

Business Modeling Types:

Business Process Modeling:

Business Process Modeling is an efficient way to represent the business processes, activities, main entities in graphical form. Below figure indicate typical busicess process model.

Process Flow Modeling:

Process Flow Modeling graphically describe the various business processes that happen in an organization and the relationships between them. Process Flow Modeling contains a diagram of several related processes often refered as Unit of Work. Process Flow Modeling is represented in the form of Arrows and Junctions. Junctions are the boxes which are used for the branching or joining operation between processes that enter or leave a junction.

Data Flow Modeling:

As name describes, Data Flow Modeling is the flow of data between various Buiness Processes or activities.

Data Modeling Types:

Following are the Data Modeling types. Click on it see more details about it.


Data Modeling

Physical Data Model

by Amol 20. February 2011 10:57

Physical Data Modeling:

The next step after Logical Data Model is to generate Physical Data Model. Physical data model is generated from the approved Logical Data Model.

Logical and Physical data model looks same but having some major differences between them. Such as Physical Data Model includes all required database objects like tables, columns, Keys, relationships, database properties for the physical implementation of databases. Some of the important parameter of Physical Data Model are database performance, indexing strategy, physical storage and normalization, denormalization

Once Physical Data Model is completed, it is then forwarded to technical teams for review and implementation.

In the figure below, the entity names has been changed to table names, changed attribute names to column names, assigned nullability constraints, and datatype for each column.


Data Modeling

Logical Data Model

by Amol 20. February 2011 10:36

Logical Data Modeling:

Once you have Conceptual Data Model, it further converted to Logical Data Model which is the actual implementation of Conceptual Data Model. Logical data model represents the entire business requirements of an organization.

Logical Data Model describe the detail level information for subject area defined in Conceptual Data Model. LDM defines the subject area and all of its attributes needed for business. Also LDM represent the referential integrity between the subject area attributes. In short Logical data model includes all required business entities, attributes, keys, and its relationships which define business rules.

In the figure below represent the Logical Data Model which has entity names, attribute names, keys and relationships.


Data Modeling


Recent Posts

Tag cloud