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.
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