Title

Integrated Framework to Model Data with Business Process and Business Rules

Abstract

Data modeling is an approach to model data by mapping operational tasks iteratively, while associated guidelines are either partly mapped in the data model or expressed through software applications. Since an organization is a collection of business processes, it is essential that data models utilize such processes to facilitate data modeling. Also, data models should incorporate guidelines for completing operational tasks through the concept of business rules. This paper outlines a unified framework on database modeling and design based on business process concepts that also incorporates business rules impacting business operations. The paper focuses on the relational database and its primary mode of conceptual modeling in the form of an entity relationship model. Concepts are illustrated through Oracle's database language PL/SQL and its Web variant PL/SQL Server Pages.

Department(s)

Information Technology and Cybersecurity

Document Type

Article

DOI

https://doi.org/10.5121/ijdms.2016.8601

Keywords

data modeling, entity relationship model, relational model, business process, business rules, oracle, PL/SQL server pages

Publication Date

2016

Journal Title

International Journal of Database Management Systems

Link to Full Text

Share

COinS