Title: Entity relationship modelling of business rules: an Oracle prototype

Authors: Rajeev Kaula

Addresses: Computer Information Systems Department, Missouri State University, 901 South National Ave., Springfield, MO 65897, USA

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.

Keywords: business rules; data modelling; entity-relationship modelling; Oracle; PL/SQL server pages; database development; relational database management; RDBMS.

DOI: 10.1504/IJDMMM.2010.032146

International Journal of Data Mining, Modelling and Management, 2010 Vol.2 No.2, pp.137 - 175

Published online: 11 Mar 2010 *

Full-text access for editors Access for subscribers Purchase this article Comment on this article