The RuleGen framework

RuleGen is a framework that aids in implementing data integrity constraints inside the Oracle RDBMS. Ideally the basis for code generation by RuleGen lies in the (set theoretic) specification of the constraint. RuleGen will lead your thoughts to spend time on a few distinctly 'separate concerns'. Once you input the outcome of these concerns into RuleGen, efficient and serializable code for enforcing the constraint is generated by this framework.

For those of you familiar with the CDM-RuleFrame product of Oracle Consulting, RuleGen can be considered, vision-wise, an equal product. However technologically these two frameworks cannot be compared.

Feature list

  • Set oriented checking model: boosts performance in case of multi-row DML often found in batch processing.
  • Efficient execution model: checks are only run when they really need to be, and they are never run more times than need to be.
  • Immediate (validate at statement level) or deferred (validate at transaction level) rule-checking execution model. Adaptable at runtime per rule, for all sessions, or per session.
  • Enabling/disabling rule-checking at runtime, for all rules, per rule, for all sessions, per session.
  • Rule execution model switchable (at runtime, per session) between 'fail-on-first' violation found and 'continue-to-validate-all' semantics. In latter case not one, but a stack of errors can be reported back.
  • Awareness of status of deferred constraints at any time inside a TX. Enabling an efficient re-execute model for these deferred constraints.
  • Your (valid) transactions can close via the standard COMMIT call (i.e. need not close via a custom 'end-of-tx' call). Likewise your transaction starts when it starts, i.e. without a custom ‘start-of-tx’ call.
  • Rule execution order controllable through registration of inter-rule dependencies.
  • Automatic fine-grained rule-locking to prevent introduction of violations by simultaneous running transactions. Efficient capture of affected row-values: only columns governed by rules are snapshot.
  • Efficient capture of table-state at start of TX through use of database flashback-feature.
  • Optional central logging of rule violations.
  • Special log-only mode of a rule, enabling silent introduction of a rule into production.

RuleGen internally uses many new features of the Oracle rdbms and requires 10G release 2 or higher.

Resources

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.