//AMIS Technology Blog » rulegen

Posts tagged rulegen

Vacatures bij AMIS services

Implementation of a moderately complex data constraint business rule using RuleGen 3.0

4
1 year ago
by Lucas Jellema in , , ,

In a previous article, I have introduced RuleGen 3.0 – a 2nd generation business rule implementation framework for the Oracle Database: http://technology.amis.nl/blog/?p=12807. RuleGen provides a solid, structured, scalable framework for database developers to implement data constraints in. This article demonstrates how a moderately complex rule is analyzed and designed and implemented with RuleGen 3.0. If you want to try out RuleGen yourself, you can download the framework under trial conditions from http://www.rulegen.com/free-download .

This article illustrates the essential steps in the business rule design and build process:

  • describe the business in human readable format – preferably using names of entities and attributes or even better tables and columns
  • analyze the events that potentially violate the business rule and should therefore trigger evaluation of the rule
  • define the filter condition (a SQL expression) that identifies the records that should be checked for each triggering event (typically only a very small subset of the records in a table need to be explicitly validated upon an event)
  • define the rule validation logic in terms of SQL – write the SQL query More >
Vacatures bij AMIS services

RuleGen 3.0 – the latest, leanest and most robust solution for complex data constraints in an Oracle Database

0
1 year ago
by Lucas Jellema in , , , ,

No matter how complex the enterprise and application architectures become, no matter the number of tiers, services, devices and user interfaces – at the heart of most enterprises will be a relational database.

And no matter how hard we try to implement a fully service based architecture or a multi-purpose business tier (for example using EJBs) – we will have multiple routes to the database and the data in it. Data will be manipulated through web applications, web services, client/server applications, batch database jobs, application managers working directly against the database from the command line or TOAD-like tools. If for no other reason – that by itself is an overridding motivation for enforcing every data constraint at the lowest possible level – the one level that none of these channels can avoid: the database itself. In addition to the fact that only enforcement inside the database can provide real integrity (and what the hack would be semi-real integrity?), for most data rules (especially complex ones) implementation inside the database is the most performant, scalable, maintainable, managable, agile, elegant and easy to implement as well.

Note: I am not advocating that More >

SIG Event

AMIS Query 18 Mei – Een Terugblik op Hotsos 2009

4 years ago
by Marco Gralike in , , , , , , , , ,
Begin maart 2009 werd in Irving, Texas, het internationale Oracle Performance Symposium Hotsos gehouden. Ook dit jaar stond het symposium garant voor inhoudelijke hoogstaande presentaties en discussies over performance. Vier Nederlanders, Jeroen Evers (Fameus), Toon Koppelaars (RuleGen), Gerwin Hendriksen (AMIS) en Marco Gralike (AMIS), hadden het genoegen om ter plekke te zijn en in de gelegenheid om al deze, over de aanwezigen uitgestorte (Oracle) performance verbeterende informatie, in zich op te nemen. Dit jaar was het Symposium sowieso bijzonder vanwege de 2 presentaties van Chris Date en een volledige in-depth training dag met Jonathan Lewis. De AMIS Query “Een terugblik op Hotsos 2009”, op 18 mei aanstaande, zal een terugblik geven over het Hotsos Symposium van dit jaar en in gaan op vier, door de presentatoren, uitgekozen presentaties, onderwerpen, die op het Hotsos Symposium werden gegeven en die door ons Nederlanders als opmerkelijk werden ondervonden en/of een erg interessant onderwerp is om (ook) over te presenteren. Jeroen Evers, een van de weinige Oracle Certified Masters in Nederland en OakTable lid, zal inhoud geven op deze avond aan de door hem bijgewoonde More >
Go to Top