Title

Entity relationship modelling of business rules: An Oracle prototype

Abstract

Business rules are generally developed as an addendum to database development using proprietary techniques. This paper provides an approach to apply the techniques of traditional entity-relationship modelling to structure the business rules as a rule repository for interaction with transactional entity types in a relational database management system. A prototype to model a sample set of business rules into relational database is provided to demonstrate the application of the concept. The paper utilises the Oracle database for illustrating the concepts. The prototype is explained through an application in Oracle's PL/SQL server pages.

Department(s)

Information Technology and Cybersecurity

Document Type

Article

DOI

https://doi.org/10.1504/IJDMMM.2010.032146

Keywords

Business rules, Data modelling, Entity-relationship, Oracle, PL/SQL server pages

Publication Date

1-1-2010

Journal Title

International Journal of Data Mining, Modelling and Management

Share

COinS