Browse Prior Art Database

Relational Process Model And Process Normalization

IP.com Disclosure Number: IPCOM000102204D
Original Publication Date: 1990-Nov-01
Included in the Prior Art Database: 2005-Mar-17
Document File: 4 page(s) / 154K

Publishing Venue

IBM

Related People

Dewell, ME: AUTHOR

Abstract

This disclosure defines the methodology or steps for designing normalized program processes using a relational process model.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Relational Process Model And Process Normalization

       This disclosure defines the methodology or steps for
designing normalized program processes using a relational process
model.

      A program process design is defined as:  the representation of
a business activity, function, or event as a set of data flows.  Fig.
1 is an example of normalized process design.  There are three stages
in process design normalization:
1.   First Normal Form - all repeating data flows are eliminated by
refining the repeating data flows into separate processes.
2.   Second Normal Form - all data flows not fully dependent on the
process primary key are eliminated by refining those data flows into
separate processes.
3.   Third Normal Form - all data flows not directly dependent on the
process primary key are eliminated by refining those data flows into
separate processes.

      From this design a relational process model is produced
consisting of a table representing each specific event, with each
column representing a specific data flow of that event, and each row
repre senting a specific instance or occurrence of that event. Each
event instance is uniquely identified by the process primary key, and
may be associated with another process by foreign keys.  A process
primary key is:  an attribute or set of attributes that uniquely
identifies one instance of the process's event.  A process foreign
key is:  an attribute or set of attributes that uniquely identifies
one instance of another process's e, i.e., the primary key of another
process.  Table 1 is the relational model representation of the
Record Order (1.1) event type in the process design model.  The name
of the table identifies the type of event.  Each column is a unique
data flow.  Each row in the table describes a unique, identifiable
instance of that event type.

      A process is in first normal form (1NF) if and only...