Frequently asked questions

Why RuleGen?

Business rules are often ambiguously specified which introduces a risk to any database application project. Once clearly documented, implementing them is yet a tedious and error-prone task for which the time required is difficult to estimate; and it usually takes more time than was planned for. In the end you will find it tough to deliver the data quality that was required by the business.

These risks can be mitigated by approaching business rules in a structured way. RuleGen forces you to do so. By using RuleGen you focus on the 'what' of the rule (the specification), and not the 'how' (the implementation) and you'll end up with a central repository where all your rules are documented in a uniform manner. And better yet, that's all there is to it: documenting them. Since once you have documented your rules in RuleGen, you can generate all code to implement them a the push of a button.

Nowadays flexibility to easily adapt your database application is a key requirement. By having the code 100% generated, flexibility is inherently achieved: just change the specification and then regenerate the code.

What is RuleGen for?

RuleGen enables you to easily and quickly enforce data integrity constraints (aka. business rules) at the database level. Enforcing constraints once at this level ensures that no matter what or who accesses your data, they will always need to pass the RuleGen layer.

How does RuleGen work?

In essence RuleGen is a (PL/SQL based) PL/SQL generator. It generates triggers on the tables in your database design. These triggers enforce the constraints. The way you specify a constraint within RuleGen is very intuitive. You need not write a single line of PL/SQL code. Instead you tell RuleGen:

  • What type of transactions require that the constraint be checked.
          This is called the "when" of a constraint.
  • How the constraint should be checked.
          This is called the "how" of a constraint.

You tell RuleGen when and how to check a constraint by writing queries. Checkout RuleGen by Example to see how this works.

What is the learning curve for RuleGen?

When we say intuitive, we mean intuitive. If you can write queries, you can use RuleGen. There is no three-day course for RuleGen. Rather a workshop of a few hours. We have seen database developers without any prior RuleGen experience, successfully use this framework within half a day.

How do I install RuleGen?

Installing RuleGen is basically a two-step process:
1) You create a schema in your database and install the RuleGen packages in this schema.
2) You import an Apex application
Done. Just start the Apex application and off you go. There is of course a bit more to it: but installation of RuleGen typically takes less than half an hour.


News & Events

Check out our new blog on triggers here.

Or follow us:

RuleGen 3.0 released

With the open architecture of release 3.0, RuleGen has set the path for the future. Improved code generation, transparent code deployment, and separation of design and runtime, are some of the key highlights of this new release.

Available now: AM4DP

Click to see book on Amazon

A great textbook about data integrity constraints in relational databases. This book describes the key concepts on which RuleGen is based. Click image to see reviews at Amazon, or here for quotes found on internet.