Integrated Framework to Model Data with Business Process and Business Rules

摘要

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