Business Rules Modeling for Business Process Events: An Oracle Prototype

Business rules guide business process activities and events, besides impacting associated business entity types. This paper outlines an approach to model business rules associated with business process events through traditional data modeling techniques like entity-relationship diagrams, and then transform the data model into application procedures that can effect business process events. A prototype to model a sample set of business rules pertaining to a business process event into a relational database is provided to demonstrate the application of the concept. The paper utilizes the Oracle database for illustrating the concepts. The prototype is explained through an application in Oracle's PL/SQL Server Pages.