1 / 57

Data and Process Modeling

Data and Process Modeling. Overview. What the system does what an event occurs: activities and interactions Traditional structured approach to representing activities and interactions Diagrams and other models of the traditional approach

osmond
Download Presentation

Data and Process Modeling

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. Data and Process Modeling

  2. Overview • What the system does what an event occurs: activities and interactions • Traditional structured approach to representing activities and interactions • Diagrams and other models of the traditional approach • Customer support system example shows how each model is related

  3. Data Flow Diagrams • Graphical system model that shows all main requirements for an IS in one diagram • Inputs / outputs • Processes • Data storage • Easy to read and understand with minimal training

  4. Data Flow Diagram Symbols

  5. DFD Fragment

  6. DFD Integrates Event Table and ERD

  7. DFD and Levels of Abstraction • Data flow diagrams (DFDs) are decomposed into additional diagrams to provide multiple levels of detail • Higher level diagrams provide general views of the system • Lower level diagrams provide detailed views of the system • Differing views are called levels of abstraction

  8. Layers of DFD Abstraction

  9. Context Diagrams • DFD that summarizes all processing activity • Highest level (most abstract) view of system • Shows system boundaries • System scope is represented by a single process, external agents, and all data flows into and out of the system

  10. Identifying Events • Can be difficult to determine • Often confused with conditions and responses • May be useful to trace a transaction’s life cycle • Certain events left to design phase • Systems controls to protect system integrity

  11. Sequence of Actions that Lead up to Only One Event Affecting the System

  12. Sequence of “Transactions” for One Specific Customer Resulting in Many Events

  13. Events Deferred Until the Design Phase

  14. Example Events • Important external events involve customers • Customer checks item availability, customer places order, customer changes or cancels order • Other external events involve departments • Shipping fulfills order, marketing sends promotion to customer, merchandising updates catalog • Temporal events include periodic reports • Time to produce order summary reports, Time to produce fulfillment summary reports

  15. Information about each Event in an Event Table

  16. DFD Fragments • Created for each event in the event table • Represents system response to one event within a single process symbol • Self contained model • Focuses attention on single part of system • Shows only data stores required to respond to events

  17. DFD Fragments for Course Registration System

  18. Event-Partitioned System Model • DFD to model system requirements using single process for each event in system or subsystem • Decomposition of the context level diagram • Sometimes called diagram 0 • Used primarily as a presentation tool • Decomposed into more detailed DFD fragments

  19. Combining DFD Fragments

  20. Context Diagram for a Customer Support System

  21. Subsystems and Events

  22. Context Diagram for an Order-Entry Subsystem

  23. DFD Fragments for an Order-Entry System

  24. Decomposing DFD Fragments • Sometimes DFD fragments need to be explored in more detail • Broken into subprocesses with additional detail • DFD numbering scheme: • Does not equate to subprocess execution sequence • It is just a way for analyst to divide up work

  25. Physical and Logical DFDs • Logical model • Assumes implementation in perfect technology • Does not tell how system is implemented • Physical model • Describes assumptions about implementation technology • Developed in last stages of analysis or in early design

  26. Detailed Diagram for Create New Order

  27. Physical DFD for scheduling courses

  28. Evaluating DFD Quality • Readable • Internally consistent • Accurately represents system requirements • Reduces information overload: Rule of 7 +/- 2 • Single DFD should have not more than 7 +/-2 processes • No more than 7 +/- 2 data flows should enter or leave a process or data store on a single DFD • Minimizes required number of interfaces

  29. Data Flow Consistency Problems • Differences in data flow content between a process and its process decomposition • Data outflows without corresponding inflows • Data inflows without corresponding outflows • Results in unbalanced DFDs

  30. Consistency Rules • All data that flows into a process must: • Flow out of the process or • Be used to generate data that flow out of the process • All data that flows out of a process must: • Have flowed into the process or • Have been generated from data that flowed into the process

  31. Unnecessary Data Input: Black Hole

  32. Process with Unnecessary Data Input

  33. Process with Impossible Data Output

  34. Documentation of DFD Components • Lowest level processes need to be described in detail • Data flow contents need to be described • Data stores need to be described in terms of data elements • Each data element needs to be described • Various options for process definition exist

  35. Data Dictionary • A data dictionary, or data repository, is a central storehouse of information about the system’s data • An analyst uses the data dictionary to collect, document, and organize specific facts about the system • Also defines and describes all data elements and meaningful combinations of data elements

  36. Data Dictionary • A data element, also called a data item or field, is the smallest piece of data that has meaning • Data elements are combined into records, also called data structures • A record is a meaningful combination of related data elements that is included in a data flow or retained in a data store

  37. Data Dictionary • Documenting the Data Elements • You must document every data element in the data dictionary • The objective is the same: to provide clear, comprehensive information about the data and processes that make up the system

  38. Data Dictionary • Documenting the Data Elements • The following attributes usually are recorded and described • Data element name or label • Alias • Type and length • Default value • Acceptable values - Domain and validity rules

  39. Data Dictionary • Documenting the Data Elements • The following attributes usually are recorded and described • Source • Security • Responsible user(s) • Description and comments

  40. Data Dictionary • Documenting the Data Flows • The typical attributes are as follows • Data flow name or label • Description • Alternate name(s) • Origin • Destination • Record • Volume and frequency

  41. Data Dictionary • Documenting the Data Stores • Typical characteristics of a data store are • Data store name or label • Description • Alternate name(s) • Attributes • Volume and frequency

  42. Data Dictionary • Documenting the Processes • Typical characteristics of a process • Process name or label • Description • Process number • Process description

  43. Data Dictionary • Documenting the Entities • Typical characteristics of an entity include • Entity name • Description • Alternate name(s) • Input data flows • Output data flows

  44. Data Dictionary • Documenting the Records • Typical characteristics of a record include • Record or data structure name • Definition or description • Alternate name(s) • Attributes

  45. Data Dictionary • Data Dictionary Reports • Many valuable reports • An alphabetized list of all data elements by name • A report describing each data element and indicating the user or department that is responsible for data entry, updating, or deletion • A report of all data flows and data stores that use a particular data element • Detailed reports showing all characteristics of data elements, records, data flows, processes, or any other selected item stored in the data dictionary

  46. Structured English • Method of writing process specifications • Combines structured programming techniques with narrative English • Well suited to lengthy sequential processes or simple control logic (single loop or if-then-else) • Ill-suited for complex decision logic or few (or no) sequential processing steps

  47. Structured English Example

  48. Process 2.1 and Structured English Process Description

  49. Decision Tables and Decision Trees • Can summarize complex decision logic better than structured English • Incorporates logic into the table or tree structure to make descriptions more readable

  50. Decision Tree for Calculating Shipping Charges

More Related