{'fraction_non_alphanumeric': 0.012640449438202247, 'fraction_numerical': 0.0, 'mean_word_length': 5.541284403669724, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Entity relationship modelling of business rules: an Oracle prototype

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.