Asee peer logo

Temporal Extensions For Enhanced Entity Relationship Notation

Download Paper |

Conference

2008 Annual Conference & Exposition

Location

Pittsburgh, Pennsylvania

Publication Date

June 22, 2008

Start Date

June 22, 2008

End Date

June 25, 2008

ISSN

2153-5965

Conference Session

Emerging Information Technologies

Tagged Division

Information Systems

Page Count

9

Page Numbers

13.1194.1 - 13.1194.9

Permanent URL

https://peer.asee.org/3580

Download Count

26

Request a correction

Paper Authors

author page

Curtis Welborn Utah Valley State College

author page

Reza Sanati-Mehrizy Utah Valley State College

Download Paper |

Abstract
NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

Temporal Extensions for Enhanced Entity Relationship Notation

Abstract An organization can have many business rules to implement in their daily operations. When these rules deal with the planning of business operations, there can be a strong need to specify the temporal relationships between business objects. Software engineers are seldom educated as to the use of temporal logic though it is often needed to accurately explain time-based relationships. Temporal logic[1],[2] defines a basic set of primitive relationships that can exist between intervals in time. These same primitive relationships can be used to express temporal relationships between business objects. The Enhanced Entity Relationship (EER) notation allows business rules to be shown in a graphic form using action assertions which keep the business rule at a conceptual level without specifying how the rule will be implemented. In this paper we will show how the EER notation can be augmented to allow a software engineer to specify temporal-based business relationships in a relational data model.

Introduction There are three common types of business rules[6]: structural assertions, action assertions and derivations. A structural assertion is concerned with statements that express an aspect or relationship about the structure of a business. A derivation is concerned with statements that can be used to derive additional information about the business, whereas an action assertion is a statement that controls or limits the actions of the business. Action assertions are important as they define constraints that a business[5] should or must operate under. A business often has many operating constraints that will be implemented in various users’ application programs. Capturing and documenting business rules in an application program can lead to consistency and manageability issues that ultimately leave the database in an inconsistent state[3].

A more modern and more reliable approach is to define the business constraints (action assertions) at a conceptual level without specifying how the rules will be implemented. The Enhanced Entity Relationship (EER) notation has been used to specify business rules. The EER notation was invented to allow more business rules to be shown in graphical form than the simpler ER notation[4]. Associating business rules with the data that it applies to can be very natural, as the rules are all about the data[8][10].

While business constraints come in many different forms, an important type of constraint on a business is a timing-based or temporal constraint. As an introduction to temporal constraints, let us review a problem that has been expressed in EER notation and explore how it could potentially be augmented with temporal constraints. We will skip any formal definition at this time and simply try to present an intuitive introduction to temporal constraints.

Welborn, C., & Sanati-Mehrizy, R. (2008, June), Temporal Extensions For Enhanced Entity Relationship Notation Paper presented at 2008 Annual Conference & Exposition, Pittsburgh, Pennsylvania. https://peer.asee.org/3580

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2008 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015